When a connection fails, look at the logs to troubleshoot connection and validation errors. To ensure that the log captures events, turn on debug mode. See “Configuring RepConnector for debugging”.
This is a sample from a log in detail mode.
[RepToEASJMS]: 09:35:32 [INFO] [REP.RepAdapterImpl]: Starting Connection RepToEASJMS. [RepToEASJMS]: 09:35:33 [INFO] [JMS.JMSQueueClient]: Starting the JMS Queue Client. [RepToEASJMS]: 09:35:33 [INFO] [JMS.JMSQueueClient]: JMS Client is configured successfully to be able to send event(s) to queue: INQ for provider iiop://cmercer-xp:9000. [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepAdapterImpl]: Successfully established client connection. [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepMetaConnection]: Executing query: >>>> select dbname from rs_databases where dsname = 'RC25XPEAS' [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepMetaConnection]: Got the new instance of SybDriver [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepMetaConnection]: Got a RSSD connection to URL: jdbc:sybase:Tds:cmercer- pc2:5000/rs125pc_RSSD?SQLINITSTR=set quoted_identifier off Login: sa [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepMetaConnection]: Executing query: >>>> select distinct rs_objects.objname, rs_subscriptions.subid, rs_objects.objid, rs_objects.phys_tablename, rs_objects.deliver_as_name, rs_objects.dbid from rs_repdbs, rs_subscriptions, rs_objects where ((dsname = 'RC25XPEAS' and dbname = 'EAS422') and rs_repdbs.dbid = rs_subscriptions.dbid and rs_subscriptions.type < 8 and rs_subscriptions.objid = rs_objects.objid) union select distinct rs_objects.objname, rs_subscriptions.subid, rs_objects.objid, rs_objects.phys_tablename, rs_objects.deliver_as_name, rs_objects.dbid from rs_repdbs, rs_articles, rs_subscriptions, rs_objects where ((dsname = 'RC25XPEAS' and dbname = 'EAS422') and rs_repdbs.dbid = rs_subscriptions.dbid and rs_subscriptions.type > 8 and rs_articles.articleid = rs_subscriptions.objid and rs_objects.objid = rs_articles.objid) [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepMetaConnection]: Executing query: >>>> select * from rs_columns where objid = 0x010000650000007A order by colnum [RepToEASJMS]: 09:35:33 [DEBUG] [REP.DataServer]: A new RepListener was added to the RepEventStream. [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepEventStream]: Added a Listener without RequiredGroup option [RepToEASJMS]: 09:35:33 [DEBUG] [REP.RepEventStream]: RepAdapterListener requires parsing and meta-data formatting.
[RepToEASJMS]: 09:35:33 [DEBUG] [REP.DataServer]: A new listener is added to the stream object. [RepToEASJMS]: 09:35:34 [DEBUG] [REP.ReplicateDB]: Created the dsi (.ser) file : C:\Program Files\Sybase\EAServer\repra\sers\DSI_RC25XPEAS_EAS422.ser [RepToEASJMS]: 09:35:34 [DEBUG] [REP.RepMetaConnection]: Executing query: >>>> select dsname, dbname from rs_databases where dsname = 'RC25XPEAS' and dbname = 'EAS422' [RepToEASJMS]: 09:35:34 [DEBUG] [REP.DataServer]: Put the DB connection to the Hashtable of ReplicationDBs. [RepToEASJMS]: 09:35:34 [DEBUG] [REP.RepAdapterImpl]: DataServer is now ready. [RepToEASJMS]: 09:35:34 [DEBUG] [REP.DSIReceiver]: jTDS server for DSI RC25XPEAS is ready to listen on port 7051.
