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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009285

Openbravo ERP

A. Platform

public

2009-06-02 12:03

2009-06-11 00:00

Reporter

pjuvara

Assigned To

AinhoaPagola

Priority

low

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

rPath Linux

Product Version

2.50MP1

Target Version

Fixed in Version

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

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

Description

When 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 Reproduce

1) 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

Proposed Solution

Additional Information