Uploaded image for project: 'Xray for Jira'
  1. Xray for Jira
  2. XRAY-11654

Xray JQL functions using date values may fail on Oracle

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Ready for Release
    • Major
    • Resolution: Unresolved
    • Xray DC 8.3.0
    • Xray DC 8.4.2
    • JQL Functions
    • None

    • .

    • Standard

    • OK

    Description

      Description
      Xray JQL functions fails for Oracle databases. The datetime is not being properly handled in the SQL queries executed against the db.

      Pre-conditions
      Jira connected to an Oracle database.

      How to reproduce

      1. Run the JQL function: 
        issue in testExecutionsWithCompletedTestRunsSince("2d")

      Actual result/Attachments
      Jira UI doesn't show results.
      In the logs, we see ORA-01830: date format picture ends before converting entire input string:

      2026-04-17 15:37:30,786+0000 http-nio-22348-exec-20 url: /rest/issueNav/1/issueTable; user: admin ERROR admin 937x840x1 dbaq3w 68.183.223.179 /rest/issueNav/1/issueTable [c.x.r.dao.impl.DAOContextImpl] Error executing SQL select statement
java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
......
	at com.xpandit.raven.jqlfunc.TestExecutionsWithCompletedTestRunsSinceFunction.a(Unknown Source)

      Attachments

        Activity

          People

            patricia.mateo Patricia Mateo
            maaf Miguel Fernandes
            Patricia Mateo, Paulo Pereira [X] (Inactive), Pedro Rodrigues
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: