dbTalk Databases Forums  

AdomdConnection.GetSchemaDataSet undaled exception

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


Discuss AdomdConnection.GetSchemaDataSet undaled exception in the microsoft.public.sqlserver.olap forum.



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

Default AdomdConnection.GetSchemaDataSet undaled exception - 01-24-2006 , 10:56 PM






Hi
When calling this function to retrieve members of a regular shared
dimension from vb.net, we receive an unhandled exception (object
referenced is nothing) ONLY if the dimension has properties and is
accessed via a virtual cube. ie Accessing the same dimension from a
regular cube does not cause this problem.

This affects about 25 % of our shared dimensions - there is no
difference in the dimension structure that you can tell from AS
manager.

The only workaround we have is to remove the properties from the
dimension which is not very helpful as properties are quite important
to the reports we generally write for our customers.

Any help much appreciated.

Thanks

Toby


Reply With Quote
  #2  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: AdomdConnection.GetSchemaDataSet undaled exception - 01-25-2006 , 06:27 AM






Hi,

What version of ADOMD.NET do you use?
What version of AS?

Vladimir Chtepa

"hellmanv3" <Toby.Hellyer (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1138164982.671497.236790 (AT) g43g2000cwa (DOT) googlegroups.com...
Quote:
Hi
When calling this function to retrieve members of a regular shared
dimension from vb.net, we receive an unhandled exception (object
referenced is nothing) ONLY if the dimension has properties and is
accessed via a virtual cube. ie Accessing the same dimension from a
regular cube does not cause this problem.

This affects about 25 % of our shared dimensions - there is no
difference in the dimension structure that you can tell from AS
manager.

The only workaround we have is to remove the properties from the
dimension which is not very helpful as properties are quite important
to the reports we generally write for our customers.

Any help much appreciated.

Thanks

Toby




Reply With Quote
  #3  
Old   
hellmanv3
 
Posts: n/a

Default Re: AdomdConnection.GetSchemaDataSet undaled exception - 01-26-2006 , 06:32 PM



Hi, repost as the last one didnt seem to come up.
admod - 8.0.700.0
AS 2000 SP3a and SP4
thanks
Toby


Reply With Quote
  #4  
Old   
hellmanv3
 
Posts: n/a

Default Re: AdomdConnection.GetSchemaDataSet undaled exception - 01-26-2006 , 07:01 PM



Hi Vladimir ,

Sorry been off for Australia day!

Adomd - 8.0.700.00
AS - SP3a and SP4 (happens on both version)

Toby


Reply With Quote
  #5  
Old   
hellmanv3
 
Posts: n/a

Default Re: AdomdConnection.GetSchemaDataSet undaled exception - 02-19-2006 , 11:35 PM



I have found that if delete the shared dimension and re-add it to the
virtual cube occasionally ie about 1 in 10 times. The problem goes
away. The structure of the dimension and the cube are not altered in
anyway.


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.