Error: Arithmetic overflow error converting expression to data type int

spaghettidba / WorkloadTools

A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud

MIT License

234 stars 53 forks source link

Error: Arithmetic overflow error converting expression to data type int #40

Closed goodsoul1914 closed 5 years ago

goodsoul1914 commented 5 years ago

seeing a lot of this type or entries in Warnings.log: Worker [325] - Error: Arithmetic overflow error converting expression to data type int. source SQL server 2016 analysis\replay: SQL server 2017

goodsoul1914 commented 5 years ago

looks like the log collecting all king of warnings\errors from replay server, I will figure the reason

spaghettidba commented 5 years ago

Warnings.log contains all the errors captured during the replay, so this is an error occurring on the target SQL Server instance. You should also find the offending statement in the log