TrueSight Smart Reporting – Server Automation (TSSR-SA): ETL fails with the error - ORA-00904: "T"."REPEATER_STAGING_DIR": invalid identifier

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Smart Reporting - Server Automation


    COMPONENT:

    TrueSight Smart Reporting - Server Automation 19.02.00


    APPLIES TO:

    TSSR-SA 19.0.x



    PROBLEM:

    After an upgrade from BMC Decision Support for Server Automation (BDSSA) to TrueSight Smart Reporting for Server Automation (TSSR-SA) the ETL process fails with the error:

    Error Description:            ODI-1228: Task D_SERVER_82 (Integration) fails on the target ORACLE connection BSA_phy_dw_svr_site1.
    Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "T"."REPEATER_STAGING_DIR": invalid identifier


    CAUSE:

    This issue is identified as defect DRTRR-1


    SOLUTION:

    To verify this as defect DRTRR-1 and the required solution collect the following items for BMC Support to review:

    * the ETL error details from the ETL run status

    * the logs files in the <TSSA-SR_HOME>/logs directory from the TSSA-SR server

    * output from this below query executed against TSSA and TSSR-DW databases:
    SELECT * FROM SYSTEM_PROPERTY WHERE NAME LIKE 'Database%Version';

    * output from this below query executed against TSSR-DW database:
    SELECT * FROM DWH_VERSION;


    Defect DRTRR-1 has been addressed in TSSR-SA 19.2.01/TSA-DW 8.9.04 P3


    Article Number:

    000169791


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles