Resolving some common SQL Errors in Decisions Instance Installation and Login

kimjohn

While performing the installation or logging into the Decisions instance, I am encountering errors like the one below. How can these errors be resolved?

Error1:-

Error2:-

Application '/LM/W3SVC/1/ROOT' with physical root 'C:\Program Files\Decisions\Decisions Server\' failed to load coreclr. Exception message: CLR worker thread exited prematurely Application '/LM/W3SVC/1/ROOT' with physical root 'C:\Program Files\Decisions\Decisions Server\' hit unexpected managed exception, exception code = '0xe0434352'. First 30KB characters of captured stdout and stderr logs: Executing 'LOADING ENVIRONMENT'... Execution time for 'LOADING ENVIRONMENT': 0s Executing 'STARTING HOST INSTANCE'... Unhandled exception. System.Exception: error bootstrapping ---> System.InvalidOperationException: The ConnectionString property has not been initialized. at System.Data.SqlClient.SqlConnection.PermissionDemand() at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at DecisionsFramework.Data.ORMapper.DatabaseDrivers.MsSqlConnectionWrapper.Open() at DecisionsFramework.Data.ORMapper.DatabaseDrivers.DBConnectionLoggin.Open() at DecisionsServiceHost.EnforceDBExists.OpenDatabaseConnection(IORMDatabaseInterface dbDriver, String& dbName) at DecisionsServiceHost.EnforceDBExists.EnforceSQLServerExists(IORMDatabaseInterface dbDriver) at DecisionsServiceHost.EnforceDBExists.Initialize() at DecisionsServiceHost.Instances.Implementations.BaseInstance.ExecuteBootInitializableStepAndCheckRestart(IBootInitializable bootInitializableStep) at DecisionsServiceHost.Instances.Implementations.BaseInstance.Start() at Decisions.Web.Core.DecisionsServer.Start() --- End of inner exception stack trace --- at Decisions.Web.Core.DecisionsServer.Start() at Decisions.Web.Core.Program.Main(String[] args) Execution time for 'STARTING HOST INSTANCE': 16.5002293s Application: w3wp.exe CoreCLR Version: 6.0.522.21309 .NET Version: 6.0.5 Description: The process was terminated due to an unhandled exception. Exception Info: System.Exception: error bootstrapping ---> System.InvalidOperationException: The ConnectionString property has not been initialized. at System.Data.SqlClient.SqlConnection.PermissionDemand() at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at DecisionsFramework.Data.ORMapper.DatabaseDrivers.MsSqlConnectionWrapper.Open() at DecisionsFramework.Data.ORMapper.DatabaseDrivers.DBConnectionLoggin.Open() at DecisionsServiceHost.EnforceDBExists.OpenDatabaseConnection(IORMDatabaseInterface dbDriver, String& dbName) at DecisionsServiceHost.EnforceDBExists.EnforceSQLServerExists(IORMDatabaseInterface dbDriver) at DecisionsServiceHost.EnforceDBExists.Initialize() at DecisionsServiceHost.Instances.Implementations.BaseInstance.ExecuteBootInitializableStepAndCheckRestart(IBootInitializable bootInitializableStep) at DecisionsServiceHost.Instances.Implementations.BaseInstance.Start() at Decisions.Web.Core.DecisionsServer.Start() --- End of inner exception stack trace --- at Decisions.Web.Core.DecisionsServer.Start() at Decisions.Web.Core.Program.Main(String[] args)

amershaik_Decisions

Please check the following for resolving above errors:

1. Check the SQL DB connection string, if there's any parameter missing. e.g. DB name, username and password etc.
2. Check the DB user permissions := db_datawriter, db_datareader, db_ddladmin

kimjohn

Error 3:-

Error in installation","Exception":"System.Net.WebException: No connection could be made because the target machine actively refused it. [::ffff:127.0.0.1]:8083 (localhost:8083).

amershaik_Decisions

It's looks like the port 8083 is being used by another service. Please check by changing the Port and restart the Decisions Instance