2651598 - Connection error messages returned by DATA ASSURANCE are difficult to diagnose - SRS Data Assurance Option

• When there is a connection or network problem, the message which reports the problem is not easy to identify in errorlog of Data Assurance:

W 2018-04-03 07:05:15.015 SERVER ProfileModule.verifyAgentProfile@223377 MY_AGENT_NAME: Could not connect to agent "MY_AGENT_NAME" (rmi://dest_machine_name.dom.ms.com:5555).
S 2018-04-03 22:09:41.041 CONTAINER ServerContextFacadeBase.a@81 Exception creating connection to: dest_machine_name.dom.ms.com; nested exception is:
 java.net.SocketTimeoutException: connect timed out (local port 63728 to address XXX.XXX.XXX.XXX (src_machine_name.dom.ms.com), remote port 5555 to address YYY.YYY.YYY.YYY (dest_machine_name.dom.ms.com))

• When a script (which do a lot of comparison over the broken connection) is executed, we will have thousands of rows like below:

A 2018-04-04 05:55:05.005 AUDIT SystemDatabaseModule.backup@260437 #275 User "da_admin" creating DASD backup in directory: /d/ny20db172/d1/syb/server/DAP_NYENG02/dasd/backup/1522821305869
I 2018-04-04 05:55:05.005 DASD SystemDatabaseModule.backup@260437 #172 Backing up current DASD to /d/ny20db172/d1/syb/server/DAP_NYENG02/dasd/backup/1522821305869
I 2018-04-07 03:00:23.023 CLT AccessMethod.executeStatement@370588

create compareset _20180407__a2oltp_ foreach table
with source NYP_DARWIN__a2oltp dbo
target HKP_CRD_1__a2query dbo
and target HKP_CRD_2__a2query dbo
and target HKP_CRD_3__a2query dbo
../..
and target NYP_CRD_14__a2query dbo
and target NYP_CRD_15__a2query dbo
exclude rs_* and dba*
I 2018-04-07 03:00:23.023 CLT AccessMethod.executeStatement@370588 java.lang.RuntimeException: LNP_CRD_1__a2query
 at com.sybase.da.server.profile.ProfileModule.getTableMetadata(Unknown Source)
 at com.sybase.da.job.CompareSetModule.a(Unknown Source)
 at com.sybase.da.job.CompareSetModule.createComparesetForeach(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.sybase.da.fw.SecurityCheckRemoteImpl.exec(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.sybase.da.fw.ServerContextImpl$c.invoke(Unknown Source)
 at com.sun.proxy.$Proxy39.exec(Unknown Source)
 at com.sybase.da.fw.SecureServerContext$ManagerInterceptor.a(Unknown Source)
 at com.sybase.da.fw.SecureServerContext$ManagerInterceptor.invoke(Unknown Source)
 at com.sun.proxy.$Proxy40.createComparesetForeach(Unknown Source)
 at com.sybase.da.clt.statement.CreateComparesetForeachStatement.execute(Unknown Source)
 at com.sybase.da.clt.tds.AccessMethod.executeStatement(Unknown Source)
 at com.sybase.da.clt.tds.DATDSHandler.handleLanguage(Unknown Source)
 at com.sybase.jdbc4.tds.SrvReceiver.language(SrvReceiver.java:532)
 at com.sybase.jdbc4.tds.SrvSession.fireEvent(SrvSession.java:682)
 at com.sybase.jdbc4.tds.SrvSession.processRequests(SrvSession.java:215)
 at com.sybase.jdbc4.tds.SrvSession.run(SrvSession.java:203)
 at java.lang.Thread.run(Thread.java:812)
Caused by: java.lang.IllegalArgumentException: LNP_CRD_1__a2query
 at com.sybase.da.agent.conn.ConnectionManager.getAdapter(Unknown Source)
 at com.sybase.da.agent.impl.AbstractAgentModule.getMetadata(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.sybase.da.fw.SecurityCheckRemoteImpl.exec(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.sybase.da.fw.ServerContextImpl$c.invoke(Unknown Source)
 at com.sun.proxy.$Proxy9.exec(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:324)
 at sun.rmi.transport.Transport$1.run(Transport.java:200)
 at sun.rmi.transport.Transport$1.run(Transport.java:197)
 at java.security.AccessController.doPrivileged(Native Method)
 at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
 at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
 at java.security.AccessController.doPrivileged(Native Method)
 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:812)
 at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:276)
 at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:253)
 at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:162)
 at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
 at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
 at com.sun.proxy.$Proxy31.exec(Unknown Source)
 at com.sybase.da.fw.client.ClientServerContextFacade$ManagerInterceptor.a(Unknown Source)
 at com.sybase.da.fw.client.ClientServerContextFacade$ManagerInterceptor.invoke(Unknown Source)
 at com.sun.proxy.$Proxy32.getMetadata(Unknown Source)
 ... 24 more

I 2018-04-07 03:00:29.029 CLT AccessMethod.executeStatement@370593

• This kind of stacks is repeated many time, and fill the errorlog with thousands of rows.

SAP Replication Server (SRS) 16.0 - Data Assurance Option

DATA ASSURANCE, DA, Rep Server, Replication Server, SRS, error, CR#815276, 815276 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement