From psudharsan@iradcle.com Wed Sep 29 09:23:40 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1492E1336FA7 for ; Wed, 29 Sep 2010 06:23:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 57789-06 for ; Wed, 29 Sep 2010 09:23:26 +0000 (UTC) X-Greylist: delayed 00:06:39.923551 by SQLgrey-1.7.6 Received: from smtpauth04.prod.mesa1.secureserver.net (smtpauth04.prod.mesa1.secureserver.net [64.202.165.95]) by mail.postgresql.org (Postfix) with SMTP id EC33D1337B55 for ; Wed, 29 Sep 2010 06:23:25 -0300 (ADT) Received: (qmail 5146 invoked from network); 29 Sep 2010 09:16:45 -0000 Received: from unknown (122.183.185.194) by smtpauth04.prod.mesa1.secureserver.net (64.202.165.95) with ESMTP; 29 Sep 2010 09:16:43 -0000 From: "JSPrabu" To: Cc: Subject: Reg: invalid byte sequence for encoding utf8 0x00 Date: Wed, 29 Sep 2010 14:48:42 +0530 Message-ID: <006601cb5fb7$51bc7430$f5355c90$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0067_01CB5FE5.6B74B030" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Actft0x2EmQRb7irSBqE+PGvs6Ry6g== Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/182 X-Sequence-Number: 35726 This is a multipart message in MIME format. ------=_NextPart_000_0067_01CB5FE5.6B74B030 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Support, Please help for the following issues which I am facing with migration and replication process of oracle to EnterpriseDB database. 1) While migrating tables from oracle to edb database, I am facing "invalid byte sequence for encoding utf8" error. Actually I am migrating through "migration studio". In this wizard, while doing online migration of oracle table with data's , constraints and indexes, constraints and indexes are migrated but I am getting this encoding error when migrating table data's. 2) In xDB replication console also, I am facing this same encoding error. In one support link, I came to know that we have to add "-DreplaceNullChar=true" and "-DnullReplacementChar=replacement char" command in advanced JVM options for replacing "null" value from oracle table to edb table, But I could not find advanced JVM options in xDB replication console. Source: database: Oracle 10.2.0.3.0 nls_lang: American nls_characterset: WE8ISO8859P1 target: database: PostgrePlus 8.4 Advanced server encoding: utf8 Thanks & Regards, ----------------------- Prabu.J.S Database Administrator | iRADcle Solutions. Handy : +91 978 624 4530 | Off : 044 44507141 ------=_NextPart_000_0067_01CB5FE5.6B74B030 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi = Support,

Please help for the = following issues which I am facing with migration and replication process of = oracle to EnterpriseDB database.

1) While = migrating tables from oracle to edb database, I am facing “invalid byte sequence for encoding utf8” error.

Actually I am migrating through “migration studio”. In this wizard, = while doing online migration of oracle table with data’s , constraints = and indexes, constraints and indexes are migrated but I am getting this = encoding error when migrating table data’s.

2) In xDB = replication console also, I am facing this same encoding error.

In one support link, I came to know that we have to add “-DreplaceNullChar=3Dtrue” and “-DnullReplacementChar=3Dreplacement char” = command in advanced JVM options for replacing = “null” value from oracle table to edb table, But I could not find advanced JVM options in xDB replication = console.

Source: =

database: = ; = &= nbsp; Oracle 10.2.0.3.0

nls_lang: = ; = &= nbsp; American

nls_characterset: &nb= sp; = WE8ISO8859P1

target: &= nbsp; =

database: = ; PostgrePlus 8.4 Advanced server

encoding: &n= bsp; utf8

Thanks & Regards,

-----------------------

Prabu.J.S

Database Administrator | iRADcle = Solutions.

Handy : +91 978 624 4530 | Off : 044 = 44507141

------=_NextPart_000_0067_01CB5FE5.6B74B030-- From shoaibmir@gmail.com Wed Sep 29 10:46:45 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id E959B1337B3E for ; Wed, 29 Sep 2010 07:46:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 69435-02 for ; Wed, 29 Sep 2010 10:46:39 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 71A351336971 for ; Wed, 29 Sep 2010 07:46:38 -0300 (ADT) Received: by wyb28 with SMTP id 28so578362wyb.19 for ; Wed, 29 Sep 2010 03:46:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=oAbE+DZje/TD81rHVEtJyzFgcxwsSJ1FMxd7blCueo8=; b=t++p8oH6UsYmHAd0BaJ2e7LmKwujlwRYIhwQMDG4FWq6leKTU00Z0QmturEafxuBWW 9bWXSlzYLB6qZfNDLlOXMarf8dPTjD8ydjIpJ9kW73laFU01R/nu5ymtBVpGBi7eOaC1 vJC7tQWaQncVZivnzqg6h4a8hXf1Xqqy4XeKU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=H3hKzjXNijmkSIwk1qjQ7YIlXIO7HDgzBmVezVTfTSuRLe4HwMHYkakYBJSuMaIYRn lvrBWGy2aJQDK21QFyJjwMnDHfRZNkRh5Mbh/1ozjeR2JdU/tNwhByJtjL3OcekgsJFv rFKXwMciR313jMrADMP0QgAIcRHrDIYJJFfaI= MIME-Version: 1.0 Received: by 10.216.35.74 with SMTP id t52mr1225227wea.41.1285757197737; Wed, 29 Sep 2010 03:46:37 -0700 (PDT) Received: by 10.216.160.141 with HTTP; Wed, 29 Sep 2010 03:46:37 -0700 (PDT) In-Reply-To: <006601cb5fb7$51bc7430$f5355c90$@com> References: <006601cb5fb7$51bc7430$f5355c90$@com> Date: Wed, 29 Sep 2010 20:46:37 +1000 Message-ID: Subject: Re: Reg: invalid byte sequence for encoding utf8 0x00 From: Shoaib Mir To: JSPrabu Cc: pgsql-admin@postgresql.org, avyasabhattu@iradcle.com Content-Type: multipart/alternative; boundary=0016367b645209dff4049163adb2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/184 X-Sequence-Number: 35728 --0016367b645209dff4049163adb2 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On Wed, Sep 29, 2010 at 7:18 PM, JSPrabu wrote: > Hi Support, > > > > Please help for the following issues which I am facing with migration and > replication process of oracle to EnterpriseDB database. > > > > 1) While migrating tables from oracle to edb database, I am facing = =93*invalid > byte sequence for encoding utf8=94* error. > > I guess you are posting it on the wrong list as this is not an EnterpriseDB mailing list but its for PostgreSQL related questions so hmm I am not sure if anyone will be able to help you with migration studio here. It will be easy to help if you can let us know of the offending row that is giving the problem? -- Shoaib Mir http://shoaibmir.wordpress.com/ --0016367b645209dff4049163adb2 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On Wed, Sep 29, 2010 at 7:18 PM, JSPrabu <psudharsan@iradcle.com> wrote:<= br>

Hi Support,

=A0

Please help for the fol= lowing issues which I am facing with migration and replication process of oracle t= o EnterpriseDB database.

=A0

1)=A0=A0=A0=A0=A0 While migrating tables from oracle to edb database, I am facing =93invalid byte sequence for encoding utf8=94 error.

I guess you are posting it on the wrong list as th= is is not an EnterpriseDB mailing list but its for PostgreSQL related quest= ions so hmm I am not sure if anyone will be able to help you with migration= studio here.

It will be easy to help if you can let us know of the o= ffending row that is giving the problem?

--
<= div>Shoaib Mir

http:= //shoaibmir.wordpress.com/
--0016367b645209dff4049163adb2--