- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- error in transactional replication
error in transactional replication
- Scott_Harris
- Topic Author
- Offline
- User
-
Less
More
- Posts: 2
- Thank you received: 0
5 months 1 week 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?
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.
5 months 1 week ago - 5 months 1 week 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.
Also, please use the latest release of the PGNP provider.
Last edit: 5 months 1 week ago by admin.
Please Log in or Create an account to join the conversation.
5 months 1 week 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
-
Less
More
- Posts: 2
- Thank you received: 0
5 months 1 week 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.
5 months 1 week 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.
- Forum
- Main PGNP Forum
- SQL Server/DTS/SSIS/Linked servers/Replication
- error in transactional replication
Time to create page: 0.077 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- error in transactional replication