0007916: Error message when trying to generate an Excel Budget Report

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007916

Openbravo ERP

09. Financial management

public

2009-02-23 13:07

2023-09-07 17:00

Reporter

plujan

Assigned To

vmromanos

Priority

high

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.40MP4

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

0007916: Error message when trying to generate an Excel Budget Report

Description

I 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 Reproduce

1. 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