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.