cancel
Showing results for 
Search instead for 
Did you mean: 

error: Arithmetic overflow occurred

Former Member
0 Kudos

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?

Former Member
0 Kudos

Thank you, Mark. It's working. but wondering why it is oaky on my dev? any server parameter to impact this?

Accepted Solutions (0)

Answers (0)