You’re offline. This is a read only version of the page.
Hi,
A client we are currently supporting is receiving the following error :-
[Microsoft][SQL Server Native Client 11.0][SQL Server] Invalid object name '##0242442 '
each time he closes GP.
Any suggestions on how to rectify this issue and kindly explain what is causing this.
Thanks in advance.
Andrea
*This post is locked for comments
Hi David,
I'm afraid not since it happened to our client and that is the only screenshot he provided. I made it a point that whenever something similar happens he takes it step by step and takes screenshot of every window in order.
Thanks for asking though.
Andrea
Hi Andrea
Is there a second error dialog that provides the name of the temp table that had the Invalid Object name '##??????' error?
This would help us know what code is having trouble.
David
Hi All,
Thanks for your responses,
Richard Wheeler I made the duplicate user as a POWERUSER just as it was before and the issue still remained, the user generally gets the issue after a day's work and when he tries to exit GP before leaving the office. With regards to third party products they have none.
Beat Bucher and David Musgrave thanks for the links and insights provided, I shall have a look at them and try to solve this issue out. Will get back to you when I have some sort of update.
Thanks again
Hi
I agree with @Beat Bucher.
Your workstation lost its SQL connection and when it reconnected with a different SPID it was no longer able to see the temporary file previously created.
Make sure you turn off hibernate or sleep power options. If the machine sleeps or hibernates while GP is logged in, you will lose your SQL connection and access to any temporary tables created before the machine went to sleep.
Read the articles on my old blog.
blogs.msdn.com/.../unexplained-temp-table-errors.aspx
blogs.msdn.com/.../more-on-sql-server-connection-issues-with-microsoft-dynamics-gp.aspx
David
Andrea,
Have a look at this GPUG Community thread and the answers posted by David Musgrave :
If you make this user a PowerUser dos this issue remain? If it doesn't then it is a security issue. You could try running GRANT.SQL plus what third-party products are you using? Also, what is this user doing when they get this message?
Yes,
It is very likely related and I'd start investigation towards your network connection stability.. Dynamics GP is a client server application that relies on a solid network connection. If your infrastructure is wacky, you're going to run into trouble.
There are numerous posts here in the forum related to the same issue.. Read a few of them to get an idea for solutions.
Update on this.
I have kept the user receiving this issues mentioned up to now ACTIVE since the client wanted to revert just in case and I created a duplicate user with the same settings the original user has. He has now received a new error as per screenshot below.
Following some research I found out this article on the error ( https://support.microsoft.com/en-au/help/3201492/-a-remove-range-operation-on-table-sycontentpagexmlcache-cannot-find-t ) which states that the error is due to a network connection getting dropped or other connectivity issue.
Could it be that the other errors are also related ? Since they revolve around the same statement just the name table changes.
HI Andrea,
Yes, I'd too create a new user based on the same security model as the faulty user that has the problem.. This way you ensure the proper access is granted on the SQL side and not miss any security on the GP side of things.
Once you can confirm the issue is resolved with the new account, you can drop the old one (or disable it).
I cannot check what is under the More Info button since this happened at our client's environment. Hopefully I can recreate the error when at the client's environment and take a screenshot of it.
With regards to dropping the user, I prefer to create a new user with the same rights as the current user and then disable the current user instead of dropping the current user (this should be ok, correct ?).
Will update you with the results in the coming days, thanks for your assistance.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (