0009038: Promissory Note print does not print in main

Description

Promissory 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 Solution

Change 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')

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0009264		closed	iperdomo	Can not print multiple promissory notes
blocks	defect	0009023		closed	dalsasua	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