Bula Vinaka Team,

We encountered the below issue while upgrading the OTGL database from V.8.1.6 to V.10.1.4.4:

The following are the Specifications of the Server:

• Windows Server 2012 R2 Standard
• Drive D Capacity: 465Gb
• Processor: Intel Xeon CPU 3.07GHZ
• Ram: 8GB

The database has been uploaded on FTP as "OTGL-LINKSOFT-10715.zip"

Please review and advise.

Regards,
Ravneet Kumar
Software Implementor

Hi Ravneet,

I have investigated the database and found an inconsistency.

Please apply the script below then continue with the upgrade.

The script has been included in version 10.146.

regards
Alvis

-------------Script below -----------

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[HR_EMP_TRAINING]') AND name = N'PK__HR_EMP_TRAINING__3631FF56')

ALTER TABLE [dbo].[HR_EMP_TRAINING] DROP CONSTRAINT [PK__HR_EMP_TRAINING__3631FF56]