Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...An excellent site which has quite possibly prevented me from having a mental/nervous breakdown..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Enterprise Applications > ERP and CRM Solution Vendors > Microsoft: Dynamics GP (Great Plains) Forum

Edit Operation on Table Failed Accessing Sql Data

thread632-1576186
Read More Threads Like This One
monet1369 (MIS)
27 Oct 09 13:22
Error: An edit operation on table SOP_Master_Number_Setup Failed accessing SQL Data.  Error was generated while in the Sales Trx Entry window.  Running Dynamics 8.0.  Sql Server 2000 on a Windows 2000 Server.  We have been having power outages quite often.  Just wondered what this error means.  I did run Check Links on this particular table.
Thanks in advance for your help!
VictoriaYudin (IS/IT--Management)
27 Oct 09 14:22
Since you've said you're experiencing power outages, my first suspicion would be a connectivity issue.  I would restart the client computer (or at least exit GP and go back in) and see if the problem persists.

If so, next question would be whether this happens everywhere (including the server) or just a particular computer.

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://victoriayudin.com

monet1369 (MIS)
28 Oct 09 9:31
Thanks so much for the info.  It is happening everywhere.  When we have power outages like this.  What should I do?  Run check links?
Thanks!
VictoriaYudin (IS/IT--Management)
28 Oct 09 11:28
First thing I would do is put good UPS's on every computer and server.  smile

Running check links on all the series is a good practice in general after power outages, disconnects, etc.

However, since the message is complaining specifically about the Master Number Setup in SOP, you can recreate this table by following these steps:

1. Run the following against your company database in SQL:
Delete SOP40500

2. Run check links on the Sales series.
 

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html
blog: http://victoriayudin.com

monet1369 (MIS)
29 Oct 09 10:09
Thanks for your help!  Our old UPS crashed and the company is aware of the problem and importance of having one, but are not willing at this point to purchase a new one.  :(  That would definitely solve the problem!   
Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Dynamics GP (Great Plains)

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close