Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

A save operation on table 'MO_Order_MSTR' failed accessing sql data

Posted on by Microsoft Employee

Hello

I am facing these two error messages  in Manufacturing Order Form and BOM form

1. A save operation on table 'MO_Order_MSTR' failed accessing sql data ,  this message appears , when i open Manufacturing Order Form ,and then when i save the Manufacturing Order .

2. A save operation on Table 'BOM_Line ' failed accessing Sql Data, when i add button after the adding new components in the BOM form

If someone knows about these errors please give me solution

HILAL UDDIN

IT Project Manager

CPC - Riyadh  

 

 

*This post is locked for comments

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: A save operation on table 'MO_Order_MSTR' failed accessing sql data

    good finding.

  • Frank Hillsnipe Profile Picture
    Frank Hillsnipe 1,330 on at
    Re: Re: A save operation on table 'MO_Order_MSTR' failed accessing sql data

    Hilal,

    I ran into a very similar situation, the issue was that I had two rows in the MPPS0230 table on my company database.

    Removing the row that did not correspond to my company id resolved the issue.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: A save operation on table 'MO_Order_MSTR' failed accessing sql data

    Hello Sir,

     I did this but still the problems ,  I face this error ''A save operation on table 'MO_Order_MSTR' failed accessing  message '' when I open MO form and after entering all MO Data , when click the Scheduel MO Button , the same error come , when I click more Information butoon on the error message ,

    [Microsoft][SQL Native Client][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    the same error message  i face when i try to add in the BOM form some new component , and I am unable to do the changes in the BOM and I cant make an MO

    So please help me if You know

    Thanks

    Hilal Uddin

    CPC - Riyadh  

     

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: A save operation on table 'MO_Order_MSTR' failed accessing sql data

    I have seen that error when the user did not properly log on to the network but was logged in to their workstation.  First try, re-login.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans