OTM is Unable to Parse Sql Statements For "Refresh Cache" Used In Agent Direct Sql Updates With Carriage Return Linefeed Characters (Doc ID 1351119.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.1.5 to 6.2.3 [Release 6.1 to 6.2]
Information in this document applies to any platform.

Symptoms


OTM is not refreshing the cache successfully when the SQL provided in SQL FOR REFRESH CACHE contains carriage return linefeed characters. This is shown as a Debug Statement in the log as below:

2011-08-17 17:09:29.465 704923 Debug Sql DBUpdate: SQLParsing: Exception or SQLException linked to Direct SQL Update could be ignored. Error is due the fact that given SQL couldn't be parsed for Intelligent Bean Cache Refresh. This exception doesn't have any impact on the execution of Sql statement given in Direct SQL Update. Reason Unable to get full Pk class name for the given table agentUtility - 1
2011-08-17 17:09:29.465 704923 Debug Sql DBUpdate: Couldn't get the items for cache refresh from given SQL agentUtility - 1


EXPECTED BEHAVIOR
-----------------------
It is expected the agent to error due to this as the refresh did not work successfully.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an agent which contains a direct sql update as well as a refresh cache statement which contains a carriage return.
2. Run the steps needed to kick off the agent.
3. Note the following seen in the logs:


2011-08-17 17:09:29.465 704923 Debug Sql DBUpdate: SQLParsing: Exception or SQLException linked to Direct SQL Update could be ignored. Error is due the fact that given SQL couldn't be parsed for Intelligent Bean Cache Refresh. This exception doesn't have any impact on the execution of Sql statement given in Direct SQL Update. Reason Unable to get full Pk class name for the given table agentUtility - 1
2011-08-17 17:09:29.465 704923 Debug Sql DBUpdate: Couldn't get the items for cache refresh from given SQL agentUtility - 1

ted..

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms