Is anybody else experiencing issues with reports since upgrading to v.14. Our scheduled Order Export Utility report keeps showing us results outside the set parameters. Both in scheduled and ad hoc runs of the report.
Once we can get the report to run properly, we cannot recreate the problem for that day.
I already have a ticket in for this issue but wanted to know if anybody else has been experiencing similar issues.
Thanks,
Karen
That sounds a bit like the T_NEXT_ID table is out of sync with the work table. Each run of the utility creates a session ID (based on the value stored in T_NEXT_ID), and rows are written and read from the work table using that session ID. If there are existing rows in the work table with the session ID, they may be included in the report output.
So what you might be experiencing is that there exist rows in the work table with session IDs greater than the value in T_NEXT_ID. Each run of the report increments the session ID, so eventually you run out of extra rows to return.