-
Title
Error: "Error. sp_declt did not connect back for table "U1"."TAB1" after 180 secs. Giving up on t -
Description
Compare config did not run successfully for all the tables in the config. Error received in the Desvr log file:
"Error. sp_declt did not connect back for table "U1"."TAB1" after 180 secs. Giving up on this table" -
Cause
Set the SP_DEQ_TIMEOUT too low.
-
Resolution
sp_ctrl>reset param SP_DEQ_TIMEOUT
Description of above parameter:
SP_DEQ_TIMEOUT
This parameter controls the connection timeout for the compare config and compare
table commands. Because the sp_desvr process relies on the replication queues to
instantiate the sp_declt process(es) on the target system, the sp_declt process cannot
start until all previous messages in the queues have been processed. If the delay is
longer than the timeout specified with this parameter, sp_desvr exits and returns an
error.
Default: 1800 seconds (30 minutes)
Range of valid values: 121 seconds or greater
Takes effect: immediately available for the next comparison