1 Reply Latest reply on Aug 27, 2010 5:18 AM by HuiSheng Xu

    jbpm4.4:  Exception when deleting a Deployment

    James Schappet Newbie

      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)