dynamic collections 200 item limit and error

[tmath1]

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 updated in 3.4.1.  However I was disappointed that I'm not able to get collections of more than ~ 120 + items.

please help. I'm going live with our site and I need this feature on our news archives pages. I might be missing a updated jar file or some Lucene configuration to handle more than 200 items.  I get a null pointer error when I set my number of items in my collections to ~120 or more.

tom

[tmath1]

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

[bremmington]

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)?

[tmath1]

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)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[tmath1]

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

[tmath1]

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)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[bremmington]

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

[bremmington]

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.