http://www.perlmonks.org?node_id=1040518


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