On Sun, 2003-08-03 at 08:10, Matthew O. Persico wrote: > I'm getting flaky behaviour from one query. It will fail with a tds token error, but > it cannot be recreated on the next run for the same data. To wit: > > 20030803.02:01:34: Portia::Utils::portfolioInfo > : Cannot execute statement <snip> > : handleType => statement > : OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (5) > NUMBER = (28) > : Message String: ct_results(): protocol specific layer: external > error: There is a tds protocol error. An illegal token was received. > : Stopped > : => at /am/common/lib/site_perl/5.6.1/Portia/Utils.pm line 431 > > Perl 5.6.1 > Adaptive Server Enterprise/12.0.0.7/P/EBF 10869 ROLLUP/Sun_svr4/OS > 5.6/1996/32bit/FBO/Fri Feb 21 03:19:58 2003 > DBD::Sybase 1.00 > DBI 1.37
First things first: Have you checked the error log for the ASE server? There may be a clue there as to why this is failing. > > I had similar problems with the same query for a while under perl 5.004, but the > error message was to the effect that no statement was executing, when the statement > did execute and there > was data to be found. I worked around that in my code by ignoring the error if I had > data, but this is entirely different. > > The funny thing is, it feels like a timing issue I don't think that is the problem. I suspect a problem at the server end, because the query in itself looks perfectly fine. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
