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

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 hundreds of Community platforms