I am unable to update to SCSM 2019 UR2 on our Data Warehouse server. Receiving Error Code: 0x80040E14. Any suggestions? Thank you
Details from the log files:
ExecuteSql: Failed to execute SQL script. Error Code: 0x80040E14. SET NOCOUNT ON;
DECLARE @Statement nvarchar(4000) ;
DECLARE table_cursor CURSOR FOR
SELECT 'ALTER TABLE .
ALTER COLUMN '+ COLUMN_NAME +' decimal(19,0);'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE ( TABLE_NAME LIKE '%CMv5_DISK' OR TABLE_NAME LIKE '%vex_GS_DISK') AND
COLUMN_NAME = 'Size0' AND DATA_TYPE != 'decimal' ;
OPEN table_cursor
FETCH NEXT FROM table_cursor
INTO @Statement
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC sp_sqlexec @Statement
FETCH NEXT FROM table_cursor
INTO @Statement
END
CLOSE table_cursor;
DEALLOCATE table_cursor;
DECLARE table_cursor CURSOR FOR
SELECT 'ALTER TABLE .
ALTER COLUMN '+ COLUMN_NAME +' decimal(19,0);'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME LIKE '%CMv5_LOGICAL_DISK' OR TABLE_NAME LIKE '%vex_GS_LOGICAL_DISK') AND
(COLUMN_NAME = 'Size0' OR COLUMN_NAME = 'FreeSpace0') AND
DATA_TYPE != 'decimal' ;
OPEN table_cursor
FETCH NEXT FROM table_cursor
INTO @Statement
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC sp_sqlexec @Statement
FETCH NEXT FROM table_cursor
INTO @Statement
END
CLOSE table_cursor;
DEALLOCATE table_cursor;
DECLARE table_cursor CURSOR FOR
SELECT 'ALTER TABLE .
ALTER COLUMN '+ COLUMN_NAME +' decimal(19,0);'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME LIKE '%CMv5_OPERATING_SYSTEM' OR TABLE_NAME LIKE '%vex_GS_OPERATING_SYSTEM') AND
COLUMN_NAME = 'TotalVisibleMemorySize0' AND
DATA_TYPE != 'decimal' ;
OPEN table_cursor
FETCH NEXT FROM table_cursor
INTO @Statement
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC sp_sqlexec @Statement
FETCH NEXT FROM table_cursor
INTO @Statement
END
CLOSE table_cursor;
DEALLOCATE table_cursor;
/*Bug-420319 - Dimension Table fix for OperatingSystem table /
IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'OperatingSystemDim' and COLUMN_NAME = 'PhysicalMemory' and DATA_TYPE != 'decimal')
BEGIN
/ Dropping Indexes */
DROP INDEX IF EXISTS NCI0_OperatingSystemDim on dbo.OperatingSystemDim;
DROP INDEX IF EXISTS NCI1_OperatingSystemDim on dbo.OperatingSystemDim;
/* Altering Data Type */
ALTER TABLE dbo.OperatingSystemDim ALTER COLUMN PhysicalMemory decimal(19,0);
/*Recreating Indexes */
CREATE INDEX NCI0_OperatingSystemDim on dbo.OperatingSystemDim(InsertedBatchId)
INCLUDE(OperatingSystemDimKey,BaseManagedEntityId,EntityDimKey,SourceId,OSVersion,OSVersionDisplayName,ProductType,
BuildNumber,CSDVersion,ServicePackVersion,SerialNumber,InstallDate,SystemDrive,WindowsDirectory,PhysicalMemory,
LogicalProcessors,CountryCode,Locale,Description,Manufacturer,OSLanguage,MinorVersion,MajorVersion,ObjectStatus_ConfigItemObjectStatusId,
ObjectStatus,AssetStatus_ConfigItemAssetStatusId,AssetStatus,Notes,DisplayName,IsDeleted ,UpdatedBatchId);
CREATE INDEX NCI1_OperatingSystemDim on dbo.OperatingSystemDim(UpdatedBatchId)
INCLUDE(OperatingSystemDimKey,BaseManagedEntityId,EntityDimKey,SourceId,OSVersion,OSVersionDisplayName,ProductType,
BuildNumber,CSDVersion,ServicePackVersion,SerialNumber,InstallDate,SystemDrive,WindowsDirectory,PhysicalMemory,
LogicalProcessors,CountryCode,Locale,Description,Manufacturer,OSLanguage,MinorVersion,MajorVersion,ObjectStatus_ConfigItemObjectStatusId,
ObjectStatus,AssetStatus_ConfigItemAssetStatusId,AssetStatus,Notes,DisplayName,IsDeleted ,InsertedBatchId);
/*Refreshing View After datatype change */
IF EXISTS (SELECT 1 from INFORMATION_SCHEMA.VIEWS where TABLE_NAME = 'OperatingSystemDimvw')
BEGIN
EXEC sp_refreshview 'dbo.OperatingSystemDimvw';
END
END
/*Bug-420319 - Dimension Table fix for LogicalDisk table */
IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'LogicalDiskDim' and COLUMN_NAME = 'Size' and DATA_TYPE != 'decimal')
BEGIN
/Altering DataType/
ALTER TABLE dbo.LogicalDiskDim ALTER COLUMN Size decimal(19,0);
/*Refreshing View after datatype change */
IF EXISTS (SELECT 1 from INFORMATION_SCHEMA.VIEWS where TABLE_NAME = 'LogicalDiskDimvw')
BEGIN
EXEC sp_refreshview 'dbo.LogicalDiskDimvw';
END
END
if object_id (N'etl.ShredWaterMark', N'IF') is not null
drop function etl.ShredWaterMark;. Additional Error Description : Incorrect syntax near the keyword 'IF'.
ExecuteSqlScriptFileFromMsi: Failed to execute sql script in the specified file. Error Code: 0x80040E14. E:\Program Files\Microsoft System Center\Service Manager\DW\build_scdw_db.sql