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/PT/
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/PT/
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.

Just to add, C application is using
esql. The esql libraries are quite old, installed around 4 yrs ago.

Just got access to stacke trace,
It seems that insert query on temp tables by procedure is causing
problem.

I am getting mesg infected with 11

But i think this bug is fixed in versions above 12.0

current process (0x29590064) infected with 11
00:00000:00186:2005/12/22 08:24:37.43 kernel Address 0x0x0000000e (),
siginfo (code, address) = (1, 0x0x004b0c40)
00:00000:00186:2005/12/22 08:24:37.46 kernel

00:00000:00186:2005/12/22 08:24:37.46 kernel SQL causing error :
insert into #temp select "dd", "ddss"