Microsoft Dynamics GP Error: “A Countrecords operation on table ‘[Not Found]’ (45).”

Microsoft Dynamics GPI was recently working onsite with a client when I was shown an error message which some users has intermittently been reporting. Every so often they would receive the following error:

A Countrecords operation on table '[Not Found]' (45).

A Countrecords operation on table '[Not Found]' (45).

A little research found me this post by Tim Wappat where he explains this is an error due to a network connection glitch.

Network interruptions are known to cause issues with Microsoft Dynamics GP; this is because it takes a persistent connection with SQL Server. Not all network interruptions are due to a problem; some of them are because clients lock their PC when they go to lunch, but left Dynamics GP running. When the PC has been locked for a few minutes it goes to sleep. Whe the user wakes it up and resumes working, Dynamics GP makes a new connection to the database which is assigned a new SID, but Dynamics GP still thinks it has the original SID.

After advising the client to have users always log out when they are leaving their PC for a while, they have reported that users no longer see the error.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

Your email address will not be published. Required fields are marked *