Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009265 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 08. Project and service management | minor | have not tried | 2009-06-01 15:28 | 2009-07-22 00:00 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | iperdomo | |||||||
| Priority | normal | Resolution | duplicate | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_11 | |||
| OS Version | rPath Linux | Database version | 8.3.5 | Ant version | 1.7.1 | |||
| Product Version | 2.40 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009265: Can not print multiple proposals inside Service Projects | |||||||
| Description | I can not print multiple proposals inside Service Projects | |||||||
| Steps To Reproduce | 1) Go to Project & Service Management || Transactions || Service Project and create a new one. 2) Go to Proposal tab and create two proposals. 3) Go to grid view and select both. 4) Click on Print button. In pi result is a blank page. In 2.40 you get the following error: 14:20:33 [http-8484-Processor22] ERROR org.openbravo.erpReports.RptCProposalJrData - SQL error in query: SELECT DISTINCT REPLACE(table3.HEADERNOTE, CHR(10), '') AS headernote, table3.C_PROJECTPROPOSAL_ID, table7.C_BPARTNER_ID, TO_CHAR(table8.address1) AS address1, to_char(table8.address2) as address2, TO_CHAR(table5.DESCRIPTION ) AS proposal, table5.VALUE AS reference, TO_CHAR(table8.ADDRESS1)|| ', '||TO_CHAR(table8.POSTAL)||' '|| TO_CHAR(table8.CITY)||' ('||TO_CHAR(table9.description)||')' AS ADDRESS, table8.CITY as CITY, to_date (table3.DATESEND) AS fecha, table7.FAX as FAX, table7.PHONE as PHONE,table5.NAME as NAME, TO_CHAR(table10.NAME) AS BPname, table11.FIRSTNAME AS namecontacto, table11.LASTNAME AS contacto, table15.CURSYMBOL as CURSYMBOL, '' as line_desc,'' as M_Product_ID_D, '' as description, '' as price,'' as quantity, '' as UOMNAME, table3.FOOTNOTE as FOOTNOTE FROM C_PROJECTPROPOSAL table3 left join AD_USER table11 on table3.AD_USER_ID = table11.AD_USER_ID left join C_GREETING on table11.C_GREETING_ID = C_GREETING.C_GREETING_ID, C_BPARTNER_LOCATION table7, C_LOCATION table8, C_REGION table9, C_BPARTNER table10, C_BPARTNER table4, C_PROJECT table5, AD_ORGINFO table13, C_CURRENCY table15 WHERE table3.C_Projectproposal_ID = (1000002,1000003) AND table3.C_BPARTNER_LOCATION_ID = table7.C_BPARTNER_LOCATION_ID AND table7.C_LOCATION_ID = table8.C_LOCATION_ID AND table8.C_REGION_ID = table9.C_REGION_ID AND table10.C_BPARTNER_ID = table7.C_BPARTNER_ID AND table3.C_BPartner_ID = table4.C_BPartner_ID AND table3.C_Project_ID = table5.C_Project_ID AND table5.C_CURRENCY_ID = table15.C_CURRENCY_ID AND table3.AD_CLIENT_ID IN (0,1000000) AND table3.AD_ORG_ID IN (0,1000000,1000002,1000003,1000004,1000005,1000006,1000008,1000009,1000007) AND 1=1Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: numeric = record 14:20:33 [http-8484-Processor22] ERROR org.openbravo.erpReports.RptC_ProposalJr - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: operator does not exist: numeric = record at org.openbravo.erpReports.RptCProposalJrData.select(RptCProposalJrData.java:200) at org.openbravo.erpReports.RptCProposalJrData.select(RptCProposalJrData.java:103) at org.openbravo.erpReports.RptC_ProposalJr.printPagePartePDF(RptC_ProposalJr.java:64) at org.openbravo.erpReports.RptC_ProposalJr.doPost(RptC_ProposalJr.java:55) at org.openbravo.base.HttpBaseServlet.doGet(HttpBaseServlet.java:188) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:134) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:257) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.CacheFilter.doFilter(CacheFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595) 14:20:33 [http-8484-Processor22] WARN org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: ERROR: operator does not exist: numeric = record | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0018412) rafaroda (developer) 2009-07-20 13:38 |
Please close it as duplicate of 0009962 if it is solved with its fix. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-01 15:28 | rafaroda | New Issue | |
| 2009-06-01 15:28 | rafaroda | Assigned To | => sathiyan |
| 2009-06-01 15:29 | rafaroda | Status | new => scheduled |
| 2009-06-01 15:29 | rafaroda | fix_in_branch | => pi |
| 2009-06-17 10:36 | rafaroda | Relationship added | related to 0009505 |
| 2009-07-20 13:30 | rafaroda | Relationship added | related to 0009962 |
| 2009-07-20 13:37 | rafaroda | Assigned To | sathiyan => iperdomo |
| 2009-07-20 13:38 | rafaroda | Note Added: 0018412 | |
| 2009-07-21 18:03 | iperdomo | Relationship replaced | duplicate of 0009962 |
| 2009-07-21 18:03 | iperdomo | Status | scheduled => closed |
| 2009-07-21 18:03 | iperdomo | Duplicate ID | 0 => 9962 |
| 2009-07-21 18:03 | iperdomo | Resolution | open => duplicate |
| 2009-07-22 00:00 | anonymous | sf_bug_id | 0 => 2825046 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |