SAP Knowledge Base Article - Preview

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

Symptom

  • 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.

Read more...

Environment

SAP Replication Server (SRS) 16.0 - Data Assurance Option

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.