topic Re: dynamic collections 200 item limit and error in Alfresco Archive

dynamic collections 200 item limit and error

tmath1 — Sat, 17 Sep 2011 01:55:22 GMT

Brian,I recently upgraded to 3.4.4 from 3.4 to take advantage of various performance upgrades specifically around was. Btw great job with performance updates. One of the features that was very attractive and necessary was for dynamic collections to return more than 200 items. This was supposedly up

Re: dynamic collections 200 item limit and error

tmath1 — Sun, 18 Sep 2011 14:08:23 GMT

Brian,

Here is the issue that we are having in Enterprise 3.4.4 although it was fixed in 3.4.1:

https://issues.alfresco.com/jira/browse/ALF-6590

ALF-6590 WebQS - Dynamic collection returning over 200 results causes 500 website exception

We get the same nullpointer error that you see in JIRA.

As always, thanks for your prompt reply.

Tom

Re: dynamic collections 200 item limit and error

bremmington — Sun, 18 Sep 2011 14:53:46 GMT

I've just checked through the source for 3.4.4, and the code changes made to fix ALF-6590 are still in place. Please would you paste in the full stack trace(s) that you're seeing (webapp and repo side as appropriate)?

Re: dynamic collections 200 item limit and error

tmath1 — Sun, 18 Sep 2011 21:19:10 GMT

I get this error in my browser for 201 items that are returned from my collection list-annoucement:


SURF    Web Script Status 500 - Internal Error

The Web Script /intranet/service/template/list-announcements has responded with a status of 500 - Internal Error.

500 Description:   An error inside the HTTP server which prevented it from fulfilling the request.
 
Message:   08182010 Failed to execute script 'org.springframework.extensions.webscripts.ResourceStore$WebApplicationStoreScriptContent@2e8a3ebe': 08182009
    
Exception:   org.springframework.extensions.webscripts.WebScriptException - 08182009
    
   org.springframework.extensions.webscripts.processor.JSScriptProcessor.executeScriptImpl(JSScriptProcessor.java:324)
    
Exception:   org.springframework.extensions.webscripts.WebScriptException - 08182010 Failed to execute script 'org.springframework.extensions.webscripts.ResourceStore$WebApplicationStoreScriptContent@2e8a3ebe': 08182009
    
   org.springframework.extensions.webscripts.processor.JSScriptProcessor.executeScript(JSScriptProcessor.java:200)
    
Server:   Spring WebScripts - v1.0.0 (Release Candidate 2 864) schema 1,000
Time:   Sep 18, 2011 4:08:43 PM
    
Diagnostics:   Inspect Web Script (template/list-announcements/list-announcements.get)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: dynamic collections 200 item limit and error

tmath1 — Sun, 18 Sep 2011 21:20:32 GMT

Here is my Query and it's working fine:

SELECT d.*, announce.* FROM cmis:document AS d JOIN swmed:announcement AS announce ON d.cmisbjectId = announce.cmisbjectId WHERE in_tree(d, '${channel:./}') order by announce.swmed:launchDate DESC

Re: dynamic collections 200 item limit and error

tmath1 — Sun, 18 Sep 2011 21:45:51 GMT

my logs show a connection refused error:

Failed to make request to Alfresco web script
java.net.SocketException: Connection reset
        at java.net.SocketInputStream.read(SocketInputStream.java:168)
        at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
        at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
        at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
        at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
        at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116)
        at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: dynamic collections 200 item limit and error

bremmington — Mon, 19 Sep 2011 07:56:11 GMT

That last stack trace has been snipped off at an unfortunate point. Please would you paste the full trace here?

Re: dynamic collections 200 item limit and error

bremmington — Thu, 22 Sep 2011 08:43:03 GMT

I've just tried this out using 3.4.4. I was using the "section.articles" asset collection on the news section for the test, increasing its maximum size to 3000 assets and copying the news articles in the lower sections lots of times. I ended up with about 400 articles in the collection. This collection is shown in its entirety on the landing page of the news section, and was working fine - I saw no errors.

I don't doubt that you are, of course, but I'm not sure that what you're seeing is exactly the same as ALF-6590. Please paste full stack traces of the errors you're seeing (webapp and repo side), and I'll try to work out what's going on.