SOTI Installation Error Database

SOTI Installation Error Database

Hi,

does anyone have any idea how to solve this or what this exactly means in detail?

 

Thanks,

 

11 Answers

Order By:   Standard | Newest | Votes
christopheBERNARD | posted this 22 April 2021

Hello,

on the server there is a log file on the root c:\,  open it and see the details of the error.

 

thanks

  • 0
  • 1
Marcus Breitenthaler | posted this 22 April 2021

Hi,

 

correct the File is under C:\DBInstall.log

Question from My Side.

What Version MobiControl are you try to Install?

What Server Version are you Using ? Windows Server 2016 / 2019 ?

Local SQL Server Express with the installer or did yu have installed a Version on the Server?

 

  • 0
  • 1
Benjamin, Wilts | posted this 22 April 2021

Hi,

 

thanks for the answer.

 

Mobi: 15.3

Server 2019

SQL Express Installation local

From the log I get the following


"2021-04-21 12:12:41.401:    DACPAC: FAILURE: DACPAC has failed to deploy: Microsoft.SqlServer.Dac.DacServicesException: An error occurred during deployment plan generation. Deployment cannot continue.
Error SQL72018: Permission could not be imported but one or more of these objects exist in your source.
 ---> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Errors occurred while modeling the target database.  Deployment can not continue.
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.ThrowIfErrors(String message, ErrorManager errors, Object category)
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeploymentEndpointServer.OnLoad(ErrorManager errors, DeploymentEngineContext context)
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.PrepareModels()
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.InitializePlanGeneratator()
   bei Microsoft.Data.Tools.Schema.Sql.Deployment.SqlDeployment.CreateController(Action`1 msgHandler)
   bei Microsoft.SqlServer.Dac.DacServices.CreateController(SqlDeployment deploymentEngine, ErrorManager errorManager)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei Microsoft.SqlServer.Dac.DacServices.CreateController(SqlDeployment deploymentEngine, ErrorManager errorManager)
   bei Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<>c__DisplayClass5.<CreatePlanInitializationOperation>b__1()
   bei Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
   bei Microsoft.SqlServer.Dac.DeployOperation.<>c__DisplayClass3.<CreatePlanInitializationOperation>b__0(Object operation, CancellationToken token)
   bei Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.ReportMessageOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.DeployOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
   bei Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
   bei Microsoft.SqlServer.Dac.DacServices.InternalDeploy(IPackageSource packageSource, Boolean isDacpac, String targetDatabaseName, DacDeployOptions options, CancellationToken cancellationToken, DacLoggingContext loggingContext, Action`3 reportPlanOperation, Boolean executePlan)
   bei Microsoft.SqlServer.Dac.DacServices.Deploy(DacPackage package, String targetDatabaseName, Boolean upgradeExisting, DacDeployOptions options, Nullable`1 cancellationToken)
   bei Soti.MobiControl.Tools.DacpacInstaller.Program.Main(String[] args)
2021/04/21 12:12:43.636(0x00001948):     ERROR: DACPAC deployment failed with error -1
2021/04/22 08:43:22.546(0x00000f84):     EVENT: [FeatureToggles] Toggles '' are read from command line:
2021/04/22 13:03:49.746(0x00000790):     EVENT: [FeatureToggles] Toggles '' are read from command line: "

  • 0
  • 0
Marcus Breitenthaler | posted this 22 April 2021

HI Benjamin,

 

did you try to Upgrade an existing MobiControl Installation?

Is the SQl Server 2016 Express installed?

Did you use the 15.3.1 installer ?

  • 0
  • 0
Benjamin, Wilts | posted this 23 April 2021

Hi Marcus,

I'm trying to "reinstall" Mobicontrol with another database I restored from a customer. SQL Express 2016 is installed.

I used the 15.3 installer, not the 15.3.1 installer.

  • 0
  • 0
Yoan R | posted this 23 April 2021

Hi Benjamin, it could be a user/permissions issue.

Database Permissions

When installing SOTI MobiControl, you must be either a SysAdmin or a DbCreator with additional ALTER ANY LOGIN permissions. When upgrading SOTI MobiControl, you must also have ALTER DATABASE permissions.

When performing regular operations for SOTI MobiControl Main and Archive databases, the user must have the following permissions:

Db_datareader
Db_datawriter
Permission for execution of all procedures

If possible, use an SA account for authentication. SA user accounts contain the right set of permissions to guarantee the proper functionality of SOTI MobiControl services. These credentials are not stored by SOTI MobiControl so store them in a safe place that is available to your organization.

  • 0
  • 0
Benjamin, Wilts | posted this 23 April 2021

Ok,

can I just add an SA User to the customers database after restoring? So that the user has enough priviliges? As I don't have a user from the customer.

  • 0
  • 0
Yoan R | posted this 23 April 2021

I guess yes.

All you need is a sa user so you can specify it in the installation wizard

  • 0
  • 0
Benjamin, Wilts | posted this 23 April 2021

Thank you,

 

will give it a try.

  • 0
  • 0
JCMOD@SOTI | posted this 26 April 2021

Hi Benjamin,

 

Could you try upgrading your SQL Server to the latest cumulative update?

 

Regards,

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |

  • 0
  • 0
Benjamin, Wilts | posted this 27 April 2021

Hi,

 

it's already on the newest one.

  • 0
  • 0

Give us your feedback
Give us your feedback
Feedback