Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-3952

SQLGrammarException in getTasksAssignedAsPotentialOwner executed via Remote API

    XMLWordPrintable

Details

    Description

      Description of problem:

      I use BPMS 6.0.2.ER3 with PostgreSQL 9.2 but I assume that on other databases could be the problem as well. Although, it does work with the default H2 database.

      When I execute getTasksAssignedAsPotentialOwner operation in the JMS TaskService, I get:

      org.kie.services.client.api.command.exception.RemoteApiException: SQLGrammarException thrown with message 'could not extract ResultSet'
      at org.kie.services.client.api.command.AbstractRemoteCommandObject.executeJmsCommand(AbstractRemoteCommandObject.java:358)
      at org.kie.services.client.api.command.AbstractRemoteCommandObject.execute(AbstractRemoteCommandObject.java:126)
      at org.jbpm.services.task.impl.command.CommandBasedTaskService.getTasksAssignedAsPotentialOwner(CommandBasedTaskService.java:185)

      I attached the part of server log where is the full stacktrace of the exception. :

      org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
      Position: 1167
      .....

      Version-Release number of selected component (if applicable):

      How reproducible:

      In your test case, it is not needed to have some existing task. In such scenario the operation should return empty list but in this case it returns the exception.

      It should be enough to run this code:
      List<TaskSummary> tasksForTestUser = taskService.getTasksAssignedAsPotentialOwner("testuser", "en-UK");

      and the list should be empty.

      Steps to Reproduce:
      1.
      2.
      3.

      Actual results:

      Expected results:

      Additional info:

      Attachments

        Activity

          People

            msalatin Mauricio Salatino (Inactive)
            ibek1@redhat.com Ivo Bek
            Ivo Bek Ivo Bek
            Ivo Bek Ivo Bek
            Ivo Bek, Kris Verlaenen, Marek Baluch, Radovan Synek, Rajesh Rajasekaran
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: