Enterprise Replication Error

Hi, The error "Enterprise replication is not active" is resolved and i am getting another error. I will explain it briefely here. I have two hosts dhl-3l and dhl-6a. Sqlhosts for dhl-3l cia32_3l group - - i=125 cia32_1 onsoctcp dhl-3l cia32_soc g=cia32_3l cia32_6a group - - i=126 cia32_2 onsoctcp 16.138.144.70 cia32_soc1 g=cia32_6a Sqlhosts for dhl-6a cia32_6a group - - i=126 cia32_2 onsoctcp dhl-6a cia32_soc1 g=cia32_6a cia32_3l group - - i=125 cia32_1 onsoctcp dhl-3l cia32_soc g=cia32_3l i made the both the servers online and issued the repl commands as from dhl-3l 1) cdr define server --init cia32_3l This initialized the ER on dhl-3l 2) cdr define server --connect=cia32_2 --init --sync cia32_3l cia32_6a the errors are as follows on dhl-6a 11:10:02 CDR queue memory reduced to 9000K bytes (30% of physical log) 11:10:02 Building 'syscdr' database ... 11:10:02 'syscdr' database built successfully. 11:10:02 CDR queuer initialization complete 11:10:02 CDR connection to server lost, id 125, name <cia32_3l> Reason: Connect failed reason: 7 11:10:02 CDR GC: operation sync connect failed (error 5). 11:10:02 CDR GC: synchronization failed (sync abort, shutting down CDR) 11:10:02 CDR NIF Shutdown: connections all shutdown. 11:10:02 CDR The NIF sub-component has shut down. 11:10:02 CDR shutdown complete Any parameter to set or am i doing something wrong. Bye.

--0__=09BBE51DDFF802648f9e8a93df938690918c09BBE51DDFF80264 Content-type: multipart/alternative; Boundary="1__=09BBE51DDFF802648f9e8a93df938690918c09BBE51DDFF80264" --1__=09BBE51DDFF802648f9e8a93df938690918c09BBE51DDFF80264 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable You were able to get through the bulk of the initialization, but were n= ot able to SYNC with you sync server. You need to look at the log on cia32_31. When the network connection was attempted, it was rejected. = By looking in the log of the sync server, you might get some idea of the r= oot cause of the problem. Once that issue is resolved, then things should = work ok. M.P. = "PARAMESHWAR...." = <pcdudyala@yahoo. = com> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Enterprise Replication Error = 01/19/2005 12:19 [4040] = AM = = = = = = Hi, The error "Enterprise replication is not active" is resolved and i am getting another error. I will explain it briefely here. I have two hosts dhl-3l and dhl-6a. Sqlhosts for dhl-3l cia32_3l group - - i=3D125 cia32_1 onsoctcp dhl-3l cia32_soc g=3Dcia32_3l cia32_6a group - - i=3D126 cia32_2 onsoctcp 16.138.144.70 cia32_soc1 g=3Dcia32_6a Sqlhosts for dhl-6a cia32_6a group - - i=3D126 cia32_2 onsoctcp dhl-6a cia32_soc1 g=3Dcia32_6a cia32_3l group - - i=3D125 cia32_1 onsoctcp dhl-3l cia32_soc g=3Dcia32_3l i made the both the servers online and issued the repl commands as from= dhl-3l 1) cdr define server --init cia32_3l This initialized the ER on dhl-3l 2) cdr define server --connect=3Dcia32_2 --init --sync cia32_3l cia32_6= a the errors are as follows on dhl-6a 11:10:02 CDR queue memory reduced to 9000K bytes (30% of physical log)= 11:10:02 Building 'syscdr' database ... 11:10:02 'syscdr' database built successfully. 11:10:02 CDR queuer initialization complete 11:10:02 CDR connection to server lost, id 125, name <cia32_3l> Reason: Connect failed reason: 7 11:10:02 CDR GC: operation sync connect failed (error 5). 11:10:02 CDR GC: synchronization failed (sync abort, shutting down CDR= ) 11:10:02 CDR NIF Shutdown: connections all shutdown. 11:10:02 CDR The NIF sub-component has shut down. 11:10:02 CDR shutdown complete Any parameter to set or am i doing something wrong. Bye. = --1__=09BBE51DDFF802648f9e8a93df938690918c09BBE51DDFF80264 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>You were able to get through the bulk of the initialization, but wer= e not able to SYNC with you sync server. You need to look at the log o= n cia32_31. When the network connection was attempted, it was rejected= . By looking in the log of the sync server, you might get some idea of= the root cause of the problem. Once that issue is resolved, then thin= gs should work ok.<br> <br> <br> M.P. <br> <br> <img src=3D"cid:10__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for &quot;PARAMESHWAR..= ..&quot; &lt;pcdudyala@yahoo.com&gt;">&quot;PARAMESHWAR....&quot; &lt;p= cdudyala@yahoo.com&gt;<br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE51= DDFF802648f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">&quot;PARAMESHWAR....&quot; &lt;pcdudyala@yahoo= .com&gt;</font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: forum.subscriber@iiug.org</font> <p><font size=3D"2">01/19/2005 12:19 AM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ids@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D09BBE51DDFF802648f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Enterprise Replication Error [4040]</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE51DDFF8= 02648f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBE51DDFF802648f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Hi,<br> <br> The error &quot;Enterprise replication is not active&quot; is resolved = and i am getting another error. I will explain it briefely here.<br> <br> I have two hosts dhl-3l and dhl-6a.<br> <br> Sqlhosts for dhl-3l<br> <br> cia32_3l &nbsp; &nbsp; group &nbsp; &nbsp; &nbsp; - &nbsp; &nbsp; &nbsp= ; &nbsp;- &nbsp; &nbsp; i=3D125<br> cia32_1 &nbsp;onsoctcp &nbsp; &nbsp; dhl-3l &nbsp;cia32_soc &nbsp;g=3Dc= ia32_3l<br> cia32_6a &nbsp; &nbsp; group &nbsp; &nbsp; &nbsp; - &nbsp; &nbsp; &nbsp= ; &nbsp;- &nbsp; &nbsp; i=3D126<br> cia32_2 &nbsp;onsoctcp &nbsp; &nbsp; 16.138.144.70 &nbsp;ci

Hi, One solution is that both servers must have the same date and time. Trust relations between servers. Hope this helps.