jpfile non-existent

anandsiva · Post by **anandsiva** » Mon May 11, 2009 5:51 pm

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..

ray.wurlod · Post by **ray.wurlod** » Mon May 11, 2009 6:20 pm

Welcome aboard.

What is jpfile?

anandsiva · Post by **anandsiva** » Mon May 11, 2009 7:07 pm

Its a datastage internal file. I don't know much details of this file. My job got aborted with that error.

Pagadrai · Post by **Pagadrai** » Tue May 12, 2009 2:33 am

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?

anandsiva · Post by **anandsiva** » Tue May 12, 2009 2:59 am

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.

anandsiva · Post by **anandsiva** » Sun May 17, 2009 6:22 pm

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.

chulett · Post by **chulett** » Sun May 17, 2009 10:46 pm

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.

anandsiva · Post by **anandsiva** » Sun May 17, 2009 11:05 pm

We are yet to deploy this patch. Will update if this patch has really helped or not..

DSXchange

jpfile non-existent

jpfile non-existent

Soln