This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 13%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Hello, I manage a Trellix EPO server here at work which records data to SQL Server and when I try to upgrade to the latest EPOI software, I get the following error below. Can somebody kindly give me step by step instructions on how to fix this? I am a SQL beginner and have never encountered this error before.
Error: Failed to execute sql –update the existing records in the table.update pp set verproductversion=cast(convert(varchar,verproductmajor),3) +right (‘000000’ +convert (varchar, verproductrevision), 6) +right(‘000000’ +convert varchar, verproductbuild),6) as bigint) from EPOProductpropertiesmt ppjoin epoproductversionsmt as v on v.parentid = pp.autoid execution failed with error : requesterror: arithmetic overflow error converting expression to data type bigint
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Gene Abutin
You can take a look at the answers below. If it helps you, please accept it.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Can you post the exact update statement that failed? The one you posted has syntax errors.
I can simulate the error with the following:
SELECT cast(convert(varchar,9999999,3) +right ('000000' +convert (varchar, '999999'), 6) +right('000000' +convert (VARCHAR, '999999'),6) as bigint)
You may need to use the same RIGHT expression for the first portion of the string.
I have to type it since this is on another computer. I believe the below is right.
error: Failed to execute SQL --Update the existing records in the Table.UPDATE pp SET verProductVersion=CAST (CONVERT (VARCHAR,verProductMajor) +RIGHT('000' +CONVERT (VARCHAR, verProductMinor),3) +RIGHT('000000' +CONVERT(VARCHAR,verProductRevision),6) +RIGHT('000000'+CONVERT(VARCHAR,verProductBuild),6) AS BIGINT)FROM EPOProductPropertiesMT PpJOIN EPOProductVersionsMT as v on v.PARENTID = Pp.AutoID execution failed with error : RequestError : Arithmetic overflow error converting expression to data type bigint.
Try to change the very first portion of the code too, e.g.
select CONVERT (RIGHT('000' + CONVERT(VARCHAR,verProductMajor),3) +RIGHT('000' +CONVERT (VARCHAR, verProductMinor),3) +RIGHT('000000' +CONVERT(VARCHAR,verProductRevision),6) +RIGHT('000000'+CONVERT(VARCHAR,verProductBuild),6) AS BIGINT)FROM EPOProductPropertiesMT PpJOIN EPOProductVersionsMT as v on v.PARENTID = Pp.AutoID
The verProductMajor probably has bad data and is more than 3 digits.
For everyone awareness this worked after I modified the verProductRevision,3
UPDATE pp SET verProductVersion=CAST (CONVERT (VARCHAR,verProductMajor) +
RIGHT('000' +CONVERT (VARCHAR, verProductMinor),3) +
RIGHT('000' +CONVERT(VARCHAR,verProductRevision),3) + <<change 00000 to 000 and 6 to 3
RIGHT('000000'+CONVERT(VARCHAR,verProductBuild),6) AS BIGINT)
FROM EPOProductPropertiesMT PpJOIN EPOProductVersionsMT as v on v.PARENTID = Pp.AutoID
Now to figure out how to force the upgrade to use this command instead of the other command.
If I understand this, you get this error when trying to upgrade a third-party product. I think you should open a support case with the software vendor. We may be able to help you to fix the problematic statement, but the fix may not be correct in the bigger scheme of things and cause more problems down the road.