DSXchange

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

Hi Mark, long time no see!

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

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

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

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?

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

Thanks Ray/Morne. Much appreciated.

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