clear log, auto-purge

[SPA_BI]

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?

[chulett]

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.

[ray.wurlod]

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.

[chulett]

Huh... ok. Also saw one post with the error where the response was a possible permissions problem. Curious what the 'checker' turns up. Is it just a checker or is it a fixer as well?

[ray.wurlod]

Fixer as well. Finishes any incomplete deletions.

[SPA_BI]

Resolved - Ray was right!

[ray.wurlod]

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?

[chulett]

Me like edification.