TSCO - Can't locate ETL/action/SQLFlagA.pm

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.5



    PROBLEM:

    We recently upgrade from Truesight Capacity Optimization 11.3.01 to 11.5 version.

    After this we started presenting below error message on our Generic Database Extractor ETL:

    BCO_ETL_FAIL108: Process cannot be started (cannot fork external perl/os process) or process fails due to severe errors (no modules in classpath, die, etc.). Reason: Can't locate ETL/action/SQLFlagA.pm in @INC (@INC contains: /opt/cpit/tco/etl/customsrc /opt/cpit/tco/etl/temp/.12005 /opt/cpit/tco/3rd_party/perl_5.8.8/lib/perl5/5.8.8 /opt/cpit/tco/3rd_party/perl_5.8.8/lib/perl5/site_perl /opt/cpit/tco/3rd_party/perl_5.8.8/lib/perl5/5.8.8/i86pc-solaris /opt/cpit/tco/3rd_party/perl_5.8.8/lib64/perl5/5.8.8 /opt/cpit/tco/3rd_party/perl_5.8.8/lib64/perl5/site_perl /opt/cpit/tco/3rd_party/perl_5.8.8/lib64/perl5/vendor_perl /opt/cpit/tco/etl/perllib /opt/cpit/tco/etl/perllib/lib/perl5/site_perl /opt/cpit/tco/etl/perllib/lib64/perl5/site_perl /opt/cpit/tco/etl/perllib/lib/perl5 /opt/cpit/tco/etl/perllib/lib64/perl5 /opt/cpit/tco/etl/perllib/share/perl5 /opt/cpit/tco/etl/perllib/usr/share/perl5 /opt/cpit/tco/etl/perllib/lib/perl/5.8.8 /opt/cpit/tco/etl/perllib/lib64/perl/5.8.8 /opt/cpit/tco/etl/perllib/share/perl/5.8.8 /opt/cpit/tco/etl/perllib/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /opt/cpit/tco/etl/perllib/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/Bundle /opt/cpit/tco/etl/perllib/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /opt/cpit/tco/etl/perllib/lib/perl5/site_perl/5.18.2 /opt/cpit/tco/etl/perllib/lib/perl5/site_perl/5.18.2/x86_64-linux-thread-multi /opt/cpit/tco/etl/perllibext /opt/cpit/tco/etl/perllibext/lib/perl5/site_perl /opt/cpit/tco/etl/perllibext/lib64/perl5/site_perl /opt/cpit/tco/etl/perllibext/lib/perl/5.8.8 /opt/cpit/tco/etl/perllibext/lib64/perl/5.8.8 /opt/cpit/tco/etl/perllibext/share/perl/5.8.8 /opt/cpit/tco/etl/perllibext/lib/perl5 /opt/cpit/tco/etl/perllibext/lib64/perl5 /opt/cpit/tco/etl/perllibext/share/perl5 /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . . ../customsrc) at /opt/cpit/tco/etl/temp/.12005/ETL/Engine.pm line 479.


    We found that the root cause for this problem is the missing SQLFlagA.pm module under:
    $BCO_HOME/etl/bin/ETL/action/


     


    SOLUTION:

    The SQLFlagA.pm module is deprecated on TSCO 11.5 version, but the Generic Database Extractor ETL does not require this module for his execution.

    It will requested only if is manually added on the ETL configuration > "You can manually edit ETL properties from this page."

    Please find below a workaround to solve this problem:

    1) create folder "action" in the following path ${CPIT_BASE}/etl/customsrc/ETL

    2) put the file SQLFlagA.pm from TSCO 11.3.01 in the location created above

    The parameters are being honored on TSCO 11.5 and it will work without problem.


    Article Number:

    000169034


    Article Type:

    Solutions to a Product Problem



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