2.4.7.3.1: Getinng Error In Business Area Initilazing

(Doc ID 2321594.1)

Last updated on OCTOBER 26, 2017

Applies to:

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

Symptoms

ISSUE:
-------
ORA-1422 initilazing INITIALIZING A BUSINESS AREA. Issue can be reproduced
with the following steps:

0) Set CDR_SAVE_CURR_STG_TAB to Yes


1) create SAS program "pgm1.sas" with source code

data target.demo1;
set sashelp.class;
run;

2) Install and run the program with run label "Submission1". We can see a
table is created in LSH.
3) Update the blinding status of the table as below:
  i. "Blinding Flag ?" to Yes
  ii. "Blinding Status" to "Blinded"
4) Install the program
5) Submit the job again by giving run label as "Submission1" and "Blind Break
  " As "Dummy".
6) After the submission of the job verify the data in the table.Also verify
the table in CDR tables by using below query passing table instance object
id.
  "SELECT * FROM Cdr_table_ref_jobs WHERE TI_OBJ_ID="
7) Submit the job again by giving run label as "Submission2" and "Blind Break
  " As "Dummy".
8) After the submission of the job verify the data in the table.Also verify
the table in CDR tables by using below query passing table instance object
id.
  "SELECT * FROM Cdr_table_ref_jobs WHERE TI_OBJ_ID="
9) check out the program pgm1.sas. Updated the source code of the program as
below
/*data target.demo1;
set sashelp.class;
run;*/

10) Install the program pgm1.sas
11) Submit the job again by giving run label as "Submission3" and "Blind
Break " As "Dummy".
12) After the submission of the job verify the data in the table.Also verify
the table in CDR tables by using below query passing table instance object
id.
  "SELECT * FROM Cdr_table_ref_jobs WHERE TI_OBJ_ID="
13) check out the program pgm1.sas. Updated the source code of the program as
below
data target.demo1;
set sashelp.class;
run;

14) Install the program pgm1.sas
15) Submit the job again by giving run label as "Submission4" and "Blind
Break " As "Dummy".
16) After the submission of the job verify the data in the table.Also verify
the table in CDR tables by using below query passing table instance object
id.
  "SELECT * FROM Cdr_table_ref_jobs WHERE TI_OBJ_ID="
  
In the LSH, we can see the run labels (under Browse data) "Submission2" and
"Submission3" as comma sepearted. and there is no run label for one of the
timestamps.

Also we can see three records with LATEST_SUCCESSFUL_JOB_YN='Y'.

17)Create the business area "BA_TEST1" under same work area and point the
table "demo1" as source
18)Install the business area.

--PL/sQL Block
set serveroutput on;
DECLARE
PI_COMPANYID NUMBER;
PI_OBJID NUMBER;
PI_OBJVER NUMBER;
PI_VCURRENCY VARCHAR2(200);
PI_VBLINDINGACCESSTYPE VARCHAR2(200);
X_RETURN_STATUS VARCHAR2(200);
X_MSG_COUNT NUMBER;
X_MSG_DATA VARCHAR2(200);
BEGIN
PI_COMPANYID := 725;--<>;
PI_OBJID := 17119041;--<>;
PI_OBJVER := 8;--<>;
PI_VCURRENCY := 'run3parta';--'Current';
PI_VBLINDINGACCESSTYPE := 'NA/Dummy';
CDR_PUB_API_GVA.SETINITILIZEBA(PI_COMPANYID => PI_COMPANYID,
  PI_OBJID => PI_OBJID,
  PI_OBJVER => PI_OBJVER,
  PI_VCURRENCY => PI_VCURRENCY,
  PI_VBLINDINGACCESSTYPE => PI_VBLINDINGACCESSTYPE,
  X_RETURN_STATUS => X_RETURN_STATUS,
  X_MSG_COUNT => X_MSG_COUNT,
  X_MSG_DATA => X_MSG_DATA);
  
DBMS_OUTPUT.PUT_LINE('X_RETURN_STATUS = '|| X_RETURN_STATUS);
DBMS_OUTPUT.PUT_LINE('X_MSG_COUNT = '|| X_MSG_COUNT);
DBMS_OUTPUT.PUT_LINE('X_MSG_DATA = '|| X_MSG_DATA);
END;
--Output
PL/SQL procedure successfully completed.
X_RETURN_STATUS = U
X_MSG_COUNT = 1
X_MSG_DATA = ORA-01422: exact fetch returns more than requested number of
rows

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