My Oracle Support Banner

EM 13c: Getting Repeating Incidents 'java.lang.IllegalStateException:oracle.sysman.emSDK.agent.sql.SqlConnection' (Doc ID 3051115.1)

Last updated on DECEMBER 06, 2024

Applies to:

Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Enterprise Manager Cloud Control is frequently generating incidents with the following error:
"java.lang.IllegalStateException:oracle.sysman.emSDK.agent.sql.SqlConnection"


Incident Id: 205
Incident Source: SYSTEM
Create Time: Thu Sep 19 10:11:09 GMT 2024
Problem Key: java.lang.IllegalStateException:oracle.sysman.emSDK.agent.sql.SqlConnection:2140
ECID: 0000P7nQE2H3n3d5TfK6yc1atRjD0000F9
Thread Id: 32
Error Message Id: OFM-99999

Context Values
--------------
threadName : GCThread-162007

Stack Trace
-----------
java.lang.IllegalStateException: JDBC Tokenization failure
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2140)
at oracle.sysman.gcagent.target.interaction.execution.JobExecutionMgr$SqlJobConnection.run(JobExecutionMgr.java:914)
at oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:198)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.text.ParseException: No matching ['] found
at oracle.sysman.emSDK.agent.sql.SqlConnection.retokenize(SqlConnection.java:1199)
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2136)
... 3 more

 Agent logs (gcagent.log) records below errors.


End; fetchDbmsOutput=True isStatement=True clientId=<client-id> SQLINPARAM3=**** SQLINPARAM2=**** ServiceName=<sevice name> SQLINPARAM1=**** ConnectDescriptor=(DESCRIPTION=(CONNECT_TIMEOUT=120)(RETRY_COUNT=20)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))(CONNECT_DATA=(SERVICE_NAME=<service_name>)))}
2024-09-09 02:00:25,069 [123219:D6DCD9BB] INFO - >>> Reporting response: PerformStreamedOperationResponse (exitCode:0 output:null error:null) (request id 1) <<<
2024-09-09 02:00:25,219 [123707:7FA5A0AD:GCThread-115407] INFO - uncaughtException handler with

java.lang.IllegalStateException: JDBC Tokenization failure
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2140)
at oracle.sysman.gcagent.target.interaction.execution.JobExecutionMgr$SqlJobConnection.run(JobExecutionMgr.java:914)
at oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:198)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.text.ParseException: No matching ['] found
at oracle.sysman.emSDK.agent.sql.SqlConnection.retokenize(SqlConnection.java:1199)
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2136)
... 3 more
2024-09-09 02:00:25,219 [123707:7FA5A0AD] INFO - uncaughtException: in the finally block with bounce of false
2024-09-09 02:00:25,220 [123707:7FA5A0AD] ERROR - Critical error:


2024-09-16 02:00:18,876 [49811:B1B601EA] ERROR - Critical error:

java.lang.IllegalStateException: JDBC Tokenization failure
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2140)
at oracle.sysman.gcagent.target.interaction.execution.JobExecutionMgr$SqlJobConnection.run(JobExecutionMgr.java:914)
at oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:198)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.text.ParseException: No matching ['] found
at oracle.sysman.emSDK.agent.sql.SqlConnection.retokenize(SqlConnection.java:1199)
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2136)
... 3 more
2024-09-16 10:10:26,857 [62720:B1C5052F] ERROR - Critical error:

java.lang.IllegalStateException: JDBC Tokenization failure
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2140)
at oracle.sysman.gcagent.target.interaction.execution.JobExecutionMgr$SqlJobConnection.run(JobExecutionMgr.java:914)
at oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:198)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.text.ParseException: No matching ['] found
at oracle.sysman.emSDK.agent.sql.SqlConnection.retokenize(SqlConnection.java:1199)
at oracle.sysman.emSDK.agent.sql.SqlConnection.ExecuteStatement(SqlConnection.java:2136)
... 3 more

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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