SAP Knowledge Base Article - Preview

2870672 - Cockpit KPI_ASE_SERVER_TRANSACTIONS Numeric Overflow - SAP ASE

Symptom

Using ASE Cockpit monitoring collections (out-of-the-box) are enabled.  In a situation where a very high volume of transactions (greater than 2147483648) is being processed, the following error is encountered:

2019-11-09 01:47:33,205 [ERROR] [ASEMAP ] [scc-scc-collections-thread::256818] com.sybase.ua.plugins.asemap.mo.ASEMO.collect_KPI_ASE_SERVER_TRANSACTIONS(2967) - [DDB] [error#=0] java.sql.SQLException: JZ00B: Numeric overflow.

com.sybase.aseaccess.exception.AALSQLException: java.sql.SQLException: JZ00B: Numeric overflow.
at com.sybase.aseaccess.sql.ASEResultSet.getColumnInt(ASEResultSet.java:847)
at com.sybase.aseaccess.container.TransactionsContainer.getMonKPA(TransactionsContainer.java:151)
at com.sybase.ua.plugins.asemap.mo.ASEMO.collect_KPI_ASE_SERVER_TRANSACTIONS(ASEMO.java:2932)
at com.sybase.ua.plugins.asemap.mo.ASEMO.collectDataFor_ASE_PERFORMANCE_APCA(ASEMO.java:1872)
at com.sybase.ua.plugins.asemap.mo.ASEMO.managedResourceCollect(ASEMO.java:1681)
at com.sybase.ua.plugins.asemap.mo.ASEMO.doKPACollect(ASEMO.java:1656)
at com.sybase.ua.plugins.asemap.mo.ASEMO.doCollect(ASEMO.java:1541)
at sun.reflect.GeneratedMethodAccessor333.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
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:298)
at com.sun.proxy.$Proxy78.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.run(FutureTask.java:266)
at com.sybase.scc.tess.impl.TaskUtil$WrappedRunnable.call(Unknown Source)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at com.sybase.ua.util.concurrent.TimedFutureTask.run(Unknown Source)
at com.sybase.scc.tess.impl.ManagedTask.run(Unknown Source)
at com.sybase.scc.tess.impl.IdlePreferredThreadPool$WorkerThread.runTask(Unknown Source)
at com.sybase.scc.tess.impl.IdlePreferredThreadPool$WorkerThread.runWorker(Unknown Source)
at com.sybase.scc.tess.impl.IdlePreferredThreadPool$WorkerThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:836)
Caused by: java.sql.SQLException: JZ00B: Numeric overflow.
at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:774)
at com.sybase.jdbc4.jdbc.Convert.checkIntOflo(Convert.java:1818)
at com.sybase.jdbc4.tds.TdsInt.getInt(TdsInt.java:105)
at com.sybase.jdbc4.jdbc.SybResultSet.getInt(SybResultSet.java:461)
at com.sybase.jdbc4.jdbc.SybResultSet.getInt(SybResultSet.java:879)
at com.sybase.aseaccess.sql.ASEResultSet.getColumnInt(ASEResultSet.java:843)


Read more...

Environment

  • Adaptive Server Enterprise 16.0 and higher
  • Cockpit repository RDBMS = SQL Anywhere, version: 16.0.0.2547
  • JDBC driver: SQL Anywhere JDBC Driver, version: 16.00.2547

Product

SAP Adaptive Server Enterprise 16.0

Keywords

ASEMAP, KPI, transactions, getColumnInt, integer, long, getColumnLong, collections, numeric overflow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.