Troubleshooting the SQL adapter

The following table describes issues that may occur while using the SQL adapter and how to resolve them.

IssueReasonResolution

Stored procedures that contain query or update action may fail and the following error message is displayed.

This issue also occurs while running the "Select * from table name" query, where the <data-type> is XML.

Error occured performing query: Message[summary=Exception in Procedure execution 
for Adapter sql. Procedure invoked insertxml 
exception sealing violation: 
package oracle.jdbc.internal is sealed, 
detail=Exception in Procedure execution for 
Adapter sql. Procedure invoked 
insertxml exception sealing violation: p
ackage oracle.jdbc.internal is sealed]

This issue may occur if you are using embedded Remedy Single Sign-On and if your Oracle version is 11.0 or later.

Verify whether there are multiple ojdbc6-11.2.0.2.0.jar files in your environment and remove the duplicate files from the following location:

AO_HOME\CDP\lib\shared

Was this page helpful? Yes No Submitting... Thank you

Comments