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 opening Maintenance Plan in SQL 2000

I've recently installed SQL 2000 on a new server. Migrated production
databases and data from old SQL 6.5.
Everything checks out OK applications work fine, all data
came over no problem. However... when I try to open or create a
database maintenance plan I get is error:
Microsoft SQL-DMO (ODBC SQLState: 42S22)
Error 207: Invalid column name 'category_id'.
Invalid column name 'netsend_address'.
Invalid column name 'last_netsend_date'.
Invalid column name 'last_netsend_time'.
these colune names do not exist, do I need to create them and if so,
which table do they need to be in? Any help is greatly appreciated. Thanks
HI;
Columns mentioned below are in the sysoperators table in msdb database
netsend_address nvarchar 100 NOT NULL
last_netsend_date int 4 NULL
last_netsend_time int 4 NULL
category_id int 4 NULL
IT Looks to me that something happend to your msdb database.
Do you have a backup to restore it from before migration?
Danijel Novak
"Lisa Hoffman" <LisaHoffman@.reish.com> wrote in message
news:OH0vej2BGHA.3584@.TK2MSFTNGP11.phx.gbl...
> I've recently installed SQL 2000 on a new server. Migrated production
> databases and data from old SQL 6.5.
> Everything checks out OK applications work fine, all data
> came over no problem. However... when I try to open or create a
> database maintenance plan I get is error:
> Microsoft SQL-DMO (ODBC SQLState: 42S22)
> Error 207: Invalid column name 'category_id'.
> Invalid column name 'netsend_address'.
> Invalid column name 'last_netsend_date'.
> Invalid column name 'last_netsend_time'.
> these colune names do not exist, do I need to create them and if so, which
> table do they need to be in? Any help is greatly appreciated. Thanks
>
|||Hi Lisa
You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB database.
If you need to restore MSDB check out
http://msdn.microsoft.com/library/de...kprst_2w1f.asp
John
"Lisa Hoffman" wrote:

> I've recently installed SQL 2000 on a new server. Migrated production
> databases and data from old SQL 6.5.
> Everything checks out OK applications work fine, all data
> came over no problem. However... when I try to open or create a
> database maintenance plan I get is error:
> Microsoft SQL-DMO (ODBC SQLState: 42S22)
> Error 207: Invalid column name 'category_id'.
> Invalid column name 'netsend_address'.
> Invalid column name 'last_netsend_date'.
> Invalid column name 'last_netsend_time'.
> these colune names do not exist, do I need to create them and if so,
> which table do they need to be in? Any help is greatly appreciated. Thanks
>
>
|||The MS article states "The model and msdb databases can only be restored
from backups created on a Microsoft? SQL Server? 2000 server. Restore of
backups of these databases made on SQL Server version 7.0 or earlier is
not supported."
This was a migration from 6.5 (and I do not have access to this db
anymore). Any other suggestions?
John Bell wrote:
[vbcol=seagreen]
> Hi Lisa
> You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB database.
> If you need to restore MSDB check out
> http://msdn.microsoft.com/library/de...kprst_2w1f.asp
> John
> "Lisa Hoffman" wrote:
>
|||Hi
I would assume that MSDB was backed up after your installation and therefore
it could be resumed to it's previous state? Any jobs etc should be reviewed
and manually re-created.
John
"Lisa Hoffman" wrote:

> The MS article states "The model and msdb databases can only be restored
> from backups created on a Microsoft? SQL Server? 2000 server. Restore of
> backups of these databases made on SQL Server version 7.0 or earlier is
> not supported."
> This was a migration from 6.5 (and I do not have access to this db
> anymore). Any other suggestions?
> John Bell wrote:
>

Error when opening Maintenance Plan in SQL 2000

I've recently installed SQL 2000 on a new server. Migrated production
databases and data from old SQL 6.5.
Everything checks out OK applications work fine, all data
came over no problem. However... when I try to open or create a
database maintenance plan I get is error:
Microsoft SQL-DMO (ODBC SQLState: 42S22)
Error 207: Invalid column name 'category_id'.
Invalid column name 'netsend_address'.
Invalid column name 'last_netsend_date'.
Invalid column name 'last_netsend_time'.
these colune names do not exist, do I need to create them and if so,
which table do they need to be in? Any help is greatly appreciated. ThanksHI;
Columns mentioned below are in the sysoperators table in msdb database
netsend_address nvarchar 100 NOT NULL
last_netsend_date int 4 NULL
last_netsend_time int 4 NULL
category_id int 4 NULL
IT Looks to me that something happend to your msdb database.
Do you have a backup to restore it from before migration?
Danijel Novak
"Lisa Hoffman" <LisaHoffman@.reish.com> wrote in message
news:OH0vej2BGHA.3584@.TK2MSFTNGP11.phx.gbl...
> I've recently installed SQL 2000 on a new server. Migrated production
> databases and data from old SQL 6.5.
> Everything checks out OK applications work fine, all data
> came over no problem. However... when I try to open or create a
> database maintenance plan I get is error:
> Microsoft SQL-DMO (ODBC SQLState: 42S22)
> Error 207: Invalid column name 'category_id'.
> Invalid column name 'netsend_address'.
> Invalid column name 'last_netsend_date'.
> Invalid column name 'last_netsend_time'.
> these colune names do not exist, do I need to create them and if so, which
> table do they need to be in? Any help is greatly appreciated. Thanks
>|||Hi Lisa
You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB databas
e.
If you need to restore MSDB check out
http://msdn.microsoft.com/library/d... />
t_2w1f.asp
John
"Lisa Hoffman" wrote:

> I've recently installed SQL 2000 on a new server. Migrated production
> databases and data from old SQL 6.5.
> Everything checks out OK applications work fine, all data
> came over no problem. However... when I try to open or create a
> database maintenance plan I get is error:
> Microsoft SQL-DMO (ODBC SQLState: 42S22)
> Error 207: Invalid column name 'category_id'.
> Invalid column name 'netsend_address'.
> Invalid column name 'last_netsend_date'.
> Invalid column name 'last_netsend_time'.
> these colune names do not exist, do I need to create them and if so,
> which table do they need to be in? Any help is greatly appreciated. Than
ks
>
>|||The MS article states "The model and msdb databases can only be restored
from backups created on a Microsoft? SQL Server? 2000 server. Restore of
backups of these databases made on SQL Server version 7.0 or earlier is
not supported."
This was a migration from 6.5 (and I do not have access to this db
anymore). Any other suggestions?
John Bell wrote:
[vbcol=seagreen]
> Hi Lisa
> You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB datab
ase.
> If you need to restore MSDB check out
> http://msdn.microsoft.com/library/d...>
rst_2w1f.asp
> John
> "Lisa Hoffman" wrote:
>|||Hi
I would assume that MSDB was backed up after your installation and therefore
it could be resumed to it's previous state? Any jobs etc should be reviewed
and manually re-created.
John
"Lisa Hoffman" wrote:

> The MS article states "The model and msdb databases can only be restored
> from backups created on a Microsoft? SQL Server? 2000 server. Restore o
f
> backups of these databases made on SQL Server version 7.0 or earlier is
> not supported."
> This was a migration from 6.5 (and I do not have access to this db
> anymore). Any other suggestions?
> John Bell wrote:
>
>

Error when opening Maintenance Plan in SQL 2000

I've recently installed SQL 2000 on a new server. Migrated production
databases and data from old SQL 6.5.
Everything checks out OK applications work fine, all data
came over no problem. However... when I try to open or create a
database maintenance plan I get is error:
Microsoft SQL-DMO (ODBC SQLState: 42S22)
Error 207: Invalid column name 'category_id'.
Invalid column name 'netsend_address'.
Invalid column name 'last_netsend_date'.
Invalid column name 'last_netsend_time'.
these colune names do not exist, do I need to create them and if so,
which table do they need to be in? Any help is greatly appreciated. ThanksHI;
Columns mentioned below are in the sysoperators table in msdb database
netsend_address nvarchar 100 NOT NULL
last_netsend_date int 4 NULL
last_netsend_time int 4 NULL
category_id int 4 NULL
IT Looks to me that something happend to your msdb database.
Do you have a backup to restore it from before migration?
--
Danijel Novak
"Lisa Hoffman" <LisaHoffman@.reish.com> wrote in message
news:OH0vej2BGHA.3584@.TK2MSFTNGP11.phx.gbl...
> I've recently installed SQL 2000 on a new server. Migrated production
> databases and data from old SQL 6.5.
> Everything checks out OK applications work fine, all data
> came over no problem. However... when I try to open or create a
> database maintenance plan I get is error:
> Microsoft SQL-DMO (ODBC SQLState: 42S22)
> Error 207: Invalid column name 'category_id'.
> Invalid column name 'netsend_address'.
> Invalid column name 'last_netsend_date'.
> Invalid column name 'last_netsend_time'.
> these colune names do not exist, do I need to create them and if so, which
> table do they need to be in? Any help is greatly appreciated. Thanks
>|||Hi Lisa
You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB database.
If you need to restore MSDB check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp
John
"Lisa Hoffman" wrote:
> I've recently installed SQL 2000 on a new server. Migrated production
> databases and data from old SQL 6.5.
> Everything checks out OK applications work fine, all data
> came over no problem. However... when I try to open or create a
> database maintenance plan I get is error:
> Microsoft SQL-DMO (ODBC SQLState: 42S22)
> Error 207: Invalid column name 'category_id'.
> Invalid column name 'netsend_address'.
> Invalid column name 'last_netsend_date'.
> Invalid column name 'last_netsend_time'.
> these colune names do not exist, do I need to create them and if so,
> which table do they need to be in? Any help is greatly appreciated. Thanks
>
>|||The MS article states "The model and msdb databases can only be restored
from backups created on a Microsoft® SQL Server� 2000 server. Restore of
backups of these databases made on SQL Server version 7.0 or earlier is
not supported."
This was a migration from 6.5 (and I do not have access to this db
anymore). Any other suggestions?
John Bell wrote:
> Hi Lisa
> You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB database.
> If you need to restore MSDB check out
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp
> John
> "Lisa Hoffman" wrote:
>
>>I've recently installed SQL 2000 on a new server. Migrated production
>>databases and data from old SQL 6.5.
>>Everything checks out OK applications work fine, all data
>>came over no problem. However... when I try to open or create a
>>database maintenance plan I get is error:
>>Microsoft SQL-DMO (ODBC SQLState: 42S22)
>>Error 207: Invalid column name 'category_id'.
>>Invalid column name 'netsend_address'.
>>Invalid column name 'last_netsend_date'.
>>Invalid column name 'last_netsend_time'.
>>these colune names do not exist, do I need to create them and if so,
>>which table do they need to be in? Any help is greatly appreciated. Thanks
>>|||Hi
I would assume that MSDB was backed up after your installation and therefore
it could be resumed to it's previous state? Any jobs etc should be reviewed
and manually re-created.
John
"Lisa Hoffman" wrote:
> The MS article states "The model and msdb databases can only be restored
> from backups created on a Microsoft® SQL Server� 2000 server. Restore of
> backups of these databases made on SQL Server version 7.0 or earlier is
> not supported."
> This was a migration from 6.5 (and I do not have access to this db
> anymore). Any other suggestions?
> John Bell wrote:
> > Hi Lisa
> >
> > You may want to run a DBCC CHECKCATALOG or DBCC CHECKDB on your MSDB database.
> >
> > If you need to restore MSDB check out
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp
> >
> > John
> >
> > "Lisa Hoffman" wrote:
> >
> >
> >>I've recently installed SQL 2000 on a new server. Migrated production
> >>databases and data from old SQL 6.5.
> >>Everything checks out OK applications work fine, all data
> >>came over no problem. However... when I try to open or create a
> >>database maintenance plan I get is error:
> >>
> >>Microsoft SQL-DMO (ODBC SQLState: 42S22)
> >>Error 207: Invalid column name 'category_id'.
> >>Invalid column name 'netsend_address'.
> >>Invalid column name 'last_netsend_date'.
> >>Invalid column name 'last_netsend_time'.
> >>
> >>these colune names do not exist, do I need to create them and if so,
> >>which table do they need to be in? Any help is greatly appreciated. Thanks
> >>
> >>
> >>
>