Microsoft Dynamics GP (Archived)

Dynamics GP 2016 Error

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (13)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

This is referring to a temp table in SQL and for whatever reason this user cannot access this table. I would try deleting this user from GP and recreating it. If you run into issues you will need to go into SSMS to clean up this user.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Richard,

Thanks for your reply I will have to check and try out your solution on site since we do not have remote access to our client's server.

In addition to my initial problem the client is also facing the issue below when trying to access the Suggest Items form from the Item Maintenance Form.

From some research I did the IV_Suggest_Sales_Setup_LINE_Temp table is also a temp table. Could both issues be related ? and also note that these issues are being faced by the same user maybe this helps.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

This is a security issue. You could try running the GRANT.SQL script but dropping and recreating the user will have the same effect. What is under the More Info button?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Andrea,

Have a look at this GPUG Community thread and the answers posted by David Musgrave :

https://www.gpug.com/communities/community-home/digestviewer/viewthread?GroupId=247&MID=23919&tab=digestviewer

Was this reply helpful? Yes No
Suggested answer

David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (0)

Report

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/.../the-stored-procedure-createsqltmptable-returned-the-following-results-dbms-12-exceptions.aspx

blogs.msdn.com/.../unexplained-temp-table-errors.aspx

blogs.msdn.com/.../tcp-chimney-setting-and-sql-server-error-tcp-provider-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspx

blogs.msdn.com/.../more-on-sql-server-connection-issues-with-microsoft-dynamics-gp.aspx

David

Was this reply helpful? Yes No