CMS file deletion

[Shamseer Abdullah]

Hi

I recently created a file in CMS libray named as x.sql. I then deleted the file from it's physical location to delete the particular version which I have created.
Now on existing cms library eventhough the file is not physically existing it is still showing the history and not allowing me to reserve/ create new element with the same file name.

Can anybody please help me to remove the link which cms have that it is referring to a file which is not existing.

Screenshot of the error is attched.

Regards
Shamseer

[Steven Schweda]

> Screenshot of the error is attched.

No, and a bit of plain text would probably
be more useful than an image of your screen.

> [...] created a file in CMS libray [...]

I believe that one creates _elements_ in a
CMS library:

HELP CMS CREATE

And then one may delete them:

HELP CMS DELETE [ELEMENT]

If I actually used CMS, I could probably tell
you more.

[Shamseer Abdullah]

Hi Stephen

You are almost there

The problem was instead of cms delete I used

delete

Hence the physical file has disappered from the CMS location. however the links are still existing. Can you please advice

Regards
Shamseer

[Heinz W Genhart]

Hi Abdullah

First of all welcome to HP ITRC OpenVMS Forum.

If I'm right you did the following:

$ cms cre element x.sql ""
$ delete 'location_of_cmslibrary':x.sql;*

and now you have the problem described above.

I tested the following

$ cre /dir [.cmslib]
$ cms cre lib [.cmslib] "description"
$ cms cre element login.com ""
$ delete [.CMSLIB.CMS$000]LOGIN.COM;1

Now I can't create another element LOGIN.COM. If I try to do so, I receive

%CMS-E-NOCREATE, error creating element DISK:[GENI.CMSLIB]LOGIN.COM
-CMS-E-ALRDYEXISTS, DISK:[GENI.CMSLIB]LOGIN.COM is already a element name

But I can do the following:

$ CMS DELETE ELEMENT LOGIN.COM ""
$ CMS CRE ELEMENT LOGIN.COM

This works, but the history records remain within the cms library.
You can then delete the history with

$ CMS DELETE HISTORY login.com ""

Hope that works for you

regards

Geni

[Shamseer Abdullah]

Thank you Geni..

The problem is resolved. Many thanks for your help....

[Shamseer Abdullah]

The error was resovled

[Robert Atkinson]

Shamseer, you could also use the '$ CMS VERIFY /REPAIR' command, which should fix any inconsistencies within your library.

Rob.