This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
BMC Decision Support - Server Automation (5 Viewer, 1 Query License)
BSA and BDSSA were both previously running 8.9 and ETL was running to completion.
BSA was upgraded to 8.9.01 and now ETL fails with the following error:
ODI-1228: Task CHECK_CONFIGURATION (Procedure) fails on the target ORACLE connection BSA_phy_dw_svr_site1.
Caused By: java.sql.SQLException: ORA-20104: DW Schema should be equal to or at higher version than OM Schema
ORA-06512: at line 43
ODI-1228: Task CHECK_CONFIGURATION (Procedure) fails on the target MICROSOFT_SQL_SERVER connection BSA_phy_dw_svr_site1.
Caused By: com.microsoft.sqlserver.jdbc.SQLServerException: DW schema version should be greater than or equal to OM schema.
BDSSA 8.9 must have a hotfix applied in order to be compatible with BSA 8.9.01
Please see the following documentation for details on where to download the BDSSA 8.9 hotfix
The hotfix zip file contains a readme_oracle.txt and readme_sqlserver.txt file with detailed installation instructions. Please follow the instructions for your BDSSA DB type.
Note: After applying this hotfix, there may be an unrelated, but also related to BSA 8.9.01, error downstream in the following ETL step:
3_PROPERTY -> TEMPLATE_PROPERTY -> LOAD_TEMPLATE_PROP_TRANSPOSE -> LOAD_TEMPLATE_PROP_TRANSPOSE
Caused By: java.sql.SQLException: ORA-20001: Procedure LOAD_TEMPLATE_PROP_TRANSPOSE Failed with error message
ORA-20001: Error while reading Template Transpose Metadata Table for CVE_IDS*
ORA-06512: at "BSARA_DW.LOAD_TEMPLATE_PROP_TRANSPOSE", line 583 ORA-06512:
If this issue is encountered, see KA 000137663 for details on how to resolve.