Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / nodus credit card adva...
Microsoft Dynamics GP (Archived)

nodus credit card advantage issues

(0) ShareShare
ReportReport
Posted on by Jennifer Kaufman

We installed Nodus Credit Card Advantage last Fall and I'm trying to determine if that software is the cause of what seems to be network connectivity issues.  About once a week when posting inventory transactions, GP will lock up and has to be forced shut down and relogon.  The user reposts the inventory transaction and all is fine except what she was trying to post before the lock up shows up on the inventory transaction report and will continue to show up on all future reports for that user until I clean up the database.  We have also see them system lock up during Item Transaction Iquries.  If the system doesn't just lock up we get errors like 'a get/change operation on table XXXX cannot find the table.  I have a constant ping check on the server and that never send out an alert that network connectivity is lost.  I have been working with Microsoft to determine the cause but they just say network connectivity.  I'm thinking it could be CCA. 

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: nodus credit card advantage issues

    I think that the best place for reports.dic as far as performance is to be local to the machine where the GP application is being run.  Not really my area of expertise, but I believe the question of which server is best would greatly depend on the specs of (and probably traffic on?) the servers - if the server specs are identical, I don't know that there is any advantage to putting reports.dic on the SQL server.  

  • Jennifer Kaufman Profile Picture
    Jennifer Kaufman on at
    Re: nodus credit card advantage issues

    thanks for the assistance.  I will continue to work with microsoft.  I doubt this is related, but where is the best place to store custom reports.dic files?  We saved shared .dic files on a file server seperate from the gp sql server.  would it be better to put them on the sql server?  

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: nodus credit card advantage issues

    My query was just seeing how many 'stranded' SQL sessions you have in GP.  Typically when there are a lot of connectivity errors I would expect that number to be much larger.  Unless you just restarted SQL Services (or ran Francisco's query, which clears out all stranded sessions/locks).

    I would recommend you keep working with support on this - as I mentioned, this type of stuff is very difficult to troubleshoot, especially in a forum, typically you need someone looking at this stuff with you, which they can do.

  • Jennifer Kaufman Profile Picture
    Jennifer Kaufman on at
    Re: nodus credit card advantage issues

    someone got an error yesterday.  Can you tell me exactly what that query is telling me?  Can't find anything in the logs that is helpful.  Microsoft gave me a netmon script to run continuously to monitor a system until the issue arises.  I guess I best get that running on the computer that got the error yesterday.   The script is supposed to keep the log files from growing out of control.  

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: nodus credit card advantage issues

    That's pretty low...have your users gotten any of the errors recently?  Is there anything in the log files when the issues do happen?  (Either SQL Server or Windows?)

    I am also surprised that MS Support would just leave it at "connectivity issues" - what do they say is the next step?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: nodus credit card advantage issues

    Please run then this script to clear out the stranded users/sessions

    delete from DYNAMICS..ACTIVITY where USERID not in (select loginame from master..sysprocesses)

    delete from tempdb..DEX_SESSION where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY)

    delete from tempdb..DEX_LOCK where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY)

    delete from DYNAMICS..SY00800 where USERID not in (select USERID from DYNAMICS..ACTIVITY)

    delete from DYNAMICS..SY00801 where USERID not in (select USERID from DYNAMICS..ACTIVITY)

  • Jennifer Kaufman Profile Picture
    Jennifer Kaufman on at
    Re: nodus credit card advantage issues

    i ran the query and the result is "2"

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: nodus credit card advantage issues

    I would be surprised if CCA is causing this.  The errors that you are experiencing do sound like connectivity issues to me.  This kind of stuff is notoriously difficult to troubleshoot if it's only happening sporadically.  Out of curiosity, when the SQL server has been up for at least a few days, or especially after these errors come up, can you run the following in SQL and post the results?

    select count(*) from tempdb..DEX_SESSION

    where Session_ID not in (select SQLSESID from DYNAMICS..ACTIVITY)

  • Jennifer Kaufman Profile Picture
    Jennifer Kaufman on at
    Re: nodus credit card advantage issues

    My systems do have 2 GB or more.  The hard drive space is also more than 20%.  We are also getting errors like 'an edit operation on table 'sop_hdr_work' failed accessing SQL data.'  

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: nodus credit card advantage issues

    Unless you actually have network issues, the most probable issue is memory on the workstation.  If the workstation has 2 gigs or less, long postings will often fill memory (remember the old memory leak problems??) and the system then locks up until you log of/log back in.  You can let the task manager run and watch free memory as the posting progresses to see if memory is running low.

    Another thing to look at is disk space on the workstation and the server.  If free space goes below 20% on either drive, then that device will start slowing down.  If more time is spent finding space to, lets say swap a task to disk then less time is available for network responses.  Too many failures and you are off line.

    We have CCA in a number of sites and did not have this problem.  But I require my customers to have more RAM than most.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans