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

Error when i click on Process Instances tab in Business Central

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 6.3.0.GA
    • Business Central

    • jboss-bpmsuite-6.3.0.GA
      Database : IBM DB2

    • Compatibility/Configuration
    • Hide

      1. Configure datasource to IBM DB2 .
      2. Create required tables out side application under a schema (for example jbpm).
      3.Change the below in Persistance.xml (

      {JBOSS_HOME}

      \standalone\deployments\business-central.war\WEB-INF\classes\META-INF):
      a)Update dialect to <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />.
      b)Added <property name="hibernate.default_schema" value="jbpm" /> all tables are created under jbpm schema.
      3) Changed value from update to validate in "<property name="hibernate.hbm2ddl.auto" value="validate" />"

      Deploy the business central application

      Show
      1. Configure datasource to IBM DB2 . 2. Create required tables out side application under a schema (for example jbpm). 3.Change the below in Persistance.xml ( {JBOSS_HOME} \standalone\deployments\business-central.war\WEB-INF\classes\META-INF): a)Update dialect to <property name="hibernate.dialect" value="org.hibernate.dialect.DB2Dialect" />. b)Added <property name="hibernate.default_schema" value="jbpm" /> all tables are created under jbpm schema. 3) Changed value from update to validate in "<property name="hibernate.hbm2ddl.auto" value="validate" />" Deploy the business central application

    Description

      After clicking on Process Instance tab in Business Central application application is not able to fetch data.

      I have create all the tables manually under a schema called jbpm ,i have not used hbm auto generation due to restriction from DBA.
      The application starts but fails when i click on the ProcessInstances/Task tab in business central. The application fetches data like select * from userid.tablename instead of jbpm.Tablename (here jbpm is my schema name)

      Note :I am not facing issue if application generates its own schema

      Attachments

        1. DB2_DDL_SCRIPT.sql
          47 kB
          Sandesh jayaprakash
        2. server.log
          185 kB
          Sandesh jayaprakash

        Activity

          People

            swiderski.maciej Maciej Swiderski (Inactive)
            sandesh.j Sandesh jayaprakash (Inactive)
            Jan Hrcek Jan Hrcek (Inactive)
            Jan Hrcek Jan Hrcek (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: