My Oracle Support Banner

"Cannot update the PROCESS_CONTROL_REQUEST record. [APP_SERVER_GID] must reference a valid APP_SERVER record" Error Generated During Startup (Doc ID 2617348.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.4.1 to 6.4.1 [Release 6.4]
Information in this document applies to any platform.

Symptoms

The following error may be generated during startup in the < OTM Home >/logs/appserver/console.log.0

[000003] [SQL_STATEMENT] insert into process_control_request (process_control_request_id,topic_alias_gid,topic_class_name,topic_parameters,next_process_time,app_server_gid,num_of_cycles,cycle_duration,time_window_gid,is_transient,domain_name,cycle_duration_gid,cycle_duration_base) values (?,?,?,?,?,?,?,?,?,?,?,?,?); [<process_control_request_id>, null, gtm.server.workflow.dataload.DataLoad$DataLoadReprocess, -user DBA.ADMIN -gtmDataLoadGid <gtm_data_load_gid>, YYYY-MM-DD HH:MM:SS UTC, <app_machine_gid>, null, null, null, false, PUBLIC]

Cannot update the PROCESS_CONTROL_REQUEST record. [APP_SERVER_GID] must reference a valid APP_SERVER record.
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (GLOGOWNER.FK_PC_APP_SERVER) violated - parent key not found

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


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