[jboss-user] [JBoss jBPM] - ProcessDefinition disapear from the database

[mailinator]

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.


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064597#4064597

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064597