Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009685
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2009-06-29 08:522011-10-28 19:19
ReportersureshbabuView Statuspublic 
Assigned Toiperdomo 
PriorityhighResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSWindowsDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009685: 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.
Tags250MP2QAcylce
Attached Filesjpg file icon Reactivate button throws wrong error message.JPG [^] (211,278 bytes) 2009-06-29 08:52


png file icon Period.png [^] (159,292 bytes) 2009-06-30 08:35

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0009724 closedvmromanos Cannot complete a POS order or Warehouse Order when it is completed the last day of the month 

-  Notes
(0017662)
areefbasha (reporter)
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 (reporter)
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 (developer)
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 (manager)
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 [^]

- Issue History
Date Modified Username Field Change
2009-06-29 08:52 sureshbabu New Issue
2009-06-29 08:52 sureshbabu Assigned To => rafaroda
2009-06-29 08:52 sureshbabu File Added: Reactivate button throws wrong error message.JPG
2009-06-29 09:31 sureshbabu Tag Attached: 250MP2QAcylce
2009-06-29 10:49 psarobe Status new => scheduled
2009-06-29 10:49 psarobe Assigned To rafaroda => areefbasha
2009-06-29 10:49 psarobe fix_in_branch => pi
2009-06-30 08:34 areefbasha Note Added: 0017662
2009-06-30 08:34 areefbasha fix_in_branch pi =>
2009-06-30 08:35 areefbasha File Added: Period.png
2009-06-30 08:35 areefbasha Status scheduled => feedback
2009-06-30 08:53 sureshbabu Note Added: 0017663
2009-06-30 09:04 sureshbabu Note Edited: 0017663
2009-06-30 18:50 psarobe Relationship added depends on 0009724
2009-06-30 18:51 psarobe Status feedback => scheduled
2009-06-30 18:51 psarobe fix_in_branch => pi
2009-08-20 07:40 harikrishnan Assigned To areefbasha => harikrishnan
2009-08-20 08:10 rafaroda Note Added: 0019086
2009-08-20 08:10 rafaroda Assigned To harikrishnan => iperdomo
2009-08-20 08:10 rafaroda Category 07. Sales management => A. Platform
2009-08-20 08:10 rafaroda fix_in_branch pi =>
2011-10-28 19:19 psarobe Note Added: 0042300
2011-10-28 19:19 psarobe Status scheduled => closed
2011-10-28 19:19 psarobe Resolution open => unable to reproduce

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker