Alfresco discussion and collaboration. Stick around a few hours after asking a question.
Official support for Enterprise subscribers: support.alfresco.com.
Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.
More information about the channel is in the wiki.
More help is available in this list of resources.
2019-11-05 08:11:56 GMT <alfresco-discord> <MorganP> Hello xkahn
2019-11-05 08:12:27 GMT <alfresco-discord> <MorganP> If you took the correct query (with the store on the last line), it should be working no matter in which store the file is
2019-11-05 08:12:45 GMT <alfresco-discord> <MorganP> Because it doesn't limit anything on the store id
2019-11-05 08:13:59 GMT <alfresco-discord> <MorganP> Can you just execute a simple: SELECT u.content_url AS "Location" FROM alf_content_url AS u WHERE u.content_url='store://YYYY/MM/DD/HH/MM/id.bin';
2019-11-05 08:14:26 GMT <alfresco-discord> <MorganP> To see if there is an entry in the alf_content_url table for the path you are looking for
2019-11-05 08:21:10 GMT <alfresco-discord> <MorganP> If there is no row, then the file might have been removed? In this case, it would have been moved to the contentstore.deleted folder and the row in the alf_content_url table has been removed as I described in another of my blog (https://blog.dbi-services.com/understand-the-lifecycle-of-alfresco-nodes/)
2019-11-05 08:21:12 GMT <alfbot> Title:Understand the Lifecycle of Alfresco Nodes - Blog dbi services Understand the Lifecycle of Alfresco Nodes - Blog dbi services (at blog.dbi-services.com)
2019-11-05 08:22:24 GMT <alfresco-discord> <MorganP> Maybe you can try a find from the alf_data folder (parent of contentstore & contentstore.deleted folders): find . -name c1c62ed0-dd19-473e-9235-73917935e2f3
2019-11-05 08:23:51 GMT <alfresco-discord> <MorganP> (it should keep the same path on the contentstore as well as contentstore.deleted if it was deleted)
2019-11-05 12:24:33 GMT <xkahn> MorganP: Ah! It's as you said. I found it!
The other logs are at http://esplins.org/hash_alfresco