2526521 - SCC Alert only reports free segment 0 - SAP ASE

• Alerts are not retrieving space and report a free segment space of 0. 
• The agent.log file reports the error:

2017-09-14 05:57:11,489 [ERROR] [ASEMAP ] [scc-collections-thread-522] com.sybase.ua.plugins.asemap.mo.SegmentMO.collectKpiAseSegmentSpaceUsage(245) - [DATABASE_NAME] [error#=3606] Arithmetic overflow occurred.

com.sybase.aseaccess.exception.AALSQLException: com.sybase.jdbc4.jdbc.SybSQLException: Arithmetic overflow occurred.

at com.sybase.aseaccess.sql.ASEResultSet.open(ASEResultSet.java:405)
at com.sybase.aseaccess.sql.ASEResultSet.open(ASEResultSet.java:301)
at com.sybase.aseaccess.sql.ASEResultSet.open(ASEResultSet.java:289)
at com.sybase.aseaccess.controller.SegmentController.getMonKPA(SegmentController.java:1008)
at com.sybase.ua.plugins.asemap.mo.SegmentMO.collectKpiAseSegmentSpaceUsage(SegmentMO.java:210)
at com.sybase.ua.plugins.asemap.mo.SegmentMO.managedResourceCollect(SegmentMO.java:184)
at com.sybase.ua.plugins.asemap.mo.SegmentMO.doCollect(SegmentMO.java:145)
at sun.reflect.GeneratedMethodAccessor442.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:75)
at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:279)
at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:112)
at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:46)
at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(MBeanIntrospector.java:237)
at com.sun.jmx.mbeanserver.PerInterface.invoke(PerInterface.java:138)
at com.sun.jmx.mbeanserver.MBeanSupport.invoke(MBeanSupport.java:252)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
at javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:292)
at com.sun.proxy.$Proxy49.doCollect(Unknown Source)
at com.sybase.ua.services.scc.collect.CollectionTask$MOCollectionTask.call(Unknown Source)
at com.sybase.ua.services.scc.collect.CollectionTask$MOCollectionTask.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:791)
Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Arithmetic overflow occurred.

at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4003)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3093)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2408)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2394)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:552)
at com.sybase.aseaccess.sql.ASEResultSet.open(ASEResultSet.java:317)
... 33 more

• The following query:

select SizeMB=convert(numeric(12,3),
         convert(float,sum(u.size))*@@maxpagesize/1048576),
         UnusedSizeMB=convert(numeric(12,3),(convert(float,sum(u.size))- sum(u.size - curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs)))*@@maxpagesize/1048576)
from prcldb.dbo.syssegments s, master.dbo.sysusages u
where 1 = 1 and 
         ((u.segmap / ((s.segment & 1) + 1)) / power(2, (s.segment & 30))) & 1 = 1 and
         u.dbid = db_id("prcldb") and
         s.name = "logsegment"

• returns the error:

Msg 3606, Level 16, State 0:
Server 'myASE', Line 1:
Arithmetic overflow occurred.

• SAP Adaptive Server Enterprise 15.7 and 16.0
• SAP Control Center (SCC)
• SAP Cockpit

CR810973, CR#810973, 810973, KPI, unreserved , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed