Removing a Project from DataStage Administrator

ray.wurlod · Post by **ray.wurlod** » Wed Mar 13, 2013 1:17 pm

Removing the directory has caused all kinds of issues. You will - at the very least - need to remove entries from UV.ACCOUNT and UV_SCHEMAS (the latter using VERIFY.SQL), and the project entry from the XMETA database.

priyadarshikunal · Post by **priyadarshikunal** » Wed Mar 13, 2013 1:37 pm

If you want to recover, you can create that folder and put 6 required files to the folder as described here. Then run ISALite to recover the VOC and other stuff.

If you want to just get rid of it, you can start from here

Regards,

priyadarshikunal · Post by **priyadarshikunal** » Wed Mar 13, 2013 2:15 pm

Can you check if there are any stray locks present in is console having same session id?

joycerecacho · Post by **joycerecacho** » Wed Mar 13, 2013 2:24 pm

priyadarshikunal wrote:If you want to recover, you can create that folder and put 6 required files to the folder as described here. Then run ISALite to recover the VOC and other stuff.

Actually my friend I don't have any of these 6 files.
But this project that I created is an empty one, I mean, there is no job or anything else. I just created to check a default information and then delete it .
I copied these 6 files from the Template directory to the project directory and, when I logged in at the Administrator and tried to delete the project, the following message appeared:

Invalid project name supplied (39129)

joycerecacho · Post by **joycerecacho** » Wed Mar 13, 2013 2:51 pm

priyadarshikunal wrote:Can you check if there are any stray locks present in is console having same session id?

No, there is not, my friend!!

Thankssss

priyadarshikunal · Post by **priyadarshikunal** » Thu Mar 14, 2013 7:53 am

if there is no such thing, I think you need to cleanup abandoned locks in xmeta repository before you try to delete the entries for this project.

There is a shell script cleanup_abandoned_locks.sh which needs to be run using root. You can find the details for clearing locks here.

priyadarshikunal · Post by **priyadarshikunal** » Thu Mar 14, 2013 8:10 am

Actually VOC must be created using ISALite in FIX mode and should not be copied from template which is mentioned there as well. But anyways check my previous post to get rid of that abandoned lock preventing the project to be deleted.