Issue Description

After upgrading to K2 4.7 the following issues occur when using the Oracle SmartObject methods:

  1. When attempting to sort a column and the column name contained spaces, an error occurs.
  2. An error occurs when filtering on a date with an invalid format.
  3. 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:

  1. ‘ORA-00901: missing right parenthesis’
  2. String cannot be converted to date
  3. No error occurred for the third issue. No results will return.

Resolution

    1. Ensure you have K2 4.7 installed.
    2. Download and install the K2 4.7 August 2017 Cumulative Update from K2 Partner and Customer Portal.
    3. Get the K2 4.7 August 2017 Cumulative Update FP5 from Regional Support.
    4. Install the K2 4.7 August 2017 Cumulative Update FP5 to apply the fix.
    5. Edit the Oracle Service Instance and set the new service key “Trim Trailing Spaces when filtering” to true.
    6. Regenerate the SmartObjects.