It's all about the answers!

Ask a question

CLM 4.0.6_All Job Failing at Build_Star Node


Nikhil Vipradas (111214) | asked Aug 12 '14, 10:00 a.m.
edited Aug 20 '14, 12:18 p.m. by Stephanie Taylor (24115)
Hello Team
We have CLM 4.0.6 and Rational Insight 1.1.1.3 Integrated. We have configured CLM4.0.6_All job for it.
In the execution its failing in the end at Build_Star node below is log file snap :

Data Manager v10.2.5000.275 -- (C) Copyright IBM Corp. 1999, 2013
COGNOS INTERNAL USE ONLY
jobstream -- start run on INMBZ1077.in.dst.ibm.com (12-Aug-2014 18:30:30)
Run context:
JobStream 'CLM4.0.6_All'
    JobStream 'Build_Star'
DM-EXP-0003 An expression validation error occurred at position 931
Unknown variable '$format_date'.
.
.
DM-EXP-0007 User-defined function 'SELECT_ETL_DATE' validation error.
DM-EXP-0003 An expression validation error occurred at position 0
Unknown variable '$format_date'.
>>>SELECT_ETL_DATE( 1, etl_start_date, 1 )
DM-EXP-0007 User-defined function 'GetETLDateID' validation error.
DM-LIB-0300 Error initializing variable 'ETL_DATEID' to:
GetETLDateID( $ETL_STARTIME ).
DM-BLD-0004 JobStream 'Build_Star' is not a valid specification.
jobstream -- failed (12-Aug-2014 18:30:32)

Can anyone give clue on what might be wrong ?
Thanks in advance.

One answer



permanent link
Kenji Sarai (96029) | answered Aug 20 '14, 10:51 p.m.
Hi Nikhil,
It looks like there is a problem in SELECT_ETL_DATE function in Insight. Does it happen just after upgrading from prior version? If so, please try to re-load the 1.1.1.3 Out-of-the-box ETL catalog. And what database are you using? Oracle?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.