Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007757Openbravo ERP09. Financial managementpublic2009-02-23 13:072009-04-25 00:00
Reporterplujan 
Assigned Tovmromanos 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007757: Error message when trying to generate an Excel Budget Report
DescriptionI generate a Budget Report in Excel. The message shown is not correct since I can not realize reading it what happened. The problem was that I used too many filters.
Steps To Reproduce1. Go Financial Management > Accounting > Transactions > Create Budget in Excel
2. Choose all the filters including all the options
3. Click on Generate Excel button
4. A new window is opened. Button has a back button (that is wrong) and the text is "Error:ERROR: subquery in FROM must have an alias". See attach.

13:00:45 [ajp-8009-2] ERROR org.openbravo.erpCommon.ad_reports.ReportBudgetGenerateExcelData - SQL error in query: SELECT ' ' AS PARTNER, PARTNERGROUP, ' ' AS PRODUCT, PRODCATEGORY, SALESREGION, ' ' AS CAMPAIGN, ' ' AS ACTIVITY, PROJECT, TRXORG, MONTH, VALIDCOMBINATION, ACCOUNTSCHEMA, CURRENCY , 0 AS QTY, 0 AS PRICE, ' ' AS AMOUNT, '' AS NAME, '' AS ID, '' AS DESCRIPTION, '' AS ACTUAL, ' ' AS PADRE, '' AS EXPORTACTUAL FROM DUAL, (SELECT AD_COLUMN_IDENTIFIER('C_BP_GROUP', TO_CHAR(C_BP_GROUP_ID), 'en_US') AS PARTNERGROUP FROM C_BP_GROUP WHERE C_BP_GROUP_ID IN('1000000')), (SELECT AD_COLUMN_IDENTIFIER('M_PRODUCT_CATEGORY', TO_CHAR(M_PRODUCT_CATEGORY_ID), 'en_US') AS PRODCATEGORY FROM M_PRODUCT_CATEGORY WHERE M_PRODUCT_CATEGORY_ID IN('1000002')), (SELECT AD_COLUMN_IDENTIFIER('C_SALESREGION', TO_CHAR(C_SALESREGION_ID), 'en_US') AS SALESREGION FROM C_SALESREGION WHERE C_SALESREGION_ID IN('1000000')), (SELECT AD_COLUMN_IDENTIFIER('C_PROJECT', TO_CHAR(C_PROJECT_ID), 'en_US') AS PROJECT FROM C_PROJECT WHERE C_PROJECT_ID IN('1000006')), (SELECT AD_COLUMN_IDENTIFIER('AD_ORG', TO_CHAR(AD_ORG_ID), 'en_US') AS TRXORG FROM AD_ORG WHERE AD_ORG_ID IN('1000003')), (SELECT AD_COLUMN_IDENTIFIER('AD_MONTH', TO_CHAR(AD_MONTH_ID), 'en_US') AS MONTH FROM AD_MONTH WHERE AD_MONTH_ID IN('102')), (SELECT AD_COLUMN_IDENTIFIER('C_ELEMENTVALUE', TO_CHAR(C_ELEMENTVALUE_ID), 'en_US' ) AS VALIDCOMBINATION FROM C_ELEMENTVALUE WHERE C_ELEMENTVALUE_ID = 1000808), (SELECT AD_COLUMN_IDENTIFIER('C_ACCTSCHEMA', TO_CHAR(C_ACCTSCHEMA_ID), 'en_US' ) AS ACCOUNTSCHEMA, ISO_CODE AS CURRENCY FROM C_ACCTSCHEMA, C_CURRENCY WHERE C_ACCTSCHEMA.C_CURRENCY_ID=C_CURRENCY.C_CURRENCY_ID AND C_ACCTSCHEMA_ID = 1000000)Exception:org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias
13:00:45 [ajp-8009-2] ERROR org.openbravo.erpCommon.ad_reports.ReportBudgetGenerateExcel - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: subquery in FROM must have an alias
javax.servlet.ServletException: @CODE=0@ERROR: subquery in FROM must have an alias
    at org.openbravo.erpCommon.ad_reports.ReportBudgetGenerateExcelData.select(Unknown Source)
    at org.openbravo.erpCommon.ad_reports.ReportBudgetGenerateExcelData.select(Unknown Source)
    at org.openbravo.erpCommon.ad_reports.ReportBudgetGenerateExcel.printPageDataExcel(Unknown Source)
    at org.openbravo.erpCommon.ad_reports.ReportBudgetGenerateExcel.doPost(Unknown Source)
    at javax.servlet.http.HttpServlet.service(Unknown Source)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(Unknown Source)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(Unknown Source)
    at javax.servlet.http.HttpServlet.service(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.openbravo.utils.CharsetFilter.doFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
    at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
    at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
    at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProcessor.process(Unknown Source)
    at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(Unknown Source)
    at org.apache.tomcat.util.net.AprEndpoint$Worker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:619)

Proposed Solution
Additional Information
Tagsmain
Relationships
depends on backport 0007916 closed vmromanos Error message when trying to generate an Excel Budget Report 
blocks defect 0007755 closed vmromanos Error message when generating an Excel Budget Report with no data is not correct 
Attached Filespng BUG_250_trunk_CreateBudgetReportMessage2.PNG (20,792) 2009-02-23 13:07
https://issues.openbravo.com/file_download.php?file_id=910&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-02-23 13:07plujanNew Issue
2009-02-23 13:07plujanAssigned To => rafaroda
2009-02-23 13:07plujanFile Added: BUG_250_trunk_CreateBudgetReportMessage2.PNG
2009-02-23 13:07plujanOBNetwork customer => No
2009-02-23 13:07plujanRegression testing => No
2009-02-23 13:07plujanIssue generated from0007755
2009-02-23 13:07plujanRelationship addedrelated to 0007755
2009-03-03 12:59rafarodaRelationship replacedblocks 0007755
2009-03-03 13:02rafarodaNote Added: 0014298
2009-03-03 13:02rafarodaAssigned Torafaroda => vmromanos
2009-03-03 13:02rafarodaPrioritylow => high
2009-03-03 13:02rafarodaProposed Solution updated
2009-03-03 13:02rafarodaStatusnew => scheduled
2009-03-03 13:02rafarodafix_in_branch => trunk
2009-03-31 16:55hgbotCheckin
2009-03-31 16:55hgbotNote Added: 0015089
2009-03-31 16:55hgbotStatusscheduled => resolved
2009-03-31 16:55hgbotResolutionopen => fixed
2009-03-31 16:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/681a35637771f53c71114df6313af492e5dcc87a [^]
2009-04-22 11:24psarobeTag Attached: main
2009-04-24 13:13sureshbabuStatusresolved => closed
2009-04-24 13:13sureshbabuNote Added: 0015691
2009-04-24 13:13sureshbabuFixed in Version => main
2009-04-25 00:00anonymoussf_bug_id0 => 2780795

Notes
(0014298)
rafaroda   
2009-03-03 13:02   
This only fails in PostgreSQL.
(0015089)
hgbot   
2009-03-31 16:55   
Repository: erp/devel/pi
Changeset: 681a35637771f53c71114df6313af492e5dcc87a
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Mar 31 16:53:15 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/681a35637771f53c71114df6313af492e5dcc87a [^]

Fixed bug 7757: Error message when trying to generate an Excel Budget Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.html
M src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.java
---
(0015691)
sureshbabu   
2009-04-24 13:13   
Tested working fine