My Oracle Support Banner

LSH 221 - BUG 23309197 - Update TD Hits ORA-20100: ERROR: CDR_ATK_UTILS.createMultipleOperators ORA-20200 (Doc ID 2156944.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Life Sciences Data Hub - Version 2.2.1 and later
Information in this document applies to any platform.

Symptoms

On LSH 2.2.1, the user receives the following error when trying to update table descriptors in a loadset


ORA-20100: *** ERROR: CDR_ATK_UTILS.createMultipleOperators

Details: ORA-20100: *** ERROR: CDR_ATK_UTILS.createMultipleOperators .
ORA-20200: *** LOADSET PROCESSING ERROR: update Column - Variable for Column ABCDEF_OTHER inside table Definition ID 234910002 could not be modified
- ORA-06512 : at "APPS.CDR_ATK_UTILS", line 863 ORA-06512: at "APPS.CDR_ATK_UTILS", line 1794 ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

 Attempting to load the AMR changes into _Rave_DEV but when the end user applies the table Descriptors, hits the error.

1. In this Work Area , Applications > Domain: XYZ 900001-1000000 > Domain: XYZ 987654 > Domain: 1234 > Application Area: Source+ >
2. Check out the LS_16244_Rave loadset,
3. Updated the loadset to point to the new version:

Version(Blank for PROD)= 356

4. Then click Upload to upload the table descriptors.
5. Use "Select All" then, unticked tables that are inactive in Rave, then clicked the "Apply" button and then, hit:

ORA-20100: *** ERROR: CDR_ATK_UTILS.createMultipleOperators
ORA-20200: *** LOADSET PROCESSING ERROR: update Column - Variable for Column ABCDEF_OTHER inside table Definition ID 234910002 could not be modified
...



Due to this issue, users cannot load the changes and the study load with new structure version  is not possible.

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
Cause
Solution
References


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.