Help ! Bad token from sql server

[Manish Dighe]

hi all,
i have two servers - A(10.1.1) and B (11.9.2)
I execute a bcp from server A to get data from server B ( and store it in
A).
This is across WAN.
The error that i get is "db-library error : bad token from sql server :
datastream processing out of sync"

this actually succeeds if i give it from the command prompt but when i
invoke it from "Ashwin Monitor"
which is a kind of scheduler it fails.

the following is the nt log of server B "the description for event id (12)
in source (SERVERNAME B)
could not be found. It countains the following insertion string(s) : 120191,
convert send, lost process disconnected : SERVERNAME A 804 spid : 1"

what we suspect is that there could be a communication problem due to the
log.
does anyone know what exactly is the meaning of this error? and how to work
around it ?

thanks
manish

[Jason Froebe]

Manish Dighe wrote:

Hi,

Please post your question on
news://forums.sybase.com/sybase.public.sqlserver.general in the future as
the sybase.public.urgent_communications is for Sybase announcements.

thanks

[Anon...@sybase.com]

When you create a connection and pass info from one point to another, the
packets sent and received should be synchronized.
In your case, I think you are loosing datastreams along the connection.
I would rather recommend to download the information using bcps to files,
ftp the files to the other server and run the upload locally.
If Sybase encounters some streaming erros in the TDS packets, you will for
sure get the error you're mentioning.
FTPing the files will guaranty you the correctness and completness of the
info being transfered.

Regards,
Sebastian.

PS : If you need any further assistance, you can reach at
kretzig_...@jpmorgan.com