Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0005371

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

backport

[Openbravo ERP] 01. General setup

critical

have not tried

2008-10-01 19:58

2009-01-29 19:54

Reporter

plujan

View Status

public

Assigned To

cromero

Priority

immediate

Resolution

fixed

Fixed in Version

2.40MP2

Status

closed

Fix in branch

2.40

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Windows

Database

PostgreSQL

Java version

OS Version

Database version

8.3.3

Ant version

Product Version

2.40

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0005371: 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.

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

closed

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

Notes
(0009426) svnbot (reporter) 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 (reporter) 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 [^]

Issue History
Date Modified	Username	Field	Change
2008-10-01 19:58	cromero	New Issue
2008-10-01 19:58	cromero	Assigned To	=> cromero
2008-10-01 19:58	cromero	Status	new => scheduled
2008-10-07 23:42	svnbot	Checkin
2008-10-07 23:42	svnbot	Note Added: 0009426
2008-10-07 23:42	svnbot	Status	scheduled => resolved
2008-10-07 23:42	svnbot	Resolution	open => fixed
2008-10-07 23:42	svnbot	svn_revision	=> 8341
2008-10-08 09:23	svnbot	Checkin
2008-10-08 09:23	svnbot	Note Added: 0009431
2008-10-08 09:23	svnbot	svn_revision	8341 => 8346
2009-01-29 19:54	psarobe	Regression testing	=> No
2009-01-29 19:54	psarobe	Status	resolved => closed

Copyright © 2000 - 2009 MantisBT Group