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.

Using the Content URL, how can I find which file it is?

sselvan

When I was trying to debug for some "content conversion failed" issues in Alfresco log and I happened to see the Content URL mentioned in the log.

I was wondering, is there anyway to find which file is causing this problem, using the ContentURL?

How do we identify which file/which upload caused this error so we can look at the file and see if there's something wrong with the file? The only identifier I can see for it is contentUrl=store://2010/1/22/13/14/6e228904-d5d2-4a99-b7b1-8fe7c03c71f3.bin, which does not help with finding it in the Web UI.

Any help is appreciated. Thank you

Find more posts tagged with

Comments

tommorris

Hi there,

I'm not sure how to query it from within alfresco, but try looking directly in the SQL tables.
The alf_node_properties table has a 'string_value' property which contains your value. e.g.
contentUrl=2010/1/22/13/14/6e228904-d5d2-4a99-b7b1-8fe7c03c71f3.bin|mimetype=application/octet-stream|size=728|encoding=UTF-8|locale=en_GB_
This table has a node_id column which relates to the alf_node table that contains the uuid that you're after.

Tom

sselvan

Thanks Tommorris for your response, however I will not be able to look into MySQL tables to debug.

Is there any other way than looking into the database?
Just by using Alfresco app itself, how do I infer?

Thank you

ssaravanan

You can use the alfresco node browser.
Select the store as workspace://SpacesStore
for eg. if your content url is like
contentUrl=2010/1/22/13/14/6e228904-d5d2-4a99-b7b1-8fe7c03c71f3.bin|mimetype=application/octet-stream|size=728|encoding=UTF-8|locale=en_GB_
just copy the node-id which is above - 6e228904-d5d2-4a99-b7b1-8fe7c03c71f3
in the node broser search for the noderef - workspace://SpacesStore/6e228904-d5d2-4a99-b7b1-8fe7c03c71f3

That will show you the details of the document.

zaizi

Try doing an advanced search for content created / modified on 22/1/2010 around 1:14 PM.

sselvan

Thanks zaizi and ssaravanan!
That was helpful.

tommorris

Good idea Zaizi - lateral thinking.

ssaravanan - I might be going mad, but I was pretty sure that the UUID of the file name is not the same as the UUID of the noderef that uses it.
I just had a look with the node browser, which confirmed that… Have you tried this?

Tom
http://www.ixxus.com

sselvan

oh, oh - good catch Tom! I also tried the same, did not really help!
Saravanan - have you tried it before or was your post just logical (in theory) thought? In advance - appreciate your response in this!

ssaravanan

Url addressability in Alfresco is by nodeRef http://wiki.alfresco.com/wiki/URL_Addressability
Content URL is most often the nodeRef only and as you referred uuid of the .bin file & the
nodeRef are not the same.

You probably need to run a sql query as mentioned in this forum post http://forums.alfresco.com/en/viewtopic.php?f=14&t=24590
Hope this helps.

sselvan

@zaizi,

Looks like there is no "time" in advanced search. There is only Date, but no time in Advanced search. so, that will be a problem for me.

@ssaravanan and All

Is there any other way, I can find in Node Browser, because that does not seem to be the right route!?
Any help?

zaizi

You can still use advanced search and check for the day, unless the system has lots of documents. In which case you can always use the node browser to run a lucene query with the time details.