Issue with variable

srinivas.g · Post by **srinivas.g** » Fri Sep 04, 2009 4:49 am

Hi All,

In my project there are so many jobs with job parameter REPORT_DATE. These jobs are in production for long time.

Now with the export this project I have created new project and started compiling jobs. Some of the jobs with this parameter are not compiling, throughing following error message,

Error preprocessing Transform Derivation for stage CFlyCtDeltaload.XTERM.

Link DSLink52, Column REPORT_DATE: Oconv(Iconv(ReportDate,'D-MDY[2,2,4]'),'D-MDY[2,2,4]')

Expected: left parenthesis ("(")

When I correct the name with Rdate job is working fine. But I cant actually change like this since this programs are in production.

Some more information

Both are same environment and same version of DataStage and UNIX not change.

Please advice.

Prakash

ArndW · Post by **ArndW** » Fri Sep 04, 2009 4:54 am

If the job parameter is "REPORT_DATE" then how is the value of "ReportDate" being derived?

laknar · Post by **laknar** » Fri Sep 04, 2009 4:59 am

this seams that ReportDate parameter is not specified for that job.
check the job parameters , the parameter name should be the ReportDate name.

srinivas.g · Post by **srinivas.g** » Fri Sep 04, 2009 5:11 am

Actually this is a sequencer and ReportDate is the sequencer parameter and this param is being assigned to the job which sequencer is calling and in the job the param name ins REPORT_DATE.

Also this is jobs are already running in production for years and never had this problem.

Just when I am importing and compiling this jobs in new development project I am getting this compilation error.

Yet in production this jobs are still running with out any changes.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Sep 04, 2009 5:13 am

Then what is Rdate?

laknar · Post by **laknar** » Fri Sep 04, 2009 5:14 am

Andy is correct .
If the job parameter is "REPORT_DATE" then how is the value of "ReportDate" being derived?

chulett · Post by **chulett** » Fri Sep 04, 2009 7:01 am

srinivas.g wrote:When I correct the name with Rdate job is working fine. But I cant actually change like this since this programs are in production.

What is this 'correction' that you need to do?

srinivas.g · Post by **srinivas.g** » Tue Sep 08, 2009 8:06 am

Hi All,

Issue is now resloved. There is one routine created one year back with name ReportDate. After this point this problem is started. we just identified and renamed the routine now every other jobs are fine.

some time it looks little ill logic but that what was happed.
Thx to all

DSXchange

Issue with variable

Issue with variable

Re: Issue with variable