1

Resolved

Cast exception when using neutralizer

description

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)

comments

jburchel wrote Jul 12, 2008 at 5: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 9:20 PM

Loopiloop wrote Jul 21, 2008 at 1:30 AM

Hi
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 5: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 6: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 6:10 PM

Changing status from "closed" to "fixed"

wrote Sep 13, 2008 at 6:11 PM

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