empty t_seclocks.EntityIF, what to do about it?

[ngong]

Switched from .eap-files to SQL Server based storage of EA model.
Transfer to .eap-file worked fine till today.

I got the message: "An error has occurred: DAO.Recordset  [3314], The field 't_seclocks.EntityID' can't contain a Null value because the Required property for this field is set to True. Enter a value in this field. [Select * from t_seclocks], Field: locktype. Press OK to continue to next row (this record will be lost). Cancel to abort

Ok, I entered the SQL query and got 5 lines as a result. In one of them the field below the column heading EntiyID is empty. Guess that causes the problem. (I do not know how it got there, I was using EA heavily, but interactivily only.)


What shall I do about it? Transfer the result back, so that that record disappears from table t_seclocks? What will be the consequences?

[qwerty]

Run a consistency check.

q.

[ngong]

Hi, qwerty: I forgot, I ran consistency check and it led to "No Problem".

[qwerty]

You could run (via Repository.Execute)  SQL like

Code: [Select]

DELETE FROM t_seclocks WHERE EntityID IS NULL
Make a backup first.

q.