Deserialization Failed: Parent Columns and Child Columns don't have type-matching columns.

After about an hour and a half of validation, my Analysis Services database has been migrated from 2000 to Analysis Services 2005.

I am now receiving the error in the subject any time I try and access the Data Source View that was created. All dimensions and cubes cannot be processed.

I have tried editing the xml manually to no avail.

Any ideas would be much appreciated!

Would still like to know what the issue is, but I found a workaround in the meantime.

I manually edited the .dsv file, renamed the ids, and restarted OLAP. I then opened the project in Business Intelligence Studio, and manually created the DSV. After a couple of renames of calculated columns the project seems to build properly.

|||I have exactly the same problem (Migration : all OK but I can not open the dsv properties )
I don't understand your resolution.
The migration generated a file .dsv.xml
What "Id" did you rename ?
I tried to rename the data source view ID but still cannot open
I cannot open the databases through Visual Studio. Same error message.

Deserialization Failed: Parent Columns and Child Columns don't have type-matching columns.

After about an hour and a half of validation, my Analysis Services database has been migrated from 2000 to Analysis Services 2005.

I am now receiving the error in the subject any time I try and access the Data Source View that was created. All dimensions and cubes cannot be processed.

I have tried editing the xml manually to no avail.

Any ideas would be much appreciated!

Would still like to know what the issue is, but I found a workaround in the meantime.

I manually edited the .dsv file, renamed the ids, and restarted OLAP. I then opened the project in Business Intelligence Studio, and manually created the DSV. After a couple of renames of calculated columns the project seems to build properly.

|||I have exactly the same problem (Migration : all OK but I can not open the dsv properties )
I don't understand your resolution.
The migration generated a file .dsv.xml
What "Id" did you rename ?
I tried to rename the data source view ID but still cannot open
I cannot open the databases through Visual Studio. Same error message.

Deploying Reports in Visual Studio

About half the time I try to deploy a report in Visual Studio, I do not get
prompted for a user name or password and then get a message that says the
user does not have sufficient rights. Sometimes rebooting the computer will
help but not always. I was told that it is a credential caching problem.
Does anyone know how to get around this problem?try to save/reopen the report. If that doesn't work. close and re-run BIDs.
There are still some issues to be worked out with the dev environment.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Dave banker" wrote:
> About half the time I try to deploy a report in Visual Studio, I do not get
> prompted for a user name or password and then get a message that says the
> user does not have sufficient rights. Sometimes rebooting the computer will
> help but not always. I was told that it is a credential caching problem.
> Does anyone know how to get around this problem?