Manual DB upgrade steps to version 24.0.0 fail with: An explicit value for the identity column in table 'LASLM' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Products

• CA Automic Workload Automation - Automation Engine
• Automic SaaS
• CA Automic One Automation
• CA Automic Service Orchestration - Automation Engine

Issue/Introduction

As part of the upgrade to Automic version 24.0.0 the package PCK.AUTOMIC_UTF-8.MIGRATION provides some manual database SQL statements.

One of them is the following:

insert into [LASLM] select * from DB.dbo.[LASLM]; 

This insert into statement is failing with the following message:

An explicit value for the identity column in table 'LASLM' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Environment

PCK.AUTOMIC_UTF-8.MIGRATION 1.0.2

MS SQL Server

Cause

Defect.

Resolution

As a workaround for now the statement can be changed from:

insert into [LASLM] select * from DB.dbo.[LASLM]; 

To:

insert into [LASLM] (LASLM_Client,LASLM_AH_Idnr,LASLM_SloName,LASLM_ServName,LASLM_ServOType,LASLM_ServRunId,LASLM_ServFStatus,LASLM_ServMsgNr,LASLM_ServMsgIns,LASLM_ServOH_Idnr,LASLM_DetectTime,LASLM_Idnr,LASLM_Date,LASLM_OH_Idnr,LASLM_LastUpdate) select LASLM_Client,LASLM_AH_Idnr,LASLM_SloName,LASLM_ServName,LASLM_ServOType,LASLM_ServRunId,LASLM_ServFStatus,LASLM_ServMsgNr,LASLM_ServMsgIns,LASLM_ServOH_Idnr,LASLM_DetectTime,LASLM_Idnr,LASLM_Date,LASLM_OH_Idnr,LASLM_LastUpdate from DB.dbo.[LASLM];

Additional Information

Defect-ID: DE124856