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.

Error when delete files

LuchoRod

Greetings,

We have installed ACS and we when we try to delete some files inside a Document Library, after waiting for a while just can't. At the log file shows the following:

the error is this: org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2

I need to know why this happens (is not just with one file, there are a lot) and how to delete those files. Any thoughs? Thanks in advance.

Find more posts tagged with

Alfresco Content Services

Comments

narkuss

Well it seems you have more than one node with the same nodeRef, could it be possible? Did you import nodes in some way? You should detect the repeated nodes and delete them separately.

Hope it helps

LuchoRod

We just upload file through Alfresco Share, how do i know about the repeated nodes?

Thanks in advance.

narkuss

You can check the nodeId of your files acessing the document-details. Then you will find the nodeId at the end of the url:

<url>/document-details?nodeRef=workspace://SpacesStore/9c8d15bf-75d8-4c0a-ab1c-bed62151df8e

To automate this process, you could use the javascript-console addon. Use below code to get all the nodeIds and names from all the documents in the folder:

var parent = search.findNode("your-folder-nodeRef");
parent.children.forEach(function(c) {
	logger.log("nodeId: " + c.getId() + " Filename: " + c.getName());
}, this);

Where "your-folder-nodeRef" must be substituted by the parent folder nodeRef.

Use this code as a base to check repeated nodeRefs in case there are lots of files.

Hope it helps