Many ORA-00001 Errors Thrown For A Specific Thread Pool Worker (Doc ID 2084352.1)

Last updated on DECEMBER 07, 2015

Applies to:

Oracle Utilities Meter Data Management - Version 2.1.0.2 and later
Information in this document applies to any platform.

Symptoms

In Meter Data Management version 2.1 when running batch jobs with multiple threadpoolworker threads, the same ORA-00001 / unique constraint error occurs numerous times in logs. The error can be resolved by restarting threadpoolworker.

00:06:12,806 [TPW_BATCH01Worker:1] ERROR
(org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-00001:
????(CISADM.F1T196P0)???????

00:06:12,807 [TPW_BATCH01Worker:1] ERROR
(com.splwg.base.support.hibernate.KeyTableHelper) Cannot insert keys into key
table F1_SYNC_REQ_IN_K with sql insert into F1_SYNC_REQ_IN_K
(F1_SYNC_REQ_IN_ID, ENV_ID) select ?, ENV_ID from F1_INSTALLATION
org.hibernate.exception.ConstraintViolationException: ORA-00001:
????(CISADM.F1T196P0)???????

at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at
org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy4.executeBatch(Unknown Source)
at

 

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