Hi.
When I run a report , it gives an error as
ORA-01002:fetch out of sequence problem.
The report contains only couple of queries with parameters. When I run the same report in different env, it works fine. But in production env, it displays with the above error message. The report works fine If i run for individual item but if I give % to run for all items. Then It displays an error message.
I asked my DBA to check the Rollaback segment, he says it is ok. I am still not able to understand, what might be the problem. Can somebody help me on this problem. I am using Oralce report 2.5. One query has some four joins.
Try the following workarounds:
1. Edit the report in Reports Designer:
- Open Reports Designer
- Find and open the relevant .rdf file that is causing the problem.
- Go to Menu -> Tools -> Tools Option -> Runtime Settings and set
Non-blocking SQL to unchecked
- The go to Menu -> File -> Compile All.
- Save the .rdf file
Note: Make a copy of the .rdf file before you edit the one that was installed with Designer as a safeguard measure. Edit the supplied file and not the copied one, otherwise the changes will not been seen in the Repository Reports area.
2. In Windows 95 and NT look at the following registry key:
EXECUTE_REPORTS_RUNTIME = C:\ORAWIN95\BIN\R25RUN32.E
Change this to:
EXECUTE_REPORTS_RUNTIME = C:\ORAWIN95\BIN\R25RUN32.E
Note: This means all reports may be passed this at runtime.
Let me know whether this fixed your problem.