Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / What steps of troubles...
Microsoft Dynamics GP (Archived)

What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

(0) ShareShare
ReportReport
Posted on by Heather Howell 85

I am supporting the dynamics installation in our environment. Recently we bought a couple of windows 7 workstations as part of a plan to eventually phase out windows xp dynamics GP client workstations. About the same time we upgraded the sql server for dynamics from 2005 x86 to 2008 x64 version. Ever since doing that we have issues with this windows 7 workstation. While running dynamics it will drop a lot of packets and then close the odbc connection back to sql server. This results in Dynamics GP hanging up and then when I launch it again I must recover the items I was trying to enter when the application crashed. This issue only exists on a windows 7 Dynamics box. I've tried x64 and x86 windows 7 professional builds.

We run the Wennsoft Classic 2010 Job Costing Module integration package.

I have open threads on sql server 2008 R2 forums and windows server 2008 forums that describes my actual issues and troubleshooting steps taken with this issue. If anyone cares to read further the links are below.

I am at a total loss as to whether this is a win 7 issue, a server 2008 issue, a sql server issue, or a dynamics issue. I think I can safely say it isn't a network hardware issue since i'm now running on a new switch that I bought to troubleshoot this issue. I'm posting this everywhere in hopes that the right person will see it.

sql forums thread -  http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/4a2d4cb4-f09d-441e-9071-375f78bf8cf8

windows server forums thread - http://social.technet.microsoft.com/Forums/en/winservergen/thread/a13fee2f-7265-4a38-9b19-a538244868bf

 

*This post is locked for comments

  • Verified answer
    Heather Howell Profile Picture
    Heather Howell 85 on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    Francisco,

    I check and auto-close is disabled on my dynamics and company databases.

    Richard,

    I was thinking the issue was something along these lines but one of my troubleshooting tries was to build the same computer but use x86 instead of x64 win 7. The issue remained however.

    Most recently I've modified some of the NIC features like tcp checksum offload, large send offload ipv4 and ipv6, and receive side scaling. Modifying these entries seemed to shorten some of the background processing time when working inside dynamics (less "non responsive" moments). And it also shortened the number of network failure messages I see each day. But my problem still happens occasionally.

    I think it's outside of dynamics really at this point. Unfortunately I really don't know where else to look. I'm going to run wireshark and see if I can watch the network failure happen.

    Thanks for the help everyone.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    It seems that I have heard that there is a special version of the ODBC if you are using Win 7 64 bit.  Have you looked at that?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    Heather, the feature of auto-close you can find it in your SQL Management Studio, right click on the database > select properties > go to options

  • Heather Howell Profile Picture
    Heather Howell 85 on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    I made a discovery yesterday when looking at my win xp dynamics clients secondary odbc (the one that is used with the access 2000 database), they were using a standard sql server odbc connection and not the native client 10.0 so I made the change to my win 7 workstation but they just called to tell me that they got the error messages again.

    The first error dialog goes something like "SQL GP Rep: Action cannot be preformed on an object that is closed", if that helps.  Looking on google that error seems to be sql syntax related but it doesn't make sense to me why the win xp users do not get this error but the win 7 users do. I would think if there is a syntax issue it would not run the sproc for anybody.

  • Heather Howell Profile Picture
    Heather Howell 85 on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    Sorry on the delay in response. I've also been fighting a custom win95 machine which runs a cnc mill and has issues only when running at 230V. Makes me want to pull my hair out!

    anywhoo..

    Richard,

    It is GP2010 and SQL Native Client 10.0 for both of my odbc connections.

    One connection is dynamics gp 2010 (installer created) and the other is the odbc to my access 2000 database (this odbc is used by my parts&vendors application)

    Francisco,

    I could not find the auto-close sql option you mentioned. Where is that?

    I am running the Sql native client 10.0 for my odbc. My Dynamics GP 2010 odbc data source was created by the installer and it uses my SA account as the execution account. However, I manually create my other odbc connection using native client 10.0 as well.

    I verified version info for you too:

    Dynamics GP version 11.00.1247

    Sql Server version 10.0.4000.0 SP2 Standard Edition 64 bit

    from what i can tell on the link you provided I am using a supported configuration..

    Today I have disabled DEP from the registry for this machine.

    Since the problem is intermittent it may take a few days to observe if these changes made any effect.

    Is there firewall configurations I should also check? I have 1433,1434, and 1954 open in TCP and UDP on my dynamics server incoming rules. On the client machine firewall I have no special settings.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    I would like to ask you how is your SQL server options configured, there is a feature in the options of the SQL server named "Auto-Close" if that is set to true, i will be closing your connections to the DB, also please take now about Richard's question,

    which ODBC client are you running?

    Please verify if your windows 7 computers have DEP turned on if so turn it off

    Also you did not mentioned which version of Dynamics GP you are running as it may turned into a non supported environment

    please verify this post and validate your environment http://gp.rosebizincblogs.com/2011/01/sql-server-and-dynamics-gp-version-compatibility.html

    Did you create the odbc connection or was done via the setup program?

     

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: What steps of troubleshooting can I take to determine the cause of network or disk error messages on windows 7 dynamics GP client workstations?

    Are you running Dynamics GP 10 or 2010?  What ODBC client are you using?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans