This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
TrueSight Smart Reporting - Server Automation
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
This issue is identified as defect DRTRR-1
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