When a connection fails

When a connection fails, look at the logs to troubleshoot connection and validation failure. To ensure that the log captures events, turn on debug mode. See “Configuring RepConnector for debugging” for instructions.

Example from repra.log

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