3 Replies Latest reply on Jan 26, 2006 1:01 PM by pedro costa

    jbpm_timer' doesn't exist

    pedro costa Apprentice

      I try to install jbpm with mysql, but when i run jbpm i get the error:

      15:07:48,412 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      15:07:48,412 ERROR [JDBCExceptionReporter] Table 'sgo_bem.jbpm_timer' doesn't exist
      15:07:48,412 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
      15:07:48,412 ERROR [JbpmSession] java.lang.NullPointerException
      15:07:48,412 ERROR [JbpmSession] couldn't rollback hibernate transaction
      org.hibernate.TransactionException: Transaction not successfully started
       at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
       at org.jbpm.db.JbpmSession.handleException(JbpmSession.java:177)
       at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:106)
       at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:121)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:34)
      15:07:48,412 WARN [JbpmSession] can't pop current session: are you calling JbpmSession.close() multiple times ?
      
      


      I've configure the properties and xml files of jbpm.sar.cfg.jar.

      Here are my files:

      jbpm.properties
      jbpm.scheduler.service.factory=org.jbpm.scheduler.impl.SchedulerServiceImpl
      jbpm.task.instance.class=org.jbpm.taskmgmt.exe.TaskInstance
      
      # uncomment the next line if JbpmSessionFactory.getInstance()
      # should lookup the singleton instance from JNDI instead of creating
      # a default one.
      #
      jbpm.session.factory.jndi.name=java:/jbpm/JbpmSessionFactory
      
      # uncomment the next line to use the file system instead of the database for
      # storing files related to a process definition
      #
      # jbpm.files.dir=c:/jbpm.data
      
      # resource path to a properties file that will overwrite all the hibernate
      # properties. For database specific builds in db project there is a different
      # hibernate.properties file on the classpath for each database. You could change
      # the default database for any testing runs by uncommenting the next line and
      # adding a hibernate.properties file in the basedir.
      #
      jbpm.hibernate.cfg.xml=jbpm.hibernate.cfg.xml
      jbpm.hibernate.properties=jbpm.hibernate.properties
      
      
      jbpm.hibernate.properties
      
      
      #hibernate.dialect=org.hibernate.dialect.SQLServerDialect
      hibernate.dialect=org.hibernate.dialect.MySQLDialect
      hibernate.connection.datasource=java:/ds/TestDS
      
      # BFP: Descometei a linha de baixo
      hibernate.show_sql=true
      
      
      
      jbpm.hibernate.cfg.xml
      
      <?xml version='1.0' encoding='utf-8'?>
      
      <!DOCTYPE hibernate-configuration PUBLIC
       "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
       "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
      
      <hibernate-configuration>
       <session-factory>
      
       <!-- jdbc connection properties -->
       <!-- // Comentado por BFP 11-01-2006
       <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
       <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
       <property name="hibernate.connection.url">jdbc:hsqldb:.;sql.enforce_strict_size=true</property>
       <property name="hibernate.connection.username">sa</property>
       <property name="hibernate.connection.password"></property>
       -->
      <!--
       <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
       <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:jtds:sqlserver://isnwassrv:1433/sigo_hf;instance=bts;tds=8.0;SelectMethod=Cursor</property>
       <property name="hibernate.connection.username">hfdev</property>
       <property name="hibernate.connection.password">hfdev</property>
      -->
      
       <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
       <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:mysql://localhost:1433/sigo_bem</property>
       <property name="hibernate.connection.username">root</property>
       <property name="hibernate.connection.password">admin</property>
      
       <!-- c3p0 connection pooling properties
       <property name="hibernate.c3p0.min_size">1</property>
       <property name="hibernate.c3p0.max_size">3</property>
       -->
      
       <!-- other hibernate properties -->
       <property name="hibernate.show_sql">true</property>
      
       <!--identity mapping files -->
       <!-- uncomment if you don't want to use the default jBPM identity mgmgt component -->
       <mapping resource="org/jbpm/identity/User.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
      
       <!-- graph.def mapping files -->
       <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
       <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>
      
       <!-- graph.node mapping files -->
       <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>
      
       <!-- graph.action mapping files -->
       <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>
      
       <!-- context.def mapping files -->
       <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>
      
       <!-- taskmgmt.def mapping files -->
       <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>
      
       <!-- module.def mapping files -->
       <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>
      
       <!-- bytes mapping files -->
       <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>
      
       <!-- file.def mapping files -->
       <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>
      
       <!-- scheduler.def mapping files -->
       <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
       <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>
      
       <!-- graph.exe mapping files -->
       <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>
      
       <!-- module.exe mapping files -->
       <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
      
       <!-- context.exe mapping files -->
       <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>
      
       <!-- taskmgmt.exe mapping files -->
       <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>
      
       <!-- scheduler.exe mapping files -->
       <mapping resource="org/jbpm/scheduler/exe/Timer.hbm.xml"/>
      
       <!-- logging mapping files -->
       <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
       <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
       <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>
      
       </session-factory>
      </hibernate-configuration>
      
      
      
      
      
      hibernate.cfg.xml
      
      <?xml version='1.0' encoding='utf-8'?>
      
      <!DOCTYPE hibernate-configuration PUBLIC
       "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
       "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
      
      <hibernate-configuration>
       <session-factory>
      
       <!-- jdbc connection properties -->
       <!-- // Comentado por BFP 11-01-2006
       <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
       <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
       <property name="hibernate.connection.url">jdbc:hsqldb:.;sql.enforce_strict_size=true</property>
       <property name="hibernate.connection.username">sa</property>
       <property name="hibernate.connection.password"></property>
       -->
      <!--
       <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
       <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:jtds:sqlserver://isnwassrv:1433/sigo_hf;instance=bts;tds=8.0;SelectMethod=Cursor</property>
       <property name="hibernate.connection.username">hfdev</property>
       <property name="hibernate.connection.password">hfdev</property>
      -->
      
       <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
       <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
       <property name="hibernate.connection.url">jdbc:mysql://localhost:1433/sigo_bem</property>
       <property name="hibernate.connection.username">root</property>
       <property name="hibernate.connection.password">admin</property>
      
       <!-- c3p0 connection pooling properties
       <property name="hibernate.c3p0.min_size">1</property>
       <property name="hibernate.c3p0.max_size">3</property>
       -->
      
       <!-- other hibernate properties -->
       <property name="hibernate.show_sql">true</property>
      
       <!--identity mapping files -->
       <!-- uncomment if you don't want to use the default jBPM identity mgmgt component -->
       <mapping resource="org/jbpm/identity/User.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
       <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
      
       <!-- graph.def mapping files -->
       <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
       <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>
      
       <!-- graph.node mapping files -->
       <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
       <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>
      
       <!-- graph.action mapping files -->
       <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>
      
       <!-- context.def mapping files -->
       <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>
      
       <!-- taskmgmt.def mapping files -->
       <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>
      
       <!-- module.def mapping files -->
       <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>
      
       <!-- bytes mapping files -->
       <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>
      
       <!-- file.def mapping files -->
       <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>
      
       <!-- scheduler.def mapping files -->
       <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
       <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>
      
       <!-- graph.exe mapping files -->
       <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
       <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>
      
       <!-- module.exe mapping files -->
       <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
      
       <!-- context.exe mapping files -->
       <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
       <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>
      
       <!-- taskmgmt.exe mapping files -->
       <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>
      
       <!-- scheduler.exe mapping files -->
       <mapping resource="org/jbpm/scheduler/exe/Timer.hbm.xml"/>
      
       <!-- logging mapping files -->
       <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
       <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
       <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
       <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>
      
       </session-factory>
      </hibernate-configuration>
      
      
      
      
      I've mysql-connector-java-3.1.12-bin.jar in /server/lib directory
      
      Thanks,
      Pedro


        • 1. Re: jbpm_timer' doesn't exist
          pedro costa Apprentice

          Here is the log of running jbpm

          ===============================================================================
          .
           JBoss Bootstrap Environment
          .
           JBOSS_HOME: C:\jboss-4.0.3SP1\bin\\..
          .
           JAVA: C:\Java\jdk1.5.0_06\bin\java
          .
           JAVA_OPTS: -Dprogram.name=run.bat -Xms128m -Xmx512m
          .
           CLASSPATH: C:\Java\jdk1.5.0_06\lib\tools.jar;C:\jboss-4.0.3SP1\bin\\run.jar
          .
          ===============================================================================
          .
          16:47:47,609 INFO [Server] Starting JBoss (MX MicroKernel)...
          16:47:47,609 INFO [Server] Release ID: JBoss [Zion] 4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231751)
          16:47:47,625 INFO [Server] Home Dir: C:\jboss-4.0.3SP1
          16:47:47,625 INFO [Server] Home URL: file:/C:/jboss-4.0.3SP1/
          16:47:47,625 INFO [Server] Patch URL: null
          16:47:47,625 INFO [Server] Server Name: default
          16:47:47,625 INFO [Server] Server Home Dir: C:\jboss-4.0.3SP1\server\default
          16:47:47,625 INFO [Server] Server Home URL: file:/C:/jboss-4.0.3SP1/server/default/
          16:47:47,625 INFO [Server] Server Temp Dir: C:\jboss-4.0.3SP1\server\default\tmp
          16:47:47,625 INFO [Server] Root Deployment Filename: jboss-service.xml
          16:47:47,938 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems Inc.
          16:47:47,938 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_06-b05,Sun Microsystems Inc.
          16:47:47,938 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
          16:47:48,563 INFO [Server] Core system initialized
          16:47:49,750 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
          16:48:00,110 WARN [TreeCache] No transaction manager lookup class has been defined. Transactions cannot be used
          16:48:11,049 ERROR [LocaleUtils] Locale name null or empty, ignoring
          16:48:18,627 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
          16:48:18,674 WARN [EhCacheProvider] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
          16:48:18,737 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
          16:48:18,799 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
          16:48:18,877 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
          16:48:18,877 WARN [EhCacheProvider] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
          16:48:19,049 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
          16:48:19,081 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
          16:48:19,127 WARN [EhCacheProvider] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
          16:48:19,159 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
          16:48:19,268 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
          16:48:21,362 WARN [NAKACK] [dwprc:1437] discarded message from non-member 192.168.25.18:3347
          16:48:21,409 WARN [NAKACK] [dwprc:1440 (additional data: 18 bytes)] discarded message from non-member 192.168.25.18:3350 (additional data: 18 bytes)
          16:48:21,456 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.security.store.SecurityPolicy]; using defaults.
          16:48:21,487 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.security.store.HbmSecurityConstraint]; using defaults.
          16:48:21,503 WARN [EhCacheProvider] Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
          16:48:21,503 WARN [EhCacheProvider] Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
          16:48:22,268 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl]; using defaults.
          16:48:22,268 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl]; using defaults.
          16:48:22,300 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl]; using defaults.
          16:48:22,331 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl]; using defaults.
          16:48:22,346 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl]; using defaults.
          16:48:22,362 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.dynamic]; using defaults.
          16:48:22,362 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl.users]; using defaults.
          16:48:22,362 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl.content]; using defaults.
          16:48:22,362 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl.strings]; using defaults.
          16:48:22,362 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl.prefMap]; using defaults.
          16:48:22,362 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.roles]; using defaults.
          16:48:22,425 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl]; using defaults.
          16:48:22,425 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl]; using defaults.
          16:48:22,440 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl.preferencesMap]; using defaults.
          16:48:22,440 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl.strings]; using defaults.
          16:48:22,471 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl]; using defaults.
          16:48:22,534 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode]; using defaults.
          16:48:22,565 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.windowStates]; using defaults.
          16:48:22,565 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl.declaredProperties]; using defaults.
          16:48:22,581 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode.children]; using defaults.
          16:48:22,581 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.modes]; using defaults.
          16:48:24,565 WARN [NAKACK] [dwprc:1437] discarded message from non-member 192.168.25.18:3347
          16:48:24,862 ERROR [LocaleUtils] Locale name null or empty, ignoring
          16:48:25,019 WARN [NAKACK] [dwprc:1447] discarded message from non-member 192.168.25.18:3366
          16:48:26,362 ERROR [LocaleUtils] Locale name null or empty, ignoring
          16:48:26,737 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
          16:48:26,737 ERROR [JDBCExceptionReporter] Table 'sgo_bem.jbpm_timer' doesn't exist
          16:48:26,737 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
          16:48:26,737 ERROR [JbpmSession] java.lang.NullPointerException
          16:48:26,737 ERROR [JbpmSession] couldn't rollback hibernate transaction
          org.hibernate.TransactionException: Transaction not successfully started
           at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
           at org.jbpm.db.JbpmSession.handleException(JbpmSession.java:177)
           at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:106)
           at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
           at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:121)
           at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:34)
          16:48:26,737 WARN [JbpmSession] can't pop current session: are you calling JbpmSession.close() multiple times ?
          16:48:26,878 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
          
          --- MBeans waiting for other MBeans ---
          ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=Invoker
           jboss.web:service=WebServer
          
          ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
           State: CONFIGURED
           I Depend On:
           jboss:service=TransactionManager
           jboss.jca:service=DataSourceBinding,name=DefaultDS
          
          ObjectName: jboss.mq:service=StateManager
           State: CONFIGURED
           I Depend On:
           jboss.jca:service=DataSourceBinding,name=DefaultDS
           Depends On Me:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq:service=DestinationManager
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=MessageCache
           jboss.mq:service=PersistenceManager
           jboss.mq:service=StateManager
           jboss:service=Naming
           Depends On Me:
           jboss.mq.destination:service=Topic,name=testTopic
           jboss.mq.destination:service=Topic,name=securedTopic
           jboss.mq.destination:service=Topic,name=testDurableTopic
           jboss.mq.destination:service=Queue,name=testQueue
           jboss.mq.destination:service=Queue,name=A
           jboss.mq.destination:service=Queue,name=B
           jboss.mq.destination:service=Queue,name=C
           jboss.mq.destination:service=Queue,name=D
           jboss.mq.destination:service=Queue,name=ex
           jboss.mq:service=SecurityManager
           jboss.mq.destination:service=Queue,name=DLQ
          
          ObjectName: jboss.mq:service=PersistenceManager
           State: CONFIGURED
           I Depend On:
           jboss.jca:service=DataSourceBinding,name=DefaultDS
           Depends On Me:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq.destination:service=Topic,name=testTopic
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
           jboss.mq:service=SecurityManager
          
          ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
           jboss.mq:service=SecurityManager
          
          ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
           jboss.mq:service=SecurityManager
          
          ObjectName: jboss.mq.destination:service=Queue,name=testQueue
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
           jboss.mq:service=SecurityManager
          
          ObjectName: jboss.mq.destination:service=Queue,name=A
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq.destination:service=Queue,name=B
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq.destination:service=Queue,name=C
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq.destination:service=Queue,name=D
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq.destination:service=Queue,name=ex
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
          
          ObjectName: jboss.mq:service=Invoker
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=TracingInterceptor
           jboss:service=Naming
           Depends On Me:
           jboss.mq:service=InvocationLayer,type=HTTP
           jboss.mq:service=InvocationLayer,type=JVM
           jboss.mq:service=InvocationLayer,type=UIL2
          
          ObjectName: jboss.mq:service=TracingInterceptor
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=SecurityManager
           Depends On Me:
           jboss.mq:service=Invoker
          
          ObjectName: jboss.mq:service=SecurityManager
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
           Depends On Me:
           jboss.mq.destination:service=Topic,name=testTopic
           jboss.mq.destination:service=Topic,name=securedTopic
           jboss.mq.destination:service=Topic,name=testDurableTopic
           jboss.mq.destination:service=Queue,name=testQueue
           jboss.mq:service=TracingInterceptor
           jboss.mq.destination:service=Queue,name=DLQ
          
          ObjectName: jboss.mq.destination:service=Queue,name=DLQ
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=DestinationManager
           jboss.mq:service=SecurityManager
          
          ObjectName: jboss.mq:service=InvocationLayer,type=JVM
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=Invoker
          
          ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
           State: CONFIGURED
           I Depend On:
           jboss.mq:service=Invoker
          
          --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
          ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
           State: NOTYETINSTALLED
           Depends On Me:
           jboss:service=KeyGeneratorFactory,type=HiLo
           jboss.mq:service=StateManager
           jboss.mq:service=PersistenceManager
          
          
          


          • 2. Re: jbpm_timer' doesn't exist
            pedro costa Apprentice

            I know that the table jbpm_timer wasn't created, but i don't understand why. This example was working with mssql, but when i change the xml file to point to mysql DB, i get this error.

            • 3. Re: jbpm_timer' doesn't exist
              pedro costa Apprentice

              To solve this problem, you must create all the tables in your DB. Make copy/paste from the sql files in jbpm-starters-kit, to your db.