Clarity

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

Hi Karim,

You are correct, it was upgrading DWH but the problem looks to be specific to database. Can you check with DBA to see if the transaction log is full or the server have the space.

Regards

Suman Pramanik 

Hi Karim,

Did you get any resolution for this.

See if this help The server failed to resume the transaction… Why? – Microsoft JDBC Driver for SQL Server Team Blog