0000552: ReportBankJR_data.xsql fails to compile in pgsql

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0000552

Openbravo ERP

Z. Others

public

2008-06-05 08:10

2008-07-01 17:56

Reporter

jpabloae

Assigned To

cromero

Priority

immediate

Severity

critical

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Gentoo - 2.6.24

Product Version

Target Version

2.40

Fixed in Version

2.40alpha-r3

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

0000552: ReportBankJR_data.xsql fails to compile in pgsql

Description

[java] 10689 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_reports/ReportBankJR_data.xsql processed
     [java] 10706 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] SELECT C_BANK.NAME AS NAME, C_BANKSTATEMENT.NAME AS NAME2, C_BANKSTATEMENT.C_BANKACCOUNT_ID AS C_BANKACCOUNT_ID,
     [java] AD_COLUMN_IDENTIFIER('C_BANKACCOUNT',C_BANKACCOUNT.C_BANKACCOUNT_ID,'es_ES') AS bankaccount,
     [java] C_BANKSTATEMENTLINE.STMTAMT AS TRXAMT, C_DEBT_PAYMENT.AMOUNT AS PAYAMT, C_BANKSTATEMENT.C_BANKSTATEMENT_ID AS BANKSTATEMENT_ID,
     [java] C_BANKSTATEMENTLINE.DATEACCT AS STATEMENTDATE, C_BANKSTATEMENT.BEGINNINGBALANCE AS BEGINING, C_BANKSTATEMENT.ENDINGBALANCE AS ENDING,
     [java] C_CURRENCY.DESCRIPTION AS CURRENCY, C_BANKSTATEMENTLINE.LINE AS LINE, C_BANKSTATEMENTLINE.DESCRIPTION AS DESCRIPTION,
     [java] INITIALBALANCE.TOTAL_AMT AS INITIALBALANCE
     [java] FROM C_BANKSTATEMENTLINE left join C_DEBT_PAYMENT on C_BANKSTATEMENTLINE.C_DEBT_PAYMENT_ID = C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID,
     [java] C_BANK, C_BANKACCOUNT, C_BANKSTATEMENT, C_CURRENCY, (
     [java] SELECT SUM(TOTAL_AMT) AS TOTAL_AMT, C_BANKACCOUNT_ID FROM
     [java] (SELECT COALESCE(SUM(C_BANKSTATEMENTLINE.STMTAMT),0) AS TOTAL_AMT, C_BANKACCOUNT.C_BANKACCOUNT_ID
     [java] FROM C_BANK, C_BANKACCOUNT, C_BANKSTATEMENT, C_BANKSTATEMENTLINE
     [java] WHERE C_BANK.C_BANK_ID = C_BANKACCOUNT.C_BANK_ID
     [java] AND C_BANKACCOUNT.C_BANKACCOUNT_ID = C_BANKSTATEMENT.C_BANKACCOUNT_ID
     [java] AND C_BANKSTATEMENT.C_BANKSTATEMENT_ID = C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID
     [java] AND 3=3 AND C_BANK.AD_CLIENT_ID IN ('2')
     [java] AND 3=3 AND C_BANK.AD_ORG_ID IN ('2')
     [java] AND C_BANKSTATEMENTLINE.DATEACCT < TO_DATE(?)
     [java] AND C_BANKSTATEMENT.PROCESSED='Y'
     [java] GROUP BY C_BANKACCOUNT.C_BANKACCOUNT_ID
     [java] UNION ALL
     [java] SELECT 0 AS TOTAL_AMT, C_BANKACCOUNT_ID
     [java] FROM C_BANKACCOUNT)
     [java] GROUP BY C_BANKACCOUNT_ID
     [java] ) INITIALBALANCE
     [java] WHERE C_BANK.c_bank_id = C_BANKACCOUNT.C_BANK_ID
     [java] AND C_BANKACCOUNT.C_BANKACCOUNT_ID = C_BANKSTATEMENT.C_BANKACCOUNT_ID
     [java] AND C_BANKSTATEMENT.C_BANKSTATEMENT_ID = C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID
     [java] AND C_BANKACCOUNT.C_CURRENCY_ID = C_CURRENCY.C_CURRENCY_ID
     [java] AND C_BANKACCOUNT.C_BANKACCOUNT_ID = INITIALBALANCE.C_BANKACCOUNT_ID
     [java] AND 4=4 AND C_BANK.AD_CLIENT_ID IN ('1')
     [java] AND 4=4 AND C_BANK.AD_ORG_ID IN ('1')
     [java] AND 1=1
     [java] AND C_BANKSTATEMENT.PROCESSED='Y'
     [java] ORDER BY C_BANK.NAME, STATEMENTDATE, LINE
     [java] Exception:org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias
     [java] org.postgresql.util.PSQLException: ERROR: subquery in FROM must have an alias

Steps To Reproduce

1. Get the latest trunk (r4832 at this moment).
2. Run "ant install.source".

Proposed Solution

Additional Information