Troubleshooting the SQL adapter
The following table describes issues that may occur while using the SQL adapter and how to resolve them.
Issue | Reason | Resolution |
|---|---|---|
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 |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*