Azure Analysis Services - Tabular Visual Studio Deployment - The stream does not have an active operation!

Question

Hello!

When I needed to deploy my last model changes in Visual Studio for my AAS Tabular Mode. I have successfully deployed the model to AAS that afternoon. I get the following error: Cannot deploy metadata. Reason: An error occurred while connecting to the server.

When I test the Deployment Server on asazure://westus2.asazure.windows.net in Options > Analysis Services Tabular I get the following error: Connection to the deployment database server failed. Reason: An error occurred while connecting to the server. The stream does not have an active operation!

I turned on Diagnosis and got the following log:


Microsoft.AnalysisServices.BackEnd.StorageException
Message : An error occurred while connecting to the server.
Exception StackTrace :    at Microsoft.AnalysisServices.BackEnd.DataModelingServer.Open(Boolean skipQueryMode)
Source : Microsoft.AnalysisServices.BackEnd
Full stack trace: 
   at Microsoft.AnalysisServices.VSHost.DebugHelper.WriteExceptions(Exception exception, String logFile)
   at Microsoft.AnalysisServices.VSHost.VSHostManager.LogExceptions(Object sender, Exception exception, String logPath)
   at Microsoft.AnalysisServices.BackEnd.DataModelingServer.Open(Boolean skipQueryMode)
   at Microsoft.AnalysisServices.VSHost.Options.AnalysisServicesDeployOptionPageControl.ClickTestConnection(Object progressControl)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart(Object obj)


System.InvalidOperationException
Message : The stream does not have an active operation!
Exception StackTrace :    at Microsoft.AnalysisServices.HttpStream.EnsureOperationIsReadyForRead()
   at Microsoft.AnalysisServices.HttpStream.GetResponseDataType()
   at Microsoft.AnalysisServices.CompressedStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.StreamReader.ReadBuffer(Char[] userBuffer, Int32 userOffset, Int32 desiredChars, Boolean& readToUserBuffer)
   at System.IO.StreamReader.Read(Char[] buffer, Int32 index, Int32 count)
   at System.Xml.XmlTextReaderImpl.ReadData()
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlReader.ReadEndElement()
   at Microsoft.AnalysisServices.XmlaReader.ReadEndElement()
   at Microsoft.AnalysisServices.Core.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion, JaXmlSerializer serializer)
   at Microsoft.AnalysisServices.Core.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
   at Microsoft.AnalysisServices.MajorObject.Refresh(ObjectExpansion expansion)
   at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString, String sessionId, ObjectExpansion expansionType)
   at Microsoft.AnalysisServices.Core.Server.Connect(String connectionString)
   at Microsoft.AnalysisServices.BackEnd.DataModelingServer.Open(Boolean skipQueryMode)
Source : Microsoft.AnalysisServices.Core
Full stack trace: 
   at Microsoft.AnalysisServices.VSHost.DebugHelper.WriteExceptions(Exception exception, String logFile)
   at Microsoft.AnalysisServices.VSHost.VSHostManager.LogExceptions(Object sender, Exception exception, String logPath)
   at Microsoft.AnalysisServices.BackEnd.DataModelingServer.Open(Boolean skipQueryMode)
   at Microsoft.AnalysisServices.VSHost.Options.AnalysisServicesDeployOptionPageControl.ClickTestConnection(Object progressControl)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart(Object obj)

I have already taken the following steps to attempt to resolve:

Make sure I am authenticated in the correct Microsoft AD account in Visual Studio
Updated Visual Studio to version 17.7.4
Updated Analysis Services Projects Extension to version 3.0.13
Restarted the workstation
Verified there was no conflicting VPNs
I had another developer test his Visual Studio and he was able to deploy successfully. There is no difference between his setup and my setup.

I am still able to connect and process to the model in SSMS, but I can not deploy my measure changes in SSMS. I need Visual Studio to the AAS deployment server for that.

Please let me know if you have any questions or need any additional details.

Answer

From the error I can understand that there is a broken connection between Visual Studio and Azure Analysis Services.

To troubleshoot, check if your firewall or network doesn't restrict communication between the two services and try running Visual Studio as an administrator. You will consider verifying role assignments in Azure to confirm you have the needed permissions. If the issue still persist you can contact the support.

Answer

Hello @Liz Rogers Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!

Did you try to update the Visual Studio and do the deployment?

Looks like the issue might be due to some missing DLLs?

Deploy a tabular model from Visual Studio

Configure default data modeling and deployment properties

Share via

Azure Analysis Services - Tabular Visual Studio Deployment - The stream does not have an active operation!

2 answers