Databases
--
Questions
--
Followers
Top Experts
Great Plains Error - A get/change first operation on table 'coProcess' failed
New company in Great Plains and a user is getting the below error:
A get/change first operation on table 'coProcess' failed accessing SQL data.
sa can login fine but no other users.
A get/change first operation on table 'coProcess' failed accessing SQL data.
sa can login fine but no other users.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thank you...as soon as I did this the user was able to access the new company.
What are the implications for other users that are not having issues when running this script? IE We have a user on our test server that is attempting to login and getting the "get/change operation on table 'sysuserdefaults' failed accessing sql data. USer has access to all companies setup correctly..this happened on a restore of production data to test server. This routinely wipes out user access but former admin did not leave steps to resolve.






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Databases
--
Questions
--
Followers
Top Experts
Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.