Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020575Openbravo ERPJ. Demo datapublic2012-05-22 09:412012-05-31 21:38
Reportervmromanos 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionDebian 5.0
Product Versionpi 
Target VersionFixed in Version3.0MP12 
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
Summary0020575: It's impossible to apply Spanish Taxes Module in an instance with sampledata
DescriptionSome Spanish regions are defined at the F&B client (client <> '0') but its UUID's are exactly the same as the one defined into the Spanish regions module (Provincias de España).
If you want to create a new client and you try to apply the Spanish taxes dataset, the following error is shown:

Referenced object Region (id: null / Region396) not present in the xml or in the database.\nReferenced object Region (id: null / Region230) not present in the xml or in the database.\nReferenced object Region (id: null / Region217) not present in the xml or in the database.\nReferenced object Region (id: null / Region248) not present in the xml or in the database.
Steps To Reproduce1. Ensure your instance has the F&B client
2. Run an Initial Client Setup and select the Spanish Taxes Module. Run the process.
3. The system will show an error:
Referenced object Region (id: null / Region396) not present in the xml or in the database.\nReferenced object Region (id: null / Region230) not present in the xml or in the database.\nReferenced object Region (id: null / Region217) not present in the xml or in the database.\nReferenced object Region (id: null / Region248) not present in the xml or in the database.
Proposed Solution1. Check there are some regions defined for the wrong client:
select * from c_region where ad_client_id<>'0';

2. All the regions must belong to the client='0'
update c_region set ad_client_id='0';

3. Check the functionality hasn't been affected

4. Export the F&B Client
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 0020656 closed ioritzCia Localization Pack: Spain Error creating an entity 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-22 09:41vmromanosNew Issue
2012-05-22 09:41vmromanosAssigned To => mirurita
2012-05-22 09:41vmromanosModules => Core
2012-05-22 09:41vmromanosOBNetwork customer => No
2012-05-24 15:53SandrahuguetStatusnew => scheduled
2012-05-24 15:53SandrahuguetAssigned Tomirurita => Sandrahuguet
2012-05-24 15:53Sandrahuguetfix_in_branch => pi
2012-05-30 11:49hgbotCheckin
2012-05-30 11:49hgbotNote Added: 0049470
2012-05-30 11:49hgbotStatusscheduled => resolved
2012-05-30 11:49hgbotResolutionopen => fixed
2012-05-30 11:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3679bfdc36e07a44dae28984dd499319cbf8d402 [^]
2012-05-31 11:41miruritaNote Added: 0049527
2012-05-31 11:41miruritaStatusresolved => closed
2012-05-31 11:41miruritaFixed in Version => 3.0MP12
2012-05-31 21:38hudsonbotCheckin
2012-05-31 21:38hudsonbotNote Added: 0049563
2012-06-20 18:37ioritzCiaRelationship addedduplicate of 0020656

Notes
(0049470)
hgbot   
2012-05-30 11:49   
Repository: erp/devel/pi
Changeset: 3679bfdc36e07a44dae28984dd499319cbf8d402
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri May 25 12:41:23 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3679bfdc36e07a44dae28984dd499319cbf8d402 [^]

Fixed bug 20575 Change the UUID of the Spanish regions in demodata
Change the UUID of the Spanish regions in demodata because it's
impossible to apply Spanish Taxes Module in an instance with demodata

---
M referencedata/sampledata/F_B_International_Group.xml
---
(0049527)
mirurita   
2012-05-31 11:41   
Testing Plan
1) Install Spanish Region module
As the dataset is system level it will be imported during update.database task.
2) Spanish regions should have been imported
They will appear duplicated because F&B already contains Spanish regions.
(0049563)
hudsonbot   
2012-05-31 21:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/3ac036c08ee6 [^]

Maturity status: Test