dbTalk Databases Forums  

Query errors on write enabled cubes using NONEMPTYCROSSJOIN functi

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


Discuss Query errors on write enabled cubes using NONEMPTYCROSSJOIN functi in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SH Woo
 
Posts: n/a

Default Query errors on write enabled cubes using NONEMPTYCROSSJOIN functi - 03-24-2006 , 01:52 AM






I have an application that can update an MSAS 2000 cube, but I get errors
when I attempt to retrieve data from cells impacted by the write back Update
Cube command. My application uses ADOMD.NET 8.0 to retrieve the cellsets
from the cube. I only receive an error if the cube contains calculations
using the NONEMPTYCROSSJOIN function.

The follwoing error is received in the ADOMDException when I execute a
cellset query:

"Some data has been updated since you began executing this query. - An error
occurred during attempt to get a cell value"

However, if the updated cells are commited to the writeback table, the error
disappears during a subsequent query for the same cellset. Is this a bug and
is there a remedy?

Thanks,
SHW

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.