Problem

Collaborative Editing does not work due to Stored AppID is missing from the DB. Even after restarting Synchrony or reenabling Collaborative Editing, the issue persists and pages can't be created or edited.

Environment

Confluence 7.2.1, 7.4.2

Diagnosis

ERROR

You will see the following error in the atlassian-confluence.log:

2020-08-07 04:36:20,042 ERROR [http-nio-8090-exec-40] [synchrony.api.v1.SynchronyTokenResource] generateToken Stored AppID is null, this instance may not have been configured.

Database

Check if AppID exists on the following tables:

select * FROM BANDANA where bandanakey like '%synchrony_collaborative%' order by bandanakey;
select * FROM "SECRETS";

The AppID would look like the following:

synchrony_collaborative_editor_app_id	<string>Synchrony-e8880686-c3f5-3b52-a39c-0ca91c65ce3f</string>
synchrony_collaborative_editor_app_secret	<string>aEev0jWWApE2qnHeLtVjCUnEJKkBeZ8lbJPyWf0TlLs=</string>

If the AppID does not exist in the above outputs, Collaborative Editing will be fail with the above error.

Cause

We cannot confirm what caused the missing AppID, but it should be recreated when Collaborative Editing is reenabled. But we found that the AppID is not created, if the below flag is set as true when we turn off Collaborative Editing:

synchrony_collaborative_editor_app_registered <string>true</string> 

Solution

1. Disable Collaborative Editing
2. Stop the Confluence

3. Clear all AppID related values and Synchrony data in the DB:

   DELETE FROM bandana WHERE bandanakey = 'synchrony_collaborative_editor_app_registered'
            OR bandanakey = 'synchrony_collaborative_editor_app_secret'
            OR bandanakey = 'synchrony_collaborative_editor_app_id';
   
   TRUNCATE TABLE "EVENTS";
   TRUNCATE TABLE "SECRETS";
   TRUNCATE TABLE "SNAPSHOTS";

4. Start Confluence
5. Enable Collaborative Editing