0009266: 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

Issue History
Date Modified	Username	Field	Change
2009-06-01 15:29	rafaroda	Type	defect => backport
2009-06-01 15:29	rafaroda	fix_in_branch	=> 2.40
2015-02-12 14:13	plujan	Note Added: 0074394
2015-02-12 14:13	plujan	Status	scheduled => closed
2015-02-12 14:13	plujan	Resolution	open => out of date

Notes
(0074394) plujan (manager) 2015-02-12 14:13	Backports to 2.40 branch are no longer supported