DSXchange

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

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

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

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.

Then what is Rdate?

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

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?

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