Alfresco Error for Document Library

[neil_benn]

Hello,

         I have a problem with one specifc user on our Alfresco system - no-one else has the same problem.  when she logs in and attempts to access the document library she receives the error:

10030013 Wrapped Exception (with status template): 10030026 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 10030025 Failed to open stream onto channel: accessor: ContentAccessor[ contentUrl=store://2011/6/27/11/13/eee289bf-864d-447f-b018-d77f6b907422.bin, mimetype=text/plain, size=0, encoding=utf-8, locale=en_GB]

  I have tried to rebuild the index but Alfresco still fails on me.  I have located the file that gives me the problem but I cannot get much more than that out of the above error.  Does anyone have an idea as to what the problem is - as I mentioned above, it only happens with this user and no-one else.  The Alfresco is 3.4.d and the OS is Ubuntu.

  Thanks, in advance for your help.

Regards,

Neil

[mikeh]

It looks like that file has zero length. Does the actual file on the disk at contentstore/2011/6/27/11/13/eee289bf-864d-447f-b018-d77f6b907422.bin have any content?

Thanks,
Mike

[neil_benn]

Hello,

         In fact - the file is not even there!  Is there a way to expunge it from whatever data source is trying to look for it?

Cheers,

Neil

[neil_benn]

Hello,

        Following on from this - does anyone know how to remove an entry from the database which does not have a matching physical file?  I am confident I have all the files I need - I just need to clean up the database and get a solid starting platform from which I can monitor and determine what is going on.  For now though - my Alfresco installation is useless for this person and we are seriously hindered as we have come to rely upon Alfresco!

  Thanks, in advance, for your help.

Regards,

Neil

[mikeh]

Have you tried creating a dummy file at that location? Then you should be able to delete it from the web interface - might save digging around in the database.

Thanks,
Mike

[neil_benn]

I put an dummy file with a simple bit of text in it at that location but I then get a JSON error when trying to access the file.  I then tried to copy a .bin file from another location but that too gave me an error.

Any help would be greatly appreciated!

Cheers,

Neil

[mikeh]

It might be useful to detail the error(s) here.

Thanks,
Mike

[neil_benn]

OK will do:

When logging into Alfresco without trying anything and accessing the Document Library.

10240165 Wrapped Exception (with status template): 10241255 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 10241254 Failed to open stream onto channel: accessor: ContentAccessor[ contentUrl=store://2011/6/27/11/13/eee289bf-864d-447f-b018-d77f6b907422.bin, mimetype=text/plain, size=0, encoding=utf-8, locale=en_GB]
—
I then made a file with just one char in it at the store location described above and got the error when trying to access the document library:

10240178 Wrapped Exception (with status template): 10241281 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/slingshot/documentlibrary/doclist.get.js': 10241280 Can not get preferences for allpress because there was an error pasing the JSON data.
—

I then tried to copy anohte rbin file from another location and rename it to the name and I got a stack trace after logging in (deleting the file allows me to log in):

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.extensions.surf.exception.UserFactoryException: Unable to retrieve user from repository
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:659)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   org.alfresco.web.site.servlet.MTAuthenticationFilter.doFilter(MTAuthenticationFilter.java:74)
   org.alfresco.web.site.servlet.SSOAuthenticationFilter.doFilter(SSOAuthenticationFilter.java:301)
root cause

org.springframework.extensions.surf.exception.UserFactoryException: Unable to retrieve user from repository
   org.springframework.extensions.surf.support.AlfrescoUserFactory.loadUser(AlfrescoUserFactory.java:188)
   org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:176)
   org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:99)
   org.springframework.extensions.surf.RequestContextUtil.initialiseUser(RequestContextUtil.java:203)
   org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:176)
   org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:131)
   org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.populateRequestContext(AbstractWebFrameworkView.java:349)
   org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.renderMergedOutputModel(AbstractWebFrameworkView.java:259)
   org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
   org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   org.alfresco.web.site.servlet.MTAuthenticationFilter.doFilter(MTAuthenticationFilter.java:74)
   org.alfresco.web.site.servlet.SSOAuthenticationFilter.doFilter(SSOAuthenticationFilter.java:301)
root cause

org.json.JSONException: Unterminated string at character 1812
   org.json.JSONTokener.syntaxError(JSONTokener.java:413)
   org.json.JSONTokener.nextString(JSONTokener.java:244)
   org.json.JSONTokener.nextValue(JSONTokener.java:344)
   org.json.JSONObject.<init>(JSONObject.java:206)
   org.json.JSONTokener.nextValue(JSONTokener.java:347)
   org.json.JSONObject.<init>(JSONObject.java:206)
   org.json.JSONTokener.nextValue(JSONTokener.java:347)
   org.json.JSONObject.<init>(JSONObject.java:206)
   org.json.JSONObject.<init>(JSONObject.java:420)
   org.springframework.extensions.surf.support.AlfrescoUserFactory.loadUser(AlfrescoUserFactory.java:182)
   org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:176)
   org.springframework.extensions.surf.support.AbstractUserFactory.initialiseUser(AbstractUserFactory.java:99)
   org.springframework.extensions.surf.RequestContextUtil.initialiseUser(RequestContextUtil.java:203)
   org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:176)
   org.springframework.extensions.surf.RequestContextUtil.populateRequestContext(RequestContextUtil.java:131)
   org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.populateRequestContext(AbstractWebFrameworkView.java:349)
   org.springframework.extensions.surf.mvc.AbstractWebFrameworkView.renderMergedOutputModel(AbstractWebFrameworkView.java:259)
   org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
   org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
   org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
   org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   org.alfresco.web.site.servlet.MTAuthenticationFilter.doFilter(MTAuthenticationFilter.java:74)
   org.alfresco.web.site.servlet.SSOAuthenticationFilter.doFilter(SSOAuthenticationFilter.java:301)

  The error only happens with this user - no other users have this problem.  I'm happy to purge the entry from the system but I obviously cannot purge the user as I would lose her histrory.  Note that she is designated as an admin.

Thanks - I'm keen to upgrade and keep with Alfresco; if there is ever a training course on setting up and administrating Alfresco I would attend.  Most course seem to be about developing add-ons though.

  Thanks again.

Cheers,

Neil

[mikeh]

OK, judging from the errors, that content item is actually the serialized JSON that we use to store favourite documents, folders & sites.

Try adding

{}‍

as the file and we you no longer get the JSON parsing errors.

Thanks,
Mike

[neil_benn]

YESS!!!!!!!!!!

Thank you very very much - that is a great relief to have that working it was causing serious problems in my company!

I will now attempt to upgrade to v4 on a test machine and then on my live - thanks again.