TN - 1365 Arithmetic Error during full reimport of InTouch tags with Tag Importer Wizard
Description
This article from InSource shows how to address the Arithmetic Error during full reimport of InTouch tags with Tag Importer Wizard.
- Author: Kwame McDonald
- Published: 5/17/2023
- Applies to: Historian
Details
Goal
After completing this how-to you will have successfully resolved the arithmetic error below.
Description:
Invalid Value.
The statement has been terminated.
Arithmetic overflow error for type int, value = 214748648.000000.
Changed database context to 'Holding'.
First Step
Back up the Runtime and the Holding databases.
Second Step
Execute the following SQL query:
USE Runtime
GO
UPDATE AnalogTag SET MaxEU = 2000000000
WHERE Tagname NOT LIKE 'Sys%'
AND MaxEU > 2000000000
UPDATE AnalogTag SET MinEU = -2000000000
WHERE Tagname NOT LIKE 'Sys%' AND MaxEU < -2000000000
Do the same for MaxRaw & MinRaw.
What's Next
OR/AND
Change the data type from INT to BIGINT for the following columns in the intgDDEIOInfo table of the Holding database:
i_minValue
i_maxValue
diio_minRaw
diio_maxRaw