Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Replication between 2 data servers having different character set

5 posts in General Discussion Last posting was on 2012-03-01 20:40:53.0Z
kiran Posted on 2012-03-01 06:30:48.0Z
From: kiran <kiranyr85@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Replication between 2 data servers having different character set
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f4f1798@forums-1-dub>
Date: 29 Feb 2012 22:30:48 -0800
X-Trace: forums-1-dub 1330583448 10.22.241.152 (29 Feb 2012 22:30:48 -0800)
X-Original-Trace: 29 Feb 2012 22:30:48 -0800, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9158
Article PK: 870322

Hi Team,

I have an situation here.Please advise.
Is it possible set replication between different char set ?

Primary Server: ASE 15.0.2 2k Page size,char set iso-01

Replication Server : REP 15 ,char set utf8

Destination Server : ASE 15.0.2 8k Page size,char set utf8

I am getting following error in rep server:

tail -n 300 errorlog_USPUB_M01A_RS
Message from server: Message: 2409, State 2, Severity 11 --
'Cannot find the requested character set in Syscharsets: name = 'utf8'.
'.
I. 2012/02/28 07:24:57. Message from server: Message: 2411, State 1,
Severity 10 -- 'No conversions will be done.
'.
I. 2012/02/28 07:24:57. Message from server: Message: 5701, State 2,
Severity 10 -- 'Changed database context to 'core_legal'.
'.
E. 2012/02/28 07:25:57. ERROR #13045 CREATE(USPUB_M01A_DS.core_rights) -
seful/cm.c(3297)
Failed to connect to server 'DBS_SM15A_SYB' as user
'core_rights_maint'. See CT-Lib and/or server error messages for more
information.
E. 2012/02/28 07:25:57. ERROR #1028 CREATE(USPUB_M01A_DS.core_rights) -
seful/cm.c(3297)


With Regards,

Kiran Kumar


peta62 Posted on 2012-03-01 07:07:02.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Replication between 2 data servers having different character set
References: <4f4f1798@forums-1-dub>
In-Reply-To: <4f4f1798@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f4f2016$1@forums-1-dub>
Date: 29 Feb 2012 23:07:02 -0800
X-Trace: forums-1-dub 1330585622 10.22.241.152 (29 Feb 2012 23:07:02 -0800)
X-Original-Trace: 29 Feb 2012 23:07:02 -0800, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9159
Article PK: 870321

Hello,
I think ( did not test and it is a long time since I was fighting
similar scenario ) you have two separate problems. Maintenance user
login into database and charset. As for the charset do you have both
charsets installed in the target ASE ?
Cheers,
Peter

On 3/1/2012 7:30 AM, kiran wrote:
> Hi Team,
>
> I have an situation here.Please advise.
> Is it possible set replication between different char set ?
>
> Primary Server: ASE 15.0.2 2k Page size,char set iso-01
>
> Replication Server : REP 15 ,char set utf8
>
> Destination Server : ASE 15.0.2 8k Page size,char set utf8
>
> I am getting following error in rep server:
>
> tail -n 300 errorlog_USPUB_M01A_RS
> Message from server: Message: 2409, State 2, Severity 11 -- 'Cannot find
> the requested character set in Syscharsets: name = 'utf8'.
> '.
> I. 2012/02/28 07:24:57. Message from server: Message: 2411, State 1,
> Severity 10 -- 'No conversions will be done.
> '.
> I. 2012/02/28 07:24:57. Message from server: Message: 5701, State 2,
> Severity 10 -- 'Changed database context to 'core_legal'.
> '.
> E. 2012/02/28 07:25:57. ERROR #13045 CREATE(USPUB_M01A_DS.core_rights) -
> seful/cm.c(3297)
> Failed to connect to server 'DBS_SM15A_SYB' as user 'core_rights_maint'.
> See CT-Lib and/or server error messages for more information.
> E. 2012/02/28 07:25:57. ERROR #1028 CREATE(USPUB_M01A_DS.core_rights) -
> seful/cm.c(3297)
>
>
> With Regards,
>
> Kiran Kumar


kiran Posted on 2012-03-01 11:47:43.0Z
From: kiran <kiranyr85@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Replication between 2 data servers having different characterset
References: <4f4f1798@forums-1-dub> <4f4f2016$1@forums-1-dub>
In-Reply-To: <4f4f2016$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f4f61df$1@forums-1-dub>
Date: 1 Mar 2012 03:47:43 -0800
X-Trace: forums-1-dub 1330602463 10.22.241.152 (1 Mar 2012 03:47:43 -0800)
X-Original-Trace: 1 Mar 2012 03:47:43 -0800, vip152.sybase.com
Lines: 57
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9160
Article PK: 870323

Yes,

I installed utf-8 language in primary server with charset command as rep
agent sends transaction to rep server with converted characters to match
rep server char set.this is what i believe how replication works.

With Regards,

Kiran

On 3/1/2012 12:37 PM, peta62 wrote:
> Hello,
> I think ( did not test and it is a long time since I was fighting
> similar scenario ) you have two separate problems. Maintenance user
> login into database and charset. As for the charset do you have both
> charsets installed in the target ASE ?
> Cheers,
> Peter
>
>
> On 3/1/2012 7:30 AM, kiran wrote:
>> Hi Team,
>>
>> I have an situation here.Please advise.
>> Is it possible set replication between different char set ?
>>
>> Primary Server: ASE 15.0.2 2k Page size,char set iso-01
>>
>> Replication Server : REP 15 ,char set utf8
>>
>> Destination Server : ASE 15.0.2 8k Page size,char set utf8
>>
>> I am getting following error in rep server:
>>
>> tail -n 300 errorlog_USPUB_M01A_RS
>> Message from server: Message: 2409, State 2, Severity 11 -- 'Cannot find
>> the requested character set in Syscharsets: name = 'utf8'.
>> '.
>> I. 2012/02/28 07:24:57. Message from server: Message: 2411, State 1,
>> Severity 10 -- 'No conversions will be done.
>> '.
>> I. 2012/02/28 07:24:57. Message from server: Message: 5701, State 2,
>> Severity 10 -- 'Changed database context to 'core_legal'.
>> '.
>> E. 2012/02/28 07:25:57. ERROR #13045 CREATE(USPUB_M01A_DS.core_rights) -
>> seful/cm.c(3297)
>> Failed to connect to server 'DBS_SM15A_SYB' as user 'core_rights_maint'.
>> See CT-Lib and/or server error messages for more information.
>> E. 2012/02/28 07:25:57. ERROR #1028 CREATE(USPUB_M01A_DS.core_rights) -
>> seful/cm.c(3297)
>>
>>
>> With Regards,
>>
>> Kiran Kumar
>


peta62 Posted on 2012-03-01 18:25:48.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Replication between 2 data servers having different characterset
References: <4f4f1798@forums-1-dub> <4f4f2016$1@forums-1-dub> <4f4f61df$1@forums-1-dub>
In-Reply-To: <4f4f61df$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f4fbf2c$1@forums-1-dub>
Date: 1 Mar 2012 10:25:48 -0800
X-Trace: forums-1-dub 1330626348 10.22.241.152 (1 Mar 2012 10:25:48 -0800)
X-Original-Trace: 1 Mar 2012 10:25:48 -0800, vip152.sybase.com
Lines: 62
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9161
Article PK: 870324

Sorry I mean "destination" by "target".

On 3/1/2012 12:47 PM, kiran wrote:
> Yes,
>
> I installed utf-8 language in primary server with charset command as rep
> agent sends transaction to rep server with converted characters to match
> rep server char set.this is what i believe how replication works.
>
> With Regards,
>
> Kiran
>
> On 3/1/2012 12:37 PM, peta62 wrote:
>> Hello,
>> I think ( did not test and it is a long time since I was fighting
>> similar scenario ) you have two separate problems. Maintenance user
>> login into database and charset. As for the charset do you have both
>> charsets installed in the target ASE ?
>> Cheers,
>> Peter
>>
>>
>> On 3/1/2012 7:30 AM, kiran wrote:
>>> Hi Team,
>>>
>>> I have an situation here.Please advise.
>>> Is it possible set replication between different char set ?
>>>
>>> Primary Server: ASE 15.0.2 2k Page size,char set iso-01
>>>
>>> Replication Server : REP 15 ,char set utf8
>>>
>>> Destination Server : ASE 15.0.2 8k Page size,char set utf8
>>>
>>> I am getting following error in rep server:
>>>
>>> tail -n 300 errorlog_USPUB_M01A_RS
>>> Message from server: Message: 2409, State 2, Severity 11 -- 'Cannot find
>>> the requested character set in Syscharsets: name = 'utf8'.
>>> '.
>>> I. 2012/02/28 07:24:57. Message from server: Message: 2411, State 1,
>>> Severity 10 -- 'No conversions will be done.
>>> '.
>>> I. 2012/02/28 07:24:57. Message from server: Message: 5701, State 2,
>>> Severity 10 -- 'Changed database context to 'core_legal'.
>>> '.
>>> E. 2012/02/28 07:25:57. ERROR #13045 CREATE(USPUB_M01A_DS.core_rights) -
>>> seful/cm.c(3297)
>>> Failed to connect to server 'DBS_SM15A_SYB' as user 'core_rights_maint'.
>>> See CT-Lib and/or server error messages for more information.
>>> E. 2012/02/28 07:25:57. ERROR #1028 CREATE(USPUB_M01A_DS.core_rights) -
>>> seful/cm.c(3297)
>>>
>>>
>>> With Regards,
>>>
>>> Kiran Kumar
>>
>


jobless Posted on 2012-03-01 20:40:53.0Z
Sender: 2743.4f4fa29e.1804289383@sybase.com
From: jobless
Newsgroups: sybase.public.rep-server
Subject: Re: Replication between 2 data servers having different character set
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f4fded5.33e3.1681692777@sybase.com>
References: <4f4f1798@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Mar 2012 12:40:53 -0800
X-Trace: forums-1-dub 1330634453 172.20.134.41 (1 Mar 2012 12:40:53 -0800)
X-Original-Trace: 1 Mar 2012 12:40:53 -0800, 172.20.134.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9162
Article PK: 870325

Maybe the Sybase doc could be of assistant:

your repserver version is 15.<?>

<some snip>
rs_charset:
This property is referenced only if you are using
Replication Server 15.0 and earlier. For Replication Server
15.0.1 and later, Replication Agent directly queries the
Replication Server property RS_charset. This is the
character set that Replication Agent uses when creating LTL
commands for Replication Server
..... more

> Hi Team,
>
> I have an situation here.Please advise.
> Is it possible set replication between different char set
> ?
>
> Primary Server: ASE 15.0.2 2k Page size,char set iso-01
>
> Replication Server : REP 15 ,char set utf8
>
> Destination Server : ASE 15.0.2 8k Page size,char set utf8
>
> I am getting following error in rep server:
>
> tail -n 300 errorlog_USPUB_M01A_RS
> Message from server: Message: 2409, State 2,
> Severity 11 -- 'Cannot find the requested character set
> in Syscharsets: name = 'utf8'. '.
> I. 2012/02/28 07:24:57. Message from server: Message: 2411
> , State 1, Severity 10 -- 'No conversions will be done.
> '.
> I. 2012/02/28 07:24:57. Message from server: Message: 5701
> , State 2, Severity 10 -- 'Changed database context to
> 'core_legal'. '.
> E. 2012/02/28 07:25:57. ERROR #13045
> CREATE(USPUB_M01A_DS.core_rights) - seful/cm.c(3297)
> Failed to connect to server 'DBS_SM15A_SYB' as
> user 'core_rights_maint'. See CT-Lib and/or server error
> messages for more information.
> E. 2012/02/28 07:25:57. ERROR #1028
> CREATE(USPUB_M01A_DS.core_rights) - seful/cm.c(3297)
>
>
> With Regards,
>
> Kiran Kumar