I have a simple script in a “Value Changed” event that collects a few tags and inserts them into a database as a single row. All was well when using MySQL however a decision was made to move to SQLServer 2012 and we now have problem. One of the tags is an int8 (its actually a timestamp in ms since 1970 whatever currently in the order of 1,494,220,442,943,758) causes an error in the runPrepUpdate() function. Hard coding the value into the script does not work but hard coding a much smaller number does, it can be a bit bigger than an int4 but not much. If the data has been written to the database with a smaller number I can then overwrite it using SSMS with the correct value so the database is configured correctly to handle large numbers (bigint).
Any suggestions on what might be wrong or how I go about debugging this error would be greatly appreciated. Ignition doesn’t seem to give me a very descriptive error. Just that there is an error executing system.db.runPrepUpdate(query,args,“IgnitionSQLServer”).