Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

OpenClient error with Perl DBI Sybase IQ

by cmahajan (Initiate)
on Jun 26, 2013 at 04:39 UTC ( #1040697=perlquestion: print w/ replies, xml ) Need Help??
cmahajan has asked for the wisdom of the Perl Monks concerning the following question:

I have another thread on this issue but it seems no one is active on that thread so starting a new one.
Old thread and more details here: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

I enabled DBI Tracing in my script and here's the error message I got in the trace file. I was lucky enough that the issue occurred shortly after I added the tracing code in my code. From the error message I believe that this is related to the network configuration on my Unix machine (IBM AIX).

Any ideas on how to go about fixing this?

-> FETCH for DBD::Sybase::db (DBI::db=HASH(0x30844064)~INNER 'Driver') + ERROR: 50 'OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = ( +5) NUMBER = (28) Server bhedw_dev, database Message String: ct_results(): protocol spec +ific layer: external error: There is a tds protocol error. An illegal + token was received. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (50) Server bhedw_dev +, database Message String: ct_cmd_drop(): user api layer: external er +ror: The connection has been marked dead.

Comment on OpenClient error with Perl DBI Sybase IQ
Download Code
Re: OpenClient error with Perl DBI Sybase IQ
by Anonymous Monk on Jun 26, 2013 at 07:49 UTC

    Any ideas on how to go about fixing this?

    Lookup the error message in the database(driver) manual or supporting mailing lists, so you know what it means and/or what to do

    Then upgrade stuff until it is fixed and/or contact support

    For example  [ddg://There is a tds protocol error. An illegal token was received.] There is a tds protocol error. An illegal token was received. -> FIX: SYBASE CT-Library Clients Cannot Connect to Microsoft SQL Server 7.0 says to install a "service pack " on the server, and/or upgrade to newer client libraries

    So you'd install new client libraries, then recompile DBD::Sybase to use those new client libraries, and then hopefully the problem goes away

Re: OpenClient error with Perl DBI Sybase IQ
by jfroebe (Vicar) on Jun 26, 2013 at 13:09 UTC

    Basically the error is Sybase's OpenClient saying we received junk data on the connection to the IQ server. I don't know what to do with it so I'll close the connection.

    This isn't a Perl issue. I would open a technical case with SAP/Sybase or ask on the SAP Sybase IQ Community web page.

    Jason L. Froebe

    Blog, Tech Blog

Re: OpenClient error with Perl DBI Sybase IQ
by mpeppler (Vicar) on Jul 19, 2013 at 11:37 UTC
    To add to jfroebe's comment - try to use the isql command that is part of your OpenClient package and connect to your IQ server.

    If that fails as well then you have a repro that your Sybase IQ techs can work with.

    Michael

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1040697]
Approved by jfroebe
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2014-08-21 02:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (127 votes), past polls