Content survey and reporting - 500 Error

[Richard Scorgie]

Just installed the new updated Confluence 4.0 ready version of this plugin and it looks great right up until I click the results link and I get a 500 Error.

Ideas?

[Jeremy Largman]

I think it's this:

https://studio.plugins.atlassian.com/browse/CKBSP-22

I hope to fix it over the holidays. Please stay tuned to that bug report and I'll update there.

[Richard Scorgie]

Any update on the MS-SQL fix?

[Jeremy Largman]

I've posted a fix. Sorry for the delay!

[Jeremy Largman]

I'm not able to replicate this. What version of Confluence are you using? Also, do you have access to your atlassian-confluence.log, where you can spot the error?

[Richard Scorgie]

Hi Jeezer, Thanks for the quick reply.

I'm using Confluence 4.0.3 with Theme Builder on top of that. I'll check the log file as well.

[Richard Scorgie]

Here is what the log file says:
2011-12-09 14:44:57,279 INFO [TP-Processor3] [atlassian.confluence.status.SystemErrorInformationLogger] writeToLog
Request Unique ID : 7fc3c6f2-1eae-499d-bcb8-fe1e56b4e99b
--------------------------
JVM Stats
--------------------------
allocatedHeap = 496697344
availablePermGen = 112843776
usedMemory = 301986568
totalMemory = 496697344
freeMemory = 194710776
maxPermGen = 268435456
usedPermGen = 155591680
freeMemoryInMegabytes = 185
freeAllocatedHeap = 194710776
availableHeap = 194710776
usedMemoryInMegabytes = 287
maxHeap = 496697344
usedHeap = 301986568
totalMemoryInMegabytes = 473
--------------------------
Request Information
--------------------------
URL: http://cait-km-wiki-stg.ca.nam.example.com/500page.jsp
Scheme: http
Server: cait-km-wiki-stg.internal.com
Port: 80
URI: /500page.jsp
Context Path:
Servlet Path: /500page.jsp
Path Info: null
Query String: key=Wiki
key : Wiki
caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Incorrect syntax near 'LIMIT'.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
caused by: java.sql.SQLException: Incorrect syntax near 'LIMIT'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)