0005370: On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005370

Openbravo ERP

01. General setup

public

2008-10-01 19:58

2008-10-06 09:39

Reporter

plujan

Assigned To

cromero

Priority

immediate

Severity

critical

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

2.40

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

0005370: On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing

Description

I installed 2.40 with sample data. If I try to delete BigBazaar client (by executing a Delete Client process), after execution some FK constraints are missing and data with no valid FK is on affected tables.

Steps To Reproduce

1. Install OpenbravoERP 2.40 with sample data on a PostgreSQL computer.
2. Go to Pgadmin and check the ad_windowaccess table, ad_windowaccess_id_role FK constraint is present.
3. Enter as Openbravo (system administrator role)
4. Go General Setup > Client > Delete Client
5. Delete Account Test client and BigBazaar client
6. Go to Pgadmin and check the ad_windowaccess table, ad_windowaccess_id_role FK constraint is missing.

Proposed Solution

Additional Information