org.hibernate.AssertionFailure while bulk import.

[atkiba]

Hi!

This is the first time I use the forum so I don't know if this is the right place for this question. I've been looking around in the forum but I didn't find an answer. I'm using Alfresco Community 3.2 and I created a Java aplication which executes a Webscript for bulk import of files. This is working really slow but the main problem is that after 4 hours of execution the aplication stops and I get this log error:

19:03:14,894 ERROR [org.alfresco.web.scripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 05140319 Wrapped Exception (with status template): null id in org.alfresco.repo.domain.hibernate.ChildAssocImpl entry (don't flush the Session after an exception occurs)org.alfresco.web.scripts.WebScriptException: 05140319 Wrapped Exception (with status template): null id in org.alfresco.repo.domain.hibernate.ChildAssocImpl entry (don't flush the Session after an exception occurs)   at org.alfresco.web.scripts.AbstractWebScript.createStatusException(AbstractWebScript.java:613)   at org.alfresco.web.scripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:165)   at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:357)   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:407)   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:424)   at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:288)   at org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:262)   at org.alfresco.web.scripts.AbstractRuntime.executeScript(AbstractRuntime.java:139)   at org.alfresco.web.scripts.servlet.WebScriptServlet.service(WebScriptServlet.java:122)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)   at java.lang.Thread.run(Thread.java:619)Caused by: org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.ChildAssocImpl entry (don't flush the Session after an exception occurs)   at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)   at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:164)   at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:120)   at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)   at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.flushSession(DirtySessionMethodInterceptor.java:304)   at org.alfresco.repo.domain.hibernate.SessionSizeResourceManager.manageResources(SessionSizeResourceManager.java:147)   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:196)   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)   at $Proxy9.hasAspect(Unknown Source)   at sun.reflect.GeneratedMethodAccessor222.invoke(Unknown Source)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)   at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)   at $Proxy9.hasAspect(Unknown Source)   at sun.reflect.GeneratedMethodAccessor222.invoke(Unknown Source)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)   at $Proxy10.hasAspect(Unknown Source)   at org.alfresco.repo.node.MLPropertyInterceptor.getPivotNodeRef(MLPropertyInterceptor.java:324)   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:164)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:203)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:203)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)   at $Proxy9.getProperty(Unknown Source)   at org.alfresco.repo.security.person.PersonServiceImpl.makeHomeFolderIfRequired(PersonServiceImpl.java:551)   at org.alfresco.repo.security.person.PersonServiceImpl.getPersonOrNull(PersonServiceImpl.java:319)   at org.alfresco.repo.security.person.PersonServiceImpl.personExists(PersonServiceImpl.java:298)   at org.alfresco.repo.model.Repository.getPerson(Repository.java:274)   at org.alfresco.repo.web.scripts.RepositoryContainer.addRepoParameters(RepositoryContainer.java:221)   at org.alfresco.repo.web.scripts.RepositoryContainer.access$200(RepositoryContainer.java:80)   at org.alfresco.repo.web.scripts.RepositoryContainer$1.execute(RepositoryContainer.java:195)   at org.alfresco.repo.web.scripts.RepositoryContainer$1.execute(RepositoryContainer.java:190)   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)   at org.alfresco.repo.web.scripts.RepositoryContainer.getTemplateParameters(RepositoryContainer.java:188)   at org.alfresco.web.scripts.AbstractWebScript.createTemplateParameters(AbstractWebScript.java:408)   at org.alfresco.web.scripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:95)   … 21 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This is the webscript I'm executing:

<javascript>
var filename = null;
var content = null;
var tipo_documento = null;
var num_liquidacion = null;
var num_folio = null;
var centro = null;
var fecha = null;
var cod_cliente = null;
var rut_cliente = null;
var Ruta_ALF = "";

//var Ruta_ALF = "Expediente de Titulo/11000000/11230000/11234500/Expediente/Reservado";

try
   {
for each (field in formdata.fields)
{
  
   if (field.name == "tipo_documento")
   {
      tipo_documento = field.value;
   }
   if (field.name == "num_liquidacion")
   {
      num_liquidacion = field.value;
   }
   if (field.name == "num_folio")
   {
      num_folio = field.value;
   }
   if (field.name == "centro")
   {
      centro = field.value;
   }
   if (field.name == "fecha")
   {  
     fecha = field.value;
      if(fecha == "")
      {     
         fecha = null;
      }
      else
      {
         fecha = fecha.replaceAll("-","/");
         fecha = new Date(fecha);
      }
   }
   if (field.name == "cod_cliente")
   {
      cod_cliente = field.value;
   }
   if (field.name == "rut_cliente")
   {
      rut_cliente = field.value;
   }
   if(field.name == "file" && field.isFile)
   {
      filename = field.filename;
      content = field.content;
   }
 
}
}catch (mierror){
     status.code = 777;
     status.message = "Error detectado: " + mierror.description;
     status.redirect = true;
     logger.log("Error detectado: " + mierror.description);
 
   }
      
   if (filename == undefined || content == undefined)
   {
     status.code = 401;
     status.message = "El archivo cargado no puede ser ubicado en el lugar solicitado";
     status.redirect = true;
     logger.log("El nombre de archivo o su contenido no han sido definidos.");
   }
else
{

//var folder = "10000000/11000000/11230000/11234500/Expediente/Reservado"



//var space = "Company Home/Lipigas/Validacion/"
var space = "Company Home/PENDIENTES/";
var espacio = roothome.childByNamePath(space+centro+"/"+num_liquidacion);


if(espacio == null || espacio == undefined)
{
   if(roothome.childByNamePath(space+centro)==null || roothome.childByNamePath(space+centro)== undefined)
   {
        path = (space);
        espacio = roothome.childByNamePath(path);
        espacio = espacio.createFolder(centro);
   }
   if(roothome.childByNamePath(space+centro+"/"+num_liquidacion)==null || roothome.childByNamePath(space+centro+"/"+num_liquidacion)== undefined)
   {
      
        path = (space+centro);
        espacio = roothome.childByNamePath(path);
        espacio = espacio.createFolder(num_liquidacion);
   }


}

     try
   {

   upload = espacio.createFile(filename); 
 
     upload.properties.content.write(content);
     upload.properties.content.encoding = "UTF-8";
     upload.properties["lip:tipo_documento"] = tipo_documento ;
     upload.properties["lip:num_liquidacion"] = num_liquidacion ;
     upload.properties["lip:num_folio"] = num_folio ;
     upload.properties["lip:centro"] = centro ;
     upload.properties["lip:fecha"] = fecha ;
     upload.properties["lip:cod_cliente"] = cod_cliente ;
     upload.properties["lip:rut_cliente"] = rut_cliente ;

     upload.save();

     model.upload = upload;
    
   }catch (mierror){
        status.code = 300;
        status.message = "Error detectado: " + mierror.description;
        status.redirect = true;
        logger.log("Error detectado: " + mierror.description);      
       }

}
</javascript>

If there is any information I've missed please tell me. I appreciate your help!

[abarisone]

Hi,
you could use this extension https://code.google.com/p/alfresco-bulk-filesystem-import/ wich allows you to have more control over import process.

Regards,
Andrea