Skip to Content
0
Jul 25, 2017 at 01:07 PM

Arithmetic overflow occurred on Sybase query

1634 Views

Hi

This query works on QA, but fails on DEV with "Arithmetic overflow occurred".

SELECT lct_admin('num_logpages', dbid) UsedPages, lct_admin('logsegment_freepages',dbid) FreePages,100.0 - lct_admin('num_logpages', dbid) * 100.0 /(lct_admin('logsegment_freepages',dbid) + lct_admin('num_logpages', dbid)) PctFree FROM master..sysdatabases WHERE name = 'MED'

I need to get it working, as it is build into a script that need to execute.

Please advise?