0009359: GeneralAccountingReports_data.xsql fails to compile

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009359

Openbravo ERP

A. Platform

public

2009-06-06 10:45

2009-06-08 09:20

Reporter

jpabloae

Assigned To

dalsasua

Priority

immediate

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Gentoo - 2.6.26

Product Version

2.40

Target Version

Fixed in Version

2.40MP5

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

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.

Proposed Solution

Additional Information