Search

SQL2012 SP1 breaks connection to Essbase through ADOMD.NET by furmangg

Active

1
0
Sign in
to vote
Type: Bug
ID: 774580
Opened: 12/17/2012 12:24:22 PM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
It looks like SQL2012 SP1 changes to ADOMD.NET broke connections to Essbase via ADOMD.NET. Now we’re getting this error:

Element 'return' was not found. Line 1, position 252.
at System.Xml.XmlReader.ReadStartElement(String name)
at Microsoft.AnalysisServices.AdomdClient.XmlaReader.ReadStartElement(String name)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperty(String propName)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()

.ClientVersion returns:
11.0.3000.0 ((SQL11_PCU_Main).121019-1325 )

Disassembling the DLL, it looks like the XmlaClient.SupportsProperty function is new. I guess Essbase doesn’t support DISCOVER_PROPERTIES? If there was a property you could set on the connection string to have it skip this code path, that would be nice.

I was able to install a prior version of ADOMD.NET and it’s working again. But a fix would be nice for the sake of others who might be using ADOMD.NET for this purpose.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Analysis Services

Operating System

Windows Server 2008 R2 Enterprise (SP1)

Operating System Language

US English

Steps to Reproduce

Use the SQL2012 SP1 version of Microsoft.AnalysisServices.AdomdClient.AdomdConnection to connect to Essbase through the XMLA provider. You get the error listed above.

Actual Results

see above

Expected Results

should work like it did before SP1

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.