SQL-8202 Error when deploying MDM from MDM Studio using Weblogic.

SQL-8202 Error when deploying MDM from MDM Studio using Weblogic.

book

Article ID: KB0093188

calendar_today

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.

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.

1). Confirm that the driver name is as follows:


<driver-name>oracle.jdbc.OracleDriver</driver-name>

2). That OnePhaseSummit is enabled rather than TwoPhaseSummit as:


<global-transactions-protocol>OnePhaseCommit</global-transactions-protocol>

Find attached (Filename: change_eCMDataSource-8028-jdbc.xml) a sample file for reference.

Issue/Introduction

SQL-8202 Error when deploying MDM from MDM Studio using Weblogic.

Attachments

SQL-8202 Error when deploying MDM from MDM Studio using Weblogic. get_app
Powered by Wolken Software