error when processing cubes just migrated from 2000 to 2005

im in the process of testing how to upgrade from analysis server 2000 to analysis server 2005. i have migrated my cubes to a test 2005 server and created a project out of them. when i try to deploy this project i get these two errors:

Error 1 OLE DB error: OLE DB or ODBC error: The multi-part identifier "PrintDimensionTransactionDate.TransactionDate" could not be bound.; 42000. 0 0

Error 2 Errors in the OLAP storage engine: An error occurred while processing the 'Print' partition of the 'Print' measure group for the 'Print' cube from the testSRDBProj database. 0 0

these cubes worked fine before i migrated them. does anyone know what could be going wrong?

Hi Winston,

It looks like it has deployed the cube, but is failing in processing it. Is there a table called PrintDimensionTransactionDate with a column of TransactionDate? This doesn't sound right. Also when processing the cube you can get the SQL query that Analysis Services is using, that may lend a clue to what is wrong with this Dimension or measure group.

David

|||yea, there is a table called printdimensionTransactionDate and there is a column called transactiondate. the table contains the full date, and also a break down of the date ( i.e fiscal month num of the date, fiscal week num of the date, etc). how do you get the query? is that by right clicking the error in the processing window? if that is the case, then it shows no SQL , just the error messages i specified previously.|||

the sql that is causing the error is shown below. is it possible to edit this sql in business intelligence development studio?if not, then where is it stored?

SELECT [dbo_PrintFactData].[Total] AS [dbo_PrintFactDataTotal0_0],[dbo_PrintFactData].[InvoiceVolume] AS [dbo_PrintFactDataInvoiceVolume0_1],[dbo_PrintFactData].[CountryDimensionID] AS [dbo_PrintFactDataCountryDimensionID0_2],[dbo_PrintFactData].[CurrencyDimensionID] AS [dbo_PrintFactDataCurrencyDimensionID0_3],[dbo_PrintFactData].[CustomerDimensionID] AS [dbo_PrintFactDataCustomerDimensionID0_4],[dbo_PrintFactData].[EngagementNameDimensionID] AS [dbo_PrintFactDataEngagementNameDimensionID0_5],[dbo_PrintFactData].[InvoiceNumberDimensionID] AS [dbo_PrintFactDataInvoiceNumberDimensionID0_6],[dbo_PrintFactData].[PONumberDimensionID] AS [dbo_PrintFactDataPONumberDimensionID0_7],[dbo_PrintFactData].[ReportDimensionID] AS [dbo_PrintFactDataReportDimensionID0_8],[dbo_PrintFactData].[SAPMessageDimensionID] AS [dbo_PrintFactDataSAPMessageDimensionID0_9],[dbo_PrintFactData].[SystemTypeDimensionID] AS [dbo_PrintFactDataSystemTypeDimensionID0_10],[dbo_PrintFactData].[TransactionDateDimensionID] AS [dbo_PrintFactDataTransactionDateDimensionID0_11],[dbo_PrintFactData].[CaseDimensionID] AS [dbo_PrintFactDataCaseDimensionID0_12],[dbo_PrintFactData].[ContractDimensionID] AS [dbo_PrintFactDataContractDimensionID0_13],[dbo_PrintFactData].[ResolutionTypeDimensionID] AS [dbo_PrintFactDataResolutionTypeDimensionID0_14]
FROM
(

SELECT "Total", "InvoiceVolume", "CountryDimensionID", "ResolutionTypeDimensionID", "ContractDimensionID", "CaseDimensionID", "TransactionDateDimensionID", "SystemTypeDimensionID", "SAPMessageDimensionID", "ReportDimensionID", "PONumberDimensionID", "InvoiceNumberDimensionID", "EngagementNameDimensionID", "CustomerDimensionID", "CurrencyDimensionID" FROM "dbo"."PrintFactData" WHERE "PrintDimensionTransactionDate"."TransactionDate" >= '1/1/2004' --problem here, table printdimensiontransactiondate not mentioned in query before this
)
AS [dbo_PrintFactData]

error when migrating cubes

i have analysis server 2000 on my server and have just installed a new instance of analysis server 2005. i tried the migration wizard but get this error:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

what does that mean? i have no idea how to debug that and google has yeilded no results.

Try installing "Microsoft SQL Server 2005 Backward Compatibility Components " package from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

If that wouldnt help, try re-installing AS2005.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error trying to create cube partition

I've converted 4 AS2000 databases to AS2005. In just one of these databases, I am not able to add any partitions to any of the cubes. As soon as I click the "New Partition" link, get the following error:

The wizard will close because of the following error: An item with the same key has already been added (mscorlib).

I get this error if I try to create a parition from either Visual Studio 2005 or SQL Server Management Studio. AS2005 version is 9.00.2047.00. I can add paritions to cubes in other databases on the same server.

I've been all over looking for help on this, with no luck at all.

If anyone can help me, I'd sure appreciate it.

Most likely something went wrong with the database during migration.

It is possible your database had some problems even before migrated and then migration wizard created AS2005 database with the wrong structure.

It is hard to say what exactly you are having. First go through your AS2000 database structure and make sure it is all valid. Make sure you got the latest AS2000 service pack.

Then migrate your database again and try creating a new AS2005 project based on migrated database. You do that by going through new project wizard and selecting "Import Analysis Ser...."

Go through your new database, open every object in editor and make sure there are no errors and all the object relationships are set right. One area is to pay attention is Dimensions Usage tab in cube editor.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I've checked the AS2000 datbase structures and it's all valid: cubes, dimenions, security roles, partitions, data. Everything there checks out from Analysis Manager as well as from our front-end application that uses OWC to connect to these cubes. The latest service pack is installed.

I have checked all of the objects in the AS2005 databases. There are no errors, and the cubes function properly.

I could migrate the database again, but it's got over 150 cubes, and over 400 seucirty roles. I really hate to do it unless I absolutely have to. Thanks for your suggestion...it may be my last resort.