error in transactional replication

  • Scott_Harris
  • Topic Author
  • Offline
  • User
  • User
More
1 year 7 months ago #14736 by Scott_Harris
error in transactional replication was created by Scott_Harris
i believe have set up replication properly from sql server 2019 to postgres 12 except only simple table seem to work. on most of my tables im getting similar errors like the one below:

ERROR:  bind message supplies 96 parameters, but prepared statement "8fd428d78d281d712bf783d878d0e3fc" requires 768

and help on what this could be or even a way to debug it?

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

More
1 year 7 months ago - 1 year 7 months ago #14738 by admin
Replied by admin on topic error in transactional replication
Please make sure that Extended Properties of the connection string contain parameters BULK_METHOD=PIPECOPY;BULK_INSERT=1000;COMMAND_TIMEOUT=0;

Also, please use the latest release of the PGNP provider.
Last edit: 1 year 7 months ago by admin.

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

More
1 year 7 months ago #14739 by admin
Replied by admin on topic error in transactional replication
For debugging please run PGNProfiler (as Administrator), and start collecting trace. Send the trace to our Support. For details refer to the Developers Manual (available from the Download page).

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

  • Scott_Harris
  • Topic Author
  • Offline
  • User
  • User
More
1 year 7 months ago #14740 by Scott_Harris
Replied by Scott_Harris on topic error in transactional replication
hi i tried changing my parameters to the ones suggested and got the same result. i dont know if it helps. but if i change bulk method to PIPECOPY it doesnt error out but is missing tons of rows on the postgres side. anyway. i emailed the files to support.

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

More
1 year 7 months ago #14741 by admin
Replied by admin on topic error in transactional replication
Yes, the parameter should be BULK_METHOD=PIPECOPY; (I said TEXTCOPY initially by mistake). The missing rows are due to the Trial limitation. The commercial build handles all rows correctly.

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

Time to create page: 0.196 seconds
Powered by Kunena Forum