Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

CLM 4.0.6_All Job Failing at Build_Star Node

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.

0 votes



One answer

Permanent link
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?

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,486
× 343

Question asked: Aug 12 '14, 10:00 a.m.

Question was seen: 5,456 times

Last updated: Aug 20 '14, 10:51 p.m.

Confirmation Cancel Confirm