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

EWS: Table "PROCESSINSTANCELOG" not found

    XMLWordPrintable

Details

    Description

      Description of problem:
      Listing of the Process instances perspective results in DB error in catalina.out

      Version-Release number of selected component (if applicable):
      BPMS 6.2.0.ER5 on EWS2

      How reproducible:
      Always

      Steps to Reproduce:
      1. Deploy business central to EWS2
      2. Start process definition
      3. List process instances

      Actual results:
      Database error

      Expected results:
      Proper listing of PI

      Additional info:
      org.h2.jdbc.JdbcSQLException: Table "PROCESSINSTANCELOG" not found; SQL statement:
      select processname, ifnull(instances,0) total, ifnull(instances_act,0) active, ifnull(instances_compl,0) completed, ifnull(instances_pend,0) pending, ifnull(instances_susp,0) suspended, ifnull(instances_abrt,0) aborted
      from
      (select processinstanceid, processname, count as instances
      from ProcessInstanceLog
      where 1 = 1
      and 1 = 1
      and 1 = 1
      and 1 = 1
      and 1 = 1
      group by processinstanceid,processname) as total
      left outer join
      (select processinstanceid, count as instances_act
      from ProcessInstanceLog
      where status=1
      and 1 = 1
      and 1 = 1
      and 1 = 1
      and 1 = 1
      and 1 = 1
      ...

      Attachments

        Activity

          People

            marco.rietveld Marco Rietveld (Inactive)
            pkralik Pavel Kralik (Inactive)
            Pavel Kralik Pavel Kralik
            Pavel Kralik Pavel Kralik
            Lukáš Petrovický (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: