Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020575
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] J. Demo dataminoralways2012-05-22 09:412012-05-31 21:38
ReportervmromanosView Statuspublic 
Assigned ToSandrahuguet 
PrioritynormalResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchpiFixed in SCM revision3679bfdc36e0
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionDebian 5.0Database version8.3.8Ant version1.7.0
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020575: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0020656 closedioritzCia Localization Pack: Spain Error creating an entity 

-  Notes
(0049470)
hgbot (developer)
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 (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2012-05-22 09:41 vmromanos New Issue
2012-05-22 09:41 vmromanos Assigned To => mirurita
2012-05-22 09:41 vmromanos Modules => Core
2012-05-24 15:53 Sandrahuguet Status new => scheduled
2012-05-24 15:53 Sandrahuguet Assigned To mirurita => Sandrahuguet
2012-05-24 15:53 Sandrahuguet fix_in_branch => pi
2012-05-30 11:49 hgbot Checkin
2012-05-30 11:49 hgbot Note Added: 0049470
2012-05-30 11:49 hgbot Status scheduled => resolved
2012-05-30 11:49 hgbot Resolution open => fixed
2012-05-30 11:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3679bfdc36e07a44dae28984dd499319cbf8d402 [^]
2012-05-31 11:41 mirurita Note Added: 0049527
2012-05-31 11:41 mirurita Status resolved => closed
2012-05-31 11:41 mirurita Fixed in Version => 3.0MP12
2012-05-31 21:38 hudsonbot Checkin
2012-05-31 21:38 hudsonbot Note Added: 0049563
2012-06-20 18:37 ioritzCia Relationship added duplicate of 0020656

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker