SY_Security_Normal_MSTR error

[csjoseph]

We recently upgraded to

enterprise 6.00g37
dexterity 6.00m059
manufacuring 6.0.19

now when we log in we get this error:

"A get/change operation on table 'SY_Security_Normal_MSTR' failed. A record was already locked"

Any ideas? Chris
LAN Admin / Programmer
cjoseph@hdii.com

 

[IceOl8d]

I got that same error when I transferred all of our GP tables into another server. To Fix the problem go into the SY02000 table and ensure that the first 5 Column names have primary keys set and that the DEX_ROW_ID column name has the identity box checked. This will fix your problem.