Apache module crashes woth ORA-01002

[hsteigstra]

Dear Marco,

We have an Apache module that regularly freezes. Today we did a test with two clients doing the same refresh of the data repeatedly and simultanously and in 10 seconds both clients crashed, one with a general exception, the other with a ORA-01002 message (Fetch out of sequence).
What might be the cause of this? I think it has to do with multi- tiering. I have set the ThreadSafe property of the TOracleSession to true, Pooling to spInternal and an TOracleSessionPool attached with Pooltype=ptDefault. We use DOA 4.06.

Any idea where to look for a cause/solution?

Thanks very much,
Herman Steigstra

 

[Marco Kalter]

Can you provide the SQL statement for which the ORA-01002 occurs?

 

[hsteigstra]

No, sorry, there are a number of queries that are refreshed. Normally there is no problem with the execution of either of them. Only when two instances request data in parallel the application crashes.....