My Oracle Support Banner

STOP_CANCELLED Request is Failing With Error 'Failed to delete Stop <>: ORA-02292: integrity constraint () violated - child record found^AAAAA: Unable to execute statement' (Doc ID 1558713.1)

Last updated on AUGUST 15, 2018

Applies to:

Oracle Real-Time Scheduler - Version 1.13.2 to 1.13.2 [Release 1.13]
Information in this document applies to any platform.

Symptoms

The following error is logged when the user attempts to cancel a STOP:

HTTP CHECK :1 packets for method STOP_CANCELLED are received
RTS_WS166 17/04/13 14:17:59.698 [00:00:28.200] WARNING: assertion << Problem is with query, not connection to database >> failed in postBox.c at line 924: continuing
RTS_WS166 17/04/13 14:17:59.698 [00:00:28.200] Failed to delete Stop <AAAAA>: ORA-02292: integrity constraint (OVS_USR_AP.FK_STOP_TW_STOP) violated - child record found^AAAAA: Unable to execute statement
RTS_WS166 17/04/13 14:17:59.698 [00:00:28.200] Unable to rollback nested transactions.

 


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.