6 Replies Latest reply on Jul 17, 2007 5:25 AM by mailinator

    ProcessDefinition disapear from the database

    mailinator Novice

      Hi,

      i have encountred some issue while testing jbpm.
      Here what i have done :
      Deploying my processdefinition with the deployer of the jbpm Designer eclipse plugin.
      Checking in the database for that processdefinition : it appeared.

      In my Struts action :

      JbpmConfiguration jbpmConfiguration=JbpmConfiguration.getInstance();
      JbpmContext jbpmContext=jbpmConfiguration.createJbpmContext();
      jbpmConfiguration.createSchema();
      ProcessDefinition processDefinition=ProcessDefinition.parseXmlResource("demandeAccesVerifUserAlerteRH/processdefinition.xml");

      This throws an exception :

      17:06:21,822 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      17:06:21,822 ERROR [JDBCExceptionReporter] ORA-00942: Table ou vue inexistante

      17:06:21,822 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou
      ld not execute query
      17:06:21,838 ERROR [JobExecutorThread] exception in job executor thread. waiting
      5000 milliseconds
      org.jbpm.JbpmException: couldn't get acquirable jobs
      at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
      at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread
      .java:111)
      at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56
      )
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
      ava:67)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
      er.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2223)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      at org.hibernate.loader.Loader.list(Loader.java:2099)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
      va:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
      :172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
      ava:811)
      at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
      ... 2 more
      Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
      830)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
      a:2391)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
      nt.java:2672)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
      edStatement.java:589)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
      dStatement.java:527)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
      186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      at org.hibernate.loader.Loader.doQuery(Loader.java:674)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
      ader.java:236)
      at org.hibernate.loader.Loader.doList(Loader.java:2220)
      ... 11 more
      17:06:26,931 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
      17:06:26,931 ERROR [JDBCExceptionReporter] ORA-00942: Table ou vue inexistante

      17:06:26,931 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou
      ld not execute query
      17:06:26,931 ERROR [JobExecutorThread] exception in job executor thread. waiting
      10000 milliseconds
      org.jbpm.JbpmException: couldn't get acquirable jobs
      at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
      at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread
      .java:111)
      at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56
      )
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
      ava:67)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
      er.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2223)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
      at org.hibernate.loader.Loader.list(Loader.java:2099)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
      va:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
      :172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
      ava:811)
      at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
      ... 2 more
      Caused by: java.sql.SQLException: ORA-00942: Table ou vue inexistante

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
      830)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
      a:2391)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
      nt.java:2672)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
      edStatement.java:589)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
      dStatement.java:527)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
      186)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
      at org.hibernate.loader.Loader.doQuery(Loader.java:674)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
      ader.java:236)
      at org.hibernate.loader.Loader.doList(Loader.java:2220)
      ... 11 more

      If someone know about this or has already encountred that issue, please keep me posted.

      Best regards,

      O.M.