nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Is it possible to delete a store

pmarreddy

I want to delete the content of a full store,Is there any mechanism to do this.
If it is possible, what are its implicit and explicit conditions
If it is not possible how to delete the store

Find more posts tagged with

Comments

derek

Hi,

No, there isn't a way to do it. It would have to be hooked into the system at a low level (NodeService) and the Lucene code would have to listen for it and remove the store's index files.

The content will take care of itself, then.

Regards

rdanner

Hi,

No, there isn't a way to do it. It would have to be hooked into the system at a low level (NodeService) and the Lucene code would have to listen for it and remove the store's index files.

The content will take care of itself, then.

Regards

Derek,

You are stating what would have to happen should this be possible? Is there a reason apart from time, technical or design issue why it is not yet possible to delete a store?

derek

Hi,

There is no technical reason why it has not been done. It's the first I've heard of it being required, but that doesn't mean that others wouldn't use the feature if it were there.

Regards

cludt

So, why did you guys implement the web service tests (contained in the SDK) in that way, that each time, a new store is created if you are not able to delete the stores again? I think, there is no way to do it manually, is there?

Maybe, you should think about changing the web service test, then. Wouldn't it be better to create new spaces in e.g. the workspace store for the WS tests? (Except from a test case where you want to create a new store, of course.)

sergio

Hi all!

I agree with all of you who have a need for a method that allows to delete stores. It could be useful to provide such a method in order to clean all the test stores created by the SDK examples.

However, what are the steps needed to be executed manually to delete each reference to a store for which protocol and id are well known?

All the best,

Sergio

cludt

Use the WebServiceAPI: For each reference, run a delete command:

RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();        
        
CMLDelete delete = new CMLDelete(new Predicate(new Reference[] {reference}, reference.getStore(), null));
CML cml = new CML();
cml.setDelete(new CMLDelete[] {delete});
        
// Execute the update
try {
   repositoryService.update(cml);
} catch (RepositoryFault e) {
   […]
} catch (RemoteException e) {
   […]
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Or create one delete for all references.

sergio

Many thanks, very useful.

But is the deleting a store procedure available only via WS?

All the best,

Sergio

cludt

At least not via the web interface. Maybe via the Java Content Repository API. But I have never worked with this, so I cannot tell.

cludt

Sorry sergio, there is no way to delete a store! Just to delete the content / spaces in a store that is usually not accessible via the web interface (e.g. stores created during the web service api test). The procedure I posted is only for deleting content / spaces!

sergio

Thanks Christian!

For the moment it is sufficient. However, after deleting the content of a store it could be convenient to delete the store itself in order to avoid an increasing of garbage inside tha alf_data folder.

I took a look at the structure of the alfresco schema inside my MySql database instance, I found some tables containing references to existing stores, for example the alf_store and alf_node tables. In your opinion could it be enough to delete store reference records from these two tables?

Cheers,

Sergio

cludt

Hi Sergio,

I am not sure if this works. The database and the file system are sort of synchronized. You would also have to delete the lucene index. I don't recommend to delete anything manually in the database. And, btw, the files in the alf_data won't be removed.

If you delete something via SOAP, the deleted items are placed in the "recycle bin", too. So, there might be a solution to delete the items finally.

I don't know anything about deleting a store, maybe one of the developers could help us here.

Regards
Christian