0 Replies Latest reply on Oct 19, 2005 5:04 AM by shi jimeng

    to deploy the jbpm3.0.1 to jboss4.0.3, db is ms sqlserver,,

    shi jimeng Newbie

      hi:
      i try to deploy the jbpm3.0.1 to jboss4.0.3, db is ms sqlserver, jdbc jtds-1.1 .
      but it gives error:

      16:03:12,930 INFO [FacesConfigurator] Reading config jar:file:/C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/myfaces23649.jar!/MET
      A-INF/faces-config.xml
      16:03:13,055 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
      16:03:13,289 DEBUG [ApplicationFactory] New ApplicationFactory instance created
      16:03:14,039 INFO [StartupServletContextListener] ServletContext 'D:\jboss-4.0.3\server\jbpm\.\tmp\deploy\tmp23647jbpm-
      exp.war\' initialized.
      16:03:14,086 DEBUG [Scheduler] starting the scheduler
      16:03:14,086 DEBUG [JbpmSessionFactory] fetching JbpmSessionFactory from 'java:/jbpm/JbpmSessionFactory'
      16:03:14,289 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
      16:03:14,367 DEBUG [SchedulerThread] checking for timers
      16:03:14,633 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:03:14,648 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER
      timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc]
      16:03:14,648 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

      16:03:14,648 ERROR [JbpmSession] java.lang.NullPointerException
      16:03:14,664 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:03:14,680 WARN [JbpmSession] can't pop current session: are you calling JbpmSession.close() multiple times ?
      16:03:14,695 INFO [SchedulerThread] runtime exception while executing timers
      java.lang.RuntimeException: couldn't commit transaction
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:107)
      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)
      Caused by: java.lang.NullPointerException
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:102)
      ... 3 more
      16:03:15,023 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      16:03:15,195 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      16:03:15,211 INFO [JkMain] Jk running ID=0 time=0/125 config=null
      16:03:15,211 INFO [Server] JBoss (MX MicroKernel) [4.0.3 (build: CVSTag=JBoss_4_0_3 date=200510042324)] Started in 29s:
      876ms
      16:03:19,695 DEBUG [SchedulerThread] checking for timers
      16:03:19,695 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
      16:03:19,695 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER
      timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc]
      16:03:19,695 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate

      16:03:19,695 ERROR [JbpmSession] java.lang.NullPointerException
      16:03:19,695 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:03:19,695 WARN [JbpmSession] can't pop current session: are you calling JbpmSession.close() multiple times ?
      16:03:19,695 INFO [SchedulerThread] runtime exception while executing timers
      java.lang.RuntimeException: couldn't commit transaction
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:107)
      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)
      Caused by: java.lang.NullPointerException
      at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:102)
      ... 3 more
      16:03:24,695 DEBUG [SchedulerThread] checking for timers


      in db ,the table jbpm_timer is exist.



      CREATE TABLE [dbo].[JBPM_TIMER] (
      [ID_] [numeric](19, 0) IDENTITY (1, 1) NOT NULL ,
      [NAME_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
      [DUEDATE_] [datetime] NULL ,
      [REPEAT_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
      [TRANSITIONNAME_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
      [EXCEPTION_] [varchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
      [ACTION_] [numeric](19, 0) NULL ,
      [TOKEN_] [numeric](19, 0) NULL ,
      [PROCESSINSTANCE_] [numeric](19, 0) NULL ,
      [TASKINSTANCE_] [numeric](19, 0) NULL ,
      [GRAPHELEMENTTYPE_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
      [GRAPHELEMENT_] [numeric](19, 0) NULL
      ) ON [PRIMARY]