Fixes issue 27918: Removes tree structure from table that is not a tree
authorAugusto Mauch <augusto.mauch@openbravo.com>
Tue, 21 Oct 2014 16:18:05 +0200
changeset 25069 5f9f3dae6e36
parent 25068 2c476c2bc328
child 25070 b22cd5e9d70d
child 25249 6ada16afd344
Fixes issue 27918: Removes tree structure from table that is not a tree

In the initial changeset for fixing 27918, the tree type of the FinancialMgmtAccountingReport table was set to null because that table is not really a tree. The problem was that the cleaning up of the table was not complete, the Is Tree flag should be set to false, and its Tree Table Category subtab should be empty. This has been done now.

The Initial Client Setup was failing because of the incomplete cleanup. The Tree Table Category of FinancialMgmtAccountingReport had a record called Accounting Report, which is the same name as the tree of the FinancialMgmtAccountingRptElement table.
src-db/database/sourcedata/AD_TABLE.xml
src-db/database/sourcedata/AD_TABLE_TREE.xml
--- a/src-db/database/sourcedata/AD_TABLE.xml	Tue Oct 21 13:55:05 2014 +0200
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Tue Oct 21 16:18:05 2014 +0200
@@ -8297,7 +8297,7 @@
 <!--800223-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--800223-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1E14B84E040007F01006125]]></AD_PACKAGE_ID>
 <!--800223-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
-<!--800223-->  <ISTREE><![CDATA[Y]]></ISTREE>
+<!--800223-->  <ISTREE><![CDATA[N]]></ISTREE>
 <!--800223--></AD_TABLE>
 
 <!--800224--><AD_TABLE>
--- a/src-db/database/sourcedata/AD_TABLE_TREE.xml	Tue Oct 21 13:55:05 2014 +0200
+++ b/src-db/database/sourcedata/AD_TABLE_TREE.xml	Tue Oct 21 16:18:05 2014 +0200
@@ -324,25 +324,6 @@
 <!--D298DD9EB4514BF8ABBDA4D88A591AFF-->  <NODEDELETIONPOLICY><![CDATA[RCN]]></NODEDELETIONPOLICY>
 <!--D298DD9EB4514BF8ABBDA4D88A591AFF--></AD_TABLE_TREE>
 
-<!--D45388802D4F41719DEACD336FA2B88F--><AD_TABLE_TREE>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <AD_TABLE_TREE_ID><![CDATA[D45388802D4F41719DEACD336FA2B88F]]></AD_TABLE_TREE_ID>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <AD_TABLE_ID><![CDATA[800223]]></AD_TABLE_ID>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <NODEIDCOLUMN><![CDATA[803760]]></NODEIDCOLUMN>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <HASMULTIPARENTNODES><![CDATA[N]]></HASMULTIPARENTNODES>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <APPLYWHERECLAUSETOCHILDNODES><![CDATA[Y]]></APPLYWHERECLAUSETOCHILDNODES>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <NAME><![CDATA[Accounting report]]></NAME>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <ISPARENTSELECTIONALLOWED><![CDATA[Y]]></ISPARENTSELECTIONALLOWED>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <ISORDERED><![CDATA[Y]]></ISORDERED>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <TREESTRUCTURE><![CDATA[ADTree]]></TREESTRUCTURE>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <ISHANDLENODESMANUALLY><![CDATA[Y]]></ISHANDLENODESMANUALLY>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <ISMAINTREE><![CDATA[Y]]></ISMAINTREE>
-<!--D45388802D4F41719DEACD336FA2B88F-->  <NODEDELETIONPOLICY><![CDATA[RCN]]></NODEDELETIONPOLICY>
-<!--D45388802D4F41719DEACD336FA2B88F--></AD_TABLE_TREE>
-
 <!--E52D2F7D418F41CCAE199ABE56CE282F--><AD_TABLE_TREE>
 <!--E52D2F7D418F41CCAE199ABE56CE282F-->  <AD_TABLE_TREE_ID><![CDATA[E52D2F7D418F41CCAE199ABE56CE282F]]></AD_TABLE_TREE_ID>
 <!--E52D2F7D418F41CCAE199ABE56CE282F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>