Openbravo Issue Tracking System - Retail Modules
-Postgres log
2015-03-09 12:05:20 UTC LOG: unexpected EOF on client connection
2015-03-09 12:22:11 UTC LOG: process 2174 detected deadlock while waiting for ShareLock on transaction 10831754 after 1000.068 ms
2015-03-09 12:22:11 UTC CONTEXT: SQL statement "UPDATE M_STORAGE_DETAIL
SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
AD_CLIENT_ID=p_client,
AD_ORG_ID=p_org,
UPDATED=TO_DATE(NOW()),
UPDATEDBY=p_user
WHERE M_PRODUCT_ID=p_product
AND M_LOCATOR_ID=p_locator
AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
AND C_UOM_ID=p_uom
AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
PL/pgSQL function "m_update_inventory" line 65 at SQL statement
2015-03-09 12:22:11 UTC STATEMENT: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
2015-03-09 12:22:11 UTC ERROR: deadlock detected
2015-03-09 12:22:11 UTC DETAIL: Process 2174 waits for ShareLock on transaction 10831754; blocked by process 2175.
Process 2175 waits for ShareLock on transaction 10831748; blocked by process 2174.
Process 2174: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
Process 2175: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
2015-03-09 12:22:11 UTC HINT: See server log for query details.
2015-03-09 12:22:11 UTC CONTEXT: SQL statement "UPDATE M_STORAGE_DETAIL
SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
AD_CLIENT_ID=p_client,
AD_ORG_ID=p_org,
UPDATED=TO_DATE(NOW()),
UPDATEDBY=p_user
WHERE M_PRODUCT_ID=p_product
AND M_LOCATOR_ID=p_locator
AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
AND C_UOM_ID=p_uom
AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
PL/pgSQL function "m_update_inventory" line 65 at SQL statement
2015-03-09 12:22:11 UTC STATEMENT: select * from M_UPDATE_INVENTORY ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13) as result
2015-03-09 12:22:11 UTC ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-03-09 12:22:11 UTC STATEMENT: insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50)
2015-03-09 12:22:23 UTC LOG: could not receive data from client: Connection reset by peer
-openbravo log
d2f0c3a5 2015-03-09 12:22:11,980 [TP-Processor16] ERROR org.openbravo.base.exception.OBException - ERROR: deadlock detected
Detail: Process 2174 waits for ShareLock on transaction 10831754; blocked by process 2175.
Process 2175 waits for ShareLock on transaction 10831748; blocked by process 2174.
Hint: See server log for query details.
Where: SQL statement "UPDATE M_STORAGE_DETAIL
SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
AD_CLIENT_ID=p_client,
AD_ORG_ID=p_org,
UPDATED=TO_DATE(NOW()),
UPDATEDBY=p_user
WHERE M_PRODUCT_ID=p_product
AND M_LOCATOR_ID=p_locator
AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
AND C_UOM_ID=p_uom
AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
PL/pgSQL function "m_update_inventory" line 65 at SQL statement
org.openbravo.base.exception.OBException: ERROR: deadlock detected
Detail: Process 2174 waits for ShareLock on transaction 10831754; blocked by process 2175.
Process 2175 waits for ShareLock on transaction 10831748; blocked by process 2174.
Hint: See server log for query details.
Where: SQL statement "UPDATE M_STORAGE_DETAIL
SET QTYONHAND=QTYONHAND + COALESCE(p_qty, 0),
QTYORDERONHAND=QTYORDERONHAND + v_qtyorder,
DATELASTINVENTORY=COALESCE(p_datelastinventory, DATELASTINVENTORY),
PREQTYONHAND=PREQTYONHAND + COALESCE(p_preqty, 0),
PREQTYORDERONHAND=PREQTYORDERONHAND + v_preqtyorder,
AD_CLIENT_ID=p_client,
AD_ORG_ID=p_org,
UPDATED=TO_DATE(NOW()),
UPDATEDBY=p_user
WHERE M_PRODUCT_ID=p_product
AND M_LOCATOR_ID=p_locator
AND COALESCE(M_ATTRIBUTESETINSTANCE_ID, '0')=COALESCE(p_attributesetinstance, '0')
AND C_UOM_ID=p_uom
AND COALESCE(M_PRODUCT_UOM_ID, '-1')=COALESCE(p_product_uom, '-1')"
PL/pgSQL function "m_update_inventory" line 65 at SQL statement
at org.openbravo.retail.posterminal.OrderLoader.updateInventory(OrderLoader.java:1224)
at org.openbravo.retail.posterminal.OrderLoader.handleStock(OrderLoader.java:1174)
at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:253)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:117)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:51)
at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:25)
at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
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.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:127)
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:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:701)
d2f0c3a5 2015-03-09 12:22:11,985 [TP-Processor16] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ('4D4719F95EF1408D935D33F554A29E16', 'C25713CF3A4D4A61AF753B305208CC96', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 12:22:10.864000 +00:00:00', 'F652F1FE9D6A421197F0B255B533569E', 'Y', 'DOCNO1425903730828', 'CO', 'RE', 'N', 'Y', 'N', '40EE9B1CD3B345FABEFDA62B407B407F', '40EE9B1CD3B345FABEFDA62B407B407F', 'BE96C6A434F30ABC473DE348654A326F', 'Relacionado con el pedido: SANJAIPER/0013004', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 00:00:00.000000 +00:00:00', '2015-03-09 00:00:00.000000 +00:00:00', '8C3E780788664FCA802A03E524D51A0B', '9B830D4D434B42F3BD0FDA35294EFF05', 'N', '2015-03-09 00:00:00.000000 +00:00:00', '102', 'P', 'AB48BC05F7
AC45F5AF1261A88212992D', '8.25', '8.50', '0C88B756441F4A3D904BCC762DF4E2CC', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '8.50', '0', '8.50', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'Y', 'N', 'RE', 'N', '71C2BFA7DEE446AD9F655CC1E6C698A4') was aborted. Call getNextException to see the cause.
d2f0c3a5 2015-03-09 12:22:11,986 [TP-Processor16] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
d2f0c3a5 2015-03-09 12:22:11,994 [TP-Processor16] ERROR org.openbravo.mobile.core.process.DataSynchronizationProcess - An error happened when processing a record:
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2868)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.openbravo.dal.service.OBDal.flush(OBDal.java:205)
at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:277)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:117)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:51)
at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:25)
at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
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.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:127)
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:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ('4D4719F95EF1408D935D33F554A29E16', 'C25713CF3A4D4A61AF753B305208CC96', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 12:22:10.864000 +00:00:00', 'F652F1FE9D6A421197F0B255B533569E', 'Y', 'DOCNO1425903730828', 'CO', 'RE', 'N', 'Y', 'N', '40EE9B1CD3B345FABEFDA62B407B407F', '40EE9B1CD3B345FABEFDA62B407B407F', 'BE96C6A434F30ABC473DE348654A326F', 'Relacionado con el pedido: SANJAIPER/0013004', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 00:00:00.000000 +00:00:00', '2015-03-09 00:00:00.000000 +00:00:00', '8C3E780788664FCA802A03E524D51A0B', '9B830D4D434B42F3BD0FDA35294EFF05', 'N', '2015-03-09 00:00:00.000000 +00:00:00', '102', 'P', 'AB48BC05F7AC45F5AF1261A88212992D', '8.25', '8.50', '0C88B756441F4A3D904BCC762DF4E2CC', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '8.50', '0', '8.50', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'Y', 'N', 'RE', 'N', '71C2BFA7DEE446AD9F655CC1E6C698A4') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 67 more
d2f0c3a5 2015-03-09 12:22:12,010 [TP-Processor16] ERROR org.openbravo.mobile.core.process.DataSynchronizationProcess - Error while loading order
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2868)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.openbravo.dal.service.OBDal.flush(OBDal.java:205)
at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:277)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:117)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:51)
at org.openbravo.mobile.core.process.JSONProcessSimple.exec(JSONProcessSimple.java:25)
at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:39)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:154)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:77)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:48)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:446)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:87)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:52)
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.codehaus.enunciate.webapp.HTTPRequestContextFilter.doFilter(HTTPRequestContextFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter$1.doAction(OBSpringSecurityContextRequestFilter.java:71)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.client.analytics.OBSpringSecurityContextRequestFilter.doFilter(OBSpringSecurityContextRequestFilter.java:79)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:127)
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:293)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction,
Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, C_Order_ID, Description, IsPrinted, SalesRep_ID, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, IsDiscountPrinted, DateOrdered, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, TotalLines, GrandTotal, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, EM_Einv_Generated, Ispaid, EM_Einv_Sent, Totalpaid, OutstandingAmt, DaysTillDue, DueAmt, UpdatePaymentMonitor, FIN_Paymentmethod_ID, EM_APRM_Addpayment, Calculate_Promotions, EM_APRM_Processinvoice, Iscashvat, C_Invoice_ID) values ('4D4719F95EF1408D935D33F554A29E16', 'C25713CF3A4D4A61AF753B305208CC96', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 12:22:10.864000 +00:00:00', 'F652F1FE9D6A421197F0B255B533569E', 'Y', 'DOCNO1425903730828', 'CO', 'RE', 'N', 'Y', 'N', '40EE9B1CD3B345FABEFDA62B407B407F', '40EE9B1CD3B345FABEFDA62B407B407F', 'BE96C6A434F30ABC473DE348654A326F', 'Relacionado con el pedido: SANJAIPER/0013004', 'Y', 'F652F1FE9D6A421197F0B255B533569E', '2015-03-09 00:00:00.000000 +00:00:00', '2015-03-09 00:00:00.000000 +00:00:00', '8C3E780788664FCA802A03E524D51A0B', '9B830D4D434B42F3BD0FDA35294EFF05', 'N', '2015-03-09 00:00:00.000000 +00:00:00', '102', 'P', 'AB48BC05F7AC45F5AF1261A88212992D', '8.25', '8.50', '0C88B756441F4A3D904BCC762DF4E2CC', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '8.50', '0', '8.50', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'Y', 'N', 'RE', 'N', '71C2BFA7DEE446AD9F655CC1E6C698A4') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 67 more
d2f0c3a5 2015-03-09 12:22:12,034 [TP-Processor16] INFO org.openbravo.mobile.core.process.DataSynchronizationProcess - Final total time: 2760
d2f0c3a5 2015-03-09 12:22:12,049 [TP-Processor16] INFO org.openbravo.mobile.core.process.SecuredJSONProcess - Process org.openbravo.retail.posterminal.OrderLoader took:2775ms params: {"data":[{"hasbeenpaid":"Y","isbeingprocessed":"Y","id":"BE96C6A434F30ABC473DE348654A326F","client":"4D4719F95EF1408D935D33F554A29E16","organization":"C25713CF3A4D4A61AF753B305208CC96","createdBy":"F652F1FE9D6A421197F0B255B533569E","updatedBy":"F652F1FE9D6A421197F0B255B533569E","documentType":"6D28F9A6D21E4B7CAEE835248660D9C6","orderType":0,"generateInvoice":true,"isQuotation":false,"oldId":null,"priceList":"0C88B756441F4A3D904BCC762DF4E2CC","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"5E4EEA6C9292D05AF4D5C6CB5ED8C684","warehouse":"4D33E7D8075C448BAE4DAFE27CD3E84D","salesRepresentative":"F652F1FE9D6A421197F0B255B533569E","salesRepresentative$_identifier":"Jaime Pérez","posTerminal":"69DBEDD2955349C4BAF04BA33FC95F24","posTerminal$_identifier":"TPV - Santa Catalina - Jaime Pérez","orderDate":"2015-03-09T11:34:16.041Z","documentnoPrefix":"SANJAIPER","quotationnoPrefix":-1,"documentnoSuffix":13004,"quotationnoSuffix":-1,"documentNo":"SANJAIPER\/0013004","bp":{"id":"8C3E780788664FCA802A03E524D51A0B","organization":"C25713CF3A4D4A61AF753B305208CC96","searchKey":"TPV_SANTA_CATALINA","_identifier":"Santa Catalina - Venta Contado","name":"Santa Catalina - Venta Contado","description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"AB48BC05F7AC45F5AF1261A88212992D","priceList ":"undefined","invoiceTerms":"I","locId":"9B830D4D434B42F3BD0FDA35294EFF05","locName":null,"postalCode":"35008","cityName":"","countryName":"Spain","contactId":null,"phone":null,"email":null,"businessPartnerCategory":"66B4C5952169447ABC1B0E261347998F","businessPartnerCategory_name":"Tiendas - Clientes Menor","creditLimit":0,"creditUsed":0,"taxExempt":false,"undefined":"Santa Catalina - Venta Contado###null###null###null###","_idx":10},"lines":[{"product":{"id":"2121FB5F80094EEF8F87EDD7F6E5DA54","searchkey":"24275","uPCEAN":null,"uOM":"100","uOMsymbol":"Ud ","productCategory":"DD46CBE77D2E49A08E6E4EBA1BDEB0C3","taxCategory":"98330D5715B748CCBA8386604586ACA9","description":"BONO 10 VIAJES DISEÑO 2013","obposScale":false,"groupProduct":true,"stocked":true,"showstock":false,"isGeneric":false,"generic_product_id":null,"brand":null,"characteristicDescription":null,"showchdesc":true,"bestseller":false,"ispack":false,"listPrice":8.5,"standardPrice":8.5,"priceLimit":0,"cost":0,"algorithm":"S","_identifier":"BONO GUAGUA 10 VIAJES","undefined":"24275###null###BONO GUAGUA 10 VIAJES###","_idx":2,"originalStandardPrice":8.5},"productidentifier":null,"uOM":"100","qty":1,"price":8.5,"priceList":8.5,"gross":8.5,"net":8.25242718,"description":"","priceIncludesTax":true,"warehouse":{"id":"92F5FCB0843A4F7B8CB405BB0B74C7E8","warehousename":"Almacén Carmen Santana"},"promotions":null,"discountedLinePrice":null,"promotionCandidates":null,"linerate":{"ind":1,"form":0,"mant":[1,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"exp":-20},"tax":"0F9D478DF69C4A03BB3CD83C49567009","taxAmount":0.24757282,"pricenet":8.25242718,"discountedNet":8.25242718,"taxLines":{"0F9D478DF69C4A03BB3CD83C49567009":{"name":"Servicios prestados en Canarias 3%","rate":3,"net":8.25242718,"amount":0.24757282}},"discountPercentage":0,"listPrice":8.25242718,"standardPrice":8.25242718,"grossListPrice":8.5,"grossUnitPrice":8.5,"lineGrossAmount":8.5}],"payments":[{"amount":8.5,"origAmount":8.5,"paid":8.5,"date":"2015-03-09T11:34:29.627Z","kind":"OBPOS_payment.cash","name":"Al contado","rate":"1","mulrate":"1.000000000000","isocode":"EUR","allowOpenDrawer":true,"isCash":true,"openDrawer":false,"printtwice":false}],"payment":8.5,"change":0,"qty":1,"gross":8.5,"net":8.25242718,"taxes":{"0F9D478DF69C4A03BB3CD83C49567009":{"name":"Servicios prestados en Canarias 3%","rate":3,"net":8.25242718,"amount":0.24757282}},"description":"","print":true,"sendEmail":false,"isPaid":false,"paidOnCredit":false,"isLayaway":false,"isEditable":true,"openDrawer":false,"totalamount":null,"approvals":[],"isNewReceipt":false,"cloningReceipt":false,"timezoneOffset":0,"created":1425900870078,"obposCreatedabsolute":"2015-03-09 11:34:30.078","obposAppCashup":"BD9B349BDBD361F394002CE17F3B066E","bpLocId":null,"businessPartner$_identifier":null,"totalNetAmount":null,"orderid":null,"receiptLines":null,"receiptPayments":null,"receiptTaxes":null}],"client":"4D4719F95EF1408D935D33F554A29E16","organization":"C25713CF3A4D4A61AF753B305208CC96","pos":"69DBEDD2955349C4BAF04BA33FC95F24","terminalName":"SCatalina-Jaiper","appName":"WebPOS"}
d2f0c3a5 2015-03-09 12:22:12,188 [TP-Processor20] INFO org.openbravo.retail.posterminal.OrderLoader - Order with docno: TEAMILMON/0000834 (uuid: CF48531D267AB2FCF014A368AD3233B0) saved correctly. Initial flush: 0; Generate bobs:1379; Save bobs:0; First flush:0; Second flush: 1047; Process Payments:118 Final flush: 3
| related to | defect | 0029203 | closed | marvintm | Deadlocks have been detected when updating c_bpartner table OrderLoader |
logs.tar.gz (307,194) 2015-03-09 13:23https://issues.openbravo.com/file_download.php?file_id=7873&type=bug