transaction replication not working

• Nad

  Grasshopper

  Points: 11

  More actions

  April 8, 2002 at 10:55 am

  #78922

  Environment:

  windows 2000 sp2, sql 2000 sp2

  I have finally gotten sp_scriptpublicationcustomprocs

  to give me some meaningful output. I set up a publication using

  transactional replication, with schedule as continuous. Publication

  contains a single artice..a table named "contact".

  When I make a change to one of the contenst in a colum on publisher

  database..for e.g. i change first name, i get the below error in agent:

  Cannot update identity column 'ContactID'.

  The last command was as follows:

  {CALL sp_MSupd_Contact (NULL,NULL,NULL,NULL,'Nad

  Cyrus',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

  NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU

  LL,NULL,NULL,NULL,NULL,NULL,NULL,1,0x1000000000)}

  Transaction sequence number and command ID of last execution batch are

  0x00001CDE0000010A000100000000 and 1.

  Any ideas? I noticed that last parameter for the update sproc is @bitmap

  binary(5)

  as well as the following if clause:

  if substring(@bitmap,1,1) & 1 = 1

  what is this @bitmap parameter? I am new to sql admin but it looks as if

  it's trying to determine some condition based on this bitmap parameter.

  if it evelautaes to true, it tries to update contactid column as well.

  Someone please Help this newbie.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 8, 2002 at 1:10 pm

  #426801

  For the first part I suspect you have too many columns defined in the proc - if you've got an identity col on the subscriber you need to either remove the param that maps to it in the proc or allow identity inserts. I'll have to look into the bitmap.

  Andy

  Andy
  Connect with me on LinkedIn