What does this mean???

ewartpm · Post by **ewartpm** » Thu Nov 11, 2004 6:09 am

I'm getting this message:

DataStage Job 145 Phantom 20687
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Internal file corruption detected. File must be repaired.
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Read operation failure. [EIO] I/O error
Program "JOB.1433470019.DT.1330157629.TRANS1": Line 113, Internal file corruption detected. File must be repaired.
DataStage Phantom Finished

Any ideas on what is happening here would be really appreciated. :D

mleroux · Post by **mleroux** » Thu Nov 11, 2004 7:00 am

Hi Mark, long time no see!

Sounds awfully much like a hardware device failure. Bad sectors, perhaps?

Amos.Rosmarin · Post by **Amos.Rosmarin** » Thu Nov 11, 2004 7:03 am

Hi,

The error msg points to the file under RT_BP145 in your project directory.
Look at line 133 to see the exact place.

HTH,
Amos

ray.wurlod · Post by **ray.wurlod** » Thu Nov 11, 2004 3:06 pm

That's known as the Old MacDonald's Farm error ([EIO] I/O error)

Yes, it looks like at best file corruption, at worst hardware failure. The subroutine in RT_BP415/JOB.1433470019.DT.1330157629.TRANS1 - which is the code generated by a Transformer stage - should give you a clue as to which file was being accessed (so should your job design).

mleroux · Post by **mleroux** » Fri Nov 12, 2004 12:11 am

Very good Ray, very good!

So how does one get to this subroutine in RT_BP415-yah-dee-yah-dee-yah and check it out, and how does one find out which file? Is it necessarily a hashed file?

ray.wurlod · Post by **ray.wurlod** » Fri Nov 12, 2004 2:10 am

Hi Morney.

RT_BP145 is a subdirectory in your project directory on the server. Telnet in, cd to the project directory, then cd to RT_BP145. You'll find a file in there called JOB.1433470019.DT.1330157629.TRANS1, which you can inspect with, for example, vi (if you :set nu, you even get line numbers!).

(The Indian cricket team can be beaten in India.)

ewartpm · Post by **ewartpm** » Fri Nov 12, 2004 5:54 am

Thanks Ray/Morne. Much appreciated.

I wonder if the Ascential engineers quietly hum Old MacDonald while they work...