1

Resolved

Can root of the PC tree be other than NULL?

description

Hello,
 
In our PC table, the parentID column is not null hence we are putting "0" (zero) for root member of the tree. In this case, it throws the below error upon
 
"Error during: [Initializing connections and calculating level depth...]
System.InvalidCastException: Specified cast is not valid.
at PCDimNaturalizer.PCDimNaturalizer.GetLevelCountFromPCTable(String Table, String ID, String PID)
at PCDimNaturalizer.SQLPCDimNaturalizer.Naturalize(Object MinLevels)"
 
One i allow nulls in my parentID column and update the root member with Null, the tools seems to work.
 
Can we allow passing the root ParentID value instead of assuming it to null?

comments

jburchel wrote Sep 13, 2008 at 8:01 AM

Thanks for reporting this. After researching, I can confirm this should work as is. I checked the spec and in fact 0 is supported as a root node value. I do not currently support it as I didn't realize this. I will make a change and check it in within the next few days.

wrote Sep 13, 2008 at 8:01 AM

jburchel wrote Sep 13, 2008 at 9:03 AM

Fixed in changeset #24270.

wrote Sep 13, 2008 at 9:03 AM

wrote Feb 13, 2013 at 11:17 PM

wrote May 16, 2013 at 5:06 AM

wrote May 16, 2013 at 5:06 AM

wrote Jun 14, 2013 at 7:53 AM