One of our secondary servers was in transit for a couple of weeks to a remote location.
It’s a satellite link, so not very strong. Currently the status in
spdiagdrs is as follows:
GlobalData Replication Status
Secondary to P01 – Error
P01 to Secondary – Failed
Site Data Replication Satus
Not Applicable
Rcmctrl.log on Primary:
- ERROR: Replication group "Secondary Site Data" has failed to initialize for subscribing Secondary, setting link state to Error.
Rcmctrl.log on Secondary
- ERROR: Replication group "Secondary Site Data" has failed to initialize for subscribing site Secondary, setting link state to Error.
The Replication link analyser recommends reinitializing the Secondary Site Data. Upon execution the sender on P01 sends about 15mb of data to the Secondary without errors. It takes 2 – 5 minutes for it to finish sending.
In the rcmctrl.log file on the Secondary you can see the reinitializing begin to take place with:
- Building request init for 87 tables in publication Secondary Site Data from site P01.
- ColumnXML output: <TABLE NAME="ActiveDirectoryForestPublishingStatus"><COLUMN COLUMN_ID="1" NAME="FORESTID" TYPENAME="int" TYPEID="56" MAX_LENGTH="4" IS_NULLABLE="0" HAS_DEFAULTVALUE="0" /><COLUMN
(snip)
And then the following errors appear:
(snip)
- Removing old data for global table ... [~~ WHILE EXISTS (SELECT * FROM [PkgPrograms_G])~~
BEGIN~~DELETE TOP(1000) [PkgPrograms_G] ~~ END~~ ] Rowcount from file [E:\ SCCM\inboxes\rcm.box\D57735B4-579B-4D65-911C-88BA7D6512F3\PkgPrograms_G.bcp.rowcount]
is [294].
- CSqlBCP::BCPIN: bcp_exec failed.
- *** DRS_Init_BCPIN() failed
- *** BCP fails due to internal sql error. Check if this table has a trigger failed to execute. CBulkInsert::DRS_Init_BCPIN : Failed to
BCP in
- BCP in result is 2147500037.
- ERROR: Failed to BCP in for table PkgPrograms_G with error code 2147500037.
- ERROR: Failed to apply BCP for all articles in publication Secondary Site Data.
- Info: Currently Site SECONDARY is initializing Site Control Data. Can't get Master SCF from database at this time. Will try later.
- STATMSG: ID=7806 SEV=E LEV=M SOURCE="SMS Server" COMP="" SYS=Secondary.server.domain SITE=SECONDARY PID=1652 TID=4588 GMTDATE=Sat Nov 03 17:18:29.507 2012 ISTR0="Secondary Site Data" ISTR1="P01" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8=""
ISTR9="" NUMATTRS=0
- ERROR: Replication group "Secondary Site Data" has failed to initialize for subscribing site Secondary, setting link state to Error.
The folder (inboxes\rcm.box\ D57735B4-579B-4D65-911C-88BA7D6512F3) on the Secondary remains there until reinitialization, and then disappear once the new folder is created and initialized.
When running RLA again it fails with the following message:
Replication initialization is unable to apply replication package from site P01 to Secondary for the replication groups: Secondary Site Data (Tables: PkgPrograms_G). Replication link analyser is unable to remediate this issue.
Eventually RLA gets to a point where it will recommend to reinitialize and the cycle above starts again.
BCP fails on table PkgPrograms_G every time.
Thanks for your time.
