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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error when saving a ne...
Microsoft Dynamics GP (Archived)

Error when saving a new account

(0) ShareShare
ReportReport
Posted on by Community Member

I am using GP10.  When I create a new account and click on Save, the following error message appears: "A Save operation on table GL_Account_MSTR (45)." and it is not allowing me to create and save new account.  Any ideas how to get rid of this error message?  Thanks.

*This post is locked for comments

I have the same question (0)
  • K Day Profile Picture
    K Day 7,365 on at

    There are two KB articles on Customersource that talk about this, except that they are a little dated (older versions of GP).  At the least, they might be able to point you in the right direction.  One has to do with running the server based indexing scripts for FRx (older versions) that were wrong, the other had to do with the ODBC connection.  I would also consider running the Grant.sql script that grants execute rights to stored procedures to the DYNGRP.

    You could also run a DEXSQL log that might be able to help you.  Let us know if you don't know how to do that.

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYMXTYYKSWTLKQNNOXTLXRRORTSQKYNXOLKVUUPVQQTUTXVUTV

     

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYVTQUUXNNZOUKYPPPVSXNPVLXVQYYYUUOROVTVTPVQSWZLKTX

  • Community Member Profile Picture
    Community Member on at

    Hi, Thanks for your help.  I feel that those two KB articles are out-dated and might not be useful to solve my current issue.  But I am eager to know how to run Grant.sql and DEXSQL log and give a try.  Also I would like to know what is the cause of this error message.  I tried synchronizing account framework, tried check links for account master, but nothing seems to be solving this!

  • K Day Profile Picture
    K Day 7,365 on at

    You can find the Grant.sql script to run on a machine that has a client installed under the C:\program files\Microsoft Dynamics\GP\SQL\Util.  It is a script you can run against the dynamics and the company databases that will grant access to stored procedures, inserts, updates, etc... for DYNGRP.

    As far as the DexSql Log, here is a link to the steps.  Basically it creates a log file sort of recording what you are doing and all the SQL stuff going on behind the scenes.  Get that error message again while the trace is going on and you might be able to track down the error that way.  Remember to turn off the trace after you are done or you will get an enormous log file pretty quickly.

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYMXTYYKSWTLKQNNOXTOSMQXUOYNXZRLUMWTNOPUTVPUWUYLPL 

  • Community Member Profile Picture
    Community Member on at

    Hi,  atlast the problem is resolved. 

    I ran the grant.sql, but after that also the problem remained.  I tried DexSql.log method to identify the issue.  Then I found that insert, update, delete stored procedures had been corrupted.  I altered all those procedures by copying them from the working Fabrikam database of another SQL server instance and ran them against company database. While doing so, I got a message that "aagGetCompanyStatus" object was missing in DYNAMICS database.  I created that object also from that Fabrikam database.

    Now the issue is completely resolved.  All the master records in GP can now be created, updated and deleted without any issues.

    Thanks for your support Day!

     

     

     

     

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans