Openbravo Issue Tracking System - Openbravo ERP
In the tomcat log file error is shown as
21:53:47 [http-80-1] ERROR org.openbravo.base.exception.OBException - ERROR: current transaction is aborted, commands ignored until end of transaction block
org.openbravo.base.exception.OBException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.openbravo.erpWindows.GoodsReceipt.Header.doPost(Header.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:221)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:359)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
at org.openbravo.base.secureApp.HttpSecureAppServlet.forwardRequest(HttpSecureAppServlet.java:1084)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:352)
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.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:52)
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:27)
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:83)
at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:48)
at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:89)
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:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
22:12:07 [http-80-3] ERROR org.openbravo.erpCommon.utility.DocumentNoData - SQL error in query: CALL AD_Sequence_Doc(?,TO_NUMBER(?),?,?)Exception:org.postgresql.util.PSQLException: ERROR: function ad_sequence_doc(character varying, numeric, character varying) does not exist
22:12:07 [http-80-3] ERROR org.openbravo.erpWindows.GoodsReceipt.HeaderData - SQL error in query: INSERT INTO M_InOut (AD_Client_ID, AD_Org_ID, C_Order_ID, DocumentNo, POReference, Description, C_DocType_ID, MovementDate, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID, Delivery_Location_ID, M_Warehouse_ID, PriorityRule, DeliveryViaRule, M_Shipper_ID, SalesRep_ID, DeliveryRule, FreightCostRule, NoPackages, M_FreightCategory_ID, Calculate_Freight, FreightAmt, C_Charge_ID, ChargeAmt, CreateFrom, GenerateTo, C_Project_ID, C_Activity_ID, C_Campaign_ID, AD_OrgTrx_ID, User1_ID, User2_ID, DocStatus, MovementType, DocAction, Posted, TrackingNo, PickDate, C_Invoice_ID, Processing, Processed, Islogistic, M_InOut_ID, IsActive, UpdateLines, GenerateLines, ShipDate, DateOrdered, DatePrinted, IsSOTrx, IsPrinted, created, createdby, updated, updatedBy) VALUES ((?), (?), (?), (?), (?), (?), (?), TO_DATE(?), TO_DATE(?), (?), (?), (?), (?), (?), (?), (?), (?), (?), (?), (?), TO_NUMBER(?), (?), (?), TO_NUMBER(?), (?), TO_NUMBER(?), (?), (?), (?), (?), (?), (?), TO_NUMBER(?), TO_NUMBER(?), (?), (?), (?), (?), (?), TO_DATE(?), (?), (?), (?), (?), (?), (?), (?), (?), TO_DATE(?), TO_DATE(?), TO_DATE(?), (?), (?), now(), ?, now(), ?)Exception:org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Screen shot attached
2.Create goods receipt for a purchase order and save it
| has duplicate | defect | 0006568 | closed | rafaroda | Error while saving a purchase invoice |
goodsreceipt.JPG (150,894) 2008-12-15 17:53https://issues.openbravo.com/file_download.php?file_id=545&type=bug