OUA V2.8.0.2 - ETL Is Failing For All Tables, Table Or View Does Not Exists Error (Doc ID 3039914.1)

Last updated on SEPTEMBER 06, 2024

Applies to:

Goal

On : 2.8.0.2.0 version, Install / Upgrade

OUA v2.8.0.2 - ETL is failing for all tables, table or view does not exists error

Identified that some of the OOTB views (B1_*_VW) in replication layer are missing. Do not see any errors during source configuration.

ERROR:

version number is: 12.2.1

- 2024-08-01 11:02:39,031 [AWT-EventQueue-0] INFO (oua.base.BIScenario) Session B1_NMS_D_CREW_KVW execution Passed after 1 attempt(s) for Session ID: 230

- 2024-08-01 11:02:39,132 [AWT-EventQueue-0] INFO (oua.base.BIScenario) ODI Agent: OracleDIAgent is alive and version number is: 12.2.1

- 2024-08-01 11:02:39,414 [AWT-EventQueue-0] INFO (oua.base.BIScenario) Session B1_F_DAMAGE_AST_DTL_KEY_NEW_VW execution Passed after 1 attempt(s) for Session ID: 231

- 2024-08-01 11:02:39,416 [AWT-EventQueue-0] ERROR (oua.base.BIScenario) No matching scenario found for name B1_D_ALARM_LOG_VW

- 2024-08-01 11:02:39,416 [AWT-EventQueue-0] ERROR (oua.build.ConfigureSource) Error while generating source views.

- 2024-08-01 11:02:39,416 [AWT-EventQueue-0] ERROR (oua.build.ConfigureSource) Error occured while configuring source. For details refer to deployodi.log in logs/system directory under OUA Home

Solution

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