Error received from the command "compare table dw2_dwh.LK_TIPO_CONTO to dw2_dwh.LK_TIPO_CONTO target bitdb02@o.dw2prd port 2104 repair ":
"Error. sp_declt did not connect back for table "DW2_DWH"."LK_TIPO_CONTO" after 1800 secs".
We suspect that could be a firewall problem, but we verified that port 2104 is opened.
Customer is running Network Address Translation (NAT) on the Source and Target on both the Source and Target. The Source and Target know each other as different addresses which are usually translated automatically by a firewall/router.
Network Address Translation (NAT) is being used on both the Source and Target, each machine cannot see the other if the default IP's are used (i.e the Source and Target know each other as different addresses which are usually translated automatically by a firewall/router). Compare needs to have some mappings in place, so if the normal IP returns no response, then another IP Address will be used. This has to be done on both Source and Target as they both have NAT.
From Source :
Source_IP_From_Source 10.1.15.10
Target_IP_From_Source 10.2.10.51
From Target :
Source_IP_From_Target 193.2.71.3
Target_IP_From_Target 193.1.71.5
There is a Shareplex parameter which allows IP Translation during the Compare/Repair Process:
To translate the IP on the source - NAT on Target:
sp_ctrl> set param SP_DEQ_IP_MAPPING "<Target_IP_From_Source >:<Target_IP_From_Target>"
To translate the IP on the target - NAT on Source:
sp_ctrl> set param SP_DEQ_IP_MAPPING "<Source_IP_From_Target> :<Source_IP_From_Source>"
This procedure can be used to allow Compare/Repair to work on either:
1. One Way Source.
2. One Way Target.
3. OR both 2 way Source and Target.
