Unable to view the Log file.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

prasanna_anbu
Participant
Posts: 42
Joined: Thu Dec 28, 2006 1:39 am

Post by prasanna_anbu »

ArndW wrote:Then you have reached an impasse. Either reduce the number and size of messages or, better yet, don't log them in the job log but elsewhere. This heavy I/O to the log file is most certainly slowing your job down as well.
once I amended the routine not to write any log to the Sequencer. i got the error like 'Failed to connect RT_LOG43'
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Could you post the whole error message? Also, did you clear the log file (i.e. ensure that it was not broken prior to the job run)?
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Why not run with a small volume ? Something like 10 records.

That way you can diagnose the problem easier.

Are you having errors in the load ? Is there any metadata mismatch ? Or is it your routine that is logging so many rows ?
prasanna_anbu
Participant
Posts: 42
Joined: Thu Dec 28, 2006 1:39 am

Post by prasanna_anbu »

Sainath.Srinivasan wrote:Why not run with a small volume ? Something like 10 records.

That way you can diagnose the problem easier.

Are you having errors in the load ? Is there any metadata mismatch ? Or is it your routine that is logging so many rows ?

Other than 'Failed to connect to RT_LOG43'. I am not able to see any error messages. I planned to try with minimum records but now the sequencer itself not shown in the director, if i tried to import newly it shows the same error.
prasanna_anbu
Participant
Posts: 42
Joined: Thu Dec 28, 2006 1:39 am

Post by prasanna_anbu »

prasanna_anbu wrote:
Sainath.Srinivasan wrote:Why not run with a small volume ? Something like 10 records.

That way you can diagnose the problem easier.

Are you having errors in the load ? Is there any metadata mismatch ? Or is it your routine that is logging so many rows ?

Other than 'Failed to connect to RT_LOG43'. I am not able to see any error messages. I planned to try with minimum records but now the sequencer itself not shown in the director, if i tried to import newly it shows the same error.
I re-imported the jobs with keep the copy, now I am able to see the logs.
I dont get the clear picture of the previous error. Thanks for everyone.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Somehow in all those shenanigans you corrupted or removed part (or all) of the log's dynamic hashed file. The reimport recreated that for you.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply