JIRA shows NullPointerException in the Incoming Authentication configuration to Fisheye

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.

Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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

The following is seen when accessing Incoming/Outgoing Authentication tab for a Trusted Apps link

Screenshot from Fisheye

Screenshot from JIRA



The following trace is thrown in the atlassian-jira.log

2015-02-12 04:19:00,037 TP-Processor55, 
unique_id=VNxwBArD2pkAAANjtHUAAAAT, time=1423732740031, 
uri=/jira/plugins/servlet/applinks/auth/conf/trusted/inbound-ual/de13fbde-be24-32ba-9f25-78cbd341430e
 ERROR      [500ErrorPage.jsp] Exception caught in 500 page null
java.lang.NullPointerException
    at com.atlassian.applinks.core.auth.trusted.ProviderConfigurationServlet.render(ProviderConfigurationServlet.java:320)
    at com.atlassian.applinks.core.auth.trusted.ProviderConfigurationServlet.doGet(ProviderConfigurationServlet.java:134)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at com.atlassian.applinks.ui.AbstractApplinksServlet.service(AbstractApplinksServlet.java:157)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:42)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java)
    at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:52)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java)
    at com.atlassian.jira.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

Cause

The trustedapp table in the JIRA database is missing the entry for this particular application

Resolution

Configure the Application Links authentication by following the OAuth security for application links guide.


Click here to expand for an alternative resolution option...

Please contact the Atlassian Support before applying the steps below

Manually enter the value in the database following these steps

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  1. Stop JIRA

  2.  Run the following query against your JIRA database

    SELECT a.propertyvalue, b.PROPERTY_KEY
FROM propertyentry as b LEFT JOIN propertystring as a ON a.ID = b.ID
LEFT JOIN propertynumber as c ON a.ID = c.ID
WHERE PROPERTY_KEY LIKE '%rpc.url%'
  3. Identify the application which is running into this problem. In the property_key column, you see see something like "applinks.admin.a73d7d06-6693-36fb-9a92-d919e60d73fc.rpc.url".
  4. a73d7d06-6693-36fb-9a92-d919e60d73fc would be the important string from this query

  5. Run the following query replacing the string you retrieved from the above query

    select b.propertyvalue 
FROM propertyentry as a LEFT JOIN propertystring as b on a.ID=b.ID
WHERE property_key LIKE '%a73d7d06-6693-36fb-9a92-d919e60d73fc.trustedapps.incoming.applicationId%'

  6. The result would be something like 0A3C020B014B92B73479F06B21620778

  7. In the Fisheye Instance Directory, open the config.xml

  8. Towards the bottom of this file, copy the string located between <publicKey>...</publicKey>

    <currentApplication><id>0A3C020B014B92B73479F06B21620778</id><publicKey>MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAibBKVYUEJLx3HrRoHxED+5ITxP51qFXnCMWHPp3/WnprVis2Lg3NMNeHgWLzN5BijYXPm+2yFUsZJ80rkOx9CaFL+dx5ohLnXltR/WpyJwhcqGXp9CO7GielMWUIxziCtIvKB5//Pcy1c46WwphgQfWNdQX8ViD4TbcA0k1F1wuHKWEIs2Yk4cJjofdHJql4NAH4PaBV2iPNc7I3+58owRD05hSx6xrgMu+rf66QOLdQpi7jI7IZR7mqzd+visB2whEapKKSX3yiQS62JUygUa1UJRnf+YXPYFMxymdCD7ft9bqq7Si8laIDoOkdRJELKaa5+4EkrHfyjj6t85eqqwIDAQAB</publicKey><privateKey>MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCJsEpVhQQkvHcetGgfEQP7khPE/nWoVecIxYc+nf9aemtWKzYuDc0w14eBYvM3kGKNhc+b7bIVSxknzSuQ7H0JoUv53HmiEudeW1H9anInCFyoZen0I7saJ6UxZQjHOIK0i8oHn/89zLVzjpbCmGBB9Y11BfxWIPhNtwDSTUXXC4cpYQizZiThwmOh90cmqXg0Afg9oFXaI81zsjf7nyjBEPTmFLHrGuAy76t/rpA4t1CmLuMjshlHuarN36+KwHbCERqkopJffKJBLrYlTKBRrVQlGd/5hc9gUzHKZ0IPt+31uqrtKLyVogOg6R1EkQspprn7gSSsd/KOPq3zl6qrAgMBAAECggEATPrsRG4PB/761obk4+GeiWt9dBkUbR5CAmx1lfO+Dbb+Bfo423zJ6PHHh/ZrpvgpsZhLn5FAjJklIlSac/dUXSr6EGNM+el5xA5og7ecxOfu7hO0vtOvSws5V6l2Q/P7V7gEJ0kz6jhmhooFDh0lTBtekDvdfcYHLWQQqIOddYHg+D4uryzhmlzbQv6+CM96siopTSRqjtDGKhDLgIFhNTJuIguzib6zmMGw0fZM3pPcRGptThdrzc1FqeIK+pjeFNYEp4KdDtcRBwBPGpt3HaFnasNsD1NMvRHZjF9tLR8uEQ/THOERpn4KK9cQUIkgObWO+jyqqZYgEiZQ20v8gQKBgQDKJbnvecH0qwY+4PLhjC+VKlndLuzDk6y84HdxM3acqJFqd+iJk9pIf5Jb/yC0POU0h2VUj+kdNxX01P/HZYcvoMICKcxZp7aUE7wuTWhOeZU4CcrOcM1V4IrRbCebiArzqpSshV1Vdo0dufc0Pw45r7SfrJeCGLP+Xt3CJKlo6wKBgQCuXojnCYGHYNcy4AnDMYoFysb70yC0tEJHwdvy6/rl6a0CCFJHrFBWlprt5nfqTOAcv0RmMo2QOwb+5fpGjy9r/nrCVkYDDL7BVIrrpigQlKJFiWR/eorEYU9AIwzowM99oMVzQNQR0uE4P5HZUXXfofBr0Q56CBTnfQFV/rpVQQKBgQCiIR3+7yXbqWvJ9Lt4oOns9lm6547n0cJifpntxfvk6+IthVyRM2+IZCEr/fTp+klPFyTzbLToRK0sf8Vh1JFXZtUTzRhj8/qgyy9L57O39RX0Kw5pAtn9fal5DAi8WqGGCxNRR2mzSPEnnWailcxAAieZRWEC6/M5Gjc8JhFl3wKBgQCV2VYrvuaa8iVealzZa3xjB+XDSqijwvnm8vnTpOrkpNHymjYjtDkCgME6S8KoD1LWQaVFcpJn7eJQMlHIS4sEcxkKY9wdCNnyCXatlwh9X06pFa7RQv14UOwrgTO53uEx5HVrW74kZyb4EOGFclUrT97uuSWIx+M3IR2ByrxVQQKBgFWLOt97/PkKSAyzIa0EXyXzyvG8ryKifw05fqC79kiQ78UTuOSPBM35ljEwBXtIMbc3VoxLyRcW8oOEO1OteD2L6u6v0Unv6uDiGRagbJT842XHkibutU3j3+9s0LwPTMJxN8JzFHczqiLP6496EnwPkaVFGYL/OvJqlThSt0Lj</privateKey></currentApplication><trustedApplication><name>jira:10175990</name><id>jira:10175990</id><publicKey>MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApZ8ZnIFi9hw0XGP3a5in/EJxewDi4kPrLrGiZpgBwxgQ/M/vVQ5kz16gxuxyujNBQBmNj3FesiOZy641jTtp+TgoXn0Y7l7Wiy12yXEd/n3M4EobBBLnoYrt3jy7+EfO+n7E4/HRqmEq6csWEyS+Tn8UbgQJWsJs5QidARc6+IkLbu9ti82Xu2bDOYtNiMOayYDHxbAifiHfOc0c4HdInNsjjawgvIcYfjZ+MDVgYzh0F8GKlRxj2VhZiz9iW1I4TziBwv0ao0VFpayp937ee1MV5no9uLlRd8Jyv0RgXH1owmzUmlqcViB8gV/S6mvoboIn/jv+5KFlNsazmHV+gwIDAQAB</publicKey><certificateTimeout>10000</certificateTimeout></trustedApplication><trustedApplication><name>jira:4639306</name><id>jira:4639306</id><publicKey>MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAgJ5CC92mVClLbVWuXYFwRW9HN91rcraFoKvNjmRLi/qi1nzntFTh1vNXUHRkur4u2LkUhsYUK+J215OY2LcuNN02zTSaPxCIeG76uQ8iulsRfzvpDJyHjVI47VmK6yXjOEJ8Vb7E/3BN4pgo1UFcD2aFPfCl5xAT0kGwfh32moNsSZfA7kTOmG0OgSoujefOHNeIK1iVrF1fAgmElLi8q8/QePDOBR8DKdCAnKvSfQQfkjGVaaikVpSzEMDKOuUBqfS5I5uozbeIbYtXTSEnO3/Z7m7WXODS/bNhs8J4yvmo5OcMPOdZoBBBBbiNaiRjpldDbGS7VFvHn+fnHZ+aGwIDAQAB</publicKey><certificateTimeout>10000</certificateTimeout></trustedApplication><check-for-updates/><snippet/></config>

  9. In the above example, it will be

    MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAibBKVYUEJLx3HrRoHxED+5ITxP51qFXnCMWHPp3/WnprVis2Lg3NMNeHgWLzN5BijYXPm+2yFUsZJ80rkOx9CaFL+dx5ohLnXltR/WpyJwhcqGXp9CO7GielMWUIxziCtIvKB5//Pcy1c46WwphgQfWNdQX8ViD4TbcA0k1F1wuHKWEIs2Yk4cJjofdHJql4NAH4PaBV2iPNc7I3+58owRD05hSx6xrgMu+rf66QOLdQpi7jI7IZR7mqzd+visB2whEapKKSX3yiQS62JUygUa1UJRnf+YXPYFMxymdCD7ft9bqq7Si8laIDoOkdRJELKaa5+4EkrHfyjj6t85eqqwIDAQAB

  10. Run the following query against your JIRA database

    insert into trustedapp values (99999,'<result from #5>','<result from #5>','<string from #8>','','',10000,'2015-01-13 14:16:59.707+08','<admin username>','2015-01-13 14:16:59.707+08','<admin username>');

    Replace the items in <> with the results obtained from the previous steps. In this example, it would be the following query

    insert into trustedapp values (99999,'0A3C020B014B92B73479F06B21620778','0A3C020B014B92B73479F06B21620778','MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAibBKVYUEJLx3HrRoHxED+5ITxP51qFXnCMWHPp3/WnprVis2Lg3NMNeHgWLzN5BijYXPm+2yFUsZJ80rkOx9CaFL+dx5ohLnXltR/WpyJwhcqGXp9CO7GielMWUIxziCtIvKB5//Pcy1c46WwphgQfWNdQX8ViD4TbcA0k1F1wuHKWEIs2Yk4cJjofdHJql4NAH4PaBV2iPNc7I3+58owRD05hSx6xrgMu+rf66QOLdQpi7jI7IZR7mqzd+visB2whEapKKSX3yiQS62JUygUa1UJRnf+YXPYFMxymdCD7ft9bqq7Si8laIDoOkdRJELKaa5+4EkrHfyjj6t85eqqwIDAQAB','','',10000,'2015-01-13 14:16:59.707+08','admin','2015-01-13 14:16:59.707+08','admin');

  11. Restart your JIRA

Last modified on Jan 24, 2025

Was this helpful?

Yes
No
Provide feedback about this article

Related content

  • No related content found
Powered by Confluence and Scroll Viewport.