none
Azure Elastic DB Jobs Fails With Dacpac RRS feed

  • Question

  • I’m trying to push dacpac elastic database jobs through powershell. The dacpac was created against the AdventureWorksLT sample that you can deploy with a new Azure Sql Database and was uploaded to a publicly available Azure Blob. I’ve followed the instructions here to download the Powershell modules and created a new Elastic Database Manager thingy (cloud service, etc.) to manage the jobs. I’ve also followed the instructions laid out by a number of articles to create a custom database collection and kick-off a new job. The following article is basically what I did, with the exception of creating a dacpac ‘Content’ with the as opposed to a script: https://blogs.msdn.microsoft.com/azuresqlemea/2016/11/04/elastic-database-jobs-sample-for-running-t-sql-code-on-multiple-databases/ Everything goes fine, however, the child targets are continually failing with the below message. I’m wondering if the worker roles that execute the jobs are out of date, but I’m at a loss. The same dacpac upgrades the Azure Sql Database through my local SSMS.

    System.AggregateException: One or more errors occurred. ---> Microsoft.Azure.SqlDatabase.Jobs.Common.UserException: An exception occured while executing command on behalf of the user. See inner exception for details. ---> Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. ---> Microsoft.Data.Tools.Schema.Extensibility.ExtensibilityException: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. at Microsoft.Data.Tools.Schema.Extensibility.ExtensionTypeLoader.InstantiateDatabaseSchemaProvider(String databaseSchemaProviderType) at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager.UpdateExtensions() at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager..ctor(String databaseSchemaProviderType) at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager.GetExtensionManager(String dsp) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateExtensionManagerFromModel(SqlPackage package) --- End of inner exception stack trace --- at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateExtensionManagerFromModel(SqlPackage package) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointPackage.OnInit(ErrorManager errors, String targetDBName) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment..ctor(SqlDeploymentConstructor constructor) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentConstructor.ConstructServiceImplementation() at Microsoft.SqlServer.Dac.DacServices.CreatePackageToDatabaseDeployment(String connectionString, IPackageSource packageSource, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, ErrorManager errorManager) at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<>c__DisplayClass5.<createplaninitializationoperation>b__1() at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action) at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<createplaninitializationoperation>b__0(Object operation, CancellationToken token) at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) --- End of inner exception stack trace --- at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken) at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext) at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken) at Microsoft.Azure.SqlDatabase.Jobs.Common.DacpacTaskExecutor.<executeasync>d__0.MoveNext() in d:\_Bld\8084\4135\Sources\Src\FleetManagement\ScriptExecution\ScriptExecutionCommon\JobTaskExecutors\DacpacTaskExecutor.cs:line 50 --- End of inner exception stack trace --- at Microsoft.Azure.SqlDatabase.Jobs.Common.DacpacTaskExecutor.<executeasync>d__0.MoveNext() in d:\_Bld\8084\4135\Sources\Src\FleetManagement\ScriptExecution\ScriptExecutionCommon\JobTaskExecutors\DacpacTaskExecutor.cs:line 78 --- End of inner exception stack trace --- ---> (Inner Exception #0) Microsoft.Azure.SqlDatabase.Jobs.Common.UserException: An exception occured while executing command on behalf of the user. See inner exception for details. ---> Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. ---> Microsoft.Data.Tools.Schema.Extensibility.ExtensibilityException: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. at Microsoft.Data.Tools.Schema.Extensibility.ExtensionTypeLoader.InstantiateDatabaseSchemaProvider(String databaseSchemaProviderType) at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager.UpdateExtensions() at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager..ctor(String databaseSchemaProviderType) at Microsoft.Data.Tools.Schema.Extensibility.ExtensionManager.GetExtensionManager(String dsp) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateExtensionManagerFromModel(SqlPackage package) --- End of inner exception stack trace --- at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateExtensionManagerFromModel(SqlPackage package) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointPackage.OnInit(ErrorManager errors, String targetDBName) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment..ctor(SqlDeploymentConstructor constructor) at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentConstructor.ConstructServiceImplementation() at Microsoft.SqlServer.Dac.DacServices.CreatePackageToDatabaseDeployment(String connectionString, IPackageSource packageSource, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, ErrorManager errorManager) at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<>c__DisplayClass5.<createplaninitializationoperation>b__1() at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action) at Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<createplaninitializationoperation>b__0(Object operation, CancellationToken token) at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) --- End of inner exception stack trace --- at Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context) at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken) at Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacAzureDatabaseSpecification creationDefaults, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext) at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken) at Microsoft.Azure.SqlDatabase.Jobs.Common.DacpacTaskExecutor.<executeasync>d__0.MoveNext() in d:\_Bld\8084\4135\Sources\Src\FleetManagement\ScriptExecution\ScriptExecutionCommon\JobTaskExecutors\DacpacTaskExecutor.cs:line 50 --- End of inner exception stack trace --- at Microsoft.Azure.SqlDatabase.Jobs.Common.DacpacTaskExecutor.<executeasync>d__0.MoveNext() in d:\_Bld\8084\4135\Sources\Src\FleetManagement\ScriptExecution\ScriptExecutionCommon\JobTaskExecutors\DacpacTaskExecutor.cs:line 78<--- </executeasync></executeasync></createplaninitializationoperation></createplaninitializationoperation></executeasync></executeasync></createplaninitializationoperation></createplaninitializationoperation>

    Thursday, March 9, 2017 4:04 PM

All replies