D365 - Deploying entity store error

Finance and Operations/AX Developer Forum
1

Hello,

im trying to deploy a entity store *.bacpac to azure SQL, i get this error below, what to do ?

The type initializer for ‘Microsoft.SqlServer.Dac.BacPackage’ threw an exception. —> System.TypeInitializationException:
The type initializer for ‘Microsoft.SqlServer.Dac.DacServices’ threw an exception. —> System.TypeInitializationException:
The type initializer for ‘SqlSchemaModelStaticState’ threw an exception. —> System.IO.FileNotFoundException:
Could not load file or assembly ‘Microsoft.SqlServer.TransactSql.ScriptDom, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlCoreAnnotationRegister.RegisterModelAnnotations(ModelSchema storeSchema)
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchemaModel.SqlSchemaModelStaticState.RegisterModelSchema()
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchemaModel.SqlSchemaModelStaticState…cctor()
— End of inner exception stack trace —
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchemaModel.SqlSchemaModelStaticState.get_ModelSchema()
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchemaModel.InitializeModelSchema()
at Microsoft.SqlServer.Dac.DacServices…cctor()
— End of inner exception stack trace —
at Microsoft.SqlServer.Dac.DacServices.Initialize()
at Microsoft.SqlServer.Dac.BacPackage…cctor()
— End of inner exception stack trace —
at Microsoft.SqlServer.Dac.BacPackage.Load(String fileName, DacSchemaModelStorageType modelStorageType)
at Microsoft.Data.Tools.Schema.CommandLineTool.Program.<>c__DisplayClass3e.b__39()
at Microsoft.Data.Tools.Schema.CommandLineTool.ValidationUtil.SafeFileAccessWrapper(Func1 action, Action1 reportException)
at Microsoft.Data.Tools.Schema.CommandLineTool.Program.DoImportBacpacOperation(CommandLineArguments parsedArgs)
at Microsoft.Data.Tools.Schema.CommandLineTool.Program.PerformAction(CommandLineArguments parsedArgs)
at Microsoft.Data.Tools.Schema.CommandLineTool.Program.Run(String[] args)
at Microsoft.Data.Tools.Schema.CommandLineTool.Program.Main(String[] args)

2

The key part is this: “Could not load file or assembly Microsoft.SqlServer.TransactSql.ScriptDom or one of its dependencies”.
It seems that your system doesn’t contain all necessary libraries.
Consider using Assembly Binding Log Viewer in cases like this.