Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
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: (6)
As of 2014-07-31 23:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (255 votes), past polls