Proactive caching notification error

I have defined a partition to use proactive caching with a polling query notification. The polling query simply returns the maximum

value of a timestamp column from the measure group transaction table. The query parses and runs from the create polling query dialoguebox.

Have set this to run every 30 seconds.

When this is deployed runs the trace on Analysis Services returns this error :

OLE DB error: OLE DB or ODBC error: Invalid object name 'fcsUltForecasts'.; 42S02.

http://support.microsoft.com/kb/225256

this article suggests can be caused by non dbo owned tables. However this table is owned by dbo (and is the table used when the parition is processed normally)

[2084 byte] By [MarkR64] at [2008-1-4]

«« Creating a Right Click menu with Sub Menus
»» Accessing Analysis Services 2005 using HTTP from Vista Business

# 1

I have not seen this error before, but I have a couple of suggestions.

Can you run the polling query in SSMS, just to make sure it works they way you expect it to?

And are you talking about a column with the timestamp data type or is this a datetime column. The reason I ask is that timestamp is a poor name for that particular data type and it is better thought of as a row version or row hash. They are a binary type and do not increase in a linear fashion over time so doing a Max() over a timestamp column would produce inconsistant results and I'm not even sure if the max() function can work with timestamps.

DarrenGosbell at 2007-9-26 >

SQL Server

SQL Server Analysis Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Proactive caching notification error...'

Proactive caching notification error

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified