topic Alfresco Error for Document Library in Alfresco Archive

Alfresco Error for Document Library

neil_benn — Thu, 03 Nov 2011 19:04:57 GMT

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*:alfre

Re: Alfresco Error for Document Library

mikeh — Thu, 03 Nov 2011 21:16:47 GMT

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

Re: Alfresco Error for Document Library

neil_benn — Thu, 03 Nov 2011 21:21:52 GMT

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

Re: Alfresco Error for Document Library

neil_benn — Sun, 13 Nov 2011 11:42:36 GMT

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

Re: Alfresco Error for Document Library

mikeh — Sun, 13 Nov 2011 14:18:58 GMT

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

Re: Alfresco Error for Document Library

neil_benn — Thu, 24 Nov 2011 12:21:04 GMT

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

Re: Alfresco Error for Document Library

mikeh — Thu, 24 Nov 2011 14:28:13 GMT

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

Thanks,
Mike

Re: Alfresco Error for Document Library

neil_benn — Thu, 24 Nov 2011 15:42:05 GMT

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

Re: Alfresco Error for Document Library

mikeh — Thu, 24 Nov 2011 16:55:03 GMT

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

Re: Alfresco Error for Document Library

neil_benn — Thu, 24 Nov 2011 18:29:33 GMT

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.

Re: Alfresco Error for Document Library

mikeh — Thu, 24 Nov 2011 22:14:57 GMT

No problem - glad we got this one fixed!

Thanks,
Mike

Re: Alfresco Error for Document Library

neil_benn — Tue, 27 Dec 2011 15:59:23 GMT

Hello,

I'm glad to add that Alfresco 4.0 does not suffer from the same problem with office documents - I have a few other problems caused by the upgrade but the slow office documents have gone away!

Regards,

Neil

Re: Alfresco Error for Document Library

rockyrakhi — Fri, 12 Jul 2013 00:52:31 GMT

org.alfresco.error.AlfrescoRuntimeException: 06110143 Can not get preferences for admin because there was an error pasing the JSON data.

can any body give any idea on this

thanks in Advance.

Re: Alfresco Error for Document Library

thaond — Mon, 11 Aug 2014 04:08:56 GMT

org.alfresco.error.AlfrescoRuntimeException: 07110364 Can not get preferences for hieutl because there was an error parsing the JSON data.
And the error trace is:
<blockcode>
2014-08-11 11:00:27,662 ERROR [extensions.webscripts.AbstractRuntime] [http-apr-80-exec-1] Exception from executeScript - redirecting to status template error: 07110090 org.alfresco.error.AlfrescoRuntimeException: 07110359 Can not update preferences for hieutl because there was an error pasing the JSON data.
org.springframework.extensions.webscripts.WebScriptException: 07110090 org.alfresco.error.AlfrescoRuntimeException: 07110359 Can not update preferences for hieutl because there was an error pasing the JSON data.
        at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1053)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
        at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:429)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:491)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:529)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:341)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
        at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1810)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:724)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 07110359 Can not update preferences for hieutl because there was an error pasing the JSON data.
        at org.alfresco.repo.preference.PreferenceServiceImpl$2.doWork(PreferenceServiceImpl.java:447)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
        at org.alfresco.repo.preference.PreferenceServiceImpl.setPreferences(PreferenceServiceImpl.java:376)
        at org.alfresco.repo.preference.script.ScriptPreferenceService.setPreferences(ScriptPreferenceService.java:130)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
        at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
        at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
        at org.mozilla.javascript.gen.c10._c1(file:/opt/alfresco-4.2.e/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/preference/preferences.post.json.js:21)
        at org.mozilla.javascript.gen.c10.call(file:/opt/alfresco-4.2.e/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/preference/preferences.post.json.js)
        at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
        at org.mozilla.javascript.gen.c10._c0(file:/opt/alfresco-4.2.e/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/preference/preferences.post.json.js:41)
        at org.mozilla.javascript.gen.c10.call(file:/opt/alfresco-4.2.e/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/preference/preferences.post.json.js)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
        at org.mozilla.javascript.gen.c10.call(file:/opt/alfresco-4.2.e/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/preference/preferences.post.json.js)
        at org.mozilla.javascript.gen.c10.exec(file:/opt/alfresco-4.2.e/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/preference/preferences.post.json.js)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:502)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:200)
        at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
        at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:174)
        at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
        at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1305)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)
        … 28 more
Caused by: org.json.JSONException: A JSONObject text must begin with '{' at character 0
        at org.json.JSONTokener.syntaxError(JSONTokener.java:413)
        at org.json.JSONObject.<init>(JSONObject.java:180)
        at org.json.JSONObject.<init>(JSONObject.java:420)
        at org.alfresco.repo.preference.PreferenceServiceImpl$2.doWork(PreferenceServiceImpl.java:396)
        … 54 more
</blockcode>
Could you help me on this problem
Best regards!

Re: Alfresco Error for Document Library

dranakan — Thu, 30 Jun 2016 06:22:37 GMT

Hi,

We get same problem after a crash system. The .bin with the preferences was empty (>= "A JSONObject text must begin with '{' at character 0").

You can delete user's preferences using curl : curl -u admin:admin -X delete http://SERVER:8080/alfresco/service/api/people/XXUSERXX/preferences

Best regards.