0 Replies Latest reply on Mar 13, 2017 7:38 AM by Sandesh jayaprakash

    Error after clicking on Process Instance tab in Business central

    Sandesh jayaprakash Newbie

      I am facing error when generating schema manually instead for generating automatically from hbm files.


      16:44:37,838 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http- SELECT * FROM ProcessInstanceLog

      16:44:37,839 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http- SELECT * FROM ProcessInstanceLog

      16:44:37,840 ERROR [org.dashbuilder.dataprovider.sql.JDBCUtils] (http- SELECT TOP 1 * FROM ProcessInstanceLog

      16:44:37,841 ERROR [org.dashbuilder.exception.ExceptionManager] (http- Can't get metadata on specified data set: jbpmProcessInstances: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmProcessInstances

        at org.dashbuilder.dataset.DataSetManagerImpl.getDataSetMetadata(DataSetManagerImpl.java:181)


      I have create schema manually from the DDL scripts and made below configuration changes,

      Changes in  Persistance.xml ({JBOSS_HOME}\standalone\deployments\business-central.war\WEB-INF\classes\META-INF):

      1)Update dialect to <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect" />.  {I am using MS SQL SERVER  2014}

      2)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" />"


      Changes in hibernate.cfg.xml ({JBOSS_HOME}\standalone\deployments\dashbuilder.war\WEB-INF\etc) :

      Added new property  "<property name="hibernate.default_schema">jbpm</property> "  under  <session-factory>


      After clicking on Processintance  Instances tab i am facing error. I am attaching full trace .

      Note :I am not facing issue if hbm generates tables own its own.