What is @bitmap role in Replication?
-
Hi,
I'm having a problem with 1 of the replication article. I've setup a transactional replication with ~130 articles. The replication setup is simple and straight away. Publisher is in SQL2K, distributor in SQL2K5 and subscribers is in SQL2K and SQL2K5. I'm having problem with 1 of the article, the error as below :
expects parameter '@bitmap', which was not supplied. (Source: MSSQLServer, Error number: 201)
This error happened when there is data change in this table and it try to push to the subscriber. This only happen to 1 of the article. The rest of the article still working fine to push data change to subscribers. I check on the sys stored procedure for replication dbo.sp_MSupd_dboxxx, there is a parameter @bitmap which is required and some how when this call up by the replication agent, it doesn't pass in any value. May I know what this parameter - @bitmap use for? How can I fix the problem? Does it related to SP1 or SP2?
Appreciate if any expert able to answer it. Thanks!
-
apparently your update storedprocedure is not being called with the correct calling convention. I don't know exactly what the reason is... something/someone must have change the article definition etc... but that is speculation.
you may be able to take that article off the publication an put it back using sp_droparticle / sp_addarticle and then running a snapshot for that table but I am not sure if that matches your configuration.
* Noel -
Hi Noel,
You are right, I check the table schema for this table in publisher and subscriber, they were diff
I've recreate the replication after fix the the table schema, it's back to the game
Thanks alot !!
-
np
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply