-710 Error in Multithreaded Informix 7.24 UCX5 on HP-UX 10.20

My multi-threaded Informix esql process received a -710 (table-name has been dropped, altered, or renamed) error. The process was using a prepared statement to fetch using a cursor. The source table was not dropped, altered, or renamed. I can't reproduce the problem. Subsequent runs of the code work just fine. Any ideas on what to investigate here? Are others getting occasional & misleading -710 error messages in multi-threaded processes with Informix 7.24 UCX5 on HP-UX 10.20?

We ran into similar -710 problems under Solaris. We were running CDR, which seemed to cause it. The solution was to catch the -710 and re-prepare all statements. -Peter Jim Maus wrote: > > My multi-threaded Informix esql process received a -710 (table-name has been > dropped, altered, or renamed) error. The process was using a prepared > statement to fetch using a cursor. The source table was not dropped, > altered, or renamed. I can't reproduce the problem. Subsequent runs of the > code work just fine. > > Any ideas on what to investigate here? Are others getting occasional & > misleading -710 error messages in multi-threaded processes with Informix > 7.24 UCX5 on HP-UX 10.20?

Slight correction ... it was HDR that we were running. -Peter Peter Sylvester wrote: > > We ran into similar -710 problems under Solaris. We were running CDR, > which seemed to cause it. The solution was to catch the -710 and > re-prepare all statements. > > -Peter > > Jim Maus wrote: > > > > My multi-threaded Informix esql process received a -710 (table-name has been > > dropped, altered, or renamed) error. The process was using a prepared > > statement to fetch using a cursor. The source table was not dropped, > > altered, or renamed. I can't reproduce the problem. Subsequent runs of the > > code work just fine. > > > > Any ideas on what to investigate here? Are others getting occasional & > > misleading -710 error messages in multi-threaded processes with Informix > > 7.24 UCX5 on HP-UX 10.20?