Sybase error -5702 and -1

Hi I saw various postings related to error 5702.
Usally the problem is solved by upgrading the sybase version as this is
a bug in previous versions. But my case is opposite.

I have a C app. that is creating a cursor on a table and calling a
stored procedure for each
entry. The stored proc creates few #temp tables, few cursors & update
few tables.
After say half an hour, the procedure returns with error -1 and
sql error in the C application is 5702 and connection terminates.

SQL Error: -5702, p_manip
Message: The SQL Server is terminating this process.

This application was working fine in version
Adaptive Server Enterprise/12.5.2/EBF 11799/P/Linux Intel/Enterprise
Linux/ase1252/1831/32-bit/OPT/

But as i moved this appl. to a higher version,
Adaptive Server Enterprise/12.5.3/EBF 12600 ESD#3/P/Linux
Intel/Enterprise
Linux/ase1253/1911/32-bit/OPT/
I had this problem.

I don't have access to server m/c. Can I see the stack trace on client
m/c

Any ptrs would be appreciated.

Thanks.

.

Relevant Pages

  • Re: SQL Server Parameters
    ... I understand what SQL Server is doing and it is doing as ... > have a missing param or misspelled it, ... >> a SQL error back that Procedure XYZ is expecting Parameter '@myParameter' ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Error The SQL Server Might Not Be Started WSS
    ... I have a WSS Site that returns an error when a user trys to post an ... SQL Error ... The SQL Server might not be Started. ...
    (microsoft.public.sharepoint.windowsservices)
  • SQL Jobs Hanging...
    ... The Jobs in my sql server 2000 are hanging.The backup job backs up all ... the 30 databases except 2 of them,but the job never completes. ... viewer or SQL error logs.When I use check db on tempdb ... temp tables. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Error The SQL Server Might Not Be Started WSS
    ... Is SQL Server running on the same ... Is you content database on a database server ... Perhaps your SQL Server is not running. ... > SQL Error ...
    (microsoft.public.sharepoint.windowsservices)