5.1.8 (although version is irrelevant) on Oracle 9.2.0.4.
I have a report with 4 data providers. DPs 1, 2 and 4 refresh no problem. DP3 fails with an ORA-03113: end-of-file on communication channel. If I copy the SQL from this DP into TOAD it runs no problem.
I removed the condition > 1, which removes the HAVING clause from my sql - and magically it works! Obviously that is no good to my user. First I changed the condition such that it was In List (2,3,4,5,6) - as it happens the possible number of values is quite small - that works so I have a fudge in place.
I then re-ordered my conditions. There are three pre-defined conditions ANDed together followed by an AND with the measure condition. If I remove all the conditions and put >1 first then add the rest it works!
Interestingly, the report had not been changed and was last successfully run on Oracle 8.1.7.4. So I just though I’d document this in case anyone trips over a similar problem in the future. 8)
Nick Daniels (BOB member since 2002-08-15)