Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0031824 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | have not tried | 2016-01-05 17:57 | 2016-01-19 15:18 | |||
| Reporter | mtaal | View Status | public | |||||
| Assigned To | mtaal | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 886ed432a5b8 | ||||
| Projection | none | ETA | none | Target Version | RR16Q2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | migueldejuana | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0031824: Import entry may not get saved in case of low level database error, webpos sees message as succesfully send | |||||||
| Description | When there is a low level error when saving an import entry the WebPOS client will think that the message is saved on the server and will remove it from the local cache. | |||||||
| Steps To Reproduce | 1- Login to webpos 2- Create a trigger which gives an exception, set as after-insert trigger on c_import_entry table. See the example trigger function attached to the issue. 3- Create a ticket in webpos and submit 4- The ticket is not saved on the server but still removed from webpos See the attached stack trace for what the console shows. | |||||||
| Proposed Solution | on the server create the correct error json and set a failure status code so that the webpos client correctly signals an error. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  trigger.txt [^] (50 bytes) 2016-01-05 17:57 [Show Content] [Hide Content]DECLARE
BEGIN
RAISE EXCEPTION 'ERROR';
END
;
stack-trace.txt [^] (54,739 bytes) 2016-01-05 17:58 [Show Content] [Hide Content]826961 [http-8080-5] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into C_IMPORT_ENTRY (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsoninfo, ImportStatus, Typeofdata, EM_Obpos_Applications_ID, AD_Role_ID, C_IMPORT_ENTRY_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2016-01-05 17:25:02.688000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2016-01-05 17:25:02.688000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '{"messageId":"8011CBE3D20A4CF13E05E1877067F69A","data":[{"hasbeenpaid":"N","isbeingprocessed":"N","id":"85FD89815389ACC6685F19DA73E27D07","client":"39363B0921BB4293B48383844325E84C","organization":"D270A5AC50874F8BA67A88EE977F8E3B","createdBy":"3073EDF96A3C42CC86C7069E379522D2","updatedBy":"3073EDF96A3C42CC86C7069E379522D2","documentType":"511A9371A0F74195AA3F6D66C722729D","orderType":0,"generateInvoice":false,"isQuotation":false,"oldId":null,"priceList":"496CF965DF9744D2A41248392D1DE407","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"386FC4E5B0D1E2AFEDE9EDB055328869","warehouse":"CE7AB151695342FF879938F837F12E6E","salesRepresentative":"3073EDF96A3C42CC86C7069E379522D2","salesRepresentative$_identifier":"Vall Blanca Store User","posTerminal":"9104513C2D0741D4850AE8493998A7C8","posTerminal$_identifier":"VBS POS Terminal","orderDate":"2016-01-05T16:25:02.283Z","creationDate":"2016-01-05T16:25:02.283Z","documentnoPrefix":"VBS1","quotationnoPrefix":-1,"documentnoSuffix":89,"quotationnoSuffix":-1,"documentNo":"VBS1\/0000089","bp":{"id":"ABD91C9D3BC94175B876FBBE9CACA008","organization":"D270A5AC50874F8BA67A88EE977F8E3B","searchKey":"VBS\/C0001","_identifier":"VBS Customer","name":"VBS Customer","firstName":"VBS Customer","lastName":null,"description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"D8955F8808A54C63BBF478A6843D834D","priceList":"496CF965DF9744D2A41248392D1DE407","invoiceTerms":"I","locId":"2AA7EADDF7EC405899262DDA3E572436","locName":"Pau Claris 138 1-1","postalCode":"08009","cityName":"Barcelona","countryName":"Spain","contactId":"032576220FC44B0DA80145B3265E4D9A","phone":null,"email":null,"businessPartnerCategory":"B1DD8B371643421C987EF1D5B358D5E9","businessPartnerCategory_name":"Customer","creditLimit":0,"creditUsed":0,"taxExempt":false,"customerBlocking":false,"salesOrderBlocking":true,"priceIncludesTax":true,"locationModel":{"id":"2AA7EADDF7EC405899262DDA3E572436","bpartner":"ABD91C9D3BC94175B876FBBE9CACA008","name":"Pau Claris 138 1-1","postalCode":"08009","cityName":"Barcelona","countryName":"Spain","countryId":"106","regionName":"BARCELONA ","regionId":"AF310D01B53B461283EB40DB21DCA6B5","_identifier":"Pau Claris 138 1-1"}},"lines":[{"product":{"id":"AC79520FEB4743B3AAA379BF70B9B7DA","searchkey":"WVG\/B0017","uPCEAN":"2112345000046","uOM":"100","uOMsymbol":"Ud ","productCategory":"0C20B3F7AB234915B2239FCD8BE10CD1","taxCategory":"FF80818123B7FC160123B804AB88000B","description":"Disposable body warmers.","obposScale":false,"groupProduct":true,"stocked":true,"showstock":false,"isGeneric":false,"generic_product_id":null,"brand":"C7B171B9289C4677829A13D7FAACE4F6","characteristicDescription":"Object: First-Aid, Price: < 20€, Use: High Mountaineering & Expeditions, Hiking & Trekking, Weight: Under 1Kg","showchdesc":true,"bestseller":false,"ispack":false,"listPrice":3.6,"standardPrice":3.6,"priceLimit":3.6,"cost":0,"algorithm":"S","_identifier":"Adhesive body warmers","originalStandardPrice":3.6},"productidentifier":null,"uOM":"100","qty":1,"price":3.6,"priceList":3.6,"gross":3.6,"net":2.98,"description":"","id":"8743E2EBFA6D8BEBE94BAD618C77BA0E","priceIncludesTax":true,"warehouse":{"id":"A154EC30A296479BB078B0AFFD74CA22","warehousename":"Vall Blanca Store Warehouse"},"grossListPrice":3.6,"promotionCandidates":null,"promotionMessages":[],"noDiscountCandidates":true,"taxLines":{"5235D8E99A2749EFA17A5C92A52AEFC6":{"name":"Entregas IVA 21%","rate":21,"net":2.98,"amount":0.62}},"tax":"5235D8E99A2749EFA17A5C92A52AEFC6","taxAmount":0.62,"pricenet":2.98,"discountedNet":2.98,"linerate":1.21,"discountPercentage":0,"listPrice":2.98,"standardPrice":2.98,"grossUnitPrice":3.6,"lineGrossAmount":3.6}],"payments":[{"amount":3.6,"origAmount":3.6,"paid":3.6,"date":"2016-01-05T16:25:01.937Z","kind":"OBPOS_payment.cash","name":"Cash","rate":"1","mulrate":"1.000000000000","isocode":"EUR","allowOpenDrawer":true,"isCash":true,"openDrawer":false,"printtwice":false}],"payment":3.6,"change":0,"qty":1,"gross":3.6,"net":2.98,"taxes":{"5235D8E99A2749EFA17A5C92A52AEFC6":{"name":"Entregas IVA 21%","rate":21,"net":2.98,"amount":0.62}},"description":"","print":true,"sendEmail":false,"isPaid":false,"paidOnCredit":false,"isLayaway":false,"isEditable":true,"openDrawer":false,"totalamount":null,"approvals":[],"isNewReceipt":false,"cloningReceipt":false,"calculateReceiptCallbacks":[],"isBeingDiscounted":false,"reApplyDiscounts":false,"timezoneOffset":-60,"created":1452011102283,"obposCreatedabsolute":"2016-01-05 17:25:02.283","movementDate":"2016-01-05T16:25:02.285Z","accountingDate":"2016-01-05T16:25:02.285Z","obposAppCashup":"3B39E21A2DD9D8B74A5C3FCB316DA1FA"}],"client":"39363B0921BB4293B48383844325E84C","organization":"D270A5AC50874F8BA67A88EE977F8E3B","pos":"9104513C2D0741D4850AE8493998A7C8","terminalName":"VBS-1","appName":"WebPOS"}', 'Initial', 'Order', '9104513C2D0741D4850AE8493998A7C8', '5FA11B3DD8F04C0986C774624809C31E', '8011CBE3D20A4CF13E05E1877067F69A') was aborted. Call getNextException to see the cause.
826962 [http-8080-5] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: ERROR
826964 [http-8080-5] ERROR org.openbravo.base.exception.OBException - Could not execute JDBC batch update - ERROR: ERROR
org.postgresql.util.PSQLException: ERROR: ERROR
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
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.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:323)
at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:266)
at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:174)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:312)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:260)
at org.openbravo.service.importprocess.ImportEntryManager$Proxy$_$$_WeldClientProxy.createImportEntry(ImportEntryManager$Proxy$_$$_WeldClientProxy.java)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:115)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:165)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:87)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:214)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
826965 [http-8080-5] ERROR org.openbravo.base.exception.OBException - org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update - ERROR: ERROR
org.postgresql.util.PSQLException: ERROR: ERROR
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
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.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:323)
at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:266)
at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:174)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:312)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:260)
at org.openbravo.service.importprocess.ImportEntryManager$Proxy$_$$_WeldClientProxy.createImportEntry(ImportEntryManager$Proxy$_$$_WeldClientProxy.java)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:115)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:165)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:87)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:214)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
826965 [http-8080-5] ERROR org.openbravo.mobile.core.process.MobileService - Error captured:
org.openbravo.base.exception.OBException: org.openbravo.base.exception.OBException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:126)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:165)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:87)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:214)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.openbravo.base.exception.OBException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:89)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:115)
... 45 more
Caused by: 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.engine.ActionQueue.executeActions(ActionQueue.java:268)
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.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:323)
at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:266)
at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:174)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:312)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:260)
at org.openbravo.service.importprocess.ImportEntryManager$Proxy$_$$_WeldClientProxy.createImportEntry(ImportEntryManager$Proxy$_$$_WeldClientProxy.java)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:87)
... 46 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into C_IMPORT_ENTRY (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsoninfo, ImportStatus, Typeofdata, EM_Obpos_Applications_ID, AD_Role_ID, C_IMPORT_ENTRY_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2016-01-05 17:25:02.688000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2016-01-05 17:25:02.688000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '{"messageId":"8011CBE3D20A4CF13E05E1877067F69A","data":[{"hasbeenpaid":"N","isbeingprocessed":"N","id":"85FD89815389ACC6685F19DA73E27D07","client":"39363B0921BB4293B48383844325E84C","organization":"D270A5AC50874F8BA67A88EE977F8E3B","createdBy":"3073EDF96A3C42CC86C7069E379522D2","updatedBy":"3073EDF96A3C42CC86C7069E379522D2","documentType":"511A9371A0F74195AA3F6D66C722729D","orderType":0,"generateInvoice":false,"isQuotation":false,"oldId":null,"priceList":"496CF965DF9744D2A41248392D1DE407","priceIncludesTax":true,"currency":"102","currency$_identifier":"EUR","session":"386FC4E5B0D1E2AFEDE9EDB055328869","warehouse":"CE7AB151695342FF879938F837F12E6E","salesRepresentative":"3073EDF96A3C42CC86C7069E379522D2","salesRepresentative$_identifier":"Vall Blanca Store User","posTerminal":"9104513C2D0741D4850AE8493998A7C8","posTerminal$_identifier":"VBS POS Terminal","orderDate":"2016-01-05T16:25:02.283Z","creationDate":"2016-01-05T16:25:02.283Z","documentnoPrefix":"VBS1","quotationnoPrefix":-1,"documentnoSuffix":89,"quotationnoSuffix":-1,"documentNo":"VBS1\/0000089","bp":{"id":"ABD91C9D3BC94175B876FBBE9CACA008","organization":"D270A5AC50874F8BA67A88EE977F8E3B","searchKey":"VBS\/C0001","_identifier":"VBS Customer","name":"VBS Customer","firstName":"VBS Customer","lastName":null,"description":null,"taxID":null,"taxCategory":null,"paymentMethod":"45A202BF44884F05B8A1BF741E2063B6","paymentTerms":"D8955F8808A54C63BBF478A6843D834D","priceList":"496CF965DF9744D2A41248392D1DE407","invoiceTerms":"I","locId":"2AA7EADDF7EC405899262DDA3E572436","locName":"Pau Claris 138 1-1","postalCode":"08009","cityName":"Barcelona","countryName":"Spain","contactId":"032576220FC44B0DA80145B3265E4D9A","phone":null,"email":null,"businessPartnerCategory":"B1DD8B371643421C987EF1D5B358D5E9","businessPartnerCategory_name":"Customer","creditLimit":0,"creditUsed":0,"taxExempt":false,"customerBlocking":false,"salesOrderBlocking":true,"priceIncludesTax":true,"locationModel":{"id":"2AA7EADDF7EC405899262DDA3E572436","bpartner":"ABD91C9D3BC94175B876FBBE9CACA008","name":"Pau Claris 138 1-1","postalCode":"08009","cityName":"Barcelona","countryName":"Spain","countryId":"106","regionName":"BARCELONA ","regionId":"AF310D01B53B461283EB40DB21DCA6B5","_identifier":"Pau Claris 138 1-1"}},"lines":[{"product":{"id":"AC79520FEB4743B3AAA379BF70B9B7DA","searchkey":"WVG\/B0017","uPCEAN":"2112345000046","uOM":"100","uOMsymbol":"Ud ","productCategory":"0C20B3F7AB234915B2239FCD8BE10CD1","taxCategory":"FF80818123B7FC160123B804AB88000B","description":"Disposable body warmers.","obposScale":false,"groupProduct":true,"stocked":true,"showstock":false,"isGeneric":false,"generic_product_id":null,"brand":"C7B171B9289C4677829A13D7FAACE4F6","characteristicDescription":"Object: First-Aid, Price: < 20€, Use: High Mountaineering & Expeditions, Hiking & Trekking, Weight: Under 1Kg","showchdesc":true,"bestseller":false,"ispack":false,"listPrice":3.6,"standardPrice":3.6,"priceLimit":3.6,"cost":0,"algorithm":"S","_identifier":"Adhesive body warmers","originalStandardPrice":3.6},"productidentifier":null,"uOM":"100","qty":1,"price":3.6,"priceList":3.6,"gross":3.6,"net":2.98,"description":"","id":"8743E2EBFA6D8BEBE94BAD618C77BA0E","priceIncludesTax":true,"warehouse":{"id":"A154EC30A296479BB078B0AFFD74CA22","warehousename":"Vall Blanca Store Warehouse"},"grossListPrice":3.6,"promotionCandidates":null,"promotionMessages":[],"noDiscountCandidates":true,"taxLines":{"5235D8E99A2749EFA17A5C92A52AEFC6":{"name":"Entregas IVA 21%","rate":21,"net":2.98,"amount":0.62}},"tax":"5235D8E99A2749EFA17A5C92A52AEFC6","taxAmount":0.62,"pricenet":2.98,"discountedNet":2.98,"linerate":1.21,"discountPercentage":0,"listPrice":2.98,"standardPrice":2.98,"grossUnitPrice":3.6,"lineGrossAmount":3.6}],"payments":[{"amount":3.6,"origAmount":3.6,"paid":3.6,"date":"2016-01-05T16:25:01.937Z","kind":"OBPOS_payment.cash","name":"Cash","rate":"1","mulrate":"1.000000000000","isocode":"EUR","allowOpenDrawer":true,"isCash":true,"openDrawer":false,"printtwice":false}],"payment":3.6,"change":0,"qty":1,"gross":3.6,"net":2.98,"taxes":{"5235D8E99A2749EFA17A5C92A52AEFC6":{"name":"Entregas IVA 21%","rate":21,"net":2.98,"amount":0.62}},"description":"","print":true,"sendEmail":false,"isPaid":false,"paidOnCredit":false,"isLayaway":false,"isEditable":true,"openDrawer":false,"totalamount":null,"approvals":[],"isNewReceipt":false,"cloningReceipt":false,"calculateReceiptCallbacks":[],"isBeingDiscounted":false,"reApplyDiscounts":false,"timezoneOffset":-60,"created":1452011102283,"obposCreatedabsolute":"2016-01-05 17:25:02.283","movementDate":"2016-01-05T16:25:02.285Z","accountingDate":"2016-01-05T16:25:02.285Z","obposAppCashup":"3B39E21A2DD9D8B74A5C3FCB316DA1FA"}],"client":"39363B0921BB4293B48383844325E84C","organization":"D270A5AC50874F8BA67A88EE977F8E3B","pos":"9104513C2D0741D4850AE8493998A7C8","terminalName":"VBS-1","appName":"WebPOS"}', 'Initial', 'Order', '9104513C2D0741D4850AE8493998A7C8', '5FA11B3DD8F04C0986C774624809C31E', '8011CBE3D20A4CF13E05E1877067F69A') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1999)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 59 more
829113 [http-8080-5] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into C_IMPORT_ENTRY (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsoninfo, ImportStatus, Typeofdata, EM_Obpos_Applications_ID, AD_Role_ID, C_IMPORT_ENTRY_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2016-01-05 17:25:04.835000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2016-01-05 17:25:04.835000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '{"messageId":"91686747781655C3FC29EB619C89538B","data":[{"posterminal":"9104513C2D0741D4850AE8493998A7C8","id":"3B39E21A2DD9D8B74A5C3FCB316DA1FA","isprocessed":"N","isbeingprocessed":"Y","netSales":1126.14,"grossSales":1362.6,"netReturns":0,"grossReturns":0,"totalRetailTransactions":1362.6,"cashPaymentMethodInfo":[{"paymentMethodId":"5EA2A7DEBB2A49A69550C7E3D8899ED5","id":"AC89E6F612643C6405CDA5755A20CE9F","searchKey":"OBPOS_payment.card","startingCash":0,"totalSales":0,"totalReturns":0,"rate":"1","isocode":"EUR","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"5EA2A7DEBB2A49A69550C7E3D8899ED5"},{"paymentMethodId":"63339A82A49A4AE0BCD9AC5929B0EA3B","id":"507AF36DCD464176AE51FBBEEB0D2FFA","searchKey":"OBPOS_payment.cash","startingCash":0,"totalSales":1438.2,"totalReturns":0,"rate":"1","isocode":"EUR","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"63339A82A49A4AE0BCD9AC5929B0EA3B"},{"paymentMethodId":"E11EBCB5CF0442618B72B903DCB6A036","id":"BB7FEB2D7A324EF3011AC069F74A9AC2","searchKey":"OBPOS.payment.usacash","startingCash":0,"totalSales":0,"totalReturns":0,"rate":"0.76082","isocode":"USD","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"E11EBCB5CF0442618B72B903DCB6A036"},{"paymentMethodId":"6E98C4DE459748BE997693E9ED956D21","id":"920CB6FA6C6F5FCB11BF9D369DB50062","searchKey":"OBPOS_payment.voucher","startingCash":0,"totalSales":0,"totalReturns":0,"rate":"1","isocode":"EUR","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"6E98C4DE459748BE997693E9ED956D21"}],"cashTaxInfo":[{"name":"Entregas IVA 21%","amount":236.46,"orderType":"0","cashupId":"3B39E21A2DD9D8B74A5C3FCB316DA1FA","id":"90502A9BB079BEF7689BFCE0C7626275"}],"cashCloseInfo":[],"cashUpDate":"","creationDate":"2015-11-20T11:47:00.000Z","userId":"3073EDF96A3C42CC86C7069E379522D2"}],"client":"39363B0921BB4293B48383844325E84C","organization":"D270A5AC50874F8BA67A88EE977F8E3B","pos":"9104513C2D0741D4850AE8493998A7C8","terminalName":"VBS-1","appName":"WebPOS"}', 'Initial', 'OBPOS_App_Cashup', '9104513C2D0741D4850AE8493998A7C8', '5FA11B3DD8F04C0986C774624809C31E', '91686747781655C3FC29EB619C89538B') was aborted. Call getNextException to see the cause.
829113 [http-8080-5] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: ERROR
829113 [http-8080-5] ERROR org.openbravo.base.exception.OBException - Could not execute JDBC batch update - ERROR: ERROR
org.postgresql.util.PSQLException: ERROR: ERROR
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
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.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:323)
at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:266)
at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:174)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:312)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:260)
at org.openbravo.service.importprocess.ImportEntryManager$Proxy$_$$_WeldClientProxy.createImportEntry(ImportEntryManager$Proxy$_$$_WeldClientProxy.java)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:115)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:165)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:87)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:214)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
829114 [http-8080-5] ERROR org.openbravo.base.exception.OBException - org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update - ERROR: ERROR
org.postgresql.util.PSQLException: ERROR: ERROR
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
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.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:323)
at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:266)
at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:174)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:312)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:260)
at org.openbravo.service.importprocess.ImportEntryManager$Proxy$_$$_WeldClientProxy.createImportEntry(ImportEntryManager$Proxy$_$$_WeldClientProxy.java)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:87)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:115)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:165)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:87)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:214)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
829115 [http-8080-5] ERROR org.openbravo.mobile.core.process.MobileService - Error captured:
org.openbravo.base.exception.OBException: org.openbravo.base.exception.OBException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:126)
at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:165)
at org.openbravo.mobile.core.process.MobileService.doGetOrPost(MobileService.java:87)
at org.openbravo.mobile.core.process.MobileService.doPost(MobileService.java:58)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:214)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:428)
at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:88)
at org.openbravo.mobile.core.process.WebServiceAuthenticatedServlet.service(WebServiceAuthenticatedServlet.java:60)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.openbravo.base.exception.OBException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:89)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.executeCreateImportEntry(DataSynchronizationProcess.java:115)
... 45 more
Caused by: 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.engine.ActionQueue.executeActions(ActionQueue.java:268)
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.dal.core.SessionHandler.flushRemainingChanges(SessionHandler.java:323)
at org.openbravo.dal.core.SessionHandler.commitAndClose(SessionHandler.java:266)
at org.openbravo.dal.service.OBDal.commitAndClose(OBDal.java:174)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:312)
at org.openbravo.service.importprocess.ImportEntryManager.createImportEntry(ImportEntryManager.java:260)
at org.openbravo.service.importprocess.ImportEntryManager$Proxy$_$$_WeldClientProxy.createImportEntry(ImportEntryManager$Proxy$_$$_WeldClientProxy.java)
at org.openbravo.mobile.core.process.DataSynchronizationProcess.createImportEntry(DataSynchronizationProcess.java:87)
... 46 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into C_IMPORT_ENTRY (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Jsoninfo, ImportStatus, Typeofdata, EM_Obpos_Applications_ID, AD_Role_ID, C_IMPORT_ENTRY_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2016-01-05 17:25:04.835000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2016-01-05 17:25:04.835000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '{"messageId":"91686747781655C3FC29EB619C89538B","data":[{"posterminal":"9104513C2D0741D4850AE8493998A7C8","id":"3B39E21A2DD9D8B74A5C3FCB316DA1FA","isprocessed":"N","isbeingprocessed":"Y","netSales":1126.14,"grossSales":1362.6,"netReturns":0,"grossReturns":0,"totalRetailTransactions":1362.6,"cashPaymentMethodInfo":[{"paymentMethodId":"5EA2A7DEBB2A49A69550C7E3D8899ED5","id":"AC89E6F612643C6405CDA5755A20CE9F","searchKey":"OBPOS_payment.card","startingCash":0,"totalSales":0,"totalReturns":0,"rate":"1","isocode":"EUR","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"5EA2A7DEBB2A49A69550C7E3D8899ED5"},{"paymentMethodId":"63339A82A49A4AE0BCD9AC5929B0EA3B","id":"507AF36DCD464176AE51FBBEEB0D2FFA","searchKey":"OBPOS_payment.cash","startingCash":0,"totalSales":1438.2,"totalReturns":0,"rate":"1","isocode":"EUR","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"63339A82A49A4AE0BCD9AC5929B0EA3B"},{"paymentMethodId":"E11EBCB5CF0442618B72B903DCB6A036","id":"BB7FEB2D7A324EF3011AC069F74A9AC2","searchKey":"OBPOS.payment.usacash","startingCash":0,"totalSales":0,"totalReturns":0,"rate":"0.76082","isocode":"USD","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"E11EBCB5CF0442618B72B903DCB6A036"},{"paymentMethodId":"6E98C4DE459748BE997693E9ED956D21","id":"920CB6FA6C6F5FCB11BF9D369DB50062","searchKey":"OBPOS_payment.voucher","startingCash":0,"totalSales":0,"totalReturns":0,"rate":"1","isocode":"EUR","totalDeposits":0,"totalDrops":0,"paymentmethod_id":"6E98C4DE459748BE997693E9ED956D21"}],"cashTaxInfo":[{"name":"Entregas IVA 21%","amount":236.46,"orderType":"0","cashupId":"3B39E21A2DD9D8B74A5C3FCB316DA1FA","id":"90502A9BB079BEF7689BFCE0C7626275"}],"cashCloseInfo":[],"cashUpDate":"","creationDate":"2015-11-20T11:47:00.000Z","userId":"3073EDF96A3C42CC86C7069E379522D2"}],"client":"39363B0921BB4293B48383844325E84C","organization":"D270A5AC50874F8BA67A88EE977F8E3B","pos":"9104513C2D0741D4850AE8493998A7C8","terminalName":"VBS-1","appName":"WebPOS"}', 'Initial', 'OBPOS_App_Cashup', '9104513C2D0741D4850AE8493998A7C8', '5FA11B3DD8F04C0986C774624809C31E', '91686747781655C3FC29EB619C89538B') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1999)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 59 more
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0083145) hgbot (developer) 2016-01-05 22:11 |
Repository: erp/pmods/org.openbravo.mobile.core Changeset: 727a4f04e3e023624bbdc36cdb682e95304129ad Author: Martin Taal <martin.taal <at> openbravo.com> Date: Tue Jan 05 18:20:56 2016 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/727a4f04e3e023624bbdc36cdb682e95304129ad [^] Fixes issue 31824: Import entry may not get saved in case of low level database error, webpos sees message as succesfully send Create correct error json and return status code 500 on error --- M src/org/openbravo/mobile/core/process/MobileService.java --- |
|
(0083405) migueldejuana (developer) 2016-01-19 15:18 |
Tested and reviewed in RR16Q2 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-01-05 17:57 | mtaal | New Issue | |
| 2016-01-05 17:57 | mtaal | Assigned To | => mtaal |
| 2016-01-05 17:57 | mtaal | File Added: trigger.txt | |
| 2016-01-05 17:57 | mtaal | Triggers an Emergency Pack | => No |
| 2016-01-05 17:57 | mtaal | Status | new => scheduled |
| 2016-01-05 17:58 | mtaal | File Added: stack-trace.txt | |
| 2016-01-05 17:58 | mtaal | Review Assigned To | => marvintm |
| 2016-01-05 22:11 | hgbot | Checkin | |
| 2016-01-05 22:11 | hgbot | Note Added: 0083145 | |
| 2016-01-05 22:11 | hgbot | Status | scheduled => resolved |
| 2016-01-05 22:11 | hgbot | Resolution | open => fixed |
| 2016-01-05 22:11 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/727a4f04e3e023624bbdc36cdb682e95304129ad [^] |
| 2016-01-14 16:15 | hgbot | Checkin | |
| 2016-01-14 16:15 | hgbot | Note Added: 0083305 | |
| 2016-01-14 16:15 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/727a4f04e3e023624bbdc36cdb682e95304129ad [^] => http://code.openbravo.com/retail/backports/3.0RR16Q1/org.openbravo.mobile.core/rev/886ed432a5b837bbd459ea148b8c195d9873aef2 [^] |
| 2016-01-14 16:18 | mtaal | Note Deleted: 0083305 | |
| 2016-01-18 16:47 | mtaal | Review Assigned To | marvintm => migueldejuana |
| 2016-01-19 15:18 | migueldejuana | Note Added: 0083405 | |
| 2016-01-19 15:18 | migueldejuana | Status | resolved => closed |
| 2017-11-16 07:40 | guillermogil | Relationship added | causes 0037301 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |