/
BigPicture Errors and Box Creation Issues on Jira 11.3.7 with Oracle JDBC Drivers

BigPicture Errors and Box Creation Issues on Jira 11.3.7 with Oracle JDBC Drivers

Troubleshooting: BigPicture Errors and Box Creation Issues on Jira 11.3.7 (Oracle Database)

This article covers two scenarios related to BigPicture compatibility issues with Oracle JDBC drivers following an upgrade to Jira 11.3.7.

Summary

After installing or upgrading to BigPicture version 8.70.11.1 on Jira Data Center 11.3.7, users may encounter persistent error notifications in the bottom-left corner and an inability to create or edit Boxes. These issues are rooted in compatibility conflicts between the app and specific Oracle JDBC driver versions. This article provides a short-term workaround and a permanent solution.

Scenario 1: Compatibility Issue with Oracle JDBCDriver 19.3 (ojdbc8.jar)

Problem

When using the Atlassian-certified ojdbc8.jar (version 19.3.0.0.0) driver, BigPicture fails to perform database write operations. Users see an error message: java.lang.IllegalStateException: Can't create selected view and are unable to create new Boxes.

Cause

BigPicture version 8.70.11.1 and earlier versions in the 8.70.x stream had a compatibility issue with the standard Oracle JDBC 19.3 driver on Jira 11.x environments.

Solution (Permanent)

Update BigPicture to version 8.70.11.3 or later. This version includes a specific fix to restore compatibility with the ojdbc8.jar 19.3.0.0.0 driver.

  1. Navigate to Administration > Manage apps.

  2. Locate BigPicture and update to version 8.70.11.3 (released August 12, 2026) or higher.

  3. Verify that Box creation and general app navigation no longer trigger error tokens.

Scenario 2: Short-term Workaround (Driver Upgrade)

Context

If you are unable to update the BigPicture app immediately but need to restore functionality, a driver-level workaround is available. Note that this involves using a driver version not explicitly listed in Atlassian's primary supported platforms documentation for Jira 11.3.

Workaround

Upgrade the Oracle JDBC driver to ojdbc11.jar version 23.26.1.0.0.

Steps to Implement:

  1. Backup: Perform a full backup of Jira and your Oracle database.

  2. Download: Obtain ojdbc11.jar (version 23.26.1.0.0) from the Oracle JDBC download page.

  3. Stop Jira: Shut down the Jira instance.

  4. Replace Driver:

    • Navigate to the Jira installation lib directory (e.g., <jira-install>/lib/).

    • Remove the existing ojdbc8.jar (or any other ojdbc*.jar files).

    • Copy the new ojdbc11.jar into the lib/ directory.

  5. Cluster Note: If running Jira Data Center, repeat these steps on every application node.

  6. Start Jira: Restart the instance.

  7. Verification:

    • Go to Administration > System > System info.

    • Confirm the Database Driver is reported as Oracle JDBC driver - 23.26.1.0.0.

    • Test BigPicture by creating a Box to ensure the IllegalStateException is resolved.

Related Error Logs

The following error pattern is typical for this issue:

2026-07-02 13:02:31,864+0200 http-nio-8080-exec-12 url: /rest/softwareplant-bigpicture/1.0/ppm/box/aggregation/OVERVIEW_HIERARCHY_COLUMN/boxes/ROOT/refresh; ERROR [c.s.u.rest.exceptionhandling.RequestThrowableTokenizer] Token: [Unique-Error-Token], Exception: java.lang.IllegalStateException: Can't create selected view