My Oracle Support Banner

Program Does Not Load Data In Real Partition With Snapshot Label And DMW Non Blinded Table As Source (Doc ID 2231750.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
LSH program does not load data in real partition of target table when used snapshot label and DMW non blinded table as source

EXPECTED BEHAVIOR
-----------------------
Expected that LSH program loads data in real partition of target table when used snapshot label and DMW non blinded table as source
.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create Loadset named "mask_snap_error"
2. Add table descriptor based on "mask_snap_src.mdd"
3. Load data by uploading mask_snap_src.csv
4. Create LSH view program named "mask_snap_src_v";
5. Add "mask_snap_src" as source table descriptor
6. Add SQL query as "select * from mask_snap_src"
7. Install the view program
8. Run applySnaphotPub.sql on APPS db account by providing work area and view table instance details.
9. Create SAS Program named "snapShotError"
10. Add mask_snap_src_v as source table descriptor
11. Create target table descriptor from file mask_snap_dest.mdd
12. Add below mentioned source code
 data target.mask_snap_dest;
  set source.mask_snap_src;
 run;
13. Install program
14. Run the program with following parameter
 Data Currency = Specify Snapshot
 Blind Break= Real(Blind Break)
 Ensure data currency tab, snapshot label created step 8 is applied.

OR

1. Create a study > DM > nonblinded table (Table5) and install and load data
2. Create a LSH view (TABLE5V) pointing to Table5 and install and apply snapshot to view created as Label1
3. Create a SAS Program and add a source table descriptor pointing to LSH view Table5V
4. Create a target Table descriptor- Table1 to sas prg
5. Create TI from TD and update the table as blinding flag=Yes, status = Blinded
6. Add the source code as below:
data TARGET.TEST;
set SOURCE.TABLE5V;
run;
7. Install and submit the program and select
8. Data Currency = Specify Snapshot
  Blind Break= Real(Blind Break)
 Ensure data currency tab, snapshot label is selected

EXPECTED RESULT: should load the non-blinded data in real partition of Table1.
ACTUAL RESULT: Does not load the data.

Changes

 Upgraded to LSW 2.4.6.10 release where <BUG:24698709> is fixed.

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!


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