My Oracle Support Banner

ETCG Transaction Synchronization and Transaction Control Analysis Fails with com.sunopsis.dwg.SQLWorkReposException: ORA-00600: internal error code (Doc ID 1641757.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Transaction Controls Governor - Version 8.6.4 to 8.6.4 [Release 8]
Information in this document applies to any platform.


On : ( version, Control Management

When attempting to schedule Transaction Synchronization, the job fails. Scheduled Transaction Control Analysis of several controls also fails.

grc log
ERROR [Thread-94] Log4jPrintStream:70 STDERR (java.lang.Throwable$WrappedPrintStream:747) com.sunopsis.dwg.SQLWorkReposException: ORA-00600: internal error code, arguments: [ktspfmdb:objdchk_kcbnew_3], [0], [78033], [4], [], [], [], [], [], [], [], []

SEVERE: Agent Internal detected that the work repository WORKREP1 went down.

SEVERE: Session preparation failure: work repository WORKREP1 went down during session preparation.

2014-03-11 17:58:09,437 ERROR [GrcExecutorThread-7] AbstractJob:419 Error occurred in concrete job implementation
oracle.apps.grc.common.job.JobExecutionException: Error occured during analysis

The issue can be reproduced at will with the following steps:
1. Schedule TCG ETL to run.
2. Review in Manage Job when the job runs.

3.Similarly, scheduled transaction Control analysis also fails.

The issue has the following business impact:
Due to this issue, users cannot have scheduled TCG ETL or Control Analysis.


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

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