August 25, 2009 at 8:42 am
We currently have 6 subscribers to our main home office set up with transactional subscriptions with queued updating.
A few days ago, we started seeing 'Unexpected Synctran Procedure' errors, and couldn't resolve them or find any information on why they occured. In order to get things running smoothly, I dumped the msreplication_queue tables on each subscriber to another database and dropped and recreated the publications.
All subscribers have been reinitialized, and I have dumped the replication_queue backup table back in msreplication_queue, but those rows will not sync to the publisher. I tried manually creating a row for one of the commands in the msrepl_queuedtraninfo table, but that caused a Synctran error on the publisher again.
Unfortunately, making the changes by hand isn't possible at the moment, because I cannot get sp_getqueuedrows to show row information. It shows the correct number of rows. It shows actual value only on a single column in whatever table I try, so far it has only been a bigint type that it will return, the rest are NULLs.
Is there anything I can do to at the very least view the data in the replication_queue table to make the row changes by hand, or hopefully get these rows to sync by rebuilding the queuedtraninfo table?
Thanks.
August 25, 2009 at 9:49 am
I reviewed the implementation of sp_getqueuedrows, and found that the packed bytestream in the data column of msreplication_queue is read using xp_readpkfromvarbin but I can't find that XP on the subscriber. Perhaps this is why the table won't populate properly?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply