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.
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.
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.