0012687: Delete Client fails to delete a corrupted client

Description

As a result of issue 12607, users can end up with partially created clients.

The natural next step would be to delete the client. However, Delete Client fails leaving the database in a corrupted state, with all triggers and constraints disabled.

See screenshot.

Steps To Reproduce

1) On a MP13 instance, install the version of the Spanish Professional Localization Pack as of March 9, 2010. This includes the following modules:
Tax Report Launcher - 1.0.0 - English (USA)
    Electronic Invoice - 0.1.4 - English (USA)
    Professional Localization pack Spain (España) - 1.2.2 - English (USA)
        Modelo 349 - 1.0.3 - Spanish (Spain)
        Localization pack Spain (España) - 1.4.2 - Spanish (Spain)
            Validador de número de cuenta bancaria - 1.0.0 - Spanish (Spain)
            Provincias de España - 1.0.4 - Spanish (Spain)
            CIF and NIF validator - 1.0.0 - English (USA)
            European Union countries - 1.0.1 - English (USA)
            Chart of accounts: PGC 2007 General - 1.0.1 - Spanish (Spain)
            Translation: Spanish-Spain (es_ES) español-España - 1.0.9 - Spanish (Spain)
            Chart of accounts: PGC 2007 PYMEs - 1.0.1 - Spanish (Spain)
            Alerts: Accounting - 1.0.2 - Spanish (Spain)
            Módulo de Impuestos para España mejorado - 0.0.5 - Spanish (Spain)
            Spanish Tax Module Improvements - 0.0.9 - English (USA)
            Taxes: configuration for Spain (Impuestos para España) - 1.2.5 - Spanish (Spain)
            Validador de CIF y NIF - 1.0.0 - Spanish (Spain)
            3 digits ISO country codes - 1.0.2 - English (USA)
            Invoices Register Book - 1.1.3 - English (USA)
        Condiciones de pago - 1.0.3 - Spanish (Spain)
        Facturación Electrónica - Facturae 3.1 - 0.2.2 - Spanish (Spain)
        Camerfactura - 0.1.3 - English (USA)
        Spain AEAT Modelo 347 - 1.1.3 - English (USA)
        Libro de Facturas - 1.1.0 - Spanish (Spain)
        Formas de pago - 1.0.2 - Spanish (Spain)
        Spain AEAT Modelo 347 - Spanish Translation - 1.1.1 - Spanish (Spain)

2) In particular, please make sure that you have the two very specific following module versions installed:
    Spanish Tax Module Improvements - 0.0.9 - English (USA)
    Taxes: configuration for Spain (Impuestos para España) - 1.2.5 - Spanish (Spain)

3) Create a client using Initial Client Setup. It will fail due to issue 12607.

4) Run Delete Client

Proposed Solution

Additionally to prevent the error to happen, modify the process description so it is explicitally recommended to back-up your instance before you perform this faulty process.

Tags

No tags attached.

Attached Files

Delete Client Error.png [^] (97,168 bytes) 2010-03-15 18:21

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0012607		closed	vmromanos	Localization Pack: Spain	error to apply reference data "Taxes: configuration for Spain (Impuestos para España) - 1.2.5 - Spanish (Spain)
related to	defect	0017641	3.0MP4	closed	marvintm	Openbravo ERP	Delete Client process does not work (this issue also groups other tickets related to the Delete Client process)

Notes
(0041341) marvintm (developer) 2011-09-28 12:44	Fixed by the recent delete client refactor.

Issue History
Date Modified	Username	Field	Change
2010-03-15 18:21	pjuvara	New Issue
2010-03-15 18:21	pjuvara	Assigned To	=> alostale
2010-03-15 18:21	pjuvara	File Added: Delete Client Error.png
2010-03-15 18:21	pjuvara	Steps to Reproduce Updated	View Revisions
2010-03-15 18:21	pjuvara	Proposed Solution updated
2010-03-15 18:22	pjuvara	Relationship added	related to 0012607
2010-03-15 18:58	iciordia	Proposed Solution updated
2010-03-22 08:33	alostale	Status	new => scheduled
2010-03-22 08:33	alostale	fix_in_branch	=> pi
2011-06-14 16:36	dmitry_mezentsev	Relationship added	related to 0017641
2011-09-28 12:44	marvintm	Note Added: 0041341
2011-09-28 12:44	marvintm	Status	scheduled => resolved
2011-09-28 12:44	marvintm	Fixed in SCM revision	=> a18a9f23fc35
2011-09-28 12:44	marvintm	Resolution	open => fixed
2011-09-28 12:44	marvintm	Status	resolved => closed