The BMC Decision Support Server Automation (BDSSA) ETL job fails in the following step:
"3_PATCH -> D_DEPOT_SOFTWARE_WIN_BULLETIN_85 -> Insert flow into I$ table"
With the following error:
ODI-1228: Task D_DEPOT_SOFTWARE_WIN_BULLETIN_85 (Integration) fails on the target ORACLE connection BSA_phy_dw_svr_site1. Caused By: java.sql.SQLException: ORA-12899: value too large for column "BSARA_DW"."I1$_D_DEPOT_SOFTWARE_WIN_BULLE"."CVE_IDS" (actual: 1573, maximum: 255)
Note: same issue occurs with D_DEPOT_SOFTWARE_WIN_HOTFIX . The same hotfix updates both tables.
The ETL job had worked until recently when a BSA-side 8.9.01 Hotfix or Rolling Update was applied
BSA Defect QM002245450 corrected an issue where all CVEs for a Microsoft Bulletin that contains multiple CVEs are not associated with the Bulletin in the BSA patch catalog.
Example: MS16-144 is a bulletin that corrects 8 CVE items:
CVE-2016-7202, CVE-2016-7278, CVE-2016-7279, CVE-2016-7281, CVE-2016-7282, CVE-2016-7283, CVE-2016-7284, CVE-2016-7287
In the BSA Patch Catalog, MS16-144 only shows CVE-2016-7279.
This BSA Defect was fixed in BSA 8.9.01 Rolling Update 3
The fix to this BSA defect also requires a BDSSA hotfix to be applied so that ETL can handle the larger CVS_IDS value.
The BDSSA hotfix can be downloaded from the following location and contains a high-level readme file as well as a specific readme file for Oracle and SQL Server environments.