Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-8988

The "org.jbpm.executor.commands.error.ProcessAutoAckErrorCommand" execution fails on Postgres database.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.33.0.Final
    • None
    • None
    • NEW
    • NEW
    • Hide

      Step-1: Create datasource and make the database Integration with RHPAM 7.5.1 by adding the given properties into </system-properties>.
      ~~~~~~~~~~~~~~
      <property name="org.kie.server.persistence.ds" value="java:jboss/datasources/postgresDatasource"/>
      <property name="org.kie.server.persistence.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
      ~~~~~~~~~~~~~

      step-2: Import the customer's jar 'AutoAckProject-1.0.0-SNAPSHOT.jar' in the PAM from the artifact of the project setting.

      step-3: Create the KIE server by configuring the deployment unit from the 'Execution Servers' in the Menu tab.
      ~~~~~~~~~~~~

      • Add deployment unit
      • Select the jar from the GAV column --> next --> Finish
        ~~~~~~~~~~~~~

      step-4: Start the process from the 'Process Definitions' without passing any value.
      ~~~~~~~~~~~~~

      • var1 should leave empty to get the "Caused by: java.lang.NumberFormatException: For input string: "
        exception.
        ~~~~~~~~~~~~~

      step-5: Abort the process from the 'Process Instances'.

      step-6: Open the 'Jobs' inside the ' Manage' tab of the 'Menu' tab.

      step-7: Create a 'New Job' with the given these two parameters.
      ~~~~~~~~~~~~~~~~~~~~
      Business Key : AnyNameHere
      Type* : org.jbpm.executor.commands.error.ProcessAutoAckErrorCommand
      ~~~~~~~~~~~~~~~~~~~

      Show
      Step-1: Create datasource and make the database Integration with RHPAM 7.5.1 by adding the given properties into </system-properties>. ~~~~~~~~~~~~~~ <property name="org.kie.server.persistence.ds" value="java:jboss/datasources/postgresDatasource"/> <property name="org.kie.server.persistence.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/> ~~~~~~~~~~~~~ step-2: Import the customer's jar 'AutoAckProject-1.0.0-SNAPSHOT.jar' in the PAM from the artifact of the project setting. step-3: Create the KIE server by configuring the deployment unit from the 'Execution Servers' in the Menu tab. ~~~~~~~~~~~~ Add deployment unit Select the jar from the GAV column --> next --> Finish ~~~~~~~~~~~~~ step-4: Start the process from the 'Process Definitions' without passing any value. ~~~~~~~~~~~~~ var1 should leave empty to get the "Caused by: java.lang.NumberFormatException: For input string: " exception. ~~~~~~~~~~~~~ step-5: Abort the process from the 'Process Instances'. step-6: Open the 'Jobs' inside the ' Manage' tab of the 'Menu' tab. step-7: Create a 'New Job' with the given these two parameters. ~~~~~~~~~~~~~~~~~~~~ Business Key : AnyNameHere Type* : org.jbpm.executor.commands.error.ProcessAutoAckErrorCommand ~~~~~~~~~~~~~~~~~~~
    • 2020 Week 04-06 (from Jan 20)

    Description

      ProcessAutoAckErrorCommand execution fails on Postgres with two
      different type of errors:

      (1) No entries in ProcessInstanceLog:

      Caused by: org.postgresql.util.PSQLException: ERROR: operator does not
      exist: character varying = bigint
      at
      org.jbpm.executor.commands.error.ProcessAutoAckErrorCommand.findErrorsToAck(ProcessAutoAckErrorCommand.java:64)

      (2) Entries in ProcessInstanceLog:

      Caused by: org.postgresql.util.PSQLException: Large Objects may not be
      used in auto-commit mode.
      at
      org.jbpm.executor.commands.error.ProcessAutoAckErrorCommand.findErrorsToAck(ProcessAutoAckErrorCommand.java:55)

      So both queries defined in this command are incompatible with Postgres.

      Attachments

        Issue Links

          Activity

            People

              elguardian@gmail.com Enrique González Martínez (Inactive)
              elguardian@gmail.com Enrique González Martínez (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: