notification operation failed when using ROLAP

#1

I have a cube which is enabled for real-time update. Sometimes when
rows are added/updated to the fact table for the cube, the subsequent
mdx query to the cube fails with the error:

"Data source provider error A SQL Server notification operation failed
(error code = 2, operation = 'sp_trace_setfilter')"

Any clue why this is happening?

Thanks,
Hitesh

#2

I wonder the existing cache affects. Did you try "Auto Synch Period"
property?

Ohjoo Kwon

"hitesh" <hiteshkhatri (AT) gmail (DOT) com> wrote

Quote:

I have a cube which is enabled for real-time update. Sometimes when
rows are added/updated to the fact table for the cube, the subsequent
mdx query to the cube fails with the error:

"Data source provider error A SQL Server notification operation failed
(error code = 2, operation = 'sp_trace_setfilter')"

Any clue why this is happening?

Thanks,
Hitesh

#3

We are reopening connection to analysis service after updations to fact
table are made. The Auto Synch Period property is set to 10,000
milliseconds (10 seconds).

Ohjoo Kwon wrote:

Quote:

I wonder the existing cache affects. Did you try "Auto Synch Period"
property?

Ohjoo Kwon

"hitesh" <hiteshkhatri (AT) gmail (DOT) com> wrote in message
news:1110359822.378732.202640 (AT) l41g2000cwc (DOT) googlegroups.com...
I have a cube which is enabled for real-time update. Sometimes when
rows are added/updated to the fact table for the cube, the
subsequent
mdx query to the cube fails with the error:

"Data source provider error A SQL Server notification operation
failed
(error code = 2, operation = 'sp_trace_setfilter')"

Any clue why this is happening?

Thanks,
Hitesh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

notification operation failed when using ROLAP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

notification operation failed when using ROLAP - 03-09-2005 , 03:17 AM

Re: notification operation failed when using ROLAP - 03-09-2005 , 11:06 AM

Re: notification operation failed when using ROLAP - 03-09-2005 , 10:51 PM