Troubleshooting SQL Exceptions
If you get an exception similar to those shown below, it is a good idea to increase the logging levels of your Confluence instance. If you request Atlassian support, this additional logging will help us work out the cause of the error.
Increased logging levels will enable us to diagnose errors like these:
This document outlines the steps to take to increasing logging on your system.
confluence/WEB-INF/classes/log4j.propertiesand uncomment the following lines. The double ## lines are comments, leave them intact. If you can not locate these lines in your
log4j.propertiesfile, please add them to the end of it.
- Restart Confluence.
- Redo the steps that led to the error.
- Zip up your logs directory and attach it your support ticket.
- If you are using Oracle and received a constraint error, please ask your database administrator which table and column the constraint (that is,
CONFLUENCE.SYS_C0012345) refers to and add that information to your support ticket.
confluence/WEB-INF/classes/log4j.propertiesagain and remove the 4 lines you added in step 1. (The additional logging will impact performance and should be disabled once you have completed this procedure.)
Was this helpful?
Thanks for your feedback!