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.
SAP Knowledge Base Article - Preview