Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdurant
Starting Member
4 Posts |
 Posted - 2009-08-20 : 16:35:11
|
| 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, 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. |
|
|
mdurant
Starting Member
4 Posts |
Posted - 2009-08-21 : 13:31:36
|
| I don't have much time left, we have some scheduled maintenance on Sunday night that requires us remove and change some publications, which means the data in the replication queue won't match the publication info.Anyone have any ideas? |
 |
|
|
mdurant
Starting Member
4 Posts |
Posted - 2009-08-21 : 19:00:46
|
| Anyone? |
|
|
|
mdurant
Starting Member
4 Posts |
Posted - 2009-08-24 : 13:15:18
|
| Any suggestions or pointing me in the direction of someone that can help would be appreciated. I've already posted on the MSDN forums also.Thanks. |
|
|
|
|
|
|
|
|
Restore msreplication_queue?