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.