CLM 4.0.6_All Job Failing at Build_Star Node
![]()
Nikhil Vipradas (11●12●14)
| asked Aug 12 '14, 10:00 a.m.
edited Aug 20 '14, 12:18 p.m. by Stephanie Taylor (241●1●5)
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
![]()
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? |