DSXchange

Folks,

I'm unable to delete some projects with the DataStage Administrator yet others deleted just fine. I get the following permissions error.

ACCESS DENIED: Cannot lock project. Could not get exclusive access to the project. Ensure no other DataStage users are attached

I checked the sessions and there are no active sessions out there. The permissions on the /opt/IBM/InformationServer/Server/Projects/<project_name> folder are rwxrwxr-x - 0775 on the AIX server. Has anyone run into this or have suggestions? Thanks everyone.

How about inactive sessions? Have you tried to do this after bouncing the services?

Yes, they recycled the DS server and I tried the delete. We are going to reboot the machine this weekend if we can't figure it out. I used there god id , isadmin, dsadmin, etc. nothing worked.

The access denied is probably in the XMETA database. Can you check whether there are any entries in the XMETA.XMETALOCKINFO table?

Having the same problem.

- No users are attached to the project.
- No entry in XMETALOCKINFO table.

Were you able to resolve this problem? Any suggestions?

Welcome aboard.

All projects, or just one? Have you checked the local repository locks (the LIST.READU command)?

We had a number of orphan processes so we killed them and rebooted and then were able to delete the project. We are going to add a term step in our jobs when errors are detected. Hope this keeps us from getting so many orphan processes.