Tx Replication from SQL Server 2008 R2 to Postgres 9.1

More
12 years 2 weeks ago #6452 by sqlrepl
Actually, the error message is :

OLE DB provider "PGNP" for linked server "PGNP_Samples" returned message "Undefined column name "Tbl1001"."columnname"".
Msg 7321, Level 16, State 2, Line 1

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

More
12 years 6 days ago #6471 by Moderator
We have tested the stored procedure call, and it worked fine in current version: 1.4.0.3056.

EXEC('pgnp_refreshmetadata('''',''test'')') AT PGNP_SAMPLE

What version of provider are you using?

Btw, another way of refreshing metadata cache in all connected OLEDB providers is to execute following statement: NOTIFY pgnp_rtx.

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

  • Visitor
  • Visitor
11 years 5 months ago #9834 by
I used the same script in order to setup a transactionnal replication between sql 2008 r2 ( publisher) and Postgresql 9.2 .
The table MSREPL7 has been created, a row is inserted , but I coudn't find the replicated table. ( Even if I reinitialize the subscription)
I've got no error on SQLSERVER.

Thank you

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

More
11 years 5 months ago #9835 by Moderator
I do not know the reason. It can happen if a step was missed during the replication configuration. Could you check SQL Server logs, NT Events log and Postgres logs in order to see if any errors were reported?

Second thought: usually a snapshot replication is used in order to create destination table(s).

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

  • Visitor
  • Visitor
11 years 3 months ago #9878 by
Hello,

I have these errors :
invalid parameter
when the agent try to bulk copy

and right after: ERROR: relation "dossier" already exists (Source : MSSQLServer, Numéro d'erreur : -2147217900)

Thank you

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

More
11 years 2 months ago #9908 by Moderator
Would you send more details on how to reproduce the issue to Support? We need configuration script, table(s) DDL, sample rows. Thank you!

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

Time to create page: 0.143 seconds
Powered by Kunena Forum