Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007916 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | have not tried | 2009-02-23 13:07 | 2023-09-07 17:00 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.40MP4 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | c341d9fa61cd | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | 13478 | |||||
| Merge Request Status | open | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| 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) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0014694) vmromanos (viewer) 2009-03-16 15:27 |
It seems that this bug is only reproducible in PostgreSQL |
|
(0015104) hgbot (developer) 2009-04-01 11:05 |
Repository: erp/stable/2.40 Changeset: c341d9fa61cdc12b0e4999ca6fd020d37dcf0d42 Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Wed Apr 01 11:04:13 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/c341d9fa61cdc12b0e4999ca6fd020d37dcf0d42 [^] Fixed bug 7916: 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 --- |
|
(0016255) arunkumar (viewer) 2009-05-11 11:43 |
This issue has been fixed |
|
(0154595) hgbot (developer) 2023-09-07 15:57 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.returns/-/merge_requests/70 [^] |
|
(0154598) hgbot (developer) 2023-09-07 17:00 |
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.returns/-/merge_requests/70 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-03-03 13:02 | rafaroda | Type | defect => backport |
| 2009-03-03 13:02 | rafaroda | fix_in_branch | => 2.40 |
| 2009-03-16 15:27 | vmromanos | Note Added: 0014694 | |
| 2009-04-01 11:05 | hgbot | Checkin | |
| 2009-04-01 11:05 | hgbot | Note Added: 0015104 | |
| 2009-04-01 11:05 | hgbot | Status | scheduled => resolved |
| 2009-04-01 11:05 | hgbot | Resolution | open => fixed |
| 2009-04-01 11:05 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/c341d9fa61cdc12b0e4999ca6fd020d37dcf0d42 [^] |
| 2009-05-10 19:37 | psarobe | Fixed in Version | => 2.40MP4 |
| 2009-05-11 11:43 | arunkumar | Status | resolved => closed |
| 2009-05-11 11:43 | arunkumar | Note Added: 0016255 | |
| 2023-09-07 15:57 | hgbot | Merge Request Status | => open |
| 2023-09-07 15:57 | hgbot | Note Added: 0154595 | |
| 2023-09-07 17:00 | hgbot | Note Added: 0154598 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |