0005066: 'Purchase Order Report' does not work in PostgreSQL

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005066

Openbravo ERP

03. Procurement management

public

2008-09-16 13:53

2008-12-09 11:46

Reporter

rafaroda

Assigned To

cromero

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 7.10

Product Version

Target Version

Fixed in Version

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

0005066: 'Purchase Order Report' does not work in PostgreSQL

Description

'Purchase Order Report' does not work in PostgreSQL if you select any of the filters that points to an ID. In Oracle it works. Take into account that this filter window is WAD generated.

This is a regression since in Openbravo ERP 2.40 production it worked both in PostgreSQL and Oracle.

Steps To Reproduce

1) Go to 'Procurement Management || Analysis Tools || Purchase Order Report', do not select any filter and click on 'OK' button.
Report works correctly.

2) Launch the same report selecting any of the filters that points to an ID (e.g., Business Partner or Project).
Report breaks with error: ERROR org.openbravo.erpCommon.utility.PrintJR - Error captured: javax.servlet.ServletException: Error executing SQL statement for : ReportPurchaseOrder

Take into account that this filter window is WAD generated.

Proposed Solution

Additional Information