JIRA shows "Configured by OnDemand" in DVCS page
Platform Notice: Data Center Only - This article only applies to Atlassian apps on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
After migrating from JIRA Cloud to JIRA Server, the DVCS page will show Configured by OnDemand as per the following screenshot. Users are unable to to remove this account as the Delete button is not visible:
Cause
In the AO_E8B6CC_ORGANIZATION_MAPPING table in the JIRA database, the ACCESS_TOKEN value of this account is null. All accounts with ACCESS_TOKEN of null will display the Configured by OnDemand image and will not be removable
Resolution
Manually add values to the database to remove that image and make it possible to delete the account
Warning: Backup your database before proceeding.
Before running any SQL in this article, create a full backup of your Jira database. This is a database-level operation with no undo other than restoring from backup. Only proceed if you're comfortable running SQL directly against the Jira database, and test on a staging or cloned environment first, wherever possible.
Stop JIRA
Run the following query to determine which account has the null value
select * from "AO_E8B6CC_ORGANIZATION_MAPPING";Take note of the row with no values in ACCESS_TOKEN and remember the NAME
Run the following query to add a value to that row
update "AO_E8B6CC_ORGANIZATION_MAPPING" set "ACCESS_TOKEN"='SF4Uu8aTjymhRyHaVE&UMq7YHL9k3hZp6ctLRAQxmc72eTqHkfj' where "NAME"='<name>';Replace <name> with the value of the NAME column in step 3
Restart JIRA
The image should be gone now and you should be able to remove the account.
Was this helpful?