0003748: Error: AccessTableNoView in two reports in Sale

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0003748

Openbravo ERP

C. Security

public

2008-06-05 16:38

2008-06-25 17:53

Reporter

cromero

Assigned To

cromero

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.35MP6

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

0003748: Error: AccessTableNoView in two reports in Sale

Description

Related to bug:
0002987

Description:
Sales Dimensional Report and Invoice (customer) Dimensional Report seem to
not have permission to be showed independently if the user has or not
permission.
It only happens in Postgre

Environment:
FF2
2.35 MP4
Postgre 8.2

Steps:
1.Log in as Big Bazaar Admin
2.Go to Sales Management > Analysis tools > Sales Dimensional Report.
Error: AccessTableNoView message appears.

This problem is due to the different interpretation of a Boolean that drivers do.
For Oracle, if the value returned is different of 0, then it is true.
For PostgreSQL, if the value returned is different of 1, then it is false.

In this case, the problem is that the report has more than 1 permission,
so the returned 2 is interpreted as a FALSE in PostgreSQL and TRUE in Oracle.

The solution will be to modify the sqlc method when returning a boolean to return always a boolean and not a number.

Steps To Reproduce

Proposed Solution

Additional Information