Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WBM27-0001gX-Dy for pgsql-admin@arkaria.postgresql.org; Thu, 06 Feb 2014 10:18:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WBM26-0000Lg-Oq for pgsql-admin@arkaria.postgresql.org; Thu, 06 Feb 2014 10:18:10 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WBM25-0000LZ-AM for pgsql-admin@postgresql.org; Thu, 06 Feb 2014 10:18:09 +0000 Received: from nm35.bullet.mail.ne1.yahoo.com ([98.138.229.28]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WBM22-0007YH-AT for pgsql-admin@postgresql.org; Thu, 06 Feb 2014 10:18:08 +0000 Received: from [127.0.0.1] by nm35.bullet.mail.ne1.yahoo.com with NNFMP; 06 Feb 2014 10:18:04 -0000 Received: from [98.138.226.176] by nm35.bullet.mail.ne1.yahoo.com with NNFMP; 06 Feb 2014 10:15:17 -0000 Received: from [106.10.166.121] by tm11.bullet.mail.ne1.yahoo.com with NNFMP; 06 Feb 2014 10:15:17 -0000 Received: from [106.10.150.24] by tm10.bullet.mail.sg3.yahoo.com with NNFMP; 06 Feb 2014 10:15:16 -0000 Received: from [127.0.0.1] by omp1025.mail.sg3.yahoo.com with NNFMP; 06 Feb 2014 10:15:16 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 922946.19105.bm@omp1025.mail.sg3.yahoo.com Received: (qmail 78927 invoked by uid 60001); 6 Feb 2014 10:15:16 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1391681716; bh=SPQP9sGXSMB00sOndJp1GxtV36fwyJJU8PMac4YXiqQ=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=QqqfI/EW8uyMnVuPsfHlO9zWrlKfui3n5aIRgnzK40fI4tUchdIpJvRx0OWVu7ZnzjtNDIpoiHow+Ko6TXGcMcu3AOdacEJKzTQnBLN65go/BjUTIbGpfbAAZ+TExqM1ufKaCQJWeT1DMdNc0aT0x1gxsvIfaD8Hns5A540dIV0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=ljiZwmm79WYTzbQkLjKaVdnCmp0ZrPH2nIgM9oWAYJrR7cJ3XMy/FAmUAO5VC+8BpNASKF+I+YrLahXSeezhFRG+Vvrl/npVCqJVMZTyU10Ml3uoiwDvb6/E3I2y+MxKEHZ/rgmb6Fw8r1Yw5kL1ryCdXXS0OObtxUL/nEwh2YY=; X-YMail-OSG: j6nYms4VM1lGViGVnv37wjUTTJ18X0seh3836NOAi1AuURB YRDakkSlAJJ0x3vg.eoXtIUpq8_M6JPi.NXrWAhSkuiPl2aTAtKhHcAP2QbM Hv_Jkla5_uYBj33IARPYNVCKH4rB6o3xdbktCPzAc4nYtk7D7kZF2tNHwOPY _B8Ul6LgHnxesmZCUJ0NqoT03Kht2RTfhUuPIFrhO8wn8G7KWMkXYuEwnNs2 JKOi8rDolg35kAwFhU59aL2n1LSnseCBqvrgnXzn2PmootUF2gf9sAtLf4cE lETbCLl6WJQXce6tfpgg6Udy.yZIo5n7d7xZUoPbBfX5yWKa6rPdXDy1zLJ. SDb9X4ihdPVHQumX.gVH1wwMxmy5QIxTfHZD5mEzkz2LA.UFF3HxDSHd2722 NcFLSDpSHyTTfIYMnm0wd87rNk75gHtnBK4NaVjM_aNMpPwOn.cJKJZMjKiV doSR6dai6upoLneOM3V5npnbjeRqJhnTyX07XAJdgM5rgCWS9xJZV88eKB7_ 7iK2mjRoztAWfBQ7URAYDYnsmgNKCo2VmGORs295VgDtW5dnFbQUDo9FQjQ- - Received: from [115.112.83.30] by web193606.mail.sg3.yahoo.com via HTTP; Thu, 06 Feb 2014 18:15:16 SGT X-Rocket-MIMEInfo: 002.001, TmV2ZXIgdHJpZWQsIEJ1dCBjYW4geW91IHRyeSBhZGRpbmcgdGFibGUgb25lIGFmdGVyIGFub3RoZXIuCgpSZWdhcmRzCkRoYW5hbmpheQpPcGVuU0NHCgoKCk9uIFRodXJzZGF5LCA2IEZlYnJ1YXJ5IDIwMTQgMToxOSBBTSwgS2lkbyBLb3Vhc3NpIDxqamtpZG9AZ21haWwuY29tPiB3cm90ZToKIApIZWxsbyBBZG1pbiwKCkkgYW0gc2V0dGluZyB1cCBhIHJlcGxpY2F0aW9uIGZyb20gYSBkYXRhYmFzZSBvbiBNUyBTUUwgMjAwMCB0aGF0IGhhcyAyMDArIHRhYmxlcyB0byBhIGRhdGFiYXNlIG9uwqAgUG9zdGcBMAEBAQE- X-Mailer: YahooMailWebService/0.8.175.631 References: Message-ID: <1391681716.70326.YahooMailNeo@web193606.mail.sg3.yahoo.com> Date: Thu, 6 Feb 2014 18:15:16 +0800 (SGT) From: Dhananjay Singh Reply-To: Dhananjay Singh Subject: Re: SQL 2000 to PostgreSQL 9.3 Replication of Large Number of Tables To: Kido Kouassi , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1007894763-150454780-1391681716=:70326" X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---1007894763-150454780-1391681716=:70326 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Never tried, But can you try adding table one after another.=0A=0ARegards= =0ADhananjay=0AOpenSCG=0A=0A=0A=0AOn Thursday, 6 February 2014 1:19 AM, Kid= o Kouassi wrote:=0A =0AHello Admin,=0A=0AI am setting up= a replication from a database on MS SQL 2000 that has 200+ tables to a dat= abase on=A0 PostgreSQL 9.3. =0A=0AThe replication works when I try replicat= ing tables one at the time. =0A=0AWhen replicating multiple tables though,= =A0 sometimes it works =0ASometimes it doesn't.=0A=0AWhen it doesn't Work,= =A0 the replication Log in MS SQL will have the following error:=0A=0A=0ABu= lk copying data into table 'Tablex'=0A>OLE DB Subscriber 'PG1': SELECT * FR= OM "Tablex" WHERE 0 =3D 1=0A>[2/4/2014 12:18:42 PM]SQL01.distribution: {cal= l sp_MSadd_distribution_history(71, 3,=A0 ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, = 0x01, 0x00)}=0A>Agent message code 21044. The number of columns in the bcp = file does not match that of the destination table.=0A>[2/4/2014 12:18:42 PM= ]SQL01.distribution: {call sp_MSadd_distribution_history(71, 6,=A0 ?, ?, 0,= 0, 0.00, 0x01, 1, ?, 54, 0x01, 0x01)}=0A>Adding alert to msdb..sysreplicat= ionalerts: ErrorId =3D 39, =0A>Transaction Seqno =3D 000007e3000005c9014e00= 000007, Command ID =3D 54=0A>Message: Replication-Replication Distribution = Subsystem: agent SQL01-sqldb-e-publication1-PG1-71 failed. The number of co= lumns in the bcp file does not match that of the destination table.=0A>[2/4= /2014 12:18:42 PM]STAGE-SQL01.distribution: {call sp_MSadd_repl_alert(3, 71= ,=A0 39, 14151, ?, 54, N'SQL01', N'sqldb1', N'PG1SQL56', N'pgdb1', ?)}=0A>E= rrorId =3D 39, SourceTypeId =3D 1=0A>ErrorCode =3D ''=0A>ErrorText =3D 'SEL= ECT * FROM "Tablex" WHERE 0 =3D 1'=0A>[2/4/2014 12:18:42 PM]SQL01.distribut= ion: {call sp_MSadd_repl_error(39, 0,=A0 1, ?, N'', ?)}=0A>=0A=0Athe funny = thing is that when I set up a replication with only the failing table, it w= orks and another table becomes problematic. =0A=0AI have one set with 18 ta= ble that works perfectly.=0A=0AAnother table with 15 is failing.=0A=0AThe I= deal would be to replicate All the tables in one set but this option is fai= ling to.=0A=0A=0ADid anybody ever run into something similar.=0A=0AYour hel= p will be highly appreciated.=0A=0AThank You,=0A=0AKido Kouassi ---1007894763-150454780-1391681716=:70326 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Never tried, But can you try adding table one afte= r another.

Rega= rds
Dhanan= jay
OpenSCG


On Thursday, 6 Feb= ruary 2014 1:19 AM, Kido Kouassi <jjkido@gmail.com> wrote:
H= ello Admin,

I am setting up a replication from a database on M= S SQL 2000 that has 200+ tables to a database on  PostgreSQL 9.3.
= =0A
The replication works when I try replicating tables one at the= time.

When replicating multiple tables though,  sometim= es it works
Sometimes it doesn't.

When it doesn't Work,&nb= sp; the replication Log in MS SQL will have the following error:
=0A
=
Bulk copying data into table 'T= ablex'
=0A= OLE DB Subscriber 'PG1': SELECT * FROM "Tablex" WHERE 0 =3D 1
[2/4/2014 12:18:42 PM]S= QL01.distribution: {call sp_MSadd_distribution_history(71, 3,  ?, ?, 0= , 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x00)}
=0AAgent message code 21044. The number of col= umns in the bcp file does not match that of the destination table.[2/4/2014 12:18:42= PM]SQL01.distribution: {call sp_MSadd_distribution_history(71, 6,  ?,= ?, 0, 0, 0.00, 0x01, 1, ?, 54, 0x01, 0x01)}
=0AAdding alert to msdb..sysreplicationa= lerts: ErrorId =3D 39,
Transaction Seqno =3D 000007e3000005c9014e00000007, Command I= D =3D 54
=0A[2/4/2014 12:18:42 PM]STAGE-SQL01.distrib= ution: {call sp_MSadd_repl_alert(3, 71,  39, 14151, ?, 54, N'SQL01', N= 'sqldb1', N'PG1SQL56', N'pgdb1', ?)}
=0AErrorId =3D 39, SourceTypeId =3D 1
= ErrorCode =3D ''
ErrorText =3D= 'SELECT * FROM "Tablex" WHERE 0 =3D 1'
=0A[2/4/2014 12:18:42 PM]SQL01.distribution: = {call sp_MSadd_repl_error(39, 0,  1, ?, N'', ?)}


the funny thing is that when I set up a replication with on= ly the failing table, it works and another table becomes problematic.
= =0A
I have one set with 18 table that works perfectly.

Another table with 15 is failing.

The Ideal would be t= o replicate All the tables in one set but this option is failing to.
=0A
Did anybody ever run into something similar.

Your help will be highly appreciated.

Thank You,

Kido Kouassi


---1007894763-150454780-1391681716=:70326--