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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.