Wednesday, March 7, 2012

Reprocessing Errors after using the migrationwizard

Hello,

I have converted a AS2000 project to AS2005 using the migrationwizard. All went well, unfortunately I get the following errors when I try to reprocess in AS2005 and I have no idea how to fix them. Does anybody have an idea what I can do ? The first error seems like there is something wrong in my DB with type matching, but it doesn't say where.

Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: Parent Columns and Child Columns don't have type-matching columns..

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Taak', Name of 'Taak' was being processed.

Errors in the OLAP storage engine: An error occurred while the 'Subtaak attribute' attribute of the 'Taak' dimension from the 'DIMSCUBE1' database was being processed.

Are any of your keys TinyInts with IDENTITY clauses on them?
If so, this is a known restriction of SQLXML (which we are using under the covers). It converts all IDENTITY columns to full integers (and thus you are getting a datatype mismatch. Using either a VIEW or a DSV named query (or computed column) convert the keys (both the PK and the FK parent column) to integers and see what happens.

_-_-_ Dave

No comments:

Post a Comment