PowerProtect Data Manager: SQL discovery and backups fail with Connection Reset errors
Summary: PowerProtect Data Manager SQL database discovery and backup operations fail with SocketException: Connection reset and ConnectionResetError(10054) errors when the network does not allow bidirectional communication between the PowerProtect Data Manager appliance and the SQL agent host on the required ports. The SQL agent may complete its discovery and backup operations successfully on the host side, but PowerProtect Data Manager cannot retrieve the results because it cannot reach the agent. ...
Symptoms
The PowerProtect Data Manager SQL discovery operations fail. Discovery may complete successfully on the agent side while failing on the PowerProtect Data Manager side. PowerProtect Data Manager SQL backup jobs complete the data move on the SQL host, but copy discovery fails because PowerProtect Data Manager cannot communicate with the agent to retrieve the results. The /var/log/brs/adm/adm.log shows the discovery starting, retrying after connection resets, and ultimately failing after exhausting all 6 retries:
2026-04-06T10:34:21.874Z INFO [] [https-jsse-nio-9001-exec-8] [][][TASK_ID:86b325f2b71f420e][TRACE_ID:901942dfb919ee07;JOB_ID:ac8347392aec07a2][] [c.e.d.e.a.s.s.i.AgentDiscoveryService.startDiscovery(169)] - Starting discovery with host IP=<my-host-ip> and isForceFull=true
2026-04-06T10:35:14.939Z ERROR [] [https-jsse-nio-9001-exec-8] [][][TASK_ID:86b325f2b71f420e][TRACE_ID:901942dfb919ee07;JOB_ID:ac8347392aec07a2][] [c.e.d.e.a.s.s.r.RetryableOperationExecutor.handleApiCallWithRetry(67)] - Caught error while posting ADHOC_DISCOVERY request. Retrying request count 6. Exception is SocketException: Connection reset
2026-04-06T10:35:27.950Z ERROR [] [https-jsse-nio-9001-exec-8] [][][TASK_ID:86b325f2b71f420e][TRACE_ID:901942dfb919ee07;JOB_ID:ac8347392aec07a2][] [c.e.d.e.a.s.s.r.RetryableOperationExecutor.handleApiCallWithRetry(77)] - Maximum of 6 retries exhausted while posting ADHOC_DISCOVERY request.2026-04-06T10:35:27.951Z ERROR [] [https-jsse-nio-9001-exec-8] [][][TASK_ID:86b325f2b71f420e][TRACE_ID:901942dfb919ee07;JOB_ID:ac8347392aec07a2][] [c.e.d.e.a.s.s.i.AgentDiscoveryService.getApiResponse(323)] - Caught exception while making adhoc discovery call: class AdhocDiscoveryRestPayload {
assetType: MSSQL_DATABASE
discoveryType: [APPLICATION_SYSTEMS, ASSETS]
taskId: f9eb4035-52b8-4fe7-a9da-01a66ba51d6e
} to host <my-host-ip> with error {}
com.emc.dpsg.ecdm.adm.schema.client.ApiException: java.net.SocketException: Connection reset
at com.emc.dpsg.ecdm.adm.schema.client.ApiClient.execute(ApiClient.java:692)
The Windows agent OpAgentSvc log at C:\Program Files\DPSAPPS\AgentService\logs\ shows the agent cannot connect back to the PowerProtect Data Manager appliance, reporting a Winsock error 10054 (connection forcibly closed by remote host):
[2026-04-06 10:34:24,880 GMT| 2026-04-06 12:34:24,880593 South Africa Standard Time| DBGHTTPSERVER| PID-8096| TID-7412| ERROR] C:\Program Files\DPSAPPS\AgentService\tmp_MEI19522\Http\HTTP_wrap_context.pyc-wrap_socket()-Line 70- Exception [WinError 10054] An existing connection was forcibly closed by the remote host occurred
Files\DPSAPPS\AgentService\tmp_MEI110122\Http\HTTPServer.pyc-get_ppdm_id_from_ppdm()Line 5608 Error occurred while sending request to PowerProtect Data Manager for fetching ppdm_id: ('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None))
The errors indicate a bidirectional communication failure — PowerProtect Data Manager cannot reach the agent, and the agent cannot reach PowerProtect Data Manager. Both TCP and ICMP connectivity may be blocked.
The agent-side operations (SQL add-on discovery, application system discovery, asset discovery, copies discovery) may complete successfully on the host. The failure occurs when PowerProtect Data Manager attempts to retrieve the results from the agent.
Cause
This is an environment issue, not a software defect. It can occur on any PowerProtect Data Manager release.
The SQL agent host is not reachable from the PowerProtect Data Manager appliance, and/or the PowerProtect Data Manager appliance is not reachable from the SQL agent host. A network configuration prevents bidirectional communication between the two systems on the required ports.
Resolution
Make sure ports 7000 is accessible from the client (SQL host) and 8443 on the server (PPDM appliance).