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
After completing this how-to you will have successfully resolved the arithmetic error below.
The statement has been terminated.
Arithmetic overflow error for type int, value = 214748648.000000.
Changed database context to 'Holding'.
Back up the Runtime and the Holding databases.
Execute the following SQL query:
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.
Change the data type from INT to BIGINT for the following columns in the intgDDEIOInfo table of the Holding database: