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.

Symptoms

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.

ERROR
-----------------------
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


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

BUSINESS IMPACT
-----------------------
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.

Cause

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