Database extractor ETL fails in date fields management "ORA-01830" in TrueSight Capacity Optimization (TSCO)

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:

    TrueSight Capacity Optimization - 11.5.01 + Oracle 11.2.04 + Oracle client 12.2.0.1



    PROBLEM:

     

    STEPS TO REPRODUCE
    Setup an etl of type Generic SQL extrctor (java) to put timestamp data into a buffer table including a date column (using CST dataset 1295)

      

    ACTUAL RESULTS:
    ETLs fail in converting fields of date/timestamp data type and produce the following error:
    ORA-01830: date format picture ends before converting entire input string

      

    The execution log shows that the ETL task automatically adds milliseconds to the date field and it fails trying to insert '2020-19-02 10:00:00.0'

      

    EXPECTED RESULTS:
    data gets in as they were on 10.7.1

    BUSINESS IMPACT:
    All the etls using CST into the environment are broken

     


    CAUSE:

    defect DRCOZ-25629 "etl CST dataset load fails with following error: ORA-01830: date format picture ends before converting entire input string"


    SOLUTION:

    The mentioned defect is fixed on CHF4 of TSCO 11.5.01 and on-wards.

    For more information about the latest CHF for your CO version check this article:
    https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000097159


    Article Number:

    000186537


    Article Type:

    Solutions to a Product Problem



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