Page 1 of 1

RT_SC213/jpfile: No such file or directory

Posted: Wed Feb 08, 2006 10:58 am
by 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 :wink: )
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 :),

Posted: Wed Feb 08, 2006 11:04 am
by 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?

Posted: Wed Feb 08, 2006 3:16 pm
by 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,

Posted: Wed Feb 08, 2006 10:49 pm
by 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).

Posted: Thu Feb 09, 2006 12:28 am
by 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