000013258 - While trying to add an additional replica: 'No more data to read from socket'

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000013258
Applies ToAuthentication Manager 7.1 SP2
While trying to add an additional replica to an AM 7.1 SP2 system, the process aborts with the following error message:
Caused by: org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{call DBMS_STREAMS_ADM.ADD_SCHEMA_RULES( ?, ?, ?, ?, ?, include_dml => TRUE, include_ddl => TRUE, include_tagged_lcr => TRUE, inclusion_rule => TRUE) }]; SQL state [null]; error code [17410]; No more data to read from socket; nested exception is java.sql.SQLException: No more data to read from socket

Please verify that replication amongst already configured replicas is working correctly. Run the following command on the primary:
AM_HOME\utils\rsautil manage-database -a exec-sql -U com.rsa.replication.admin -f diagnostics\primary_replication_status.sql

The status on at least one of the replica might be shown as follows:
remote_apply_status => ABORTED 
remote_apply_error => ORA-26714: User error encountered while applying 
remote_apply_time => 21-03-2010 02:23:26 PM 
remote_apply_timeout => TIMEOUT 
remote_heartbeat_received_time => 21-03-2010 06:12:23 AM +08

Please note the remote_apply_time time value. It is possible that replication against this replica stopped working correctly when a replica was previously added to the system.

remote_apply_status => ABORTED 
cannot add additional replica
No more data to read from socket
Legacy Article IDa50329