While attempting to run a Jet Query, I am receiving the following error message:
This is a report I run weekly, and I am getting this error at the end of the month so it seems to be happening when there is an increase in amount of data it is returning (or the time it is taking).
Any ideas where to look?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello,
Does this happen every time you run the report at month end?
The connection is being closed on the server side. You may need to investigate why the server is closing the connection.
Regards, -
Jet Reports Historic Posts Thanks for your reply. Not always at month end, but never in the begging of the month. Could it be the server is timing out? I will have a look to try and determine why the server is closing the connection.
-
Jet Reports Historic Posts Hi Bruce,
The error says there was a server initiated shutdown.
Either the NAV service was restarted, or NAV took to long to respond to a Jet request and stopped the connection.
If this happens each time a user runs the report, please turn on logging and send in the logs (make sure that logging is not left enabled as it create large files and slows down reporting).
If it does not happen regularly, it was a coincidence of the report running when someone restarted the NAV service.
Regards,
Please sign in to leave a comment.