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
        2. server.log
          185 kB

        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: