Page 1 of 1
jpfile non-existent
Posted: Mon May 11, 2009 5:51 pm
by anandsiva
I'm getting the following error.
DataStage Job 3446 Phantom 29135
rm: RT_SC3446/jpfile non-existent
5 record(s) selected to SELECT list #1.
Please advice..
Posted: Mon May 11, 2009 6:20 pm
by ray.wurlod
Welcome aboard.
What is jpfile?
Posted: Mon May 11, 2009 7:07 pm
by anandsiva
Its a datastage internal file. I don't know much details of this file. My job got aborted with that error.
Posted: Tue May 12, 2009 2:33 am
by Pagadrai
anandsiva wrote:Its a datastage internal file. I don't know much details of this file. My job got aborted with that error.
Hi,
I havent come across any internal file with such name.
Anyway, can you post details about your job and also the complete error message from the log?
Posted: Tue May 12, 2009 2:59 am
by anandsiva
This Jobs loads the data from staging table to target table using Oracle OCI.
DataStage Job 3446 Phantom 29135
rm: RT_SC3446/jpfile non-existent
5 record(s) selected to SELECT list #1.
is the complete log from the director for that error.
Soln
Posted: Sun May 17, 2009 6:22 pm
by anandsiva
This is a Known issue in datastage. IBM has a fix for this.
Please find below the response from IBM support:
------------------------------------------------------------------------------------------------------------------------
I have found a patch e75177-multi-ux.zip which may help resolve this problem.
Posted: Sun May 17, 2009 10:46 pm
by chulett
So... "may help resolve" or "has resolved"? I know you marked the post 'resolved' but the message from IBM leaves some wiggle room for them, it seems.
Posted: Sun May 17, 2009 11:05 pm
by anandsiva
We are yet to deploy this patch. Will update if this patch has really helped or not..