I have received the following error ORA-01002 fetch of sequence quite a few times while generating reports.
The Clients which have been developed in Reports 2.5
the DB Version is Oracle8 Enterprise Edition Release - Production . PL/SQL Release - Production .

The error is not often though and can be solved while re-writing the query or removing the order by which is not possible always .

The query runs fine from SQL though .....