Not able to remove Fisheye Application Link

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

After working through Remove an application link from Jira server using SQL, you see the following error:

The webpage at http://localhost:8081/jira/plugins/servlet/applinks/listApplicationLinks might be temporarily down or it may have moved permanently to a new web address.
Error code: ERR_CONTENT_DECODING_FAILED

または

2013-11-04 21:08:06,246 http-bio-8081-exec-14 ERROR      [500ErrorPage.jsp] Exception caught in 500 page org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getOrphanedTrustCertificates' in  class com.atlassian.applinks.ui.velocity.ListApplicationLinksContext threw exception java.lang.NullPointerException at com/atlassian/applinks/ui/admin/list_application_links.vm[line 80, column 20]
com.atlassian.templaterenderer.RenderingException: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getOrphanedTrustCertificates' in  class com.atlassian.applinks.ui.velocity.ListApplicationLinksContext threw exception java.lang.NullPointerException at com/atlassian/applinks/ui/admin/list_application_links.vm[line 80, column 20]
	at com.atlassian.templaterenderer.velocity.one.six.internal.VelocityTemplateRendererImpl.render(VelocityTemplateRendererImpl.java:113)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getOrphanedTrustCertificates' in  class com.atlassian.applinks.ui.velocity.ListApplicationLinksContext threw exception java.lang.NullPointerException at com/atlassian/applinks/ui/admin/list_application_links.vm[line 80, column 20]
	at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223)
...
Caused by: java.lang.NullPointerException
	at com.atlassian.applinks.core.DefaultTypeAccessor.loadApplicationType(DefaultTypeAccessor.java:106)
	at com.atlassian.applinks.core.DefaultApplicationLinkService.retrieveApplicationLink(DefaultApplicationLinkService.java:396)

There are a couple inconsistencies in the Fisheye/Crucible application link as the Project Mapping data has not been cleared up completely

In this example, our applink key is 'd04c4377-186a-3973-a0d4-1b4c4e2c79eb'.

To find the key of the Fisheye instance you want to remove, please use:

SELECT SUBSTR(a.property_key,16,36) as "Application Key", b.propertyvalue as "Application Name" FROM propertyentry a join propertystring b on a.id=b.id where a.property_key like 'applinks.admin%name';

-- NOTE: For MSSQL use the following query:
SELECT substring(a.property_key,16,36) as "Application Key", b.propertyvalue as "Application Name" FROM propertyentry a join propertystring b on a.id=b.id where a.property_key like 'applinks.admin%name';
  1. Jira を停止します。
  2. Run the following SQL commands and make sure every query is returning results:

    SELECT * from propertyentry where id in (select id from propertytext where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%');
    SELECT * from propertytext where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%';
    SELECT * from propertyentry where id in (select id from propertystring where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%');
    SELECT * from propertystring where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%';
    SELECT * from propertystring where id in (select id from propertyentry where property_key like '%Project_Key%');
    SELECT * from propertytext where id in (select id from propertyentry where property_key like '%Project_Key%');
    SELECT * from propertyentry where property_key like '%<Project_Key>%';
  3. Next , run the SQL commands below to delete the corrupted data:

    delete from propertyentry where id in (select id from propertytext where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%');
    delete from propertytext where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%';
    delete from propertyentry where id in (select id from propertystring where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%');
    delete from propertystring where propertyvalue like '%d04c4377-186a-3973-a0d4-1b4c4e2c79eb%';
    delete from propertystring where id in (select id from propertyentry where property_key like '%Project_Key%');
    delete from propertytext where id in (select id from propertyentry where property_key like '%Project_Key%');
    delete from propertyentry where property_key like '%Project_Key%';
  4. Restart JIRA and delete the Fisheye/Crucible Application Link via UI.

最終更新日 2018 年 7 月 31 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.