The Upgrade Has Errored Out At Step : Generate And Update Statistics File (Doc ID 2030839.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11 [IP2013] version, Upgrade

When attempting upgrade from 7.8.2.16 [19255] LANG_INDEPENDENT to 8.1.1.11 SIA [23030] ENU has errored out at step : Generate and Update Statistics File

ERROR
-----------------------
D:\Siebel\8.1.1.11.0\ses\siebsrvr\log\upgrep_prod_782\output/ddlctl_tab.log /Z Y).UpgradeLog UpgradeError 1 0000000255a015e8:0 2015-07-10 20:59:06 There was an error in launching the application.UpgradeLog UpgradeError 1 0000000255a015e8:0 2015-07-10 20:59:06 Execute file action failed.UpgradeLog UpgradeError 1 0000000255a015e8:0 2015-07-10 20:59:06 Error executing action ().

and in the On further checking the log file ddlctl_tab.log we could see a time out error:
  add "UPG_ICL_PATH_CD" vargraphic(30)2015-07-10 20:59:06 [IBM][CLI Driver][DB2/NT64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=400012015-07-10 20:59:06
2015-07-10 20:59:06 40001: [IBM][CLI Driver][DB2/NT64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".


STEPS
-----------------------

We are doing a uphgrade from 7.8.2.16 [19255] LANG_INDEPENDENT to 8.1.1.11 SIA [23030] ENU

Product Version is to 8.1.1.11 SIA [23030] ENU

During the run of the Siebel Upgrade Wizard
We are running into a timeout or deadlok in step Generate and Update Statistics File
We found this error in file upgwiz.log

D:\Siebel\8.1.1.11.0\ses\siebsrvr\log\upgrep_prod_782\output/ddlctl_tab.log /Z Y).UpgradeLog UpgradeError 1 0000000255a015e8:0 2015-07-10 20:59:06 There was an error in launching the application.

UpgradeLog UpgradeError 1 0000000255a015e8:0 2015-07-10 20:59:06 Execute file action failed.UpgradeLog UpgradeError 1 0000000255a015e8:0 2015-07-10 20:59:06 Error executing action ().

and in the ddlctl_tab.log we could see a time out error:


  add "UPG_ICL_PATH_CD" vargraphic(30)2015-07-10 20:59:06 [IBM][CLI Driver][DB2/NT64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=400012015-07-10 20:59:06
2015-07-10 20:59:06 40001: [IBM][CLI Driver][DB2/NT64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms