Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005371Openbravo ERP01. General setuppublic2008-10-01 19:582009-01-29 19:54
Reporterplujan 
Assigned Tocromero 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP2 
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
Summary0005371: 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
blocks defect 0005368 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:58cromeroNew Issue
2008-10-01 19:58cromeroAssigned To => cromero
2008-10-01 19:58cromeroStatusnew => scheduled
2008-10-07 23:42svnbotCheckin
2008-10-07 23:42svnbotNote Added: 0009426
2008-10-07 23:42svnbotStatusscheduled => resolved
2008-10-07 23:42svnbotResolutionopen => fixed
2008-10-07 23:42svnbotsvn_revision => 8341
2008-10-08 09:23svnbotCheckin
2008-10-08 09:23svnbotNote Added: 0009431
2008-10-08 09:23svnbotsvn_revision8341 => 8346
2009-01-29 19:54psarobeRegression testing => No
2009-01-29 19:54psarobeStatusresolved => closed

Notes
(0009426)
svnbot   
2008-10-07 23:42   
Repository: openbravo
Revision: 8341
Author: cromeroherrero
Date: 2008-10-07 23:41:57 +0200 (Tue, 07 Oct 2008)

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

---
U branches/r2.40/src-db/database/model/postscript-PostgreSql.sql
---

https://dev.openbravo.com/websvn/openbravo/?rev=8341&sc=1 [^]
(0009431)
svnbot   
2008-10-08 09:23   
Repository: openbravo
Revision: 8346
Author: villind
Date: 2008-10-08 09:23:28 +0200 (Wed, 08 Oct 2008)

Merged change 8341. Fixed bug 5371: On PostgreSQL, when deleting BigBazaar client using the Delete Client process, some contraints are missing

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-db/database/model/postscript-PostgreSql.sql
_U branches/bonware/r2.40/update.database.launch
---

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