Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012687Openbravo ERPA. Platformpublic2010-03-15 18:212011-09-28 12:44
pjuvara 
alostale 
urgentmajorhave not tried
closedfixed 
5
2.50MP13 
 
Core
No
0012687: Delete Client fails to delete a corrupted client
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.
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
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.
No tags attached.
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 00176413.0MP4 closed marvintm Openbravo ERP Delete Client process does not work (this issue also groups other tickets related to the Delete Client process) 
png Delete Client Error.png (97,168) 2010-03-15 18:21
https://issues.openbravo.com/file_download.php?file_id=2345&type=bug
png
Issue History
2010-03-15 18:21pjuvaraNew Issue
2010-03-15 18:21pjuvaraAssigned To => alostale
2010-03-15 18:21pjuvaraFile Added: Delete Client Error.png
2010-03-15 18:21pjuvaraSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=161#r161
2010-03-15 18:21pjuvaraProposed Solution updated
2010-03-15 18:22pjuvaraRelationship addedrelated to 0012607
2010-03-15 18:58iciordiaProposed Solution updated
2010-03-22 08:33alostaleStatusnew => scheduled
2010-03-22 08:33alostalefix_in_branch => pi
2011-06-14 16:36dmitry_mezentsevRelationship addedrelated to 0017641
2011-09-28 12:44marvintmNote Added: 0041341
2011-09-28 12:44marvintmStatusscheduled => resolved
2011-09-28 12:44marvintmFixed in SCM revision => a18a9f23fc35
2011-09-28 12:44marvintmResolutionopen => fixed
2011-09-28 12:44marvintmStatusresolved => closed

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