Omatic Support

Hi everyone, we were performing an import that creates a gift batch. When the files were finished importing and the gift batch was going to be saved, we received the following error: Line 1: Error saving batch on data row # 1. Error = 'General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar value '-2147219858' overflowed an INT2 column. Use a larger integer column.
Native error:244
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Native error:3621

'.

 

Has anyone else experienced this error, and does anyone know the fix?

 

Thanks!

Jocelyn Brulotte,

Edmonton Humane Society

Hi Ann,

I would refer to this knowledgebase article and if you are still experiencing the issue feel free to reach out to our support team https://omaticsoftware.freshdesk.com/support/solutions/articles/28000006411-error-error-saving-batch-on-data-row-1-error-general-odbc-error-microsoft-odbc-sql-server-d

Thanks!

John