My Oracle Support Banner

Batch Job Failure In Production Due To TPW Issue (Doc ID 1935813.1)

Last updated on AUGUST 15, 2018

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0 to 2.2.0 [Release 2.1 to 2.2]
Oracle Real-Time Scheduler - Version 2.1.0 to 2.2.0 [Release 2.1 to 2.2]
Information in this document applies to any platform.

Symptoms

Batch Job Failure in Production due to TPW Issue.

Following Error Received:

- 2014-07-05 21:17:47,364 [main] ERROR (support.sql.PreparedStatementImpl) Error executing update for rawSQL:
 insert into F1_TSPACE_ENTRY (TSPACE_ENTRY_ID,TSPACE_NAME,TSPACE_ENTRY_TY,CREATED_DTTMS,EXP_DTTMS,UPD_SW,UPD_DTTMS,LESSEE_NODE,LEASE_EXP_DTTMS,DEST_NODE, TSPACE_ENTRY_BODY) values (?,?,?,CAST(SYSTIMESTAMP AS DATE),?,?,CAST(SYSTIMESTAMP AS DATE),?,?,?,?)
with 'timestamp' parameter named 'LEASE_EXP_DTTMS' to : 'null' to indices: 7
with 'string' parameter named 'TSPACE_ENTRY_ID' to : '2f0b07e8-8a3a-4608-9195-bfac97edf59c' to indices: 1
with 'string' parameter named 'LESSEE_NODE' to : ' ' to indices: 6
with 'timestamp' parameter named 'EXP_DTTMS' to : 'null' to indices: 4
with 'string' parameter named 'TSPACE_NAME' to : 'DEFAULT' to indices: 2
with 'string' parameter named 'UPD_SW' to : 'Y' to indices: 5
with 'clobString' parameter named 'TSPACE_ENTRY_BODY' to : '2f0b07e8-8a3a-4608-9195-bfac97edf59c42c8b8e75-3801-4153-a483-ff7aa3b655d1false0' to indices: 9
with 'string' parameter named 'DEST_NODE' to : ' ' to indices: 8
with 'string' parameter named 'TSPACE_ENTRY_TY' to : 'MEMBER_VALID' to indices: 3

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CISADM.SYS_C008086) violated

 

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!


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