AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Sql server arithmetic overflow error11/14/2023 ![]() ![]() We didn’t need any of the logs, so truncating the table (which also resets the IDENTITY value) resolved the problem. And now it had exhausted its supply of IDENTITY values on the id column, triggering the execution/validation of any package logging to it to instantly fail and flood the operations log with overflow errors. Whoever installed SSIS on this box must have set it to the user database in question. This is the sysssislog table, usually found in msdb. Oh, what’s this? That doesn’t look like a user table…I wonder… For example from a numeric figure to an integer because the integer type can handle smaller figures compared to the numeric type. Let’s loop over all the user databases on the server and run the below script to check for identity columns of type int… SELECT OBJECT_NAME(c.) AS 'TableName', An arithmetic overflow error is an error faced when converting from one SQL Server data type to another one. So, we’re looking at system tables.īut I’d checked those? Well, I’d checked system databases… Clue #2 suggested the user tables were not even getting touched so could not be throwing overflow errors.
0 Comments
Read More
Leave a Reply. |