Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009359 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] A. Platform | critical | always | 2009-06-06 10:45 | 2009-06-08 09:20 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.40MP5 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 98326538f3c4 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | 1.6.0_11 | |||
| OS Version | Gentoo - 2.6.26 | Database version | 10.2.0.4 | Ant version | 1.7.0 | |||
| Product Version | 2.40 | SCM revision | ccb53a51e7ef | |||||
| 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 | 0009359: GeneralAccountingReports_data.xsql fails to compile | |||||||
| Description | [java] 18952 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql processed [java] 19055 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] SELECT A_O.AD_ORG_ID AS ID, A_O.NAME, '' as pagebreak, '' AS PADRE, '' AS START, '' AS END, '' AS PREVIOUS_YEAR, '' AS PREVIOUS_YEAR_ID [java] FROM AD_ORG A_O, AD_ROLE_ORGACCESS A_R_O, AD_ROLE R [java] WHERE A_R_O.AD_ORG_ID = A_O.AD_ORG_ID [java] AND A_R_O.ISACTIVE = 'Y' [java] AND A_R_O.AD_ROLE_ID = R.AD_ROLE_ID [java] AND R.ISACTIVE = 'Y' [java] AND A_R_O.AD_ROLE_ID = TO_NUMBER(?) [java] ORDER BY A_O.NAME [java] Exception:java.sql.SQLException: ORA-00923: FROM keyword not found where expected | |||||||
| Steps To Reproduce | Run "ant install.source" on rev id ccb53a51e7ef. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0017063) hgbot (developer) 2009-06-07 02:01 |
Repository: erp/stable/2.40 Changeset: 98326538f3c4f6f7e4f1bedfe0abf34e56712585 Author: David Alsasua <david.alsasua <at> openbravo.com> Date: Sun Jun 07 01:59:49 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/98326538f3c4f6f7e4f1bedfe0abf34e56712585 [^] Allow general accounting reports to calculate on the fly opening balance working with Oracle as well. Fixes Issue 9359: GeneralAccountingReports_data.xsql fails to compile --- M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql --- |
|
(0017070) psarobe (viewer) 2009-06-08 09:05 |
This night it compiled without any problems |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-07 01:53 | dalsasua | Type | defect => backport |
| 2009-06-07 02:01 | hgbot | Checkin | |
| 2009-06-07 02:01 | hgbot | Note Added: 0017063 | |
| 2009-06-07 02:01 | hgbot | Status | scheduled => resolved |
| 2009-06-07 02:01 | hgbot | Resolution | open => fixed |
| 2009-06-07 02:01 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/98326538f3c4f6f7e4f1bedfe0abf34e56712585 [^] |
| 2009-06-08 09:04 | psarobe | Status | resolved => closed |
| 2009-06-08 09:04 | psarobe | Fixed in Version | => 2.40MP5 |
| 2009-06-08 09:05 | psarobe | Note Added: 0017070 | |
| 2009-06-08 09:20 | rafaroda | Assigned To | rafaroda => dalsasua |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |