Cast exception when using neutralizer


I'm getting the following error when tryin to flatten a sql table
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)


jburchel wrote Jul 12, 2008 at 6:45 PM

Thanks Loopiloop. I think I may have fixed this since I found a problem in this function that I checked in right around the time you posted your issue. Can you test with the latest source, or send me the data to reproduce the failure, and I will test it? If it is the same problem I fixed, the problem was caused because I always planned on the root nodes being NULL only in the PC dimension table when I should have accounted for other forms of PC tables, such as parent missing.

wrote Jul 12, 2008 at 10:20 PM

Loopiloop wrote Jul 21, 2008 at 2:30 AM

I just downloaded latest. Still same error. It happens when there is more than one parent at the root. While in most cases this is probably not a supported scenario, i'm working with TFS data, Areas and Iterations, specifically. I'm using a CTE to flatten it for now, i can post code if you like. Your tool is very cool though, nice work.

jburchel wrote Aug 27, 2008 at 6:39 AM

Thanks for helping me find this. The level count function was not correctly identifying the case where root nodes are specified by having their own id as parent. This is a supported scenario though, so it should definitely be covered. It is updated now to account for this. I missed your comment until just today, so please do not hesitate to email me directly if you do not see a reply on a post right away. I am not sure why it didn't notify me... I will check it regularly though for any future comments/issues to be sure I don't miss them again.

jburchel wrote Sep 13, 2008 at 7:10 PM

Corrected this, adding support for non NULL root member values (parent is self, null or missing).

** Closed by jburchel 7/12/2008 2:20 PM

jburchel wrote Sep 13, 2008 at 7:10 PM

Changing status from "closed" to "fixed"

wrote Sep 13, 2008 at 7:11 PM

wrote Feb 14, 2013 at 12:17 AM

wrote May 16, 2013 at 6:06 AM

wrote May 16, 2013 at 6:06 AM

wrote Jun 14, 2013 at 8:53 AM