Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007757 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | have not tried | 2009-02-23 13:07 | 2009-04-25 00:00 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 681a35637771 | |||
| 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 | ||||||||
| 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 | 0007757: 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 | main | |||||||
| Attached Files |  BUG_250_trunk_CreateBudgetReportMessage2.PNG [^] (20,792 bytes) 2009-02-23 13:07
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0014298) rafaroda (viewer) 2009-03-03 13:02 |
This only fails in PostgreSQL. |
|
(0015089) hgbot (developer) 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 (viewer) 2009-04-24 13:13 |
Tested working fine |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-02-23 13:07 | plujan | New Issue | |
| 2009-02-23 13:07 | plujan | Assigned To | => rafaroda |
| 2009-02-23 13:07 | plujan | File Added: BUG_250_trunk_CreateBudgetReportMessage2.PNG | |
| 2009-02-23 13:07 | plujan | OBNetwork customer | => No |
| 2009-02-23 13:07 | plujan | Regression testing | => No |
| 2009-02-23 13:07 | plujan | Issue generated from | 0007755 |
| 2009-02-23 13:07 | plujan | Relationship added | related to 0007755 |
| 2009-03-03 12:59 | rafaroda | Relationship replaced | blocks 0007755 |
| 2009-03-03 13:02 | rafaroda | Note Added: 0014298 | |
| 2009-03-03 13:02 | rafaroda | Assigned To | rafaroda => vmromanos |
| 2009-03-03 13:02 | rafaroda | Priority | low => high |
| 2009-03-03 13:02 | rafaroda | Proposed Solution updated | |
| 2009-03-03 13:02 | rafaroda | Status | new => scheduled |
| 2009-03-03 13:02 | rafaroda | fix_in_branch | => trunk |
| 2009-03-31 16:55 | hgbot | Checkin | |
| 2009-03-31 16:55 | hgbot | Note Added: 0015089 | |
| 2009-03-31 16:55 | hgbot | Status | scheduled => resolved |
| 2009-03-31 16:55 | hgbot | Resolution | open => fixed |
| 2009-03-31 16:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/681a35637771f53c71114df6313af492e5dcc87a [^] |
| 2009-04-22 11:24 | psarobe | Tag Attached: main | |
| 2009-04-24 13:13 | sureshbabu | Status | resolved => closed |
| 2009-04-24 13:13 | sureshbabu | Note Added: 0015691 | |
| 2009-04-24 13:13 | sureshbabu | Fixed in Version | => main |
| 2009-04-25 00:00 | anonymous | sf_bug_id | 0 => 2780795 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |