March 11, 2005 at 9:42 am
The process could not bulk copy into table '"customer"'.
Last command - select * from "customer" where 1 = 2
Transaction sequence number and command ID of last execution batch are 0x0000D4C60000031800050000000B and 39.
Full message Function sequence error
How to fix this error- thanks in advance
March 11, 2005 at 1:41 pm
Wich type of replication is it? Transactional? Are you applying the initial snapshot?
If so, I would reinitialize the subscription, generate a new snapshot and apply it again.
If the table at the subscriber has data, you should check that in won't fail because of a duplicate record.
March 11, 2005 at 1:47 pm
It is transactional replicaton, I did reinitialize the scrbscription, still Iam getting this error
January 22, 2008 at 2:30 pm
gettgin same error, same symptoms, transactional replication. The DB being replcaited to was off-line for a while as it is a test server. All other replcaition from two other databases on the same piblisher/distributor is working to the same subscriber database.
Did you ever resolve this?
March 5, 2008 at 1:47 am
Hi,
I have the same problem too. I did a reinitialization. But it failed halfway. When I try to Start Synchronizing again, it gives this error.. even though I check the box to leave the data unchanged if a table exists.
March 5, 2008 at 1:50 am
I have a table with data already initialized. But the synchronizing fails because of the above error. How can I ensure that the new rows added to the publisher are also added to my subscriber now?
March 5, 2008 at 5:28 am
I'm not sure what was causing my error. I had changed the columns on part of the publication. I wound up dropping the table from the publication that was causing the trouble and readding it and it worked after that. I made the same change to the production server just a few days ago but I did not have the same issues when dropping the column.
March 6, 2008 at 4:47 am
Hi any help will be greatly appreciated
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply