Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009285
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2009-06-02 12:032009-06-11 00:00
ReporterpjuvaraView Statuspublic 
Assigned ToAinhoaPagola 
PrioritylowResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisiond7fc5e28a753
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP1SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009285: Poor error message when trying to delete current project phase

DescriptionWhen you try to delete a project phase from a multiphase project, you get an error if the phase that you are trying to delete is the current phase of the project. This is correct because the project has a foreign key to the phase.

However, the error that you receive is a nasty foreign key violation and it is not clear to the user:
      
ERROR: update or delete on table "c_projectphase" violates foreign key constraint "cprojectphase_cproject" on table "c_project" Detail: Key (c_projectphase_id)=(459C20F33A7340E88F1267800175CA14) is still referenced from table "c_project".
Steps To Reproduce1) Define a project type with at least one phase
2) Define a multiphase project
3) Set the project type to the one you defined in 1) and set the current phase
4) Navigate to Phases and try to delete the current phase
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0009363 closedAinhoaPagola Foreing key violated: Contraint not registeted in AD_Message 

-  Notes
(0017113)
hgbot (developer)
2009-06-08 18:33

 Repository: erp/devel/pi
Changeset: d7fc5e28a753e7da72573372c87c62c875e9dac1
Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com>
Date: Mon Jun 08 18:27:48 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d7fc5e28a753e7da72573372c87c62c875e9dac1 [^]

Fixes bug 9285 and 9363: Poor error messages on foreign key violations

---
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0017178)
sureshbabu (viewer)
2009-06-10 13:11

 Tested error message has been fine tuned to
" This record cannot be deleted because it is associated with other existing elements. Please see Linked Items
 "

- Issue History
Date Modified Username Field Change
2009-06-02 12:03 pjuvara New Issue
2009-06-02 12:03 pjuvara Assigned To => rafaroda
2009-06-02 12:03 pjuvara OBNetwork customer => No
2009-06-05 09:59 rafaroda Assigned To rafaroda => alostale
2009-06-05 09:59 rafaroda Priority normal => low
2009-06-05 09:59 rafaroda Status new => scheduled
2009-06-05 09:59 rafaroda Category 08. Project and service management => A. Platform
2009-06-08 10:13 AinhoaPagola Relationship added related to 0009363
2009-06-08 10:19 AinhoaPagola Assigned To alostale => AinhoaPagola
2009-06-08 18:33 hgbot Checkin
2009-06-08 18:33 hgbot Note Added: 0017113
2009-06-08 18:33 hgbot Status scheduled => resolved
2009-06-08 18:33 hgbot Resolution open => fixed
2009-06-08 18:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d7fc5e28a753e7da72573372c87c62c875e9dac1 [^]
2009-06-10 13:11 sureshbabu Status resolved => closed
2009-06-10 13:11 sureshbabu Note Added: 0017178
2009-06-10 13:11 sureshbabu Fixed in Version => pi
2009-06-11 00:00 anonymous sf_bug_id 0 => 2804447

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker