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 25144 b2ffb13649dd
parent 25143 e3c93d6001f3
child 25145 7a5d14d1381d
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:09:51 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:09:51 2014 +0200
+++ b/src-db/database/sourcedata/AD_TABLE_TREE.xml	Tue Oct 21 16:18:05 2014 +0200
@@ -304,25 +304,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>