[jboss-user] [jBPM] - jbpm4.4: Exception when deleting a Deployment

[James Schappet]

James Schappet [http://community.jboss.org/people/jschappet] created the discussion

"jbpm4.4:  Exception when deleting a Deployment"

To view the discussion, visit: http://community.jboss.org/message/559024#559024

--------------------------------------------------------------
While trying to run the following Code:

         List<ProcessDefinition> procDefs = repositoryService.createProcessDefinitionQuery().list();
            for (ProcessDefinition procDef : procDefs) {
                log.debug (procDef.getId() + " [" + procDef.getKey() + "] ");
            } 
            repositoryService.deleteDeploymentCascade("CRUAPPROVAL");



I get the following
13:50:56,828 DEBUG CRUController:129 - CRUAPPROVAL-1 [CRUAPPROVAL] 
13:50:56,828 DEBUG CRUController:129 - userRegistration-1 [userRegistration] 
13:50:56,849 ERROR JDBCExceptionReporter:78 - ERROR: column "cruapproval" does not exist
  Position: 572


Here is the full stack:

org.postgresql.util.PSQLException: ERROR: column "cruapproval" does not exist
  Position: 572
     org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
     org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
     org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
     org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
     org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
     org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
     org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
     org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
     org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
     org.hibernate.loader.Loader.doQuery(Loader.java:674)
     org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
     org.hibernate.loader.Loader.doList(Loader.java:2220)
     org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
     org.hibernate.loader.Loader.list(Loader.java:2099)
     org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
     org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
     org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
     org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
     org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
     org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:93)
     org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:67)
     org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:67)
     org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.list(ProcessDefinitionQueryImpl.java:157)
     org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:61)
     org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
     org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
     org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
     org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
     org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
     org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
     org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
     edu.uiowa.icts.superappbackend.controller.CRUController.removeProcess(CRUController.java:131)


--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/559024#559024]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100825/6cc23320/attachment.html