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
good finding.
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156