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 JULY 20, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.