ETL process fails to run with error

User_06302021

Hello,

I am dealing with an issue involving DAC. Since the start of 2021 users are seeing their Siebel Answers reports not showing updated data.

I researched and found a solution to this issue on docs.oracle.com that basically involved removing the refresh date from W_DAY_D table and setting the $$END_DATE parameter on a task (SIL_DayDimension). reference: https://docs.oracle.com/cd/E12127_01/doc/bia.795/e12083/anyimp_oracle_apps.htm#BACBGAAJ

After performing these steps the ETL was run, however, it did not fix the issue. I realized that I had not pushed the changes to references. So I tried to follow the documentation to do that. reference:

"About Object Ownership in DAC"  https://docs.oracle.com/cd/E12513_01/doc/bic.101/e12652/dacbasicconcepts.htm

After doing these steps I ran the ETL and I am getting an error :

Message: Error while loading nodes.

Error while loading nodes.null

I tried to Assemble all subject areas and build the Execution plan, which was successful. I re ran the ETL but still I have the same error.

1490 INFO Wed Jun 30 00:40:46 EDT 2021 Loading Node Tables

1491 FINER Wed Jun 30 00:40:46 EDT 2021 Datasource: null

Query: UPDATE 

W_ETL_DEFN_RUN

SET

STATUS_DESC = ?

WHERE

ROW_WID = ?

Bindset: [Type: java.lang.String Value: Loading Node Tables, Type: java.lang.String Value: 5A484BADF0F9A1D86674C416569DD890]

1492 SEVERE Wed Jun 30 00:40:46 EDT 2021 Could not find session for LIPA_SIL_OptyAggColumn_Update(SEBL_78->DataWarehouse)

1493 SEVERE Wed Jun 30 00:40:46 EDT 2021  

ANOMALY INFO::: Error while loading nodes.

Need help to resolve this error.

Thanks.