SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Deleted Object Still Appears Checked-out

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 109
Accepted Solution

Deleted Object Still Appears Checked-out

(DI Studio 4.9)

 

i have a library designed specifically for testing a proof of concept. That proof is over, so I wanted to delete it. I checked it out first, then deleted it. The library is no longer in my Checkout tree, however it appears in the Folder tree still (noted as checked out by me) as well as appearing under Libraries in Management Console.

 

I seem to be stuck here. I can't checkout the library to attempt another deletion because SAS thinks it's checked out to me . It's not in my checkout list and nor can I delete it from Management Console.

 

Any suggestion on what to do from here?

 

Thanks,

-Jeff


Accepted Solutions
Solution
a month ago
SAS Employee
Posts: 28

Re: Deleted Object Still Appears Checked-out

You are not missing anything, 

It has been a while since I deleted objects via a Project repository so I incorrectly assumed a check-in was neccessary.

 

You are correct it should have disappeared.

 

A couple of things to do:

 

- Check the Metadata Server log , it might reveal the underlying problem.

- Before checking out the object, select the Checkouts tab, right click and select Clear. That will clear your project repository in case corrupted data has been created. Now try and check-out your object again and delete it.

 

If the problem persists you may have to do a Analyze/Repair of your metadata repositories. This is done from SAS Management Console. Remember to backup the metadata repositories before doing that. Repeat the Analyze/Repair until no more errors are found.

 

If this does not help, please raise a track with SAS Tech Support.

View solution in original post


All Replies
SAS Employee
Posts: 28

Re: Deleted Object Still Appears Checked-out

did you commit your delete?

 

Regards,

Michael

Frequent Contributor
Posts: 109

Re: Deleted Object Still Appears Checked-out

Posted in reply to MichaelLarsen

Hmmm....I'm not sure what that means in the context of DI Studio.

I followed the same procedure I always have when I wanted to delete an object:

1) check it out to my repository

2) rt-click and delete

3) confirm deletion in the alert window

4) object is deleted

 

What am I missing?

 

Thanks!

Solution
a month ago
SAS Employee
Posts: 28

Re: Deleted Object Still Appears Checked-out

You are not missing anything, 

It has been a while since I deleted objects via a Project repository so I incorrectly assumed a check-in was neccessary.

 

You are correct it should have disappeared.

 

A couple of things to do:

 

- Check the Metadata Server log , it might reveal the underlying problem.

- Before checking out the object, select the Checkouts tab, right click and select Clear. That will clear your project repository in case corrupted data has been created. Now try and check-out your object again and delete it.

 

If the problem persists you may have to do a Analyze/Repair of your metadata repositories. This is done from SAS Management Console. Remember to backup the metadata repositories before doing that. Repeat the Analyze/Repair until no more errors are found.

 

If this does not help, please raise a track with SAS Tech Support.

Frequent Contributor
Posts: 109

Re: Deleted Object Still Appears Checked-out

[ Edited ]
Posted in reply to MichaelLarsen

@MichaelLarsen, thanks!

'Clearing' out the Checkout tree unlocked the object. I could then check it out (again) and delete it...this time successfully!

 

Cheers!

-Jeff

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 173 views
  • 0 likes
  • 2 in conversation