TIBCO MDM Studio , throws an error while deploying a data model. "Code: SQL-8202: Failed while executing SQL statement..."

TIBCO MDM Studio , throws an error while deploying a data model. "Code: SQL-8202: Failed while executing SQL statement..."

book

Article ID: KB0087140

calendar_today

Updated On:

Products Versions
TIBCO MDM -
Not Applicable -

Description

Resolution:

Symptoms:
========
Here is the error (SEC-5503) that is displayed:

Code: SQL-8202: Failed while executing SQL statement. SQL state 25P01. Database specific error code (if any) was 0. Database error message (if any) was: org.postgresql.util.PSQLException: ERROR: SAVEPOINT can only be used in transaction blocks.
ID: 0AD3370A_8A53B78A417B1DC30141803499A90077
DATETIME: Thu Oct 03 15:23:52 MDT 2013
EXCEPTIONMESSAGE: org.postgresql.util.PSQLException: ERROR: SAVEPOINT can only be used in transaction blocks
STACKTRACE: org.postgresql.util.PSQLException: ERROR: SAVEPOINT can only be used in transaction blocks
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)
    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
    at com.tibco.mdm.infrastructure.db.MQPreparedStatement.__executeUpdate(MQPreparedStatement.java:348)
    at com.tibco.mdm.infrastructure.db.DBUtil.executeUpdate(DBUtil.java:2993)
    at com.tibco.mdm.infrastructure.db.MqDebuggableStatement.executeUpdate(MqDebuggableStatement.java:409)
    at com.tibco.mdm.repository.relationship.dao.RelationshipDAO.saveCP_withCheckPoint(RelationshipDAO.java:566)
    at com.tibco.mdm.repository.relationship.dao.RelationshipDAO.createAllRelationship(RelationshipDAO.java:226)
    at com.tibco.mdm.repository.relationship.dao.RelationshipDAO.createAllRelationship(RelationshipDAO.java:142)
    at com.tibco.mdm.repository.relationship.dao.RelationshipDAO.createRelationshipInBatch(RelationshipDAO.java:122)
    at com.tibco.mdm.session.repository.core.CatalogProcessorSsnBean.createRelationshipInBatch(CatalogProcessorSsnBean.java:6198)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    at com.tibco.mdm.ui.infrastructure.MaliciousRequestContentFilter.doFilter(MaliciousRequestContentFilter.java:45)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
    at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
    at java.lang.Thread.run(Thread.java:724)
DBERRORCODE: 0
DBSTATE: 25P01
EXCEPTIONMESSAGE: ERROR: SAVEPOINT can only be used in transaction blocks
SQL: savepoint R_0
METHODNAME: MqDebuggableStatement.executeQuery()
ERRORMESSAGE: Failed to execute prepared statement - ERROR: SAVEPOINT can only be used in transaction blocks
<MqException: END>

Resolution:
=========
On creating Datasource through the JBoss console, it takes the Java Transaction API value as false. Open the standalone.xml file and search for "datasource".

<datasource jta="false" jndi-name="java:jboss/eCMDataSource" pool-name="test_ds" enabled="true" use-ccm="false">

Make jta="true" or remove the jta tag.

Issue/Introduction

TIBCO MDM Studio , throws an error while deploying a data model. "Code: SQL-8202: Failed while executing SQL statement..."

Additional Information

N/A