Hi there,
I'm having trouble saving an auto-purge change. I make the change, but when i go to save (by clicking "OK"), i get the following error message:
Unable to return an attached Job.
Cannot open file RT_LOG
what does this mean?
clear log, auto-purge
Moderators: chulett, rschirm, roy
clear log, auto-purge
from SPA_BI
I would assume your repository indexes are blown. Make sure there are no other connections to the project in question and rebuild them. You can either do this directly using DS.REINDEX or using Option #2 - Rebuild Repository Indices - from the DS.TOOLS menu, both accessed from a TCL prompt.
The caveat about making sure no other connections exist is very important. If you are unsure, stop and restart DataStage to ensure this.
The caveat about making sure no other connections exist is very important. If you are unsure, stop and restart DataStage to ensure this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not indexes - the RT_... tables are not indexed.
This error message usually occurs when you're trying to attach to a job that is incomplete, perhaps because someone is in the process if deleting it.
It can also occur if the connection from Director to server has been interrupted, even temporarily.
Instead of running DS.TOOLS or DS.REINDEX, try executing the DS.CHECKER command, which checks for orphaned Repository objects.
This error message usually occurs when you're trying to attach to a job that is incomplete, perhaps because someone is in the process if deleting it.
It can also occur if the connection from Director to server has been interrupted, even temporarily.
Instead of running DS.TOOLS or DS.REINDEX, try executing the DS.CHECKER command, which checks for orphaned Repository objects.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For Craig's edification - or at least to assuage his curiosity - can you please check whether DS.CHECKER recorded its activity in a file in the &COMO& subdirectory in your project and, if so, please post its contents?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.