Error received during Compare causing it to fail:
"Line: 15716 - 06/28/06 21:45 Internal error: sp_declt did not connect back for table "xxxxx."xxxxxxx", going on to next table if any [sp_desvr(deq)/21827]"
- Backlog Messages in the queues.
- Connectivity issues between the source and target
This error indicates that the compare process started on the source, but didn't receive a message back from the target compare client. There are two main reasons this happens.
The first scenario is that the target compare client is started by passing a request via the queues for this process to be spawned. If there is a backlog in the queue, and a message cannot be passed through the queue in less than 30 minutes, then this eror will occur.
The second scenario is that the target compare client did start, and it tried to talk back to the source on a different IP port than the one the queues are using, and this failed because of a firewall. If there is a firewall between the source and target, we need an additional port opened between the systems for compare to run. You can specify the port number to use as part of the compare command on the source.
