Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^4: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

by cmahajan (Initiate)
on Jun 25, 2013 at 02:47 UTC ( #1040518=note: print w/replies, xml ) Need Help??


in reply to Re^3: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4
in thread 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 specific 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 error: The connection has been marked dead. ===================================
  • Comment on Re^4: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

Replies are listed 'Best First'.
Re^5: DBD::Sybase query execute hangs randomly for Sybase IQ 15.4
by jfroebe (Parson) on Sep 19, 2013 at 13:08 UTC

    Try running the query from isql or dbisql. isql will handle t-sql and dbisql will handle Watcom-SQL.

    Jason L. Froebe

    Blog, Tech Blog

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1040518]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (4)
As of 2021-10-25 21:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (90 votes). Check out past polls.

    Notices?