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