Manager Webservices: An internal error occured while processing the request: Connection reset

Products

• CA Automic Dollar Universe

Issue/Introduction

DUAS Web manager is being used successfully to obtain a key for a web process. Recently there have been issues causing uproc to fail with the following message seen in the java manager log.

Later on if the failed uproc, is rerun, then the web connection is successful.

Is there an issue with the DUAS WEB manager being unstable or could this just be an issue with the target URL?

• Java manager log

| 2022-03-31 09:00:07 |WARN | SubmitWorker-DynamicWorkerThread-43 | com.orsyp.mgr4java.engine.requesthandling.RequestHandlingServiceImpl | An internal error occured while processing the request: Connection reset 
com.orsyp.mgr4java.engine.requesthandling.InternalHandlerException: Connection reset

Environment

Release : 6.x

Component : DOLLAR UNIVERSE

Subcomponent: Manager for WebServices

Cause

Third-party issue

Resolution

After some queries at the Webservice side, it appears to concur with an issue on the target server. 

When the following error appeared when the job was launched  in manager4java.log:

| 2022-03-31 09:00:07 |WARN | SubmitWorker-DynamicWorkerThread-43 | com.orsyp.mgr4java.engine.requesthandling.RequestHandlingServiceImpl | An internal error occured while processing the request: Connection reset 
com.orsyp.mgr4java.engine.requesthandling.InternalHandlerException: Connection reset

In webservice logs we could find an error stating that the target SQL Server could not be reached, explaining why the job would fail:

2022-03-31 09:01:15,950 TransactionID=CorrelationID= [25] ERROR Microsoft.EntityFrameworkCore.Query - An exception occurred while iterating over the results of a query forcontext type 'XXX.Security.IdentityServer.Data.IdentityDatabaseContext'.Microsoft.Data.SqlClient.SqlException (0x80131904):A network-related orinstance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.