topic Re: Missing .bin file after restore in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/missing-bin-file-after-restore/m-p/311063#M264193 <HTML><HEAD></HEAD><BODY><SPAN>When we rolled back the database, the ALF_CONTENT_URL table was still pointing to content that wasn't there after having deleted the contentstore.&nbsp;&nbsp;&nbsp; Basically any time the database is not in sync with the contentstore this problem could arise.&nbsp; Orphaned pointers.</SPAN><BR /><BR /><SPAN>This is what I did to fix the same problem:</SPAN><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>#!/bin/sh</SPAN><BR /><BR /><SPAN>FAVS_PATH="${CONTENTSTORE_HOME}/alf_data/contentstore/2014/4/28/14/58/"</SPAN><BR /><SPAN>FAVS_FILE="${FAVS_PATH}0c2bf591-1138-4a33-bf8b-c28239d80b83.bin"</SPAN><BR /><BR /><SPAN>mkdir -p $FAVS_PATH</SPAN><BR /><SPAN>echo "{}" &gt; $FAVS_FILE</SPAN><BR /><SPAN>chmod 755 $FAVS_FILE</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN><BR /><BR /><SPAN>Here was my error:</SPAN><BR /><SPAN>&lt;em&gt;</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: org.springframework.dao.ConcurrencyFailureException: store://2014/4/28/14/58/0c2bf591-1138-4a33-bf8b-c28239d80b83.bin no longer exists</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>&lt;/em&gt;</SPAN></BODY></HTML> Fri, 29 Jul 2016 21:07:12 GMT aowian 2016-07-29T21:07:12Z Missing .bin file after restore https://connect.hyland.com/t5/alfresco-archive/missing-bin-file-after-restore/m-p/311062#M264192 After we did Alfresco restore some random users couldn't login to Alfresco. In the logs for each login attempt there is following stacktrace:REPO_ 2015-11-16 16:46:12,569&nbsp; ERROR [extensions.webscripts.AbstractRuntime] [http-apr-9443-exec-9] Exception from executeScript - redirecting to status templa Tue, 17 Nov 2015 14:27:15 GMT https://connect.hyland.com/t5/alfresco-archive/missing-bin-file-after-restore/m-p/311062#M264192 streetturtle 2015-11-17T14:27:15Z Re: Missing .bin file after restore https://connect.hyland.com/t5/alfresco-archive/missing-bin-file-after-restore/m-p/311063#M264193 <HTML><HEAD></HEAD><BODY><SPAN>When we rolled back the database, the ALF_CONTENT_URL table was still pointing to content that wasn't there after having deleted the contentstore.&nbsp;&nbsp;&nbsp; Basically any time the database is not in sync with the contentstore this problem could arise.&nbsp; Orphaned pointers.</SPAN><BR /><BR /><SPAN>This is what I did to fix the same problem:</SPAN><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>#!/bin/sh</SPAN><BR /><BR /><SPAN>FAVS_PATH="${CONTENTSTORE_HOME}/alf_data/contentstore/2014/4/28/14/58/"</SPAN><BR /><SPAN>FAVS_FILE="${FAVS_PATH}0c2bf591-1138-4a33-bf8b-c28239d80b83.bin"</SPAN><BR /><BR /><SPAN>mkdir -p $FAVS_PATH</SPAN><BR /><SPAN>echo "{}" &gt; $FAVS_FILE</SPAN><BR /><SPAN>chmod 755 $FAVS_FILE</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN><BR /><BR /><SPAN>Here was my error:</SPAN><BR /><SPAN>&lt;em&gt;</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>Caused by: org.springframework.dao.ConcurrencyFailureException: store://2014/4/28/14/58/0c2bf591-1138-4a33-bf8b-c28239d80b83.bin no longer exists</SPAN><BR /><SPAN>…</SPAN><BR /><SPAN>&lt;/em&gt;</SPAN></BODY></HTML> Fri, 29 Jul 2016 21:07:12 GMT https://connect.hyland.com/t5/alfresco-archive/missing-bin-file-after-restore/m-p/311063#M264193 aowian 2016-07-29T21:07:12Z