Runing confluence 3.5.16
I am trying to remove existing trusted applications after upgrading from 2.10.x. Receive this message Failed to delete orphaned trust certificate: Incorrect result size: expected 1, actual 2
I followed the knowledgebase https://confluence.atlassian.com/pages/viewpage.action?pageId=158107208.
Ran the command on the database SELECT * FROM KEYSTORE;
Received the output.
But received this error message
Does anybody have a solution removing the existing trutsted application.
I need to removed them as they conflicting when I am trying to created new trusted relationship with jira.
If anybody could provide any assistance would be greatly appreicated
1. First, back up the database, just in case
2. Then run these commands against the database in this order:
3. delete from trustedapprestriction;
4. delete from trustedapp;
delete from keystore where alias like 'jira%';
Hopefully you can now make a trusted application with Jira
I'm not keen on Oracle, but the error is pretty clear, you need to find out the parent record that is preventing you from completing the delete statement. Also, if you're confident enough on database manipulation, you might as well drop the constraint that is being reported in the stack trace ((CONFL_OWNER.FKDDB119CA9C85ADB1), I found some instructions here: http://www.java2s.com/Code/Oracle/Constraints/Drop-Constraint.htm
Just bear in mind to create a database backup prior to any changes.
Hope it helps.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
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!
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