AnsweredAssumed Answered

SQL Server failed to resume the transaction Desc:10d000000d3 when upgrading from 14.3 to 15.2

Question asked by KarimD on Jun 8, 2017
Latest reply on Jun 8, 2017 by Suman Pramanik

Hello,

 

We are facing a issue that failed our upgrade from 14.3 to 15.2. The error is below :

 

BEGIN
6/06/17 6:41 PM (ExecTask) EXEC CMN_DROP_DEFAULT_CONSTRAINT_SP 'DWH_INV_PERIOD_FACTS', 'FCST_OPER_COST';
6/06/17 6:41 PM (ExecTask) UPDATE DWH_INV_PERIOD_FACTS SET FCST_OPER_COST = '0' WHERE FCST_OPER_COST IS NULL;
6/06/17 6:41 PM (ExecTask) ALTER TABLE DWH_INV_PERIOD_FACTS ALTER COLUMN FCST_OPER_COST NUMERIC ( 32, 6 ) NOT NULL;
6/06/17 6:41 PM (ExecTask) java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The server failed to resume the transaction. Desc:10d000000d3.
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.ddcw.b(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.ddcw.a(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.ddcv.b(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.ddcv.a(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserver.dda3.m(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.dde7.e(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.dde7.a(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.dde7.x(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.dde7.t(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at com.ca.clarity.jdbc.sqlserverbase.dde7.execute(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
6/06/17 6:41 PM (ExecTask)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
6/06/17 6:41 PM (ExecTask)  at java.lang.reflect.Method.invoke(Method.java:497)
6/06/17 6:41 PM (ExecTask)  at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
6/06/17 6:41 PM (ExecTask)  at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$93ab4440.execute(<generated>)
6/06/17 6:41 PM (ExecTask)  at com.niku.dbtools.Utilities.executeAndCommitSql(Utilities.java:2764)
6/06/17 6:41 PM (ExecTask)  at com.niku.dbtools.DriverApp.apply(DriverApp.java:1502)
6/06/17 6:41 PM (ExecTask)  at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:722)
6/06/17 6:41 PM (ExecTask)  at com.niku.dbtools.Utilities.run(Utilities.java:1864)
6/06/17 6:41 PM (ExecTask)  at com.niku.dbtools.Utilities.main(Utilities.java:977)
6/06/17 6:41 PM (ExecTask) ALTER TABLE DWH_INV_PERIOD_FACTS ADD  DEFAULT '0' for FCST_OPER_COST;
6/06/17 6:41 PM (ExecTask) END

 

I had this error several times and I think it happens when upgrading data warehouse database.

 

Any idea to resolve this issue will be appreciated ?

 

Regards,

Karim

Attachments

Outcomes