Problems starting Database Engine Tuning Advisor on MSSQL Linux Install - Unable to find assembly DTAClient (mscorlib)

Marcel Flaig 1 Reputation point
2022-11-09T19:42:15.003+00:00

Hi,

we are running MSSQL on 2x Ubuntu 20.04.5 LTS Virtual Machines.

both machines are set up exactly the same and mssql has been configured and installed the same way - there were no error messages seen

we have a test machine where DTA is working.

on our LIVE Environment we get

Failed to initialize MSD database for tuning (exit code: -1).(DTAClient)  

when we directly try to connect with Database Engine tuning Advisor

and

Unable to find assembly 'DTAClient Version=15.0.0.0., Culture=neutral, PublicKeyToken=....) (mscorlib)  

when we use right-click inside MSSQL Management Studio toAnalyze the Querry in Database Engine Tuning Advisor,

on the other system it just works - on both systems the "sa" account was used. i can't find any error in the logs. how can i debug this further?
what really worries me is that there is no error in the logs and i didnt see any error on installation time.

thank you in advance and kind regards

Marcel

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Marcel Flaig 1 Reputation point
    2022-11-09T19:47:21.927+00:00

    tried with MSSQL Studio in Admin mode and got

    ===================================

    Failed to write to an IPC Port: Die Pipe wird gerade geschlossen.
    (mscorlib)

    ------------------------------

    Program Location:

    Server stack trace:
    at System.Runtime.Remoting.Channels.Ipc.IpcPort.Write(Byte[] data, Int32 offset, Int32 size)
    at System.Runtime.Remoting.Channels.Ipc.PipeStream.Write(Byte[] buffer, Int32 offset, Int32 count)
    at System.Runtime.Remoting.Channels.ChunkedMemoryStream.WriteTo(Stream stream)
    at System.Runtime.Remoting.Channels.Ipc.IpcClientHandler.SendRequest(IMessage msg, ITransportHeaders headers, Stream contentStream)
    at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
    at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

    Exception rethrown at [0]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    at Microsoft.SqlServer.Management.UI.VSIntegration.ISessionController.CreateSessionFromQuery(SqlConnectionInfo connectionInfo, String sqlQuery, String batchSeparator)
    at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnDatabaseTuningAdvisor(Object sender, EventArgs a)

    0 comments No comments

  2. Seeya Xi-MSFT 16,451 Reputation points
    2022-11-10T07:01:07.157+00:00

    Hi @Marcel Flaig ,

    Welcome to Microsoft Q&A! Run the follow query to check the 'DTAClient ' assembly:
    select * from sys.assemblies
    Alternatively, you can run select @@version to see what version you have. If the latest cumulative update is not installed, you can install the latest cumulative update.

    Best regards
    Seeya Xi