My Oracle Support Banner

ISR 6.2p4: New Sync Issue (Doc ID 2632829.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Communications Interactive Session Recorder - Version 6.2 and later
Information in this document applies to any platform.

Symptoms

 After upgrading to 6.2p4 we have synchronization problems in the database.

  Last_SQL_Error: Error 'Cannot delete or update a parent row: a foreign key constraint fails (`ipcr_db`.`sessions_recordings`, CONSTRAINT` fk_session_recording_tmp_recordings1` FOREIGN KEY (`tmp_recording_id`) REFERENCES` tmp_recordings` (`recording_id` NO) ON UPDATE N) 'on query. Default database: 'ipcr_db'. Query: 'delete from tmp_recordings where vmg_id = 3'

Changes

 Customer upgraded the software from 6.2p0 to 6.2p4.

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
  
References


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