Starting on 01/01/2021, it is observed that the TrueSight Server Automation – Data Warehouse (TSSA-DW) ETL job is not successfully loading Job Run data for TSSA jobs run in the year 2021. The symptoms in SQL Server and Oracle environments are different: SQL Server Environments: The ETL job runs to completion without an error message, but Job Run data from the year 2021 is not transferred to the Data Warehouse and is therefore not visible in TSSR-SA Reports Oracle Environments: The ETL job fails with the following error message: ETL Step: 5_LOAD_EXTENDED_OBJECT_INFO - LOAD_EXTENDED_OBJECT_INFO - V_EXTENDED_OBJECT_INFO Error Message: (The specific stored procedure which throws the error may vary) ODI-1228: Task LOAD_EXTENDED_OBJECT_INFO (Procedure) fails on the target ORACLE connection BSA_phy_dw_svr_site1. Caused By: java.sql.SQLException: ORA-20001: Procedure load_extended_object_info Failed with error message ORA-01403: no data found ORA-06512: at "BDSSA_DW.LOAD_EXTENDED_OBJECT_INFO", line 925 ORA-06512: at line 2 OR ODI-1228: Task LOAD_SYSTEM_INFO_ASSETS (Procedure) fails on the target ORACLE connection BSA_phy_dw_svr_site1. Caused By: java.sql.SQLException: ORA-20001: Procedure process_sys_info_snapshots Failed with error message ORA-01403: no data found ORA-06512: at "BDSSA_DW.PROCESS_SYS_INFO_SNAPSHOTS", line 536 ORA-06512: at line 2 |
This defect has been identified on 01/04/2021 Contact BMC Customer Support with the following information to get a hotfix: 1) TSSA/TSSA-DW DB Vendor and Version 2) Version of TSSA-DW - Run the following on the TSSA-DW Schema/DB: >> Select value from SYSTEM_PROPERTY where name = 'DatabaseVersion'; Note: This issue has been fixed in TSSA DW 21.02 onwards. |