Elk RP Error- Too many rows affected

[jrooks]

Hi: M1G and RP have been working flawlessly for years. I added a couple rules via Xp and got this error report when I attempted to save.
-----------
ElkRP Error Report - 11/23/2012 12:01

Error Number: -2147467259
Description: Key column information is insufficient or incorrect. Too many rows were affected by update.
Executable: M1G.dll
Module: WhenThen
Function: Form_Save

ElkRP Version: 1.6.26.0
M1G.dll Version: 4.5.30.0
M1.dll Version: 4.5.30.0
EZ8.dll Version: 4.5.30.0
ElkComm.dll Version: 1.2.10.10
ConvertDB.dll Version: 1.2.10.0
ElkSafe.dll Version: 1.0.2.0
ErrorDlg.dll Version: 1.0.10.0

Microsoft Windows XP ProfessionalService Pack 3 (Build 2600) service pack 3.0
----------
I finally got it to go away and closed RP. When I re-opened RP and re-connected my new rules were there so apparently they had been saved in spite of the error report. I was not able to test them yet so I don't actually know if they work or not.

What is happening? What does "too many rows were affected" mean?
What is a row?
How many is too many?
What does "Key column information is insufficient or incorrect" mean?
Is everything actually working , and can I ignore this error? If so, how do I easily make it go away?

I have not updated anything in years (everything worked great).

Is this a known problem that has been fixed (or could be fixed by an update or refresh)?
Updates can be spooky unless they are absolutely needed and I would rather not do anything in this area unless it is a known solution.

Thanks, John

 

[Del91574]

Update your RP. You're woefully out of date.

 

[tmbrown97]

That's a generic unhandled exception - meaning RP was trying to do something internally and couldn't keep up; has nothing to do with the Elk itself and is no way a meaningful error.

Try DEL's suggestion and update software - there have been a lot of changes lately.

 

[wuench]

It's a SQL error indicating possible database corruption. If you keep seeing the error you might want to try and create a new clean DB file an import all of your settings from the Elk into it.

 

[jrooks]

I won't be able to do the update for a couple weeks. I will let you know how it works out. Thanks, John