Replication initialization fails if more than 1 row

More
10 years 10 hours ago #4432 by michaelgg
Hi there. I finally have things almost working. Replication works, except the initial sync. If there is one row of data, the initial sync from snapshot works just fine. If there is more than 1 row of data (tried with 3), then it fails, with "Invalid parameters". Here's what the SQL Server log shows (in time order):

Date 2012-01-23 8:14:45 PM
Log SQL Server (Current - 2012-01-23 6:00:00 PM)
Source spid69
Message
Error: 14151, Severity: 18, State: 1.

Date 2012-01-23 8:14:45 PM
Log SQL Server (Current - 2012-01-23 6:00:00 PM)
Source spid69
Message
Replication-Replication Distribution Subsystem: agent ERGO-vfk-vfkpub-192.168.146.134-226 failed. Invalid parameters

I tried adding: SQLSERVER=2008;BULK_INSERT=10;BULK_METHOD=Copy to my extended properties on the subscription and linked server, but it doe the same.

I've verified that deleting all but one row makes it work. SQL Server and SQL Server Agent are running as Local System; so certainly they don't have access problems, like error 14151 might lead me to think.

I looked at a network trace of Postgres between the machines, and don't see any error, except the one from "SET ANSI_PADDING ON" - but that's seemingly ignored because it works with a single row. (I've also manually edited the .sch file and removed that; no difference.) The trace shows it parsing the INSERT command, and then... nothing. So it must be some interaction with SQL Server and the PGNP driver; it's not the remote server rejecting things.

What am I missing? Why can't I initialize replication from a snapshot with more than one row?

Please Log in or Create an account to join the conversation.

More
10 years 8 hours ago #4433 by michaelgg
OK I got my full 1.3 license, and that seems to work! The trial 1.4 does not.

Please Log in or Create an account to join the conversation.

Time to create page: 0.046 seconds
Powered by Kunena Forum