topic Re: RE: Need help on installing Decipher Server 2.2 in Product Forum

Need help on installing Decipher Server 2.2

Cloud_777 — Tue, 20 Jun 2023 17:23:00 GMT

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.

RE: Need help on installing Decipher Server 2.2

Athiban_Mahamathi — Wed, 21 Jun 2023 03:07:00 GMT

Hello Eric,

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

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

RE: Need help on installing Decipher Server 2.2

Cloud_777 — Wed, 21 Jun 2023 13:18:00 GMT

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
------------------------------

RE: Need help on installing Decipher Server 2.2

lookman — Wed, 21 Jun 2023 14:23:00 GMT

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
------------------------------

RE: Need help on installing Decipher Server 2.2

hg_OAS — Tue, 12 Mar 2024 23:13:00 GMT

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
------------------------------

RE: Need help on installing Decipher Server 2.2

Cloud_777 — Wed, 13 Mar 2024 12:04:00 GMT

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
------------------------------

RE: Need help on installing Decipher Server 2.2

hg_OAS — Wed, 13 Mar 2024 23:00:00 GMT

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

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

Re: RE: Need help on installing Decipher Server 2.2

ines_99 — Wed, 27 Mar 2024 14:41:10 GMT

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