WebCenter Analytics Search Report Returns No Results and Causes java.sql.sqlexception: numeric overflow error (Doc ID 1176764.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle WebCenter Analytics - Version 10.3.0.1 to 10.3.0.1
Information in this document applies to any platform.

Symptoms

When executing a search report in WebCenter Analytics Console in WebCenter Interaction portal, results may not displayed.

To be more specific, if a search term that would appear in the report has more than 127 hits, then this problem will occur. This typically occurs when you run a report that covers a long time range like several months. Additionally, the following error will appear in the wrapper.log file:

INFO | jvm 1 | 2009/08/03 14:15:05 |
com.plumtree.analytics.core.exception.AnalyticsRuntimeException: could not
execute query!
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.report.dataprovider.BaseDataProvider.getDataSet(BaseDataProvider.java:135)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.report.dataprovider.DataProviderWrapper.getDataSet(DataProviderWrapper.java:20)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.ui.faces.handler.ReportHandler.generateReport(ReportHandler.java:398)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
java.lang.reflect.Method.invoke(Method.java:585)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
javax.faces.component.UICommand.broadcast(UICommand.java:312)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:887)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:696)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2009)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
java.lang.Thread.run(Thread.java:595)
INFO | jvm 1 | 2009/08/03 14:15:05 | Caused by:
com.plumtree.analytics.query.QueryException: could not execute Hibernate
query
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.query.QueryManagerImpl.queryData(QueryManagerImpl.java:793)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.query.QueryManagerImpl.getRankingDimIds(QueryManagerImpl.java:251)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:116)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.query.QueryManagerImpl.executeResultSetQuery(QueryManagerImpl.java:59)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.report.dataprovider.BaseDataProvider.getDataSet(BaseDataProvider.java:132)
INFO | jvm 1 | 2009/08/03 14:15:05 | ... 29 more
INFO | jvm 1 | 2009/08/03 14:15:05 | Caused by:
org.hibernate.exception.GenericJDBCException: could not execute query
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.Loader.doList(Loader.java:1596)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.Loader.list(Loader.java:1577)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.analytics.query.QueryManagerImpl.queryData(QueryManagerImpl.java:737)
INFO | jvm 1 | 2009/08/03 14:15:05 | ... 33 more
INFO | jvm 1 | 2009/08/03 14:15:05 | Caused by: java.sql.SQLException:
[plumtree][SQLServer JDBC Driver]Numeric overflow.

INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.jdbc.base.BaseExceptions.createException(Unknown Source)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.jdbc.base.BaseExceptions.getException(Unknown Source)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.jdbc.base.BaseData.getByte(Unknown Source)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.jdbc.base.BaseResultSet.getByte(Unknown Source)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.jdbc.base.BaseResultSet.getByte(Unknown Source)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.connectionpool.pool.PooledResultSet.getByte(PooledResultSet.java:370)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
com.plumtree.connectionpool.pool.LeasedResultSet.getByte(LeasedResultSet.java:158)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.type.ByteType.get(ByteType.java:26)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:77)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:68)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.hql.QueryLoader.getResultColumnOrRow(QueryLoader.java:357)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:329)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.Loader.doQuery(Loader.java:412)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
INFO | jvm 1 | 2009/08/03 14:15:05 | at
org.hibernate.loader.Loader.doList(Loader.java:1593)
INFO | jvm 1 | 2009/08/03 14:15:05 | ... 39 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms