My Oracle Support Banner

OPA Java Process Crashing Intermittently (Doc ID 2572794.1)

Last updated on AUGUST 16, 2019

Applies to:

Oracle Policy Automation - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

In Oracle Policy Automation 12.2.9 attempting to view an interview the following error occurs.

ERROR
-----------------------
<[HubRuntimeMonitorThread]> (SessionStatisticsDAOImpl.java:484) -  SQL exception occurred while creating session statistics
java.sql.SQLException: Invalid conversion requested
at oracle.jdbc.driver.T4CVarcharAccessor.StringToNUMBER(T4CVarcharAccessor.java:772)
at oracle.jdbc.driver.T4CVarcharAccessor.getNUMBER(T4CVarcharAccessor.java:242)
at oracle.jdbc.driver.T4CVarcharAccessor.getLong(T4CVarcharAccessor.java:540)
at oracle.jdbc.driver.GeneratedStatement.getLong(GeneratedStatement.java:206)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getLong(GeneratedScrollableResultSet.java:259)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleReturnResultSet.getLong(Unknown Source)
at com.oracle.determinations.hub.storage.jdbc.SessionStatisticsDAOImpl.createSessionStatistics(SessionStatisticsDAOImpl.java:480)
at com.oracle.determinations.hub.service.impl.StatisticsServiceImpl._initialiseSessionStatistics(StatisticsServiceImpl.java:119)
at com.oracle.determinations.hub.runtime.instrumentation.event.HubStartNewSessionStatisticsEvent.process(HubStartNewSessionStatisticsEvent.java:15)
at com.oracle.determinations.hub.runtime.instrumentation.HubSessionStatisticsLogger.processQueue(HubSessionStatisticsLogger.java:193)
at com.oracle.determinations.hub.runtime.instrumentation.HubSessionStatisticsLogger.access$1200(HubSessionStatisticsLogger.java:20)
at com.oracle.determinations.hub.runtime.instrumentation.HubSessionStatisticsLogger$HubSessionStatisticsHeartbeatListener.notify(HubSessionStatisticsLogger.java:263)
at com.oracle.determinations.hub.runtime.monitor.HubRuntimeMonitor.refresh(HubRuntimeMonitor.java:1301)
at com.oracle.determinations.hub.runtime.monitor.HubRuntimeMonitorRunnable.run(HubRuntimeMonitorRunnable.java:40)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NumberFormatException
at java.math.BigDecimal.(BigDecimal.java:494)
at java.math.BigDecimal.(BigDecimal.java:383)
at java.math.BigDecimal.(BigDecimal.java:806)
at oracle.jdbc.driver.T4CVarcharAccessor.StringToNUMBER(T4CVarcharAccessor.java:767)
... 14 more
<[HubRuntimeMonitorThread]> (StatisticsServiceImpl.java:124) - Hub runtime exception occurred while initialising session statistics
com.oracle.determinations.hub.exception.HubStorageException: SQL exception occurred while creating session statistics
at com.oracle.determinations.hub.storage.jdbc.SessionStatisticsDAOImpl.createSessionStatistics(SessionStatisticsDAOImpl.java:485)
at com.oracle.determinations.hub.service.impl.StatisticsServiceImpl._initialiseSessionStatistics(StatisticsServiceImpl.java:119)
at com.oracle.determinations.hub.runtime.instrumentation.event.HubStartNewSessionStatisticsEvent.process(HubStartNewSessionStatisticsEvent.java:15)
at com.oracle.determinations.hub.runtime.instrumentation.HubSessionStatisticsLogger.processQueue(HubSessionStatisticsLogger.java:193)
at com.oracle.determinations.hub.runtime.instrumentation.HubSessionStatisticsLogger.access$1200(HubSessionStatisticsLogger.java:20)
at com.oracle.determinations.hub.runtime.instrumentation.HubSessionStatisticsLogger$HubSessionStatisticsHeartbeatListener.notify(HubSessionStatisticsLogger.java:263)
at com.oracle.determinations.hub.runtime.monitor.HubRuntimeMonitor.refresh(HubRuntimeMonitor.java:1301)
at com.oracle.determinations.hub.runtime.monitor.HubRuntimeMonitorRunnable.run(HubRuntimeMonitorRunnable.java:40)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Invalid conversion requested
at oracle.jdbc.driver.T4CVarcharAccessor.StringToNUMBER(T4CVarcharAccessor.java:772)
at oracle.jdbc.driver.T4CVarcharAccessor.getNUMBER(T4CVarcharAccessor.java:242)
at oracle.jdbc.driver.T4CVarcharAccessor.getLong(T4CVarcharAccessor.java:540)
at oracle.jdbc.driver.GeneratedStatement.getLong(GeneratedStatement.java:206)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getLong(GeneratedScrollableResultSet.java:259)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleReturnResultSet.getLong(Unknown Source)
at com.oracle.determinations.hub.storage.jdbc.SessionStatisticsDAOImpl.createSessionStatistics(SessionStatisticsDAOImpl.java:480)
... 8 more
Caused by: java.lang.NumberFormatException
at java.math.BigDecimal.(BigDecimal.java:494)
at java.math.BigDecimal.(BigDecimal.java:383)
at java.math.BigDecimal.(BigDecimal.java:806)
at oracle.jdbc.driver.T4CVarcharAccessor.StringToNUMBER(T4CVarcharAccessor.java:767)
... 14 more


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.