Need help on installing Decipher Server 2.2

[Cloud_777]

We followed the Blue Prism online instruction to install Decipher IDP 2.2.   Now, stuck at Decipher Server installation.  See below details, how to solve the error?  Thanks,

Below is the error message in the log file.

Info: SFXCA: Binding to CLR version v4.0.30319
Info: Calling custom action WixSharp!WixSharp.ManagedProjectActions.WixSharp_BeforeInstall_Action
Info: UPDATING THE DATABASE...!
ActionStart: Action 13:14:51: callAddProgressInfo. Updating database...
Info: Unable to initialize database. Invalid object name 'VersionControl'.
Info: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'VersionControl'.
   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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at SsiServerSetup.Utils.SqlServerUtils.ExecuteDbScriptAndReturnFirstRow(String connectionString, String cmdTxt)
   at SsiServerSetup.Utils.SqlServerUtils.GetDatabaseVersion(String connectionString)
   at SsiServerSetup.Utils.DbSetup.GetDbVersion()
   at SsiServerSetup.Program.BeforeInstall(SetupEventArgs e)
ClientConnectionId:547b2bc6-c2b6-426c-b2d5-6744c9567dba
Error Number:208,State:1,Class:16
Info: CustomAction WixSharp_BeforeInstall_Action returned actual error code 1602 (note this may not be 100% accurate if translation happened inside sandbox)
Info: Action ended 13:14:53: WixSharp_BeforeInstall_Action. Return value 2.

[Athiban_Mahamathi]

Hello Eric,

Are you using the same DB connection for BP, Licensing Service and Server Service? 

------------------------------
Athiban Mahamathi ,
SimplifyNext,
Technical Consultant
------------------------------

[Cloud_777]

yes, same DB connection for all three.  And by following the instructions, BP, Licensing Services were installed successfully..

------------------------------
Eric Dong
Solution Designer
RBC
America/Toronto
------------------------------

[lookman]

Hi Eric.

If you do not get past this, open a ticket with support as Decipher installation issues is something they are very good with.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[hg_OAS]

Hi Eric, Did you ever get confirmation on what the cause of this was? We're seeing the same error for the same situation (same DB connection used for all three, only have issues with Server). Thanks in advance!

------------------------------
Harriet Gray
------------------------------

[Cloud_777]

It turned out that the ID we used to setup the Decipher did not have the create DB SQL server role. Once that was fixed, then we were able to install the 

Decipher Server successfully. 

------------------------------
Eric Dong
Solution Designer
RBC
America/Toronto
------------------------------

[hg_OAS]

Thanks for the reply Eric, really appreciate it! Not our problem as we've checked the permissions, but thank you anyway. 🙂

------------------------------
Harriet Gray
------------------------------

[ines_99]

Hello,
We have the same problem. Were you able to fix this problem?