AnsweredAssumed Answered

Problem Deleting a space reviously imported by acp

Question asked by cgonzalez on May 14, 2008
Hi,

I have a problem deleting a folder in the Company Home folder. The space i want to delete was previusly imported using a module (AMP).

To import the acp into the alfresco I write this into de module-context.

<bean id="moduleId.bootstrapSpaces" class="org.alfresco.repo.module.ImporterModuleComponent"    parent="module.baseComponent">
      <property name="moduleId" value="moduleId" />
      <property name="name" value="moduleId.bootstrap" />
      <property name="description" value="Initial data requirements" />
      <property name="sinceVersion" value="1.0" />
      <property name="appliesFromVersion" value="0.0" />
      <property name="executeOnceOnly" value="true" />
      <property name="importer" ref="spacesBootstrap" />
      <property name="bootstrapViews">
         <list>
            <props>
               <prop key="path">/${spaces.company_home.childname}</prop>
               <prop key="location">alfresco/module/moduleId/resources/spaces.acp</prop>
            </props>
         </list>
      </property>
   </bean>

The space was imported correctly and i have been working fine with it. But i need to delete this space right know and i receive this error:


ERROR [ui.common.Utils] Unable to delete Space due to system error:
  [sshexec] org.hibernate.exception.ConstraintViolationException: could not update: [org.alfresco.repo.domain.hibernate.NodeImpl#153868]
  [sshexec]    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
  [sshexec]    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  [sshexec]    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2375)
  [sshexec]    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2257)
  [sshexec]    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2557)
  [sshexec]    at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
  [sshexec]    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
  [sshexec]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
  [sshexec]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
  [sshexec]    at org.hibernate.event.def.AbstractFlushingEv
  [sshexec] entListener.performExecutions(AbstractFlushingEventListener.java:298)
  [sshexec]    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  [sshexec]    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
  [sshexec]    at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.flush(HibernateNodeDaoServiceImpl.java:299)
  [sshexec]    at sun.reflect.GeneratedMethodAccessor1227.invoke(Unknown Source)
  [sshexec]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  [sshexec]    at java.lang.reflect.Method.invoke(Method.java:597)
  [sshexec]    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
  [sshexec]    at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
  [sshexec]    at $Proxy179.flush(Unknown Source)
  [sshexec]    at org.alfresco.repo.node.db.DbNodeServiceImpl.getNodeHierarchy(DbNodeServiceImpl.java:1648)
  [sshexec]    at org.alfresco.repo.node.db.DbNodeServiceImpl.archiveNode(DbNodeServiceImpl.java:1582)
  [sshexec]    at org.alfresco.repo.node.db.DbNodeServiceImpl.deleteNode(DbNodeServiceImpl.java:737)
  [sshexec]    at sun.reflect.GeneratedMethodAccessor1223.invoke(Unknown Source)
  [sshexec]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  [sshexec]    at java.lang.reflect.Method.invoke(Method.java:597)
  [sshexec]    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
  [sshexec]    at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
  [sshexec]    at $Proxy180.deleteNode(Unknown Source)
  [sshexec]    at sun.reflect.GeneratedMethodAccessor1223.invoke(Unknown Source)
  [sshexec]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  [sshexec]    at java.lang.reflect.Method.invoke(Method.java:597)
  [sshexec]    at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
  [sshexec]    at $Proxy181.deleteNode(Unknown Source)
  [sshexec]    at sun.reflect.GeneratedMethodAccessor1223.invoke(Unknown Source)
  [sshexec]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  [sshexec]    at java.lang.reflect.Method.invoke(Method.java:597)
  [sshexec]    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
  [sshexec]    at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:211)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
  [sshexec]    at $Proxy180.deleteNode(Unknown Source)
  [sshexec]    at sun.reflect.GeneratedMethodAccessor1223.invoke(Unknown Source)
  [sshexec]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  [sshexec]    at java.lang.reflect.Method.invoke(Method.java:597)
  [sshexec]    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
  [sshexec]    at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:256)
  [sshexec]    at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:191)
  [sshexec]    at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
  [sshexec]    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
  [sshexec]    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
  [sshexec]    at $Proxy180.deleteNode(Unknown Source)
  [sshexec]    at org.alfresco.web.bean.spaces.DeleteSpaceDialog.finishImpl(DeleteSpaceDialog.java:93)
  [sshexec]    at org.alfresco.web.bean.dialog.BaseDialogBean$1.execute(BaseDialogBean.java:118)
  [sshexec]    at org.alfresco.web.bean.dialog.BaseDialogBean$1.execute(BaseDialogBean.java:115)
  [sshexec]    at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:225)
  [sshexec]    at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)
  [sshexec]    at org.alfresco.web.bean.dialog.BaseDialogBean.finish(BaseDialogBean.java:124)
  [sshexec]    at org.alfresco.web.bean.dialog.DialogManager.finish(DialogManager.java:347)
  [sshexec]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  [sshexec]    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  [sshexec]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  [sshexec]    at java.lang.reflect.Method.invoke(Method.java:597)
  [sshexec]    at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
  [sshexec]    at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
  [sshexec]    at javax.faces.component.UICommand.broadcast(UICommand.java:109)
  [sshexec]    at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
  [sshexec]    at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
  [sshexec]    at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
  [sshexec]    at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
  [sshexec]    at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
  [sshexec]    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
  [sshexec]    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
  [sshexec]    at org.apache.catalina.core.ApplicationFilterChain.
  [sshexec] doFilter(ApplicationFilterChain.java:188)
  [sshexec]    at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
  [sshexec]    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
  [sshexec]    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
  [sshexec]    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
  [sshexec]    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
  [sshexec]    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  [sshexec]    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
  [sshexec]    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
  [sshexec]    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
  [sshexec]    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
  [sshexec]    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol
  [sshexec] .java:665)
  [sshexec]    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
  [sshexec]    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
  [sshexec]    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
  [sshexec]    at java.lang.Thread.run(Thread.java:619)
  [sshexec] Caused by: java.sql.SQLException: ORA-00001: unique constraint (ALFRESCO.SYS_C004182) violated
  [sshexec]
  [sshexec]    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  [sshexec]    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  [sshexec]    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  [sshexec]    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  [sshexec]    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
  [sshexec]    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
  [sshexec]    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
  [sshexec]    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePr
  [sshexec] eparedStatement.java:3285)
  [sshexec]    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
  [sshexec]    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
  [sshexec]    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2357)
  [sshexec]    … 103 more

Any Tip?

Thanks in advance.

Outcomes