Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009358 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | critical | always | 2009-06-06 10:45 | 2009-06-08 00:00 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| 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 | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009358: 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 |
|
|
(0017056) jpabloae (reporter) 2009-06-06 10:45 |
Hudson build: http://builds.openbravo.com/job/erp_stable_2.40-full-oracle/37/consoleText [^] |
|
(0017057) psarobe (manager) 2009-06-06 20:02 |
It doesn't compile either in the QA machines |
|
(0017062) dalsasua (reporter) 2009-06-07 01:54 |
Only occurs in 2.40 branch |
|
(0017064) jpabloae (reporter) 2009-06-07 08:36 |
I don't understand. This bug was reported against 2.40 only, not pi. Why was it closed as "no change required" if a commit was done? |
|
(0017065) dalsasua (reporter) 2009-06-07 18:00 |
When scheduling it, it seems turned to fix_in_branch pi. I created a backport (0009359) of it on 2.40, and solved that. Regards. |
|
(0017066) jpabloae (reporter) 2009-06-07 18:31 |
OK, makes sense then. Thank you for the explanation. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-06 10:45 | jpabloae | New Issue | |
| 2009-06-06 10:45 | jpabloae | Assigned To | => rafaroda |
| 2009-06-06 10:45 | jpabloae | Note Added: 0017056 | |
| 2009-06-06 10:56 | jpabloae | fix_in_branch | => 2.40 |
| 2009-06-06 10:56 | jpabloae | Description Updated | |
| 2009-06-06 20:02 | psarobe | Note Added: 0017057 | |
| 2009-06-07 01:53 | dalsasua | Status | new => scheduled |
| 2009-06-07 01:53 | dalsasua | Assigned To | rafaroda => dalsasua |
| 2009-06-07 01:53 | dalsasua | fix_in_branch | 2.40 => pi |
| 2009-06-07 01:54 | dalsasua | Status | scheduled => closed |
| 2009-06-07 01:54 | dalsasua | Note Added: 0017062 | |
| 2009-06-07 01:54 | dalsasua | Resolution | open => no change required |
| 2009-06-07 08:36 | jpabloae | Note Added: 0017064 | |
| 2009-06-07 18:00 | dalsasua | Note Added: 0017065 | |
| 2009-06-07 18:31 | jpabloae | Note Added: 0017066 | |
| 2009-06-08 00:00 | anonymous | sf_bug_id | 0 => 2802647 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |