Skip to Content
0
Former Member
Mar 18, 2014 at 05:18 PM

error: Arithmetic overflow occurred

285 Views

I have 2 sybase database:

one is production

one is restored from production for dev.

I try to run following

select "Procedure Cache Hit Ratio" = (Requests-Loads)*100/Requests from master..monProcedureCache

on dev, it is fine. I got Hit Ratio percentage.

But when I run it on production, I got error:

Arithmetic overflow occurred

Both production and dev has same ASE 12.5.4. How to find out the reason and fix it?