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

PSQLException is show when execute the testExecWithTestRunsAssignedToUser JQL with status

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Done
    • R3.3.0
    • 4.1.0
    • JQL Functions
    • NOK

    Description

      When is used a status, at the Postgres database, a SQL exception is show at the console

      issue in testExecWithTestRunsAssignedToUser('userDPC', "FAIL")

      [c.x.r.dao.impl.DAOContextImpl] Error executing SQL select statement
      org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "tr"
        Position: 430
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
      	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
      	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
      	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
      	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
      	at com.xpandit.raven.dao.impl.DAOContextImpl.executeQuery(DAOContextImpl.java:176)
      	at com.xpandit.raven.dao.impl.TestRunDAOImpl.getTestRunTestExecutions(TestRunDAOImpl.java:77)
      	at com.xpandit.raven.jqlfunc.TestExecWithTestRunsAssignedToUserFunction.getValues(TestExecWithTestRunsAssignedToUserFunction.java:145) 

      Attachments

        Issue Links

          Activity

            People

              dpca Diamantino Campos
              gbml Goncalo Lima
              Claudio Sousa, Fabio Cunha, Sara Santos [X] (Inactive), Tomás Caldas [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 3 hours
                  2d 3h