Date: Mon, 28 Nov 2016 12:22:11 -0600 Message-ID: <20161128122211.Horde.jOH0CZ7Di4GcyGVNuyQXj9q@webmail.ssf.com.mx> From: christian@ssf.com.mx To: Rogelio Delgado Cc: MARIO MORENO ROBLES , martin@ssf.com.mx Subject: Re: Contacto - DESPLIEGUE DE =?utf-8?b?VkVSU0nDk04=?= EN SERVIDOR Z GAS DE PRUEBA References: <2441196D340CBC4B8B49A31D0626AD6FB36C99E5@SRVJRZCASMBX1.grupozeta.com> <583881B5.4060508@ssf.com.mx> <2441196D340CBC4B8B49A31D0626AD6FB36C9C29@SRVJRZCASMBX1.grupozeta.com> <2441196D340CBC4B8B49A31D0626AD6FB36CBDA8@SRVJRZCASMBX1.grupozeta.com> In-Reply-To: Received: from fixed-189-248-187-189-248-81.iusacell.net (fixed-189-248-187-189-248-81.iusacell.net [187.189.248.81]) by webmail.ssf.com.mx (Horde Framework) with HTTP; Mon, 28 Nov 2016 12:22:11 -0600 User-Agent: Horde Application Framework 5 Content-Type: text/plain; charset=utf-8; format=flowed; DelSp=Yes MIME-Version: 1.0 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Ok, enterado, lo estoy checando. Saludos! Quoting Rogelio Delgado : > Ah ok, entonces, en el ambiente de pruebas, seg=C3=BAn entiendo se desple= g=C3=B3 la > semana pasada. Se ha comportado igual? > > Christian, por favor revisa los logs del ambiente de pruebas para buscar > los tiempos de respuesta. Esos logs tu los hiciste junto con Jorge la vez > pasada. > > Espero comentarios, gracias. > > El lun., 28 nov. 2016 a las 10:39, MARIO MORENO ROBLES (< > sistemasjalisco5@grupozeta.com>) escribi=C3=B3: > >> La informaci=C3=B3n que les envi=C3=A9, es del entorno en producci=C3=B3= n >> >> >> >> >> >> *De:* Rogelio Delgado [mailto:rogelio@ssf.mx] >> *Enviado el:* domingo, 27 de noviembre de 2016 11:43 p. m. >> *Para:* MARIO MORENO ROBLES; Christian >> *CC:* martin@ssf.com.mx >> >> >> *Asunto:* Re: Contacto - DESPLIEGUE DE VERSI=C3=93N EN SERVIDOR Z GAS DE= PRUEBA >> >> >> >> Gracias Mario, >> >> >> >> Christian, necesitamos revisar la excepci=C3=B3n que nos pasa Mario. Las >> modificaciones que hicimos no fueron suficientes. Ma=C3=B1ana nos reunim= os para >> definir pasos a seguir. >> >> >> >> Saludos! >> >> >> >> El s=C3=A1b., 26 nov. 2016 a las 8:32, MARIO MORENO ROBLES (< >> sistemasjalisco5@grupozeta.com>) escribi=C3=B3: >> >> Nuevamente obtuvimos este resultado >> >> >> >> >> >> Apache Tomcat/7.0.42 - Informe de Error Estado HTTP 500 - Request >> processing failed; nested exception is >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statementtype Informe de Excepci=C3=B3nmensaje Request processing failed= ; nested >> exception is org.springframework.dao.DataIntegrityViolationException: co= uld >> not execute statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statementdescripci=C3=B3n El servidor encontr=C3=B3 un error interno que= hizo que no >> pudiera rellenar este requerimiento.excepci=C3=B3n >> org.springframework.web.util.NestedServletException: Request processing >> failed; nested exception is >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:965) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateA= ccessException(SessionFactoryUtils.java:643) >> org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptio= nIfPossible(HibernateJpaDialect.java:106) >> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateEx= ceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) >> org.springframework.dao.support.ChainedPersistenceExceptionTranslator.tr= anslateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) >> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(Dat= aAccessUtils.java:213) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:163) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLS= tateConversionDelegate.java:129) >> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(S= tandardSQLExceptionConverter.java:49) >> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHel= per.java:126) >> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHel= per.java:112) >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(Res= ultSetReturnImpl.java:211) >> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(Non= BatchingBatch.java:62) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3124) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3581) >> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct= ion.java:104) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463= ) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349= ) >> org.hibernate.event.internal.AbstractFlushingEventListener.performExecut= ions(AbstractFlushingEventListener.java:350) >> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl= ushEventListener.java:56) >> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana= gerImpl.java:1335) >> sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManag= erInvocationHandler.invoke(SharedEntityManagerCreator.java:241) >> com.sun.proxy.$Proxy215.flush(Unknown Source) >> mx.ssf.sicom.scgaspar.dao.impl.GenericDataAccessImpl.save(GenericDataAcc= essImpl.java:115) >> sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:155) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricc= i=C3=B3n >> de unicidad =C2=ABpk_equipment_orders=C2=BB Detail: Ya existe la llave (= order_folio, >> equipment_id)=3D(35161073, df5a4674-0cd7-451f-9fb8-434879711511). >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu= torImpl.java:2103) >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp= l.java:1836) >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:= 257) >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme= nt.java:512) >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb= c2Statement.java:388) >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S= tatement.java:334) >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(Res= ultSetReturnImpl.java:208) >> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(Non= BatchingBatch.java:62) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3124) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3581) >> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct= ion.java:104) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463= ) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349= ) >> org.hibernate.event.internal.AbstractFlushingEventListener.performExecut= ions(AbstractFlushingEventListener.java:350) >> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl= ushEventListener.java:56) >> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana= gerImpl.java:1335) >> sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManag= erInvocationHandler.invoke(SharedEntityManagerCreator.java:241) >> com.sun.proxy.$Proxy215.flush(Unknown Source) >> mx.ssf.sicom.scgaspar.dao.impl.GenericDataAccessImpl.save(GenericDataAcc= essImpl.java:115) >> sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:155) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) nota La tra= za >> completa de la causa de este error se encuentra en los archivos de diari= o >> de Apache Tomcat/7.0.42.Apache Tomcat/7.0.42 >> >> Enviado >> >> Enviado >> >> No. Unidad Actividad Estatus >> >> 7 40780 >> >> 41419 >> >> 41426 >> >> 41499 >> >> 41511 >> >> 41513 >> >> 41530 >> >> 17 Pronosticos enviados al apoyo >> >> 17 Pronosticos enviados al apoyo >> >> 78 Pronosticos enviados al apoyo >> >> 22 Pronosticos enviados al apoyo >> >> 21 Pronosticos enviados al apoyo >> >> 28 Pronosticos enviados al apoyo >> >> 119 Pronosticos enviados al apoyo >> >> Enviado >> >> Enviado >> >> Apache Tomcat/7.0.42 - Informe de Error Estado HTTP 500 - Request >> processing failed; nested exception is >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statementtype Informe de Excepci=C3=B3nmensaje Request processing failed= ; nested >> exception is org.springframework.dao.DataIntegrityViolationException: co= uld >> not execute statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statementdescripci=C3=B3n El servidor encontr=C3=B3 un error interno que= hizo que no >> pudiera rellenar este requerimiento.excepci=C3=B3n >> org.springframework.web.util.NestedServletException: Request processing >> failed; nested exception is >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:965) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateA= ccessException(SessionFactoryUtils.java:643) >> org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptio= nIfPossible(HibernateJpaDialect.java:106) >> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateEx= ceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) >> org.springframework.dao.support.ChainedPersistenceExceptionTranslator.tr= anslateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) >> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(Dat= aAccessUtils.java:213) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:163) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLS= tateConversionDelegate.java:129) >> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(S= tandardSQLExceptionConverter.java:49) >> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHel= per.java:126) >> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHel= per.java:112) >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(Res= ultSetReturnImpl.java:211) >> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(Non= BatchingBatch.java:62) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3124) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3581) >> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct= ion.java:104) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463= ) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349= ) >> org.hibernate.event.internal.AbstractFlushingEventListener.performExecut= ions(AbstractFlushingEventListener.java:350) >> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl= ushEventListener.java:56) >> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana= gerImpl.java:1335) >> sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManag= erInvocationHandler.invoke(SharedEntityManagerCreator.java:241) >> com.sun.proxy.$Proxy215.flush(Unknown Source) >> mx.ssf.sicom.scgaspar.dao.impl.GenericDataAccessImpl.save(GenericDataAcc= essImpl.java:115) >> sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:155) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricc= i=C3=B3n >> de unicidad =C2=ABpk_equipment_orders=C2=BB Detail: Ya existe la llave (= order_folio, >> equipment_id)=3D(37461975, d42c201d-897e-44b4-afec-c645753b3809). >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu= torImpl.java:2103) >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp= l.java:1836) >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:= 257) >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme= nt.java:512) >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb= c2Statement.java:388) >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S= tatement.java:334) >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(Res= ultSetReturnImpl.java:208) >> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(Non= BatchingBatch.java:62) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3124) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3581) >> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct= ion.java:104) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463= ) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349= ) >> org.hibernate.event.internal.AbstractFlushingEventListener.performExecut= ions(AbstractFlushingEventListener.java:350) >> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl= ushEventListener.java:56) >> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana= gerImpl.java:1335) >> sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManag= erInvocationHandler.invoke(SharedEntityManagerCreator.java:241) >> com.sun.proxy.$Proxy215.flush(Unknown Source) >> mx.ssf.sicom.scgaspar.dao.impl.GenericDataAccessImpl.save(GenericDataAcc= essImpl.java:115) >> sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:155) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) nota La tra= za >> completa de la causa de este error se encuentra en los archivos de diari= o >> de Apache Tomcat/7.0.42.Apache Tomcat/7.0.42 >> >> Enviado >> >> Enviado >> >> Enviado >> >> Apache Tomcat/7.0.42 - Informe de Error Estado HTTP 500 - Request >> processing failed; nested exception is >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statementtype Informe de Excepci=C3=B3nmensaje Request processing failed= ; nested >> exception is org.springframework.dao.DataIntegrityViolationException: co= uld >> not execute statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statementdescripci=C3=B3n El servidor encontr=C3=B3 un error interno que= hizo que no >> pudiera rellenar este requerimiento.excepci=C3=B3n >> org.springframework.web.util.NestedServletException: Request processing >> failed; nested exception is >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:965) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >>=20org.springframework.web.servlet.FrameworkServlet.service(FrameworkServ= let.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.springframework.dao.DataIntegrityViolationException: could not execu= te >> statement; SQL [n/a]; constraint [null]; nested exception is >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateA= ccessException(SessionFactoryUtils.java:643) >> org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptio= nIfPossible(HibernateJpaDialect.java:106) >> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateEx= ceptionIfPossible(AbstractEntityManagerFactoryBean.java:403) >> org.springframework.dao.support.ChainedPersistenceExceptionTranslator.tr= anslateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58) >> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(Dat= aAccessUtils.java:213) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:163) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.hibernate.exception.ConstraintViolationException: could not execute >> statement >> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLS= tateConversionDelegate.java:129) >> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(S= tandardSQLExceptionConverter.java:49) >> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHel= per.java:126) >> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHel= per.java:112) >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(Res= ultSetReturnImpl.java:211) >> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(Non= BatchingBatch.java:62) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3124) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3581) >> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct= ion.java:104) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463= ) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349= ) >> org.hibernate.event.internal.AbstractFlushingEventListener.performExecut= ions(AbstractFlushingEventListener.java:350) >> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl= ushEventListener.java:56) >> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana= gerImpl.java:1335) >> sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManag= erInvocationHandler.invoke(SharedEntityManagerCreator.java:241) >> com.sun.proxy.$Proxy215.flush(Unknown Source) >> mx.ssf.sicom.scgaspar.dao.impl.GenericDataAccessImpl.save(GenericDataAcc= essImpl.java:115) >> sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:155) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) causa ra=C3= =ADz >> org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricc= i=C3=B3n >> de unicidad =C2=ABpk_equipment_orders=C2=BB Detail: Ya existe la llave (= order_folio, >> equipment_id)=3D(37240016, feafea35-6ffe-4f7a-b8b9-3fba68ff4f35). >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu= torImpl.java:2103) >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp= l.java:1836) >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:= 257) >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme= nt.java:512) >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb= c2Statement.java:388) >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S= tatement.java:334) >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(Res= ultSetReturnImpl.java:208) >> org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(Non= BatchingBatch.java:62) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3124) >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn= tityPersister.java:3581) >> org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct= ion.java:104) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463= ) >> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349= ) >> org.hibernate.event.internal.AbstractFlushingEventListener.performExecut= ions(AbstractFlushingEventListener.java:350) >> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl= ushEventListener.java:56) >> org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222) >> org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana= gerImpl.java:1335) >> sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManag= erInvocationHandler.invoke(SharedEntityManagerCreator.java:241) >> com.sun.proxy.$Proxy215.flush(Unknown Source) >> mx.ssf.sicom.scgaspar.dao.impl.GenericDataAccessImpl.save(GenericDataAcc= essImpl.java:115) >> sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.dao.support.PersistenceExceptionTranslationIntercept= or.invoke(PersistenceExceptionTranslationInterceptor.java:155) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy250.save(Unknown Source) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveNewOrdersForEquipment(EquipmentCatalogsSynchronizatio= nServiceImpl.java:450) >> mx.ssf.sicom.operationalServices.servicesImpl.EquipmentCatalogsSynchroni= zationServiceImpl.saveEquipmentOrderList(EquipmentCatalogsSynchronizationSe= rviceImpl.java:435) >> sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(= AopUtils.java:317) >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp= oint(ReflectiveMethodInvocation.java:183) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:150) >> org.springframework.transaction.interceptor.TransactionInterceptor$1.pro= ceedWithInvocation(TransactionInterceptor.java:96) >> org.springframework.transaction.interceptor.TransactionAspectSupport.inv= okeWithinTransaction(TransactionAspectSupport.java:260) >> org.springframework.transaction.interceptor.TransactionInterceptor.invok= e(TransactionInterceptor.java:94) >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref= lectiveMethodInvocation.java:172) >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo= pProxy.java:204) >> com.sun.proxy.$Proxy253.saveEquipmentOrderList(Unknown Source) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .sendOrdersPosToEquipment(OrdersController.java:135) >> mx.ssf.sicom.integration.corporateStructure.controllers.OrdersController= .saveOrdersPos(OrdersController.java:98) >> sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor= Impl.java:43) >> java.lang.reflect.Method.invoke(Method.java:606) >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(Inv= ocableHandlerMethod.java:215) >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForR= equest(InvocableHandlerMethod.java:132) >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa= ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand= lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.= handle(AbstractHandlerMethodAdapter.java:82) >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS= ervlet.java:919) >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe= rvlet.java:851) >> org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor= kServlet.java:953) >> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet= .java:855) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle= t.java:829) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:728) nota La tra= za >> completa de la causa de este error se encuentra en los archivos de diari= o >> de Apache Tomcat/7.0.42.Apache Tomcat/7.0.42 >> >> >> >> >> >> *De:* Christian [mailto:christian@ssf.com.mx] >> *Enviado el:* viernes, 25 de noviembre de 2016 12:24 p. m. >> *Para:* MARIO MORENO ROBLES >> >> >> *CC:* Rogelio Delgado; martin@ssf.com.mx >> *Asunto:* Re: Contacto - DESPLIEGUE DE VERSI=C3=93N EN SERVIDOR Z GAS DE= PRUEBA >> >> Hola buen d=C3=ADa, >> >> Env=C3=ADo este email, para confirmar que se ha desplegado la versi=C3= =B3n con >> cambios para las pruebas pertinentes en el WebService de pedidos. >> Mario, pudiera apoyarme con la ejecuci=C3=B3n del WebService? >> Saludos. >> >> El 24/11/16 a las 15:39, MARIO MORENO ROBLES escribi=C3=B3: >> >> Gracias, >> >> >> >> Pudieron conectarse al servidor 10.21.90.30? >> >> >> >> Saludos,. >> >> >> >> >> >> >> >> >> >> >> >> *De:* Rogelio Delgado [mailto:rogelio@ssf.mx ] >> *Enviado el:* jueves, 24 de noviembre de 2016 01:41 p. m. >> *Para:* MARIO MORENO ROBLES; Christian >> *Asunto:* Contacto >> >> >> >> Hola Mario, buen d=C3=ADa. >> >> >> >> Env=C3=ADo tu contacto a Chritian Trejo, =C3=A9l es la persona que est= =C3=A1 revisando el >> problema con el Web Service ya estar=C3=A1 haciendo los despliegues en e= l >> ambiente de pruebas. Cualquier asunto relacionado a este tema te >> agradecer=C3=ADa que te dirijas a el con copia a mi y a Mart=C3=ADn por = favor. >> >> >> >> Saludos! >> >> -- >> >> ____________________________________ >> L.I Rogelio Delgado Gonz=C3=A1lez >> >> * Smart Software Factory* >> >> :: Innovando en servicios tecnol=C3=B3gicos :: >> >> >> >> -- >> >> Saludos! >> >> ____________________________________ >> L.I Rogelio Delgado Gonz=C3=A1lez >> >> * Smart Software Factory* >> >> :: Innovando en servicios tecnol=C3=B3gicos :: >> > -- > Saludos! > ____________________________________ > L.I Rogelio Delgado Gonz=C3=A1lez > * Smart Software Factory* > :: Innovando en servicios tecnol=C3=B3gicos ::