Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0003748 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] C. Security | minor | always | 2008-06-05 16:38 | 2008-06-25 17:53 | |||
| Reporter | cromero | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.35MP6 | |||
| Status | closed | Fix in branch | 2.3x | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0004187) cromero (viewer) 2008-06-05 16:44 edited on: 2008-06-12 09:27 |
Logged In: YES user_id=1500614 Originator: YES Fixed in the 2.3x branch in revision 4850 |
|
(0007337) user71 2005-06-01 00:00 edited on: 2008-06-12 09:44 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1985519 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-06-24 13:49 | cromero | Target Version | => 2.35 |
| 2008-06-24 13:50 | cromero | Fixed in Version | 2.35 => 2.35MP6 |
| 2008-06-25 17:53 | plujan | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |