0009266: Can not print multiple proposals inside Service Projects

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009266

Openbravo ERP

08. Project and service management

public

2009-06-01 15:28

2015-02-12 14:13

Reporter

rafaroda

Assigned To

sathiyan

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

out of date

Platform

OS Version

rPath Linux

Product Version

2.40

Target Version

Fixed in Version

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

Summary

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

Proposed Solution

Additional Information