My Oracle Support Banner

Error Received While Doing Mass Changes 362000: Problem Validating CDS Changes Against Target Tables (Doc ID 1499418.1)

Last updated on AUGUST 19, 2021

Applies to:

Oracle Clinical - Version 4.5.1 to 4.6.6 [Release 4.5.1 to 4.6.6]
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.

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
References


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