"Error selecting from log file RT_LOG862"

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

Try to save job under a new Name maybe that thereafter it might be okay.
Wolfgang Hürter
Amsterdam
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Seems like your running out of space and this particular hashed file got corrupted. Clear the file, clear your logs, save it by some other name and delete the original job so that this file also gets deleted.
Also try to keep the log file sizes in check.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What happened when you ran Exact Match searches for DS.TOOLS and DS.CHECKER ? I got quite a number of hits which answered both questions.

Please give that a shot and then let us know if you have any specific questions on either subject.
-craig

"You can never have too many knives" -- Logan Nine Fingers
georgesebastian
Participant
Posts: 83
Joined: Tue Dec 19, 2006 8:38 am

Post by georgesebastian »

chulett wrote:What happened when you ran Exact Match searches for DS.TOOLS and DS.CHECKER ? I got quite a number of hits which answered both questions.

Please give that a shot and then let us know if you have any specific questions on either subject.
Sorry,It was my fault.
When i tried searching both individually,i got the result that i needed.

Thanks
George
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

And so can you mark the thread as resolved?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
georgesebastian
Participant
Posts: 83
Joined: Tue Dec 19, 2006 8:38 am

Post by georgesebastian »

ray.wurlod wrote:And so can you mark the thread as resolved?
Hi Ray,

I dont think i can mark this as resolved since i am not the one who opened the thread.I think MORIS can only do this


Thanks
George
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Ah. So we await Mr Morris's return.

Can't open dictionary suggests that job number 862 has been incompletely deleted. If this is not the case, please post the results of the following command issued from TCL:

Code: Select all

LIST.ITEM VOC 'RT_LOG862'
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Pete Morris
Charter Member
Charter Member
Posts: 39
Joined: Wed Jun 23, 2004 4:33 am
Location: UK, chester

Post by Pete Morris »

i imported the old project into a new project.
This resolved the problem.

If this happens again i will use the 'LIST.ITEM VOC 'job number' command as suggested.

Is there a TCL command that will tidy up a corrupted job.
Pete Morris
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Dont let it happen again. Utilize the job log purge settings option. Dont let it grow too large.
If you exported your entire project to a new project, then you can drop the old project. This will ensure all hashed files are removed pertaining to logs.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Pete Morris wrote:Is there a TCL command that will tidy up a corrupted job.
As noted earlier - DS.CHECKER - but the answer could depend on exactly what you mean by 'tidy up'. :wink:
-craig

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