Error received during a compare session:
"Error. sp_declt did not connect back for table "Schema"."TableName" after 1800 secs. Giving up on this table"
The source compare server process did not receive a reply back from the target compare client process within the specified default 30 minutes (as defined by the source SP_DEQ_TIMEOUT parameter).
When a compare command is issued on the source, a compare process (sp_desvr) is started there, and a message is placed into the queue asking the target to start it's accompanying process (sp_declt). Should the client process (target) not initiate communication with the server (source) before the timeout set by the parameter SP_DEQ_TIMEOUT then this error is raised.
Possible reasons for this error are:
a) The message passing through the queues may have been delayed by a backlog in the queues. Check that the backlog is less than the timeout and if necessary wait for the backlog to go down.
b) A firewall blocked the messages between sp_desvr and sp_declt. These processes communiate via TCP and UDP over a different port to the one used by SharePlex. If the port number was not specified with the compare command syntax, a random port will be used. If there is a firewall then a port will need to be opened in both directions for UDP and TCP traffic, and the port number will need to be specified when the compare command is issued.
c) The sp_declt process may have failed. Check the log directory on the target system for a logfile containing the compare_id as displayed by the show compare command. Examine the logfile for Oracle errors such as lack of sort space and SharePlex messages reporting issues.
d) Network Address Translation will need to be configured if it is being used. Refer to Solution 14809 - Error: "Error. sp_declt did not connect back for table "DW2_DWH"."LK_TIPO_CONTO" after 1800 secs":
https://support.quest.com/SUPPORT/index?page=solution&id=SOL14809
e)Compare could not acquire lock on the table specified in the desvr log.You will also see following entry in the desvr log for this situation
244: NOTE: table/row locked (de_trans_get_read_consistent_view,L1474)
Run compare process when there is less activity on the table.
