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

EWS: Table "PROCESSINSTANCELOG" not found

XMLWordPrintable

      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
      ...

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

                Created:
                Updated:
                Resolved: