web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2010 - Unresolved Er...
Microsoft Dynamics GP (Archived)

GP2010 - Unresolved Errors on User Desktops / Clients

(0) ShareShare
ReportReport
Posted on by Srinivasan Sundaram 765

To ALL the GP Gurus & Experts:

We are getting the following errors SPORADICALLY in PO transactions Entry , Receiving Transaction Entry, Account Inquiry screens etc when the user wither completes the entry and closes the window to exit out or when trying to print to screen etc.  The errors are sporadic and cannot be created at will. It is not limited to few transaction screens or inquiry screens. It happens all over.  There are no messages in the SQL server nor any in the client event logs specific to these errors.  I do have DEX log dump and willing to share if anyone is interested in examining it further. I cannot make sense as to why these errors are happening so inconsistently. Fortunately, the transaction seems to be saved properly and as far as I know there is no data corruption or inconsistencies in the database.  However,  it is quite annoying to keep acknowledging the error messages that pops up one after another plus it is a concern too.. 

I have listed information about our environment and collated the error messages into 3 sets. The listed error messages are just a sample of big stack that I have..

I have spend hours searching  & googling and cannot find any definite solution/ explanation to this issues. We have been using Great Pains from version 9.0 on and recently upgraded to 2010. We did have these errors in GP10 but so rampant and frequent...

PLEASE help me understand and address this errors.

===============
Our Environment
===============

Application software : GP2010

Database Server - Windows 2008 SP1 - 64 Bit - 8 GB
Database version - SQL 2008 R2

User Desktops  - VM Ware clients running Windows XP - SP3 - 32 bit
ODBC Driver on Clients - SQL Server Native Client 10.0

=========
1st Set-:
=========
 1.1. A get/change operation on table 'SY_ResourceActivity' failed accesing SQL Data.
 1.2. An edit operation on table 'POP_Receipt' failed accessing SQL Data. 
 1.3. A get/change operaton on table 'ENC_audit_TEMP' cannot find the table.
etc etc
=========
2nd Set-:
=========
   2.1. ODBC Error: 08S01
        An error occured executing the SQL statements.
        GPS Erorr: 12
        SQL Error: 0 [Microsoft][SQL Server Native Client 10.0] Communication Link Failure.
========
3rd Set:
========
 3.1. The stored procedure create TmpTable returned the following results:
    DBMS: 12, Microsoft Dynamics GP: 0
     FP: Couldn't close table !.

 3.2. FP: Can't close table !.

 3.3 The stored procedure glpCreatePostingActivity returned the following results:
    DBMS:10054, Microsoft Dynamics GP: 0

 Please feel free to reach me for additional information or clarification regarding this errors.

Thanks in Advance.

SriniS

ssundaram@eid.org

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Well in a sense just by looking at the descriptions of your errors it all relates either to your conenction to the SQL server or permissions.

    on your first set, I would verify that the owner of your databases is DYNSA and re-run the Grant.SQL script.

    On your second set: could be your network card, or your network settings something that is breaking your communication to the server

    on your 3rd set error DBMS 10054 means as well that there is a disconnection to the server, that there was a failure on the communication and the connection was closed/

    As well i would check SQL databases and review if the property AutoClose is set to false

    It wouldnt hurt to review your ODBC settings to have unchecked ANSI-Nulls, as well any firewalls, ports etc,

    How are you connecting your clients to the server all via ODBC or thru citrix or any other remote desktop service, are you using hubs or switches, this is a large area to investigate but at least you can try something I am providing.

    Have a great day

  • Srinivasan Sundaram Profile Picture
    Srinivasan Sundaram 765 on at

    Francisco:

    Thanks for your input.

    I have already done the following-:

    1. Checked and ensured that DYNAMICS and company databases are owned by DYNSA user.

    2. I have executed the "grant.sql" so many times to ensure that permissions are set correctly for DYNSA user.

    3. The "Auto Close" property is set to False.

    4. I have unchecked all the boxes/options in SQL Server Native Client 10.0 ODBC settings as mentioned in the GP2010 upgrade documents.

    5. I have uninstalled Symantec AntiVirus that caused issues with Dexerity and GP2010 from coming up properly.

    So we have to kind of rule out the above.

    As far as the Clients are concerned, the Clients (Desktop users) connect to database server using the ODBC connection and NOT thru CITRUS or Terminal Server.

    Coming to the switches, network packets etc I have banking on our Network Admin to provide some ideas/ suggestions and unfortunately he cannot see any issue as well... It sounds weird and freaks me.. I tired this error messages and disruptions..

    Any more ideas ?? Please Share.

    Thanks Again

    SriniS

    ssundaram@eid.org

  • Community Member Profile Picture
    Community Member on at

    What SQL Server collation are you using?

    Ian.

  • Community Member Profile Picture
    Community Member on at

    Also - just the more I think about this...did you upgrade SQL recently, or did you transfer to a new server? or anything like that.

    What if you set up a brand new user in GP - will they get errors?

    Have you run the Grant.sql against the Dynamics database?

    Is Port 1433 definately available all of the time?

    Are you using the 32 bit or 64 bit version of the ODBC? Whichever one you are using...try the other!!

    (Use - C:\Windows\SysWOW64\odbcad32.exe to set up the 32 bit version).

    Ian.

  • Srinivasan Sundaram Profile Picture
    Srinivasan Sundaram 765 on at

    Ian:

    Thanks for pitching in..

    To answer your questions -:

    1. I have executed the "grant.sql" against the Dynamics and Company database several times.

    2. I have installed the GP2010 Client on newly imaged Windows XP environment and even on that there are these issues.

    3. The SQL Server collation is "SQL_Latin1_General_CP1_CI_AS" and compatibility level is "SQL Server 2008 (100) " as the database is "SQL Server 2008 R2 version".

    4. Prior to GP2010 upgrade, I upgraded the database (IN PLACE UPGRADE) from SQL Server 2005 to SQL Server 2008 R2 and only thing I changed in the Server option is the compatibility level to 100.

    5. I upgraded the application from GP10 to GP2010  IN PLACE UPGRADE and did not move/ migrate to another server or host. I did the upgrade after 3 months of SQL 2008 R2 upgrade.

    6. The ODBC version is definitely 32-bit on the Windows XP SP3 Client/ Desktop environment. I can try using another ...

    7. I haven't setup any new user. It is going to be challenge to have some user use it to do their daily transactions. I am not sure how that is going to help? Any basis for such a change?

    8.  How do I Check if port 1433 is always available? I assumed it is. any reason it will be locked out or something ?  Please tell me.

    Regards

    SriniS

    ssundaram@eid.org

  • Sureshn07 Profile Picture
    Sureshn07 702 on at

    Hi Srini,

    If there are any customizations, disable those and try.

  • Srinivasan Sundaram Profile Picture
    Srinivasan Sundaram 765 on at

    Suresh:

    Thanks for checking in.. We don't have any customizations !!

    Any idea as to what could be causing these errors?

    Regards

    SriniS

  • Azhar Jadoon Profile Picture
    Azhar Jadoon 260 on at

    Please check your Network Connection is - set properly ,

    the first set of problem happens when a network disconnction took  place and the following next in result  ,

    try on wired network and static IP -

    hope this may resolve

  • Srinivasan Sundaram Profile Picture
    Srinivasan Sundaram 765 on at

    Azhar:

    The network connections are set properly and it is a wired network. so What next?

    Anyone any more ideas? It is surprising that only we are facing this issue.. Anysite with more than 15 users concurrently logged in and using the system?

    Thanks

    SriniS

  • MarkM110 Profile Picture
    MarkM110 125 on at

    I assume that by now you would have found a solution to this issue. We are having similar troubles.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans