Upgrading from 2021.1.9 to 2022.1.6 - Execution Timeout Expired

Kinetic ERP
1

Getting the following error upgrading from 11.1.100.9 to 11.2.100.6. I did a data purge on the GLTran table in the test environment to reduce the size, but still get the same error.

dbmigration
dbmigration1061×879 45.9 KB

…
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: MigratePatchFldUOM.sql
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: MigratePatchFldXbSyst.sql
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: UpdateARMovement.sql
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: UpdateFSCallDt.sql
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: UpdateTaxSvcConfig.sql
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: UpdateXFileAttch.sql
Information Upgrade Process Upgrade Process ERP11.2.100.0~ Executing: UpdateXFileAttchForECOMtlECOOprPartMtlPartOpr.sql
Error Upgrade Process ModifyTranGLC.sql Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
if not exists (select 1 from information_schema.co
Error Upgrade Process ModifyTranGLC.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyVendor.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyVendor.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyXbSyst.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyXbSyst.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyXbSyst.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyXbSyst.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyXbSyst.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
Error Upgrade Process ModifyXbSyst.sql ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed.
…

2

Now upgrading from 2021.1.9 to 2022.2.14 and getting the same error. I was able to resolve this issue by increasing the TempDB drive for the upgrade. A 500GB database with a 30GB TempDB was too small. Increase the drive to 60GB.

1 Like
3

Hi Ken,
Looks like an issue with your database server. Can you share the logs from that server out of SSMS?
Thanks