Hi,
I'm getting the error 'Fetch Out of Sequence' in QA and Production servers but not in development server. Our QA and production servers are under AIX OS.
The particular module was working fine in production server till our previous release, but in the last release it is not working though we haven't done any code change.
Please help me in getting the solution for fixing this issue.
Thanks in advance.
> No, we are indexing by number. Please note that this
> is working fine in our development environment. But
> in production enviroment it is not working.
This actually makes things worse IMO.
The problem is one of the following and all of these should be investigated.
1) Differences between platforms in development and production regarding database vendor and/or version, driver vendor and/or version. It's possible you have a development environment that supports an out of order fetch while in the production you don't.
Hopefully it's (1) because the next two are worse.
2) There are unaccounted for changes in the structure of tables between your development and production environments. These are far more likely to be the source of the problem if you are doing something silly like SELECT *
3) You have a threading problem of some sort. This one would be the nastiest but is certainly a possibility and often the kind of problem one encounters when one did not test properly and then has problems taking working code from a development environment to a production environment.
