TSCO - Java-based ETL with SQL parameters fails when 1 parameter returns no rows

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 Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    TSCO 11.3.01



    PROBLEM:

    In a Java-based ETL (Generic - Database extractor (Java)) when using the SQL Parameter set, e.g. parameter binding, and one of the listed parameters returns no rows, there are 2 issues that occur. 

    1. If the parameter with an empty dataset is in any position other than the end, the ETL will stop execution and exit with an OK status. It will not populate any data and will not continue with the next parameter in the list. 
    2. If the parameter with an empty dataset is the last in the list, the ETL will also exit with an OK status and not populate any data extracted in the ETL.

    On below screenshot you can see the ETL configuration with the different parameters set:

    User-added image

    In this scenario the empty parameter is the last of the list, you can see from the logs is extracting data.

    But at the end of the execution even when is ending in OK is not populating the data.

    User-added image


    SOLUTION:

    We have validate both scenarios reported and confirm this as defect, we have generated below tracking number:

    DRCOZ-21633

    Fix will be available in CHF:

    11.3.01.01.C00016

    You can find the latest CHF for Truesight Capacity Optimization 11.3.01 on below FTP link:
    ftp://ftp.bmc.com/pub/perform/co/chf/11.3.01/
     


    Article Number:

    000169036


    Article Type:

    Solutions to a Product Problem



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