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".