Home > Forum > Installation > Portal Failure after Update to BPS 2022.1.3.65

Portal Failure after Update to BPS 2022.1.3.65
0

Good morning,

following information to resolve another issue with one server I updated this from 2022.1.2.59 to 2022.1.3.65, including all pre-requisites.

Installation and database conversion as well as service start went through without error.

But unfortunatly the portal does not come up again; also a connect through Designer Studio fails.

The web browser tells an error: HTTP Error 502.5 - ANCM Out-Of-Process Startup Failure

Investigating this I started the file "" within path "" manually and received the error dump added below.

The sql user can connect with the password given and all rights within sql server are appropriate.

What looks strange is the attempt to reach the server through Named Pipes. This is not configured.


Does anybody have (had) a similar issue and can tell me where to fix the connection string?


Thank you for your help in advance.

Best, Ingo

(Begin Dump)
C:\Program Files (x86)\WEBCON\WEBCON BPS Portal>webcon.bpscloud.portal
URL: http://*:48439
ConnectionString: Data Source=SQLServer;Initial Catalog=BPS_Config_19T;User ID=BPS_SQLUser;Password=xxxx
Unhandled exception. System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
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 WebCon.BPSCloud.Data.Repositories.PortalBaseUrlDownloader.LoadParamFromDb(String prmName)
at WebCon.BPSCloud.Data.Repositories.PortalBaseUrlDownloader.GetPortalBaseUrl()
at WebCon.BPSCloud.Portal.Program.Main(String[] args)
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:53,State:0,Class:20
(End Dump)

In reply to: Michał Bednarz

Hi,
Are you using local sql aliases configured with cliconfg.exe?
In 2022 R3 we use Net 6, and .net 6 can not use local sql aliases.

Hi, wenn I try the connection string manually, this fails: The string for the log thing does use the old alias that I removed.

(Begin Dump)
C:\Program Files (x86)\WEBCON\WEBCON BPS Portal>webcon.bpscloud.portal -c "Data Source=<servername>;Initial Catalog=BPS_Config_19T;User ID=BPS_SQLUser;Password=xxx"
URL: http://*:48439
ConnectionString: Data Source=<servername>;Initial Catalog=BPS_Config_19T;User ID=BPS_SQLUser;Password=xxx
Logs ConnectionString: Data Source=SQLServer;Initial Catalog=BPS_Config_19T;User ID=BPS_SQLUser;Password=xxx
(End Dump)