Code Fix: After upgrading to K2 4.7 the Oracle SmartObject methods did not function correctly
KB002031
PRODUCTK2 blackpearl 4.7
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue Description
After upgrading to K2 4.7 the following issues occur when using the Oracle SmartObject methods:
- When attempting to sort a column and the column name contained spaces, an error occurs.
- An error occurs when filtering on a date with an invalid format.
- When a column value has trailing spaces, for example “Bob “, searching for “Bob” does not return any results as no match is found.
Error Message
The following error messages occur:
- ‘ORA-00901: missing right parenthesis’
- String cannot be converted to date
- No error occurred for the third issue. No results will return.
Resolution
-
- Ensure you have K2 4.7 installed.
- Download and install the K2 4.7 August 2017 Cumulative Update from K2 Partner and Customer Portal.
- Get the K2 4.7 August 2017 Cumulative Update FP5 from Regional Support.
- Install the K2 4.7 August 2017 Cumulative Update FP5 to apply the fix.
- Edit the Oracle Service Instance and set the new service key “Trim Trailing Spaces when filtering” to true.
- Regenerate the SmartObjects.