Error Received While Doing Mass Changes 362000: Problem Validating CDS Changes Against Target Tables

(Doc ID 1499418.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version 4.5.1 to 4.6.6 [Release 4.5.1 to 4.6.2]
Information in this document applies to any platform.


On : 4.6.0 version, Procedures, Discrepancy, DCF's, Mass Changes, Batch Data Load, In & Out of Study

When attempting to validate mass changes for Responses, the following error occurs.

362000: Problem validating CDS changes against target tables: EXEC SQL EXECUTE Failed with SQLERR=-1458, Check Data Integrity, FailureAction() failed; ProcessResponseChanges() Failed; type is 1, message

The issue can be reproduced at will with the following steps:
1. Setup mass change criteria
2. Attempt to validate the mass changes

The issue has the following business impact:
Due to this issue, users cannot complete the mass change for two studies. This is critical due to business timelines.


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 hundreds of Community platforms