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

[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?