Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009358Openbravo ERPA. Platformpublic2009-06-06 10:452009-06-08 00:00
Reporterjpabloae 
Assigned Todalsasua 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS30OS VersionGentoo - 2.6.26
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009358: 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 ReproduceRun "ant install.source" on rev id ccb53a51e7ef.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0009359 closed dalsasua GeneralAccountingReports_data.xsql fails to compile 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-06 10:45jpabloaeNew Issue
2009-06-06 10:45jpabloaeAssigned To => rafaroda
2009-06-06 10:45jpabloaeOBNetwork customer => No
2009-06-06 10:45jpabloaeNote Added: 0017056
2009-06-06 10:56jpabloaefix_in_branch => 2.40
2009-06-06 10:56jpabloaeDescription Updated
2009-06-06 20:02psarobeNote Added: 0017057
2009-06-07 01:53dalsasuaStatusnew => scheduled
2009-06-07 01:53dalsasuaAssigned Torafaroda => dalsasua
2009-06-07 01:53dalsasuafix_in_branch2.40 => pi
2009-06-07 01:54dalsasuaStatusscheduled => closed
2009-06-07 01:54dalsasuaNote Added: 0017062
2009-06-07 01:54dalsasuaResolutionopen => no change required
2009-06-07 08:36jpabloaeNote Added: 0017064
2009-06-07 18:00dalsasuaNote Added: 0017065
2009-06-07 18:31jpabloaeNote Added: 0017066
2009-06-08 00:00anonymoussf_bug_id0 => 2802647

Notes
(0017056)
jpabloae   
2009-06-06 10:45   
Hudson build:
http://builds.openbravo.com/job/erp_stable_2.40-full-oracle/37/consoleText [^]
(0017057)
psarobe   
2009-06-06 20:02   
It doesn't compile either in the QA machines
(0017062)
dalsasua   
2009-06-07 01:54   
Only occurs in 2.40 branch
(0017064)
jpabloae   
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   
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   
2009-06-07 18:31   
OK, makes sense then. Thank you for the explanation.