VMware Workspace ONE Community
rmann100
Contributor
Contributor

Database update fails 2206.48 to 2209

Not able to upgrade past 2206.48 anyone seen this? 

Script execution error. The executed script:
CREATE FUNCTION dbo.TryConvertAppleOSVersionToNumeric
(@BuildVersion CHAR (16))
RETURNS BIGINT
AS
BEGIN
DECLARE @FirstAlphabet AS INT = 0;
DECLARE @SecondAlphabet AS INT = 0;
DECLARE @Result AS BIGINT;
IF (PATINDEX('%[0-9][A-Z][0-9]%', @BuildVersion) = 0
OR PATINDEX('%[A-Z][A-Z]%', @BuildVersion) > 0)
RETURN NULL;
SELECT @FirstAlphabet = PATINDEX('%[A-Z]%', @BuildVersion);
SELECT @SecondAlphabet = PATINDEX('%[a-z]%', SUBSTRING(@BuildVersion, @FirstAlphabet + 1, LEN(@BuildVersion) - @FirstAlphabet));
DECLARE @FirstPart AS VARCHAR (3) = RIGHT('000' + SUBSTRING(@BuildVersion, 1, @FirstAlphabet - 1), 3);
DECLARE @SecondPart AS VARCHAR (3) = RIGHT('000' + CAST (ASCII(SUBSTRING(@BuildVersion, @FirstAlphabet, 1)) AS VARCHAR), 3);
DECLARE @ThirdPart AS VARCHAR (5);
DECLARE @FourthPart AS VARCHAR (3) = '000';
IF (@SecondAlphabet > 0)
BEGIN
SELECT @ThirdPart = RIGHT('00000' + SUBSTRING(@BuildVersion, @FirstAlphabet + 1, @
2024-03-06 20:42:37.322 [INFO] An error occurred while the batch was being executed.
2024-03-06 20:42:37.334 [INFO] Updating database (Failed)

0 Kudos
0 Replies