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.

Replicate type Image to MS SQL Server

6 posts in Replication Agent Last posting was on 2007-07-19 06:19:21.0Z
Robson Posted on 2007-07-18 13:50:28.0Z
From: "Robson" <robsonbrandao@gmail.com>
Newsgroups: sybase.public.rep-agent
Subject: Replicate type Image to MS SQL Server
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 200.136.13.168
X-Original-NNTP-Posting-Host: 200.136.13.168
Message-ID: <469e1aa4@forums-1-dub>
Date: 18 Jul 2007 06:50:28 -0700
X-Trace: forums-1-dub 1184766628 200.136.13.168 (18 Jul 2007 06:50:28 -0700)
X-Original-Trace: 18 Jul 2007 06:50:28 -0700, 200.136.13.168
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:895
Article PK: 841521

Hi,

I have a problem to replicate a field Image from Sybase to MS SQL Server.

I use Direct Connect 12.50.07.0006 with SQL Server 2000.

When I replicate this field(type Image), its returns a error:

I. 2007/07/13 15:13:42. The DSI thread for database 'FMDITESTE.FM_USP' is
started.
E. 2007/07/13 15:13:45. ERROR #1028 DSI EXEC(302(1) FMDITESTE.FM_USP) -
dsiqmint.c(3059)
Message from server: Message: 30291, State 0, Severity 19 --
'[VENDORLIB] Vendor Library Error: [[Message Iteration=1|Data Source
Name=fmdisql|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC SQL
Server Driver][SQL Server]'ciphertext' is not a recognized option.] <DCA>'.
H. 2007/07/13 15:13:45. THREAD FATAL ERROR #5049 DSI EXEC(302(1)
FMDITESTE.FM_USP) - dsiqmint.c(3066)
The DSI thread for database 'FMDITESTE.FM_USP' is being shutdown.
DSI received data server error #30291 which is mapped to STOP_REPLICATION.
See logged data server errors for more information. The data server error
was caused by output command #1 mapped from input command #2 of the failed
transaction.
I. 2007/07/13 15:13:45. The DSI thread for database 'FMDITESTE.FM_USP' is
shutdown.

Can you help me. please ?


Michael Peppler Posted on 2007-07-18 16:12:17.0Z
From: Michael Peppler <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: Replicate type Image to MS SQL Server
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2007.07.18.16.12.19.601233@peppler.org>
Newsgroups: sybase.public.rep-agent
References: <469e1aa4@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 185-191.5-85.cust.bluewin.ch
X-Original-NNTP-Posting-Host: 185-191.5-85.cust.bluewin.ch
Date: 18 Jul 2007 09:12:17 -0700
X-Trace: forums-1-dub 1184775137 85.5.191.185 (18 Jul 2007 09:12:17 -0700)
X-Original-Trace: 18 Jul 2007 09:12:17 -0700, 185-191.5-85.cust.bluewin.ch
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:896
Article PK: 862451


On Wed, 18 Jul 2007 07:50:28 -0700, Robson wrote:

> Hi,
>
> I have a problem to replicate a field Image from Sybase to MS SQL Server.
>
> I use Direct Connect 12.50.07.0006 with SQL Server 2000.
>
> When I replicate this field(type Image), its returns a error:
>
> I. 2007/07/13 15:13:42. The DSI thread for database 'FMDITESTE.FM_USP' is
> started.
> E. 2007/07/13 15:13:45. ERROR #1028 DSI EXEC(302(1) FMDITESTE.FM_USP) -
> dsiqmint.c(3059)
> Message from server: Message: 30291, State 0, Severity 19 --
> '[VENDORLIB] Vendor Library Error: [[Message Iteration=1|Data Source
> Name=fmdisql|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC SQL
> Server Driver][SQL Server]'ciphertext' is not a recognized option.] <DCA>'.
> H. 2007/07/13 15:13:45. THREAD FATAL ERROR #5049 DSI EXEC(302(1)

Hmmm - I don't see how this is related to the IMAGE datatype. It looks to
me like you've created a connection with sqlserver function class, rather
than mssql, so it is sending Sybase ASE commands.

At least that's what it looks like to me.

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html


Robson Posted on 2007-07-18 18:32:39.0Z
From: "Robson" <robsonbrandao@gmail.com>
Newsgroups: sybase.public.rep-agent
References: <469e1aa4@forums-1-dub> <pan.2007.07.18.16.12.19.601233@peppler.org>
Subject: Re: Replicate type Image to MS SQL Server
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 200.136.13.168
X-Original-NNTP-Posting-Host: 200.136.13.168
Message-ID: <469e5cc7@forums-1-dub>
Date: 18 Jul 2007 11:32:39 -0700
X-Trace: forums-1-dub 1184783559 200.136.13.168 (18 Jul 2007 11:32:39 -0700)
X-Original-Trace: 18 Jul 2007 11:32:39 -0700, 200.136.13.168
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:897
Article PK: 841522

Do you have idea about what´s happened in this case ? ´ciphertext´ is
strange.

"Michael Peppler" <mpeppler@peppler.org> escreveu na mensagem
news:pan.2007.07.18.16.12.19.601233@peppler.org...

> On Wed, 18 Jul 2007 07:50:28 -0700, Robson wrote:
>
>> Hi,
>>
>> I have a problem to replicate a field Image from Sybase to MS SQL Server.
>>
>> I use Direct Connect 12.50.07.0006 with SQL Server 2000.
>>
>> When I replicate this field(type Image), its returns a error:
>>
>> I. 2007/07/13 15:13:42. The DSI thread for database 'FMDITESTE.FM_USP' is
>> started.
>> E. 2007/07/13 15:13:45. ERROR #1028 DSI EXEC(302(1) FMDITESTE.FM_USP) -
>> dsiqmint.c(3059)
>> Message from server: Message: 30291, State 0, Severity 19 --
>> '[VENDORLIB] Vendor Library Error: [[Message Iteration=1|Data Source
>> Name=fmdisql|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC SQL
>> Server Driver][SQL Server]'ciphertext' is not a recognized option.]
>> <DCA>'.
>> H. 2007/07/13 15:13:45. THREAD FATAL ERROR #5049 DSI EXEC(302(1)
>
> Hmmm - I don't see how this is related to the IMAGE datatype. It looks to
> me like you've created a connection with sqlserver function class, rather
> than mssql, so it is sending Sybase ASE commands.
>
> At least that's what it looks like to me.
>
> Michael
> --
> Michael Peppler - Peppler Consulting SaRL
> mpeppler@peppler.org - http://www.peppler.org
> Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
> Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
>


Robson Posted on 2007-07-18 21:46:43.0Z
From: "Robson" <robsonbrandao@gmail.com>
Newsgroups: sybase.public.rep-agent
References: <469e1aa4@forums-1-dub> <pan.2007.07.18.16.12.19.601233@peppler.org> <469e5cc7@forums-1-dub>
Subject: Re: Replicate type Image to MS SQL Server
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 200.136.13.168
X-Original-NNTP-Posting-Host: 200.136.13.168
Message-ID: <469e8a43@forums-1-dub>
Date: 18 Jul 2007 14:46:43 -0700
X-Trace: forums-1-dub 1184795203 200.136.13.168 (18 Jul 2007 14:46:43 -0700)
X-Original-Trace: 18 Jul 2007 14:46:43 -0700, 200.136.13.168
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:898
Article PK: 841523

Hi,

I have an other information:

I make insert without troubles. This error appear only I make an update.

"Robson" <robsonbrandao@gmail.com> escreveu na mensagem
news:469e5cc7@forums-1-dub...

> Do you have idea about what´s happened in this case ? ´ciphertext´ is
> strange.
>
> "Michael Peppler" <mpeppler@peppler.org> escreveu na mensagem
> news:pan.2007.07.18.16.12.19.601233@peppler.org...
>> On Wed, 18 Jul 2007 07:50:28 -0700, Robson wrote:
>>
>>> Hi,
>>>
>>> I have a problem to replicate a field Image from Sybase to MS SQL
>>> Server.
>>>
>>> I use Direct Connect 12.50.07.0006 with SQL Server 2000.
>>>
>>> When I replicate this field(type Image), its returns a error:
>>>
>>> I. 2007/07/13 15:13:42. The DSI thread for database 'FMDITESTE.FM_USP'
>>> is
>>> started.
>>> E. 2007/07/13 15:13:45. ERROR #1028 DSI EXEC(302(1) FMDITESTE.FM_USP) -
>>> dsiqmint.c(3059)
>>> Message from server: Message: 30291, State 0, Severity 19 --
>>> '[VENDORLIB] Vendor Library Error: [[Message Iteration=1|Data Source
>>> Name=fmdisql|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC
>>> SQL
>>> Server Driver][SQL Server]'ciphertext' is not a recognized option.]
>>> <DCA>'.
>>> H. 2007/07/13 15:13:45. THREAD FATAL ERROR #5049 DSI EXEC(302(1)
>>
>> Hmmm - I don't see how this is related to the IMAGE datatype. It looks to
>> me like you've created a connection with sqlserver function class, rather
>> than mssql, so it is sending Sybase ASE commands.
>>
>> At least that's what it looks like to me.
>>
>> Michael
>> --
>> Michael Peppler - Peppler Consulting SaRL
>> mpeppler@peppler.org - http://www.peppler.org
>> Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
>> Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
>>
>
>


mpeppler Posted on 2007-07-19 06:19:21.0Z
Sender: 3939.46767b80.1804289383@sybase.com
From: mpeppler@peppler.org
Newsgroups: sybase.public.rep-agent
Subject: Re: Replicate type Image to MS SQL Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <469f0269.76dc.1681692777@sybase.com>
References: <469e8a43@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2007 23:19:21 -0700
X-Trace: forums-1-dub 1184825961 10.22.241.41 (18 Jul 2007 23:19:21 -0700)
X-Original-Trace: 18 Jul 2007 23:19:21 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:900
Article PK: 862449


> Hi,
>
> I have an other information:
>
> I make insert without troubles. This error appear only I
> make an update.

Mark is right on the money (and much clearer than me!)

Anyway - in heterogeneous environments I find it useful to
view the DSI trace. You can enable this with

trace "on", dsi, dsi_buf_dump

in the replication server.

Michael


"Mark A. Parsons" <iron_horse Posted on 2007-07-18 23:34:53.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
Subject: Re: Replicate type Image to MS SQL Server
References: <469e1aa4@forums-1-dub> <pan.2007.07.18.16.12.19.601233@peppler.org> <469e5cc7@forums-1-dub>
In-Reply-To: <469e5cc7@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: ool-4357fce9.dyn.optonline.net
X-Original-NNTP-Posting-Host: ool-4357fce9.dyn.optonline.net
Message-ID: <469ea39d$1@forums-1-dub>
Date: 18 Jul 2007 16:34:53 -0700
X-Trace: forums-1-dub 1184801693 67.87.252.233 (18 Jul 2007 16:34:53 -0700)
X-Original-Trace: 18 Jul 2007 16:34:53 -0700, ool-4357fce9.dyn.optonline.net
Lines: 82
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:899
Article PK: 862452

I think Michael's line of reasoning goes something like:

1 - the error message states: 'ciphertext' is not a recognized option

There 2 keywords here ... 'option' implying a 'set' command was issued ... 'ciphertext' being the argument to the 'set'
command. So MSSQL probably received something like: 'set ciphertext ...'

2 - 'set ciphertext' is probably an invalid command in MSSQL (hence the error message), but 'set ciphertext' *is* a
valid command in Sybase ASE

3 - since the error message is being generated by the DSI thread this would imply the 'set ciphertext' command was
issued by the DSI connection to the MSSQL server

4 - The DSI thread communicates with the target dataserver/database using the language constructs available in the
function string class assigned to the DSI thread.

5 - If the DSI is sending a 'set ciphertext' command, and 'set ciphertext' is a Sybase ASE command, then it sounds like
you may have an ASE function string class (eg, rs_sqlserver_function_class) assigned to your DSI

6 - Since your DSI is talking to a MSSQL server it should be using a MSSQL-specific function string class (eg,
rs_msss_function_class)

Soooo, this *may* just be a case of having your DSI configured incorrectly. And, yes, you may find that some commands
go through ok while others do not ... this is due primarily to the fact that MSSQL server is a spin-off of Sybase ASE
and so there are quite a few commands that will work in both products.

You can verify your function string class assignments by logging into your RSSD and issuing the following:

===========
rs_helpdb
go
===========

Find the result record for the MSSQL database in question and see what's listed under the 'funcclass' column.

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

If none of the above makes sense ... post back here with the *entire* output from running 'rs_helpdb' in your RSSD.

Robson wrote:
> Do you have idea about what´s happened in this case ? ´ciphertext´ is
> strange.
>
> "Michael Peppler" <mpeppler@peppler.org> escreveu na mensagem
> news:pan.2007.07.18.16.12.19.601233@peppler.org...
>> On Wed, 18 Jul 2007 07:50:28 -0700, Robson wrote:
>>
>>> Hi,
>>>
>>> I have a problem to replicate a field Image from Sybase to MS SQL Server.
>>>
>>> I use Direct Connect 12.50.07.0006 with SQL Server 2000.
>>>
>>> When I replicate this field(type Image), its returns a error:
>>>
>>> I. 2007/07/13 15:13:42. The DSI thread for database 'FMDITESTE.FM_USP' is
>>> started.
>>> E. 2007/07/13 15:13:45. ERROR #1028 DSI EXEC(302(1) FMDITESTE.FM_USP) -
>>> dsiqmint.c(3059)
>>> Message from server: Message: 30291, State 0, Severity 19 --
>>> '[VENDORLIB] Vendor Library Error: [[Message Iteration=1|Data Source
>>> Name=fmdisql|SQLState=42000|Native Error=195|Message=[Microsoft][ODBC SQL
>>> Server Driver][SQL Server]'ciphertext' is not a recognized option.]
>>> <DCA>'.
>>> H. 2007/07/13 15:13:45. THREAD FATAL ERROR #5049 DSI EXEC(302(1)
>> Hmmm - I don't see how this is related to the IMAGE datatype. It looks to
>> me like you've created a connection with sqlserver function class, rather
>> than mssql, so it is sending Sybase ASE commands.
>>
>> At least that's what it looks like to me.
>>
>> Michael
>> --
>> Michael Peppler - Peppler Consulting SaRL
>> mpeppler@peppler.org - http://www.peppler.org
>> Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
>> Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html
>>
>
>