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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009038
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2009-05-15 09:452009-06-27 00:00
ReporterrafarodaView Statuspublic 
Assigned Toareefbasha 
PriorityhighResolutionfixedFixed in Versionmain
StatusclosedFix in branchFixed in SCM revisionfabc8fbe0b1b
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product VersionmainSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009038: Promissory Note print does not print in main

DescriptionPromissory Note print does not print in main with error ERROR: column "fa0e4bee411911dead74001b388c05f0" does not exist

08:40:47 [http-8888-2] ERROR org.openbravo.erpReports.RptPromissoryNoteAfterData - SQL error in query: SELECT C_BANKACCOUNT_ID AS BANK FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID IN (FA0E4BEE411911DEAD74001B388C05F0)Exception:org.postgresql.util.PSQLException: ERROR: column "fa0e4bee411911dead74001b388c05f0" does not exist
08:40:47 [http-8888-2] ERROR org.openbravo.erpReports.RptPromissoryNote - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: column "fa0e4bee411911dead74001b388c05f0" does not exist
javax.servlet.ServletException: @CODE=0@ERROR: column "fa0e4bee411911dead74001b388c05f0" does not exist
    at org.openbravo.erpReports.RptPromissoryNoteAfterData.selectDebtPaymentBank(RptPromissoryNoteAfterData.java:321)
    at org.openbravo.erpReports.RptPromissoryNote.printPagePDF(RptPromissoryNote.java:76)
    at org.openbravo.erpReports.RptPromissoryNote.doPost(RptPromissoryNote.java:49)
    at org.openbravo.base.HttpBaseServlet.doGet(HttpBaseServlet.java:283)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:331)
    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: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: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)
Steps To Reproduce-Go to purchase invoice
-Create an invoice
-Complete the invoice
-Go to payment tab
-Click the print button
Proposed SolutionChange select: SELECT C_BANKACCOUNT_ID AS BANK FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID IN (FA0E4BEE411911DEAD74001B388C05F0)
to make it look like by
SELECT C_BANKACCOUNT_ID AS BANK FROM C_DEBT_PAYMENT WHERE C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID IN ('FA0E4BEE411911DEAD74001B388C05F0')
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0009264 closediperdomo Can not print multiple promissory notes 
blocks defect 0009023 closeddalsasua The print button on the payment tab on the invoices does not work 

-  Notes
(0017515)
hgbot (developer)
2009-06-22 12:48

Repository: erp/devel/pi
Changeset: fabc8fbe0b1b3c01be065b97955d1e72ac6e3e8a
Author: Areef Basha <areef.basha <at> openbravo.com>
Date: Mon Jun 22 16:14:42 2009 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/fabc8fbe0b1b3c01be065b97955d1e72ac6e3e8a [^]

Fixes bug 9038: Promissory Note print does not print in main.
Now the textual replacement has been made correctly in sql query parameter.

---
M src/org/openbravo/erpReports/RptPromissoryNoteAfter_data.xsql
---

- Issue History
Date Modified Username Field Change
2009-05-15 09:45 rafaroda New Issue
2009-05-15 09:45 rafaroda Assigned To => dalsasua
2009-05-15 09:45 rafaroda Regression testing => No
2009-05-15 09:46 rafaroda Status new => scheduled
2009-05-15 09:46 rafaroda fix_in_branch => pi
2009-05-15 09:46 rafaroda Relationship added blocks 0009023
2009-05-19 11:10 rafaroda Assigned To dalsasua => rafaroda
2009-05-19 11:10 rafaroda version => main
2009-05-19 11:10 rafaroda fix_in_branch pi =>
2009-05-20 13:31 rafaroda Steps to Reproduce Updated
2009-06-01 14:13 rafaroda Assigned To rafaroda => sathiyan
2009-06-01 14:13 rafaroda Proposed Solution updated
2009-06-01 14:13 rafaroda Steps to Reproduce Updated
2009-06-01 15:17 rafaroda Steps to Reproduce Updated
2009-06-01 15:25 rafaroda Relationship added related to 0009264
2009-06-02 06:12 sathiyan Assigned To sathiyan => areefbasha
2009-06-22 12:48 hgbot Checkin
2009-06-22 12:48 hgbot Note Added: 0017515
2009-06-22 12:48 hgbot Status scheduled => resolved
2009-06-22 12:48 hgbot Resolution open => fixed
2009-06-22 12:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fabc8fbe0b1b3c01be065b97955d1e72ac6e3e8a [^]
2009-06-22 23:04 psarobe Fixed in Version => main
2009-06-26 17:56 psarobe Status resolved => closed
2009-06-27 00:00 anonymous sf_bug_id 0 => 2813021


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker