My Oracle Support Banner

LSH 2.2.2.9: Broken Version Control On Oracle T&V Loadsets (Doc ID 2028501.1)

Last updated on JULY 10, 2018

Applies to:

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

Symptoms

On : LSH 2.2.2.9, users notice that removing a table descriptor from a Oracle Tables and Views loadset breaks load set instances that use prior versions of that load set definition.



ERROR
-----------------------
Error
ORA-06502: PL/SQL: numeric or value error in Package cdr_df_parameter Procedure modifyParamDefaultValues


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

1. Domain, AA, WA 1 and WA 2
2. In WA 1, create a LS with Tables and Views Adapter, Select a Remote Location/Database Schema (for example: IL22UT/APPS
3. Complete Mapping
4. Install, Omit None
5. Clone WA 1 into WA 2
6. In WA 2, click Update and change name to say WA 2 Cloned
7. Install WA 2 Cloned, Omit None, Apply and Install
8. Installation Successful
9. Submit Loadset in WA 2 Cloned, use same Remote Location/Database Schema IL22UT/APPS on the Submission Parameters
10. Installation Successful, you are able to browse data
11. Go back to WA1 ==> LS ==> Click LS ==> Check Out this Load Set ==> and then remove AEAEA
note this is now version 2
12. DO NOT CHECK IN YET
13. WA2 Cloned ==> Load Set

Remote Location IL22UT/APPS
Database Schema APP

If you click the deleted table of:
~AEAEA

The Table Descriptor Parameters section is BLANK !!!

***PROBLEM #1***

14. If you click the UPDATE button here:

The resulting screen is blank (Table Descriptor Parameters)

***PROBLEM #2***

15. If you Click Apply or Cancel, you see the following:

Error
ORA-06502: PL/SQL: numeric or value error in Package cdr_df_parameter Procedure modifyParamDefaultValues


Table Descriptor Parameters

Cancel Apply

***PROBLEM #3***


16. Navigate to AA ==> WA 2 Cloned ==> and then click submit ==> in the submission parameters ==> remote location put IL22UT/APPS then click Submit


We notice that the logs from the first run and second run are different and are using different information in the fields in the log:

Table Descriptor Parameter Schema Name
Table Descriptor Parameter Object Name

***PROBLEM #4*** (see <====HERE)


Log from the Second Run:

774538201 Immediate. Success CDRUSER@ORACLE.COM

Start of Processing: Remote Location = IL22UT/APPS
Getting the Database Link: il22ut_30_737676001_1

 Starting Processing for Table AEAEA
  Table Descriptor Parameter Schema Name is APPS <=====HERE
  Table Descriptor Parameter Object Name is   Table Descriptor Parameter Where Clause is
  Validating Remote Structure
  Validation Succeeded, Structure for Remote and Local Tables are the same.
  Processing Records for Table AEAEA



VERSUS the Log from the First Run

The Log From The First Run:
774537701 Immediate. Success CDRUSER@ORACLE.COM

Start of Processing: Remote Location = IL22UT/APPS
Getting the Database Link: il22ut_30_737676001_1

 Starting Processing for Table AEAEA
  Table Descriptor Parameter Schema Name is APPS <=====HERE
  Table Descriptor Parameter Object Name is AEAEA <=====HERE
  Table Descriptor Parameter Where Clause is
  Validating Remote Structure
  Validation Succeeded, Structure for Remote and Local Tables are the same.
  Processing Records for Table AEAEA


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.