Content survey and reporting - 500 Error

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?

2 answers

0 votes

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?

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.

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)

0 votes

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.

Any update on the MS-SQL fix?

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

60 views 4 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you