Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005368Openbravo ERP01. General setuppublic2008-10-01 19:172008-12-16 12:04
Reporterplujan 
Assigned Tocromero 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005368: On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing
DescriptionI 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 Reproduce1. 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
TagsNo tags attached.
Relationships
depends on backport 0005370 closed cromero On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing 
depends on backport 0005371 closed cromero On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-01 19:17plujanNew Issue
2008-10-01 19:17plujanAssigned To => cromero
2008-10-01 19:17plujansf_bug_id0 => 2140731
2008-10-01 19:17plujanRegression testing => No
2008-10-01 19:58cromeroStatusnew => scheduled
2008-10-01 19:58cromerofix_in_branch => trunk
2008-10-07 23:43svnbotCheckin
2008-10-07 23:43svnbotNote Added: 0009427
2008-10-07 23:43svnbotStatusscheduled => resolved
2008-10-07 23:43svnbotResolutionopen => fixed
2008-10-07 23:43svnbotsvn_revision => 8342
2008-12-16 12:04psarobeStatusresolved => closed

Notes
(0009427)
svnbot   
2008-10-07 23:43   
Repository: openbravo
Revision: 8342
Author: cromeroherrero
Date: 2008-10-07 23:43:08 +0200 (Tue, 07 Oct 2008)

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

---
U trunk/src-db/database/model/postscript-PostgreSql.sql
---

https://dev.openbravo.com/websvn/openbravo/?rev=8342&sc=1 [^]