Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014264Openbravo ERPJ. Demo datapublic2010-08-23 09:362010-09-13 12:38
Reportergorka_gil 
Assigned Tostaffrm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version2.50MP20 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014264: Referenced entity belongs to an organization which is not part of the natural tree
DescriptionImporting the sampledata of BigBazaar in 2.50MP20 gives this error:

BUILD FAILED
/tmp/oberp.2.50MP21/OpenbravoERP/build.xml:652: The following error occurred while executing this line:
/tmp/oberp.2.50MP21/OpenbravoERP/build.xml:565: The following error occurred while executing this line:
/tmp/oberp.2.50MP21/OpenbravoERP/src/build.xml:238: org.openbravo.base.exception.OBException: Exception (org.openbravo.base.exception.OBSecurityException: Entity false - Somerled - P - 37915.04 - 30-12-2006 (FinancialMgmtDebtPayment) with organization Connecticut references an entity The South Bank - through its property bankAccount but this referenced entity belongs to an organization California which is not part of the natural tree of Connecticut) while importing from file /tmp/oberp.2.50MP21/OpenbravoERP/referencedata/sampledata/BigBazaar.xml
Steps To Reproduce1.- Place the BigBazaar.xml in the referencedata/sampledata/ directory.
2.- Remove SmallBazaar.xml from this directory
3.- Run an install.source
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 00144022.50MP22 closed marvintm import.sample.data: add an optional parameter to bypass the checkReferencedOrganizations validation 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-08-23 09:36gorka_gilNew Issue
2010-08-23 09:36gorka_gilAssigned To => adrianromero
2010-08-23 09:41iciordiaPriorityhigh => urgent
2010-08-23 09:43iciordiaNote Added: 0030215
2010-08-23 09:59jpabloaeIssue Monitored: jpabloae
2010-08-23 11:55gorka_gilAssigned Toadrianromero => staffrm
2010-09-09 00:31jpabloaeRelationship addedrelated to 0014397
2010-09-09 00:31jpabloaeRelationship addedrelated to 0014402
2010-09-09 00:31jpabloaeRelationship deletedrelated to 0014397
2010-09-09 00:32jpabloaeNote Added: 0030874
2010-09-10 14:32iciordiaNote Added: 0030940
2010-09-10 14:32iciordiaStatusnew => closed
2010-09-10 14:32iciordiaResolutionopen => no change required
2010-09-13 12:38anonymoussf_bug_id0 => 3065180

Notes
(0030215)
iciordia   
2010-08-23 09:43   
Data in BigBazaar.xml is incorrect: there is a debt-payment in an organization referencing to a bank account in another organization, not included in the natural tree of the original

You can see the wrong record at http://demo.openbravo.com [^] (go to Financial Management >> Receivables and Payables >> Analysis Tools >> Payment Report, and filter by due date from 30-12-2006 to 30-12-2006, Amount from 35.000 to 40.000 and Payable. After Search the report only returns one record. From that record you can navigate to the Generated Settlement where the error is more evident: the debt-payment is linked to organization Connecticut and check that the Bank Account field is invalid ('** -'). If you switch to Grid view you can see that the bank account is 'The South Bank' (linked to organization California)

To fix this particular issue is trivial but to fix the whole dataset could become really complex since there are more cases in which debt-payments in Connecticut reference to bank-accounts in California, and it could happen in many other references.
(0030874)
jpabloae   
2010-09-09 00:32   
Having issue 0014402 resolved, do you agree on considering this as a closed issue?
(0030940)
iciordia   
2010-09-10 14:32   
Juanpa, yes, there is no need to do any other change. Closing the issue.

Ismael