Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0009038 | Openbravo ERP | 03. Procurement management | public | 2009-05-15 09:45 | 2009-06-27 00:00 | ||||||||||||||
| Reporter | rafaroda | ||||||||||||||||||
| Assigned To | areefbasha | ||||||||||||||||||
| Priority | high | Severity | major | Reproducibility | always | ||||||||||||||
| Status | closed | Resolution | fixed | ||||||||||||||||
| Platform | OS | 20 | OS Version | rPath Linux | |||||||||||||||
| Product Version | main | ||||||||||||||||||
| Target Version | Fixed in Version | main | |||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 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') | ||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| 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 | ||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||