SQL-8202 Error when deploying MDM from MDM Studio using Weblogic.
Article ID: KB0093188
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM Studio | - |
| Not Applicable | - |
Description
Description:
When MDM project fails to deploy from MDM studio with the application server Weblogic, the following SQL error is thrown:
SQL-8202: Failed while executing SQL statement. SQL state 42000. Database specific error code (if any) was 2089. Database error message (if any) was: java.sql.SQLSyntaxErrorException: ORA-02089: COMMIT is not allowed in a subordinate session.
When MDM project fails to deploy from MDM studio with the application server Weblogic, the following SQL error is thrown:
SQL-8202: Failed while executing SQL statement. SQL state 42000. Database specific error code (if any) was 2089. Database error message (if any) was: java.sql.SQLSyntaxErrorException: ORA-02089: COMMIT is not allowed in a subordinate session.
Issue/Introduction
SQL-8202 Error when deploying MDM from MDM Studio using Weblogic.
Resolution
This issue occurs when a correct JDBC driver is not selected or if a two phase commit is enabled in the datasource. This can be corrected in the configuration file (eCMDataSource-*-jdbc.xml) under config/jdbc directory for the WebLogic domain set up.
Find attached (Filename: change_eCMDataSource-8028-jdbc.xml) a sample file for reference.
1). Confirm that the driver name is as follows:
2). That OnePhaseSummit is enabled rather than TwoPhaseSummit as:
Find attached (Filename: change_eCMDataSource-8028-jdbc.xml) a sample file for reference.
Attachments
Feedback
Yes
No
Powered by
