0008745: Project data in Small Bazaar sample data: tree node values in ad_treenode for tree PR point to non-existing projects

Notes
(0015761) rajagopal (viewer) 2009-04-27 11:30 edited on: 2009-04-27 11:34	Below is the link of ant task execution log while executing ant export.sample.data for defect id : 8276. http://pastebin.com/f14b36978 [^]

(0015848) psarobe (viewer) 2009-04-28 13:29	Hi Martin, Which is the consequence of this? Shall we fix it for 250MP1? Thanks

(0015849) mtaal (viewer) 2009-04-28 13:33	Hi Rafa, Maybe one thing which can be checked if in 2.40 this 'error' already existed (so treenodes which point to non-existing projects). It would be good to have this extra info (to determine if this error started in 2.50). In any case I don't think that we need to solve this in MP1. It is just sample.data and it can be solved also as part of a fix later. gr. Martin

(0015850) mtaal (viewer) 2009-04-28 13:33	I mean 'Hi Pablo' ofcourse :-) gr. Martin

(0016406) mtaal (viewer) 2009-05-17 11:08	Hi Pablo, Rafa, I tried export.sample.data and it did not work because of this issue. I can disable the check for this for now to make exporting possible. But I think it makes sense to solve this for MP2. The solution is two step: 1) validate that it is correct that the refered projects are not there, if they should have been there then that shows a different issue (projects not part of sample data...) 2) if these projects are indeed not ment to be part of sample data then these tree nodes can be removed, if the tree that contains these nodes does not have any other nodes then this tree can also be removed. Imo both steps should be done by someone responsible for the project management functionality. Here is the previous log string this time with the id's of the treenode: TreeNode (with id:52118BF1A8614D84E040007F01005FEC): The value 1000002 used in treeNode 52118BF1A8614D84E040007F01005FEC is not valid, there is no Project with that id TreeNode (with id:52118BF1A8624D84E040007F01005FEC): The value 1000003 used in treeNode 52118BF1A8624D84E040007F01005FEC is not valid, there is no Project with that id TreeNode (with id:52118BF1A8664D84E040007F01005FEC): The value 1000007 used in treeNode 52118BF1A8664D84E040007F01005FEC is not valid, there is no Project with that id TreeNode (with id:52118BF1A8674D84E040007F01005FEC): The value 1000008 used in treeNode 52118BF1A8674D84E040007F01005FEC is not valid, there is no Project with that id gr. Martin

(0016407) mtaal (viewer) 2009-05-17 11:14	Correction :-), the data is exported, still it makes sense to solve this imo. It is little work and solves an inconsistency in the data gr. Martin

(0033642) gorkaion (viewer) 2011-01-14 10:45	SmallBazaar sample data has been replaced by F&B

Issue History
Date Modified	Username	Field	Change
2009-04-23 14:02	mtaal	New Issue
2009-04-23 14:02	mtaal	Assigned To	=> rafaroda
2009-04-23 14:02	mtaal	OBNetwork customer	=> No
2009-04-23 14:02	mtaal	Regression testing	=> No
2009-04-27 11:30	rajagopal	Note Added: 0015761
2009-04-27 11:34	rajagopal	Note Edited: 0015761
2009-04-28 13:29	psarobe	Note Added: 0015848
2009-04-28 13:29	psarobe	Status	new => feedback
2009-04-28 13:33	mtaal	Note Added: 0015849
2009-04-28 13:33	mtaal	Note Added: 0015850
2009-04-29 16:53	psarobe	Severity	major => minor
2009-04-29 16:53	psarobe	Status	feedback => scheduled
2009-05-17 11:08	mtaal	Note Added: 0016406
2009-05-17 11:14	mtaal	Note Added: 0016407
2009-06-01 17:18	rafaroda	Assigned To	rafaroda => gorkaion
2009-06-01 17:18	rafaroda	Category	08. Project and service management => J. Demo data
2009-06-09 17:00	rafaroda	Relationship added	has duplicate 0009400
2009-09-18 13:04	rafaroda	Relationship added	has duplicate 0010610
2009-10-28 14:22	shuehner	Relationship added	related to 0011161
2011-01-14 10:45	gorkaion	Note Added: 0033642
2011-01-14 10:45	gorkaion	Status	scheduled => closed
2011-01-14 10:45	gorkaion	Resolution	open => out of date
2011-01-15 00:00	anonymous	sf_bug_id	0 => 3158555