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 FEBRUARY 03, 2019

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.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.