Hello;
I cant 15.2 to 15.6.6 upgrade. What can i fix the problem?
Thx
Hello;
I cant 15.2 to 15.6.6 upgrade. What can i fix the problem?
Thx
2024-03-05 15:41:03.147: DACPAC: FAILURE: DACPAC has failed to deploy: Microsoft.SqlServer.Dac.DacServicesException: An error occurred during deployment plan generation. Deployment cannot continue.
Error SQL0: The reference to external elements from the source named 'MobiControlDB_Archive.dacpac' could not be resolved, because no such source is loaded.
Warning SQL72025: No file was supplied for reference MobiControlDB_Archive.dacpac; deployment might fail. When package was created, the original referenced file was located C:\J\WS\MC\AIN\DATABASE\MOBICONTROLDB_ARCHIVE\BIN\RELEASE\MOBICONTROLDB_ARCHIVE.DACPAC.
---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: An error occurred while adding references. Deployment cannot continue.
at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.ThrowIfErrors(String message, ErrorManager errors, Object category)
at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointPackage.DeploymentEndpointReferenceLoader.OnLoaded(ErrorManager errors)
at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointPackage.OnLoad(ErrorManager errors, DeploymentEngineContext context)
at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.PrepareModels()
at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.InitializePlanGeneratator()
at Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateController(Action`1 msgHandler)
at Microsoft.SqlServer.Dac.DacServices.CreateController(SqlDeployment deploymentEngine, ErrorManager errorManager)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dac.DacServices.CreateController(SqlDeployment deploymentEngine, 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.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
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, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
at Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
at Soti.MobiControl.Tools.DacpacInstaller.Program.Main(String[] args)
Ok, sorry I can't help you in this case.
I suggest to reach out to SOTI support for further assistance.
First check: https://soti.net/mc/help/v15.6/en/setup/upgrading/upgrade_errors.html
In the past we had similar issues, best way is to contact SOTI Professional Services as they have a lot of knowledge and sql scripts to check database.
It fixed when i changed os language and region settings English (US or UK)
Hi Sinan,
Thank you for posting on SOTI Pulse. Thanks Simon and Onno for responding to the post, your expertise and willingness to help are greatly appreciated!
If you are still facing the issue, then to address your query, please open a support ticket with SOTI and we will connect you with our dedicated professional services team to investigate this issue and It will be a paid activity as it is an on premise server.