Querying Jira on premise's Exalate database for error lists

General Questions
3

To query the Exalate database for Jira on-premise and retrieve the specified error list information, you’ll need to write a SQL query. However, you should first ensure that you have the necessary permissions and access to the database.

Here’s an example SQL query that might help you retrieve the required information:

SELECT
    local_issue_id,
    remote_issue_id,
    connection_name,
    description,
    root_cause_details,
    root_cause_detail_text,
    root_cause_error_type_name,
    creation_time
FROM
    exalate_errors

Explanation:

  • local_issue_id, remote_issue_id: Retrieve the local and remote issue IDs.
  • connection_name: Retrieve the name of the connection.
  • description: Retrieve the description of the error.
  • root_cause_details, root_cause_detail_text, root_cause_error_type_name: Retrieve details related to the root cause of the error.
  • creation_time: Retrieve when the error was created.

Make sure to adapt the table name exalate_errors and column names if they are different in your actual database schema. Also, ensure that the necessary SQL query permissions are in place to run this query on your Exalate for Jira database.

For more specific guidance or further customization, you may want to consult official Exalate documentation or reach out to your database administrator.

If you have any more questions or need further assistance, feel free to ask!