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 vote

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 vote

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published 7 hours ago in Hipchat

Moving from Hipchat to Stride? Here’s what you’ll love

Heya, Hipchat friends! We’re so happy you’re checking out   Stride. Whether you know it or not, you have been instrumental in making Stride come to life. Every feature, design, and functionality...

30 views 0 3
Read article

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