Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009685Openbravo ERPA. Platformpublic2009-06-29 08:522011-10-28 19:19
Reportersureshbabu 
Assigned Toiperdomo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS10OS Version
Product Version2.50MP2 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009685: When Sales invoice is created through a process, when i click Reactivate button for the first time system throws error message
DescriptionCreated a sales order with document type as POS, on completing the POS Sales order Sales Shipment & Sales invoice documents are created automatically.

When i tried reactivate the above created sales invoice by clicking the Reactivate button for the first time, System wrongly throws error message as "ERROR:Document processed/posted "

Note:when i click the reactivate button for the second time, Process completed message appears and the invoice document moves to draft stage.
Steps To Reproduce1) Create a sales order with Transaction Document field as POS ORDER and enter the remaining details.and complete the sales order.(Shipment & Invoice document will be generated with complete status)

2) Open the above created Sales invoice in edit mode and click Re-activate button .

System throws error message as "Document processed/posted"

Note:when i click the reactivate button for the second time, Process completed message appears and the invoice document moves to draft stage.
Proposed Solution
Additional Information
Tags250MP2QAcylce
Relationships
depends on defect 0009724 closed vmromanos Cannot complete a POS order or Warehouse Order when it is completed the last day of the month 
Attached Filesjpg Reactivate button throws wrong error message.JPG (211,278) 2009-06-29 08:52
https://issues.openbravo.com/file_download.php?file_id=1487&type=bug
jpg

png Period.png (159,292) 2009-06-30 08:35
https://issues.openbravo.com/file_download.php?file_id=1498&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-06-29 08:52sureshbabuNew Issue
2009-06-29 08:52sureshbabuAssigned To => rafaroda
2009-06-29 08:52sureshbabuFile Added: Reactivate button throws wrong error message.JPG
2009-06-29 09:31sureshbabuTag Attached: 250MP2QAcylce
2009-06-29 10:49psarobeStatusnew => scheduled
2009-06-29 10:49psarobeAssigned Torafaroda => areefbasha
2009-06-29 10:49psarobefix_in_branch => pi
2009-06-30 08:34areefbashaNote Added: 0017662
2009-06-30 08:34areefbashafix_in_branchpi =>
2009-06-30 08:35areefbashaFile Added: Period.png
2009-06-30 08:35areefbashaStatusscheduled => feedback
2009-06-30 08:53sureshbabuNote Added: 0017663
2009-06-30 09:04sureshbabuNote Edited: 0017663
2009-06-30 18:50psarobeRelationship addeddepends on 0009724
2009-06-30 18:51psarobeStatusfeedback => scheduled
2009-06-30 18:51psarobefix_in_branch => pi
2009-08-20 07:40harikrishnanAssigned Toareefbasha => harikrishnan
2009-08-20 08:10rafarodaNote Added: 0019086
2009-08-20 08:10rafarodaAssigned Toharikrishnan => iperdomo
2009-08-20 08:10rafarodaCategory07. Sales management => A. Platform
2009-08-20 08:10rafarodafix_in_branchpi =>
2011-10-28 19:19psarobeNote Added: 0042300
2011-10-28 19:19psarobeStatusscheduled => closed
2011-10-28 19:19psarobeResolutionopen => unable to reproduce

Notes
(0017662)
areefbasha   
2009-06-30 08:34   
Hi Suresh,

Following your step 1) in the steps to reproduce section, i am getting Error: "The Period does not exist or it is not opened"(Screen shot is attached). Further i am unable to complete order. Please let me know if i am missing any necessary data to reproduce this issue.

Thanks,
Areef
(0017663)
sureshbabu   
2009-06-30 08:53   
(edited on: 2009-06-30 09:04)
Areef,

The error message which you are getting is nothing to do with the defect which i raised here. Period should be opened before you perform any accounting transactions.

And i am finding this issue in my working copy also, even though period is already opened. Yesterday when i raised this defect i didn't find any difficulty in complete the Sales order.

 i will try to find out the root cause for this, mean while if you find the root cause for this issue, kindly let me know.
(0019086)
rafaroda   
2009-08-20 08:10   
Hi,

This seems to be an issue related to Auto Save since the behavior is the following:
1) Click on Reactivate button.
2) Pop-up automatically open and closes.
3) Document closed/processed message is shown (see attached image).
4) Click on reactivate button again and all works perfectly.
Please notice that this only happens the first time.

Log error:

08:59:18 [http-8989-5] ERROR org.openbravo.erpWindows.SalesInvoice.HeaderData - SQL error in query: UPDATE C_Invoice SET AD_Client_ID = (?) , AD_Org_ID = (?) , C_Order_ID = (?) , DateOrdered = TO_DATE(?) , DocumentNo = (?) , POReference = (?) , Description = (?) , C_DocTypeTarget_ID = (?) , DateInvoiced = TO_DATE(?) , DateAcct = TO_DATE(?) , C_BPartner_ID = (?) , Taxdate = TO_DATE(?) , C_BPartner_Location_ID = (?) , AD_User_ID = (?) , M_PriceList_ID = (?) , C_Currency_ID = (?) , SalesRep_ID = (?) , IsDiscountPrinted = (?) , C_Charge_ID = (?) , ChargeAmt = TO_NUMBER(?) , PaymentRule = (?) , C_PaymentTerm_ID = (?) , C_Project_ID = (?) , C_Activity_ID = (?) , C_Campaign_ID = (?) , AD_OrgTrx_ID = (?) , User1_ID = (?) , User2_ID = (?) , TotalLines = TO_NUMBER(?) , GrandTotal = TO_NUMBER(?) , DocStatus = (?) , C_DocType_ID = (?) , DocAction = (?) , Posted = (?) , CreateFrom = (?) , CopyFrom = (?) , C_Invoice_ID = (?) , C_Withholding_ID = (?) , IsSelfService = (?) , GenerateTo = (?) , IsTaxIncluded = (?) , IsPrinted = (?) , IsSOTrx = (?) , IsActive = (?) , DatePrinted = TO_DATE(?) , Processed = (?) , Processing = (?) , Withholdingamount = TO_NUMBER(?) , updated = now(), updatedby = ? WHERE C_Invoice.C_Invoice_ID = ? AND C_Invoice.AD_Client_ID IN ('1000000') AND C_Invoice.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007') Exception:java.sql.SQLException: ORA-20501: Document processed/posted
ORA-06512: en "TADPI.C_INVOICE_TRG", línea 54
ORA-04088: error durante la ejecución del disparador 'TADPI.C_INVOICE_TRG'

08:59:18 [http-8989-5] ERROR org.openbravo.base.exception.OBException - Document posted/processed
org.openbravo.base.exception.OBException: Document posted/processed
    at org.openbravo.erpWindows.SalesInvoice.Header.doPost(Header.java:67)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:326)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    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:654)
    at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:557)
    at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:481)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.forwardRequest(HttpSecureAppServlet.java:1138)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:319)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    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: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.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85)
    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:175)
    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:263)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:619)
(0042300)
psarobe   
2011-10-28 19:19   
Openbravo provides community support only for the latest Openbravo version, which is Openbravo 3. This version has significantly improved financial flow, filtering, performance, etc and this issue is not present there. Upgrade path from Openbravo 2.50 to latest Openbravo version is available so we recommend to upgrade your instance to get this issue fixed.

Life cycle guarantee (backporting bug fixes to the previos to latest releases (Openbravo 2.40, 2.50)) is available for Professional Edition subscribers only. Please register your ticket through Openbravo Support Portal (http://support.openbravo.com/ [^]) if you have valid Professional subscription.

You can find more details about our Support policy in the following blog post
http://paolojuvara.blogspot.com/2009/12/maintenance-policy-for-openbravo-250.html [^]