SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.