RT_SC213/jpfile: No such file or directory

[roy]

Hi All,
I noticed the below in some of my EE jobs
Does anyone know what it means?
The job in question has nothing but a Dataset to Dataset nothing more.
Director log shows all is well
The job is using a Message Handler.
All seems to be ok but this enty is disturbing
(Almost as disturbing as the fact I even looked in the &PH& files )

DSD.RUN_10309_13919
::::::::::::::
DataStage Job 213 Phantom 26330
RT_SC213/jpfile: No such file or directory

3 record(s) selected to SELECT list #1.
DataStage Phantom Finished.

Thanks in advance for your time ,

[ArndW]

The RT_SC file is filled at compile with the scripts that PX uses - does the error go away if you recompile the job?

[roy]

Thanks for the reply Arnd,
In this particular case I can compile the job, but since this is in the production server any job containing a transformer is not compile-able since there is no compiler there .
I used the export/import with executables to get the jobs to the prod server.
Any ideas on how I might prevent such issues to begin with?
Thanks in advance,

[ray.wurlod]

One way might be to count the number of pieces that should exist for job number xxx before promoting and verifying that number after promotion. RT_BPxxx, RT_SCxxx and RT_BPxxx.O. If you want to be thorough, do the same for RT_CONFIGxxx and RT_STATUSxxx using SQL queries (SELECT COUNT(*) FROM tablename).

[elavenil]

Hi Roy,

Check this RT_SCnn file in the folder for that job and if this file exists in the folder then this could be a bug in DS and we had the same issue in my earlier project and we had to apply the patch and it worked.

HTWH.

Regards
Saravanan