I am using RMS 1.3 with MSSQL 2000 running on windows 2003 STD with 2GB ram, Dual 2.4 Xeon, Raid 5 Server.
I have a databse that is 5GB and everything runs great except when my purchaseing manager works with Purchase Orders.
When going to commit a Purchase Order he receives the following run time error ?Run-time error ?-2147221503(8004001)?: Data has changed! Another user has updated this data record. The system cannot save your changes.? At the time of the error there is no one else even in POs. He also receives multiple other errors when the shipping guy is receiving on a diferrent po and he is going to save his PO.
I had opened a ticket with Microsoft and they were unable to come up with a solution to this error. They had me do maintenance from Admin and backup the database from Admin and restore.
This error happens on multiple computers multiple computers at random times so it leads me to believe that it is something that is happening on the database side.
Anybody have any ideas. I am willing to try anything at this point.
Thanks Jacob