0006251: Navigation changes broke some windows in Grid mode

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0006251

Openbravo ERP

A. Platform

public

2008-11-28 12:51

2008-12-18 12:29

Reporter

iperdomo

Assigned To

shuehner

Priority

high

Severity

major

Reproducibility

sometimes

Status

closed

Resolution

fixed

Platform

OS Version

2.6.23-gentoo-r9

Product Version

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

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

Proposed Solution

Additional Information