Unable to create or edit pages

Question

In our dev Confluence server environment, we copied the Production database and changed the name, however we are unable to edit any pages or create any new pages.  We've tried restarting Confluence, uninstalling and re-installing Confluence, upgrading Confluence, and we've had the same problem each time.

2023-06-26 18:21:38,345 ERROR [http-nio-8090-exec-9] [atlassian.xwork.interceptors.TransactionalInvocation] commitOrRollbackTransaction Action /pages/editpage.action (EditPageAction.doDefault()) is already completed and can not be committed again.
-- url: /pages/editpage.action | traceId: f67699851882ed14 | userName: kristin | referer: http://localhost:8090/display/NAME/NAME2
2023-06-26 18:21:38,346 ERROR [http-nio-8090-exec-9] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- url: /pages/editpage.action | traceId: f67699851882ed14 | userName: kristin | referer: http://localhost:8090/display/NAME/NAME2
java.lang.NullPointerException

Kristin Lyons · Answer

* We unfortunately no longer have Atlassian Support since we are still on Server. 
* I do not see an option for Check Content Integrity.
* I verified the database collations are the same

Albert Manuel · Answer

Hi there,

A bit odd, but you need to take this step by step - because the message that is received, "NullPointerException" is kinda generic. I would continue the troubleshooting with the following steps:

1) Check Database Consistency: Use Confluence's built-in tool to check for inconsistencies in the database. You can find this in Confluence's Administration section under "Content Tools > Check Content Integrity".

2)Verify Database Collation: Make sure the collation of your development database matches that of your production database. If the collations are different, it could lead to this type of error "NullPointerException"

If none of these steps help, it might be necessary to reach out to Atlassian Support...