TN 1365 Arithmetic Error during full reimport of InTouch tags with Tag Importer Wizard

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