Skip to main content
To homepage To homepage
Solved

Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll'

  • September 8, 2020
  • 2 replies
  • 105 views
M
Starter
  • mgc
  • Starter
  • 1 reply

I have enabled simple mode on a project with 1 data source and 1 Business Unit. 

I have also updated the settings for all tables to support simple mode:

When i try to deploy the project i get the error:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. The specified module could not be found.

Location: Business Unit 'ABC'.

Details:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. The specified module could not be found.
Module: mscorlib
System.IO.FileNotFoundException
at System.Reflection.RuntimeAssembly.GetType(RuntimeAssembly assembly, String name, Boolean throwOnError, Boolean ignoreCase, ObjectHandleOnStack type)
at System.Reflection.RuntimeAssembly.GetType(String name, Boolean throwOnError, Boolean ignoreCase)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
at Microsoft.SqlServer.Management.Common.ServerConnection.BeginTransaction()
at TimeXtender.Sql.Engine.SqlEngineBase.InitializeFromSqlServer(SqlServer sqlServer)
at TimeXtender.DataManager.DataSource_Sql.GetSqlEngine(Boolean startTransaction, Boolean singleConnection)
at TimeXtender.DataManager.StepTableSimpleDeploy.DoAbstractStep(StepSetup stepSetup)

Environment:

SQL Server 2019

TineXtender 20.5.7.64

 

Best answer by Anonymous

Hi, this kind of error is usually not related to Simple mode but to some SQL Server components missing (SMO and CLRtype) that you need to install.

You can find more info and details here:

https://legacysupport.timextender.com/hc/en-us/articles/360046007931-Error-Could-not-load-file-or-assembly-Microsoft-SqlServer-BatchParser-dll-

 

View original
    Did this topic help you find an answer to your question?

    2 replies

    A
    • Anonymous
    • 0 replies
    • Answer
    • September 8, 2020

    Hi, this kind of error is usually not related to Simple mode but to some SQL Server components missing (SMO and CLRtype) that you need to install.

    You can find more info and details here:

    https://legacysupport.timextender.com/hc/en-us/articles/360046007931-Error-Could-not-load-file-or-assembly-Microsoft-SqlServer-BatchParser-dll-

     

    M
    Starter
    • mgc
    • Author
    • Starter
    • 1 reply
    • September 8, 2020

    Thanks for the quick response, your solution fixed the problem.

    I assumed because i run SQL 2019 i shouldn't install the 2016 feature pack.

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings