[JRASERVER-68475] Custom Field Optimizer shows blank screen (Jira Data Center) with Oracle database

Type: Bug
Resolution: Fixed
Priority: Low (View bug fix roadmap)
Fix Version/s: 7.12.4, 7.13.1
Affects Version/s: 7.12.3
Component/s: System Administration - Others
Labels:

Fixed in Long Term Support Release/s:

Download 7.13
Introduced in Version:
7.12
Support reference count:
4
Symptom Severity:
Severity 2 - Major
UIS:
15
Bug Fix Policy:
View Atlassian Server bug fix policy

Summary

Users on Data Center trying to open the CustomFieldOptimizer after the first scan will get a blank page and will not be able to make use of this feature.

Symptoms

The 'Custom Field Optimizer' is running into the following NullPointerException:

2018-11-21 16:55:22,673 http-nio-7123-exec-18 ERROR admin 1015x455x2 14fjner 0:0:0:0:0:0:0:1 /rest/optimizer/1/recommendations/info [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: null
java.lang.NullPointerException
	at com.atlassian.jira.optimizer.ao.RecommendationsDao.parceProjectIdString(RecommendationsDao.java:74)
	at com.atlassian.jira.optimizer.beans.RecommendationBean.<init>(RecommendationBean.java:66)
	at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
	at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
	at com.atlassian.jira.optimizer.impl.RecommendationsManager.getRecommendations(RecommendationsManager.java:183)
	at com.atlassian.jira.optimizer.impl.DefaultOptimizerService.getRecommendationsInfo(DefaultOptimizerService.java:109)
	at com.atlassian.jira.optimizer.rest.OptimizerResource.getRecommendationsInfo(OptimizerResource.java:103)
	... 3 filtered
	at java.lang.reflect.Method.invoke(Method.java:498)
	... 19 filtered
	at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154)
	... 1 filtered
	at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68)
	... 32 filtered
	at com.atlassian.servicedesk.internal.web.ExternalCustomerLockoutFilter.doFilter(ExternalCustomerLockoutFilter.java:56)
	... 13 filtered
	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
	... 53 filtered
	at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
	... 1 filtered
	at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
	... 16 filtered
	at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)
	... 19 filtered
	at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
	... 5 filtered
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.lambda$invokeFilterChain$0(CustomerContextSettingFilter.java:181)
	at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.rteInvoke(ReentrantThreadLocalBasedCodeContext.java:137)
	at com.atlassian.servicedesk.internal.api.util.context.ReentrantThreadLocalBasedCodeContext.runOutOfContext(ReentrantThreadLocalBasedCodeContext.java:90)
	at com.atlassian.servicedesk.internal.utils.context.CustomerContextServiceImpl.runOutOfCustomerContext(CustomerContextServiceImpl.java:47)
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.outOfCustomerContext(CustomerContextSettingFilter.java:174)
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilterImpl(CustomerContextSettingFilter.java:130)
	at com.atlassian.servicedesk.internal.web.CustomerContextSettingFilter.doFilter(CustomerContextSettingFilter.java:121)
	... 4 filtered
	at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:32)
	... 8 filtered
	at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
	... 4 filtered
	at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
	... 26 filtered
	at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
	... 24 filtered
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)

This is affecting JIRA application running with Oracle database.

Cause:

When we run the optimizer scan, "AO_0AC321_RECOMMENDATION_AO" database table is populated. If the PROJECT_IDS is empty, NULL is inserted instead of en empty string – for Oracle database.

package com.atlassian.jira.optimizer.ao where class resides -

RecommendationsDao.class

public static List<Long> parceProjectIdString(String projectIdString) {
        return "".equals(projectIdString) ? Collections.emptyList() : (List)Stream.of(projectIdString.split(",")).map(Long::parseLong).collect(Collectors.toList());
    }

Reproduce

Create Oracle database for Jira
Connect Jira DC to database
Create Project (empty or sample)
Create custom field with global context
Navigate to Jira administration -> System -> Custom Field Optimizer
Do initial scan
Come back to 'Custom Field Optimizer' page

Expected Results

User should see recommendations

Actual Results

Blank screen for this feature

Workaround

No workaround for Oracle database users, as "AO_0AC321_RECOMMENDATION_AO" is always re-populated on scan, so removing the NULL records won't work.

mentioned in: Page Failed to load; Page Failed to load; Page Failed to load; Page Failed to load; Page Failed to load; Page Loading...

relates to: POSTSEFCON-6027 Loading...; FLASH-1167 Loading...

(1 mentioned in, 2 relates to)

set-jac-bot made changes - 22/May/2020 8:24 AM

Fixed in Enterprise Release/s

New: [Download 7.13|https://confluence.atlassian.com/enterprise/atlassian-enterprise-releases-948227420.html]

llagos added a comment - 17/Jun/2019 4:09 PM - edited

we have 2 JSD DC 7.12.3... prod and a clone (dev), both using MS-SQL Server. On prod, this option is missing.. in Dev, it shows up... however, if I copy&paste the URL from dev to prod, it shows up as well...

<jira;:port>/secure/admin/CustomfieldsAnalyzer.jspa

So, what the ...???

llagos added a comment - 17/Jun/2019 4:09 PM - edited we have 2 JSD DC 7.12.3... prod and a clone (dev), both using MS-SQL Server. On prod, this option is missing.. in Dev, it shows up... however, if I copy&paste the URL from dev to prod, it shows up as well... <jira;:port>/secure/admin/CustomfieldsAnalyzer.jspa So, what the ...???

Bugfix Automation Bot made changes - 28/Mar/2019 12:26 AM

Minimum Version

New: 7.12

Mila made changes - 14/Mar/2019 2:39 PM

Remote Link

New: This issue links to "Page (Confluence)" [ 415412 ]

Mila made changes - 13/Mar/2019 3:26 PM

Remote Link

New: This issue links to "Page (Confluence)" [ 415219 ]

Kamil Kolonko made changes - 29/Jan/2019 2:17 PM

Resolution		New: Fixed [ 1 ]
Status	Original: Waiting for Release [ 12075 ]	New: Closed [ 6 ]

kasia (Inactive) made changes - 11/Jan/2019 1:50 PM

Remote Link

Original: This issue links to "POSTSEFCON-6027 (Bulldog)" [ 406405 ]

New: This issue links to "POSTSEFCON-6027 (Bulldog)" [ 406405 ]

kasia (Inactive) made changes - 11/Jan/2019 1:49 PM

Remote Link

New: This issue links to "POSTSEFCON-6027 (Bulldog)" [ 406405 ]

Marek Piwnicki made changes - 09/Jan/2019 1:58 PM

Remote Link

New: This issue links to "Page (Confluence)" [ 405898 ]

Mila made changes - 04/Jan/2019 7:52 AM

Labels

Original: data-center pse-request warranty

New: data-center data-center-specific pse-request warranty

Assignee:: Ilya Zinoviev (Inactive)

Reporter:: KellyW (Inactive)

Affected customers:: 4 This affects my team

Watchers:: 11 Start watching this issue

Created:: 21/Nov/2018 6:08 AM

Updated:: 22/May/2020 8:24 AM

Resolved:: 29/Jan/2019 2:17 PM

Jira Data Center

Details

Description

Summary

Symptoms

Cause:

Reproduce

Expected Results

Actual Results

Workaround

Attachments

Issue Links

Forms

Activity

Collapse comment: llagos added a comment - 17/Jun/2019 4:09 PM, Edited by llagos - 17/Jun/2019 4:10 PM

Expand comment: llagos added a comment - 17/Jun/2019 4:09 PM, Edited by llagos - 17/Jun/2019 4:10 PM

People

Dates