This documentation is for an old version of Dataplane Reports.
View the latest documentation, or the list of documentation for all versions.
FAQ
Frequently Asked Questions
- 1 General
- 1.1 Can Dataplane report on issues created before it was installed or only on those issues created or modified after installation?
- 1.2 How current is the data I'm viewing in Dataplane Reports?
- 1.3 Does Dataplane Reports modify Jira project or issue data?
- 1.4 Is Dataplane Reports subject to the same 1000 issue export limit as the Jira Issue Navigator?
- 2 Dashboard Gadgets
- 2.1 When using Dataplane Reports gadgets in Confluence, why am I getting an authentication prompt?
- 2.2 When using Dataplane Reports gadgets in Confluence, why am I getting a PermissionException error?
- 2.3 When using Dataplane Reports gadgets in Confluence, why am I getting HTTP 504 timeout errors?
- 2.4 When using Dataplane Reports gadgets in Confluence, why is the gadget blank or cannot be configured?
- 2.5 I'm still having problems with rendering Dataplane Reports gadgets in Confluence. Help!
- 3 Jira Issue Fields
- 4 Calculations and Values
- 5 Fonts
- 6 Administration
- 7 Security
- 8 Licensing
General
Can Dataplane report on issues created before it was installed or only on those issues created or modified after installation?
Dataplane reports on the entire history of your Jira instance, providing a comprehensive analysis of even those issues created or modified before Dataplane Reports was installed.
When Dataplane Reports is first installed, it automatically indexes your entire Jira instance history including every issue creation, workflow transition, and field value change ever made. Once the initial index is complete, all subsequent changes in your Jira instance are tracked by Dataplane Reports in realtime.
So with Dataplane you get the same detailed insight into past project and team performance and metrics as you have going forward.
How current is the data I'm viewing in Dataplane Reports?
After Dataplane Reports does an initial index, upon installation, of your Jira instance history, all subsequent changes in your Jira instance are then tracked by Dataplane Reports in realtime.
So all Dataplane reports reflect the most current state of your Jira issues. There is no delay between Jira issue changes and those changes being reflected in Dataplane Reports, whether those reports are viewed within Dataplane, on Jira dashboards, or in Confluence via a Dataplane Reports gadget.
Does Dataplane Reports modify Jira project or issue data?
No. All Jira project and issue data is treated as read-only by Dataplane Reports.
For its performance-optimized reporting and storing of saved reports and other app user data and settings, Dataplane Reports creates and maintains its own separate database tables within the Jira database.
Is Dataplane Reports subject to the same 1000 issue export limit as the Jira Issue Navigator?
No. Dataplane Reports works completely independent of the Jira Issue Navigator and is not subject to this limitation.
If you have not yet run into this limitation in the Jira Issue Navigator, it refers to trying to do an Excel export of the results of a Jira search and being limited to a maximum of 1000 issues (rows) that can be exported at any one time. This can make it difficult to pull comprehensive Jira data into Excel for additional analysis. The limit built into the Jira Issue Navigator is due to potential performance and memory issues with larger exports. You may increase this limit via a Jira configuration parameter but should carefully monitor instance performance and memory usage in making any changes. Any changes made to Jira's export limit is independent of Dataplane Reports and has no effect on your export of issues from Dataplane.
With Dataplane Reports you can easily run reports on and export results containing tens of thousands of issues. Dataplane Reports' Issues Table Report is an excellent substitute for viewing and exporting issues from the Jira Issue Navigator.
Dataplane's report queries are run directly against the Jira database rather than Jira's internal issue cache. So that Dataplane Reports' database queries are not completely unbounded in result size, Dataplane places a soft limit on database query results of 20 million result items (20,000,000 rows x columns of data). While we expect this limit should be more than sufficient for the majority of Jira instances, if running a Dataplane report produces an error indicating this limit has been reached, you may tune the limit with the following JVM parameter:
-Dcom.arsenalesystems.dataplane.query.result.limit=30000000Dashboard Gadgets
When using Dataplane Reports gadgets in Confluence, why am I getting an authentication prompt?
On some systems, after you add a Dataplane report to a Confluence page, users see a message similar to the following at the top of the gadget in Confluence:
If you are a registered user, there may be more information available to you. You will need to log in and approve this gadget's access to your account. (Show Restricted URLs)
[Login & Approve]
This message instructs users to confirm their identity to the Jira server. (The confirmation is performed using the industry-standard OAuth protocol.) When the user clicks "Login & Approve", they will be sent to the Jira server in order to confirm the connection, and they are then returned to Confluence to see the Dataplane report. This authentication prompt is a general feature of all Atlassian Gadget that require user authentication, so it is not specific to Dataplane.
In general, users should only have to perform this approval once. If users need to continually approve the gadget, or if even performing one approval is too much, some alternate solutions are listed below.
Solution 1: Switch to Trusted Application authentication
The easiest way to work around the problem is to configure the Application Link between the two applications to use Trusted Applications authentication. When Trusted Applications authentication is in use, authentication is automatic and users will never be asked to approve the gadget. To enable Trusted Applications:
In Jira, go to Toolgear » Add-ons » Application Links.
Find the Application Link corresponding to your Confluence server, then click "Edit".
Click on "Outgoing Authentication".
Click on the "Trusted Applications" tab (or ensure that it is already selected), then click "Enable".
Click on "Incoming Authentication".
Click on the "Trusted Applications" tab (or ensure that it is already selected), then click "Enable". You may need to scroll to the bottom of the dialog window to find the Enable button.
This procedure will enable Trusted Applications authentication for all gadgets, and the confirmation dialog should no longer appear.
Solution 2: Diagnose and Fix OAuth Configuration
If you do not wish to use (or cannot use) Trusted Applications for your Application Links, but you still receive the approval confirmation dialog more than once per user session, something is likely broken with your OAuth configuration.
Some of the following issues are known to cause problems with the OAuth confirmation:
accessing Confluence (or Jira) with a URL other than the base URL configured in the application's configuration page. For example, if Jira is configured with a base URL of "http://jira.mycompany.com" but users typically access Jira using a shortcut of "http://jira", OAuth may not work properly. To correct this issue, ensure that the base URL is configured correctly in the Jira system configuration, and then ensure that all users are accessing it with that name. If you run Jira behind a web server, you may wish to configure your web server to redirect all nonstandard URLs to the canonical URL.
configuring both Confluence and Jira on the same hostname, only differentiated by a context path or port. OAuth may not always work as desired if, for example, your Confluence server is accessible at http://tools/confluence and Jira is accessible at http://tools/jira. Similarly, trying to access Jira as http://tools:8080 and trying to access Confluence as http://tools:8090 may also cause problems. In this scenario, consider creating different hostnames for each applications. Both services can still continue to be run on the same physical or virtual machine, but they should be given their own distinct hostnames and URLs.
One additional tool for investigating OAuth problems is the OAuth authentication tokens page in the user's profile. To access this tool:
First, log onto Confluence as one of the users who is having authentication problems.
Try to display pages containing Dataplane gadgets a few times. Make sure that you authenticate the gadgets more than once.
Next, log into Jira as the same user.
Click on the user profile icon in the top right corner and select "Profile".
Click the "Tools" dropdown in the top right corner of the page, and select "View OAuth Access Tokens".
The subsequent OAuth Tokens page will show a list of all of the approved OAuth Access Tokens for the specified user. If you see a large number of tokens that were all approved at around the same time, you may need to go back and double-check the URL configurations.
When using Dataplane Reports gadgets in Confluence, why am I getting a PermissionException error?
When viewing a Dataplane Reports gadget in Confluence, users may get a message such as the following, even though they are correctly logged into both Confluence and Jira:
PermissionException: In order to access this feature, you need to log in.
This typically happens when using Application Links that are configured with Trusted Applications, but you are using incompatible versions of Jira and Confluence. In particular, Atlassian published a number of security advisories on 2014-02-26 that impact the following versions of Jira and Confluence:
Confluence 5.4.1 and below (official Atlassian security advisory)
Jira 6.1.3 and below (official Atlassian security advisory)
If either your Confluence instance or your Jira instance fall into the above version range, you need to apply the official patches to both systems for the Trusted Applications link to work properly. For example, patching only Jira but not Confluence can lead to the above PermissionException errors, and, likely, other parts of the Application Link will not work correctly either.
If only one of your applications falls into the above version range, that application still must be patched, since the Application Links in later versions of Confluence and Jira are not compatible with earlier versions in the above range that do not have the patch.
When using Dataplane Reports gadgets in Confluence, why am I getting HTTP 504 timeout errors?
By default, Confluence has a short timeout when making HHTP requests to Jira from a Confluence macro. The default timeout in Confluence 6. x and above is only 5 seconds and in Confluence 5. x and below it is 15 seconds.
To solve the problem, you change the default settings in your instance.
How to change the timeout settings
In your Confluence instance, click on the settings icon
.
In Configuration, select General Configuration.
In Connection Timeouts, select Edit to adjust the settings.
If the problem persists, you need to edit the JVM system parameters for Confluence.