dbTalk Databases Forums  

AdomdCacheExpiredException and ADOMD.NET

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


Discuss AdomdCacheExpiredException and ADOMD.NET in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter Kenyon
 
Posts: n/a

Default AdomdCacheExpiredException and ADOMD.NET - 06-09-2005 , 05:23 PM






With ADOMD.Net, making the most minor changes to cubes results in
applications throwing the above exception, with the message "The Cubes
collection has been updated on the server". Users then need to restart their
applications. In most cases there should not be any need for this, as the
sorts of changes we are likely to make (such as adding member properties to
dimensions) don't really change the cube metadata significantly. Certainly
not to the extent that user queries would be affected.

Is there any way to prevent this behaviour, or work around it? Putting
try/catch blocks in every place where cube metatadata is queried in order to
catch this exception and reopen the connection would be overkill.

Thanks,

Peter



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.