This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
TrueSight Capacity Optimization
TrueSight Capacity Optimization - 11.5.01 + Oracle 11.2.04 + Oracle client 18.104.22.168
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)
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'
data gets in as they were on 10.7.1
All the etls using CST into the environment are broken
defect DRCOZ-25629 "etl CST dataset load fails with following error: ORA-01830: date format picture ends before converting entire input string"
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: