0006251: Navigation changes broke some windows in Grid mode

Description

Accessing Conversion Rates window you get an error:

12:44:16 [http-8880-Processor25] ERROR org.openbravo.erpCommon.utility.ExecuteQuery - SQL error in query: SELECT C_Conversion_Rate_ID
FROM (SELECT ROWNUM AS rn1, A.* FROM (
SELECT C_Conversion_Rate.C_Conversion_Rate_ID
FROM C_Conversion_Rate
left join (select IsActive, ad_ref_list_id, ad_reference_id, value, name from ad_ref_list) td2 on C_Conversion_Rate.ConversionRateType = td2.value AND td2.ad_reference_id = ?
left join (SELECT ad_language, name, ad_ref_list_id from ad_ref_list_trl) td_trl2 on td2.ad_ref_list_id = td_trl2.ad_ref_list_id AND td_trl2.ad_language = ?
left join (SELECT C_Currency_ID, ISO_Code FROM C_Currency) td1 on C_Conversion_Rate.C_Currency_ID_To = td1.C_Currency_ID
left join (SELECT C_Currency_ID, ISO_Code FROM C_Currency) td0 on C_Conversion_Rate.C_Currency_ID = td0.C_Currency_ID
WHERE C_Conversion_Rate.AD_Client_ID IN (0,1000003)
AND C_Conversion_Rate.AD_Org_ID IN (0,1000011)
ORDER BY TO_DATE(C_Conversion_Rate.ValidFrom) ASC, ((CASE td2.isActive WHEN 'N' THEN '**' ELSE '' END) || (CASE WHEN td_trl2.name IS NULL THEN td2.name ELSE td_trl2.name END)) ASC, COALESCE(TO_CHAR(td1.ISO_Code), '') ASC, COALESCE(TO_CHAR(td0.ISO_Code), '') ASC, TO_DATE(C_Conversion_Rate.ValidFrom) ASC, ((CASE td2.isActive WHEN 'N' THEN '**' ELSE '' END) || (CASE WHEN td_trl2.name IS NULL THEN td2.name ELSE td_trl2.name END)) ASC, COALESCE(TO_CHAR(td1.ISO_Code), '') ASC, COALESCE(TO_CHAR(td0.ISO_Code), '') ASC, C_Conversion_Rate.C_Conversion_Rate_ID)
A)
  WHERE rn1 BETWEEN ? AND ?Exception:java.sql.SQLException: Missing IN or OUT parameter at index:: 3
javax.servlet.ServletException: @CODE=17041@Missing IN or OUT parameter at index:: 3
    at org.openbravo.erpCommon.utility.ExecuteQuery.selectAndSearch(ExecuteQuery.java:222)
    at org.openbravo.erpWindows.ConversionRates.ConversionRate.firstElement(ConversionRate.java:478)
    at org.openbravo.erpWindows.ConversionRates.ConversionRate.doPost(ConversionRate.java:55)
    at org.openbravo.base.HttpBaseServlet.doGet(HttpBaseServlet.java:188)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    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:803)
    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.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.valves.AccessLogValve.invoke(AccessLogValve.java:544)
    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)

Steps To Reproduce

With an application built from r2.40performance branch (rev.10730) access Conversion Rates window

Issue History
Date Modified	Username	Field	Change
2008-11-28 12:51	iperdomo	New Issue
2008-11-28 12:51	iperdomo	Assigned To	=> shuehner
2008-11-28 12:51	iperdomo	sf_bug_id	0 => 2355530
2008-11-28 12:51	iperdomo	Regression testing	=> No
2008-11-28 12:52	iperdomo	Status	new => scheduled
2008-11-28 12:52	iperdomo	fix_in_branch	=> trunk
2008-11-28 14:22	svnbot	Checkin
2008-11-28 14:22	svnbot	Note Added: 0010815
2008-11-28 14:22	svnbot	Status	scheduled => resolved
2008-11-28 14:22	svnbot	Resolution	open => fixed
2008-11-28 14:22	svnbot	svn_revision	=> 10738
2008-12-18 12:29	krishna	Status	resolved => closed

Notes
(0010815) svnbot (reporter) 2008-11-28 14:22	Repository: openbravo Revision: 10738 Author: huehner Date: 2008-11-28 14:22:57 +0100 (Fri, 28 Nov 2008) Fixed 6251 Re-add some backed-out parameters again needed for the optional inner joins of the navigation queries (fixes bug introduced in r10650) --- U trunk/src/org/openbravo/erpCommon/utility/TableSQLData.java --- https://dev.openbravo.com/websvn/openbravo/?rev=10738&sc=1 [^]