1

Resolved

Divide by Zero Error Creating Auditing Output When No Rows Are Processed

description

When I run a KimballSCD package where there are no rows in the source and no rows in the existing dimension (no rows in any input) SSIS crashes and I get this error:
 
Error: 0x0 at DF (Risk), SCD: Internal error (Attempted to divide by zero.) in CreateAuditingRow.
 
This is not a major problem since this is not really a real production scenario. We just hadn't inserted any rows into the production source table for one of our dimensions. Easy to work around, but probably worth fixing, that being said.
 
I'm using version 1.4.

comments

toddmcdermid wrote Dec 17, 2009 at 9:51 PM

Ah yes, I think I've run into that one too - or at least I pre-emptively fixed that in v1.5. (BTW - TYVM for mentioning the version.)

I'll double-check to make sure - that's a good test for my regression harness. Hopefully I'll get that buttoned up soon. Maybe over the holidays... >:(

toddmcdermid wrote Jan 16, 2010 at 8:07 AM

Good news - v1.5 passes this test.