0012687: Delete Client fails to delete a corrupted client

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0012687

Openbravo ERP

A. Platform

public

2010-03-15 18:21

2011-09-28 12:44

Reporter

pjuvara

Assigned To

alostale

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.50MP13

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

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.

Additional Information

Tags

No tags attached.

Relationships

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)