Error- The CreateJobUser task failed unexpectedly

When running BBInstaller40SP7.exe to install Blackbaud CRM Service Pack 7, this error appears:

Deleting Credential 'BBJobUser' from SQL Server...
Deleting Credential 'BBJobUser_ServerName_40' from SQL Server...
Deleting proxy 'Blackbaud ActiveX Proxy - ServerName_40'
The "CreateJobUser" task failed unexpectedly. 
System.Data.SqlClient.SqlException (0x80131904): Cannot delete proxy (3). It is used by at least one jobstep. Change this proxy for all jobsteps by calling sp_reassign_proxy.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Blackbaud.AppFx.Platform.BuildTasks.CreateJobUser.DeleteExistingProxiesAndCredentials(SqlConnection conn, String proxyName, String credentialName)
   at Blackbaud.AppFx.Platform.BuildTasks.CreateJobUser.Execute()
   at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
   at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__20.MoveNext()
ClientConnectionId:0465aa49-baf3-455d-9e04-a63addfc5e62
Error Number:14518,State:1,Class:16

Process failed.
 
Run the installer as a local admin, not “BBJobUser.” Login as a local admin, and re-try the installation.

This error indicates a problem creating the Job user, and that the account that is running the installer doesn’t have enough rights to create the Job user. BBJobUser doesn’t have enough permissions to complete the installation, because the installation should be run by a local admin. Also, this account is trying to delete and recreate the proxy. This proxy already exists and is being used by at least one job already. 

Steps to Duplicate

1) Login as BBJobUser
2) Run the installer BBInstaller40SP7.exe with the 'AlwaysRecreate' flag turned on
3) Observe error

Environment

 Blackbaud CRM
 4.0
 4.0

Was this article helpful?