I'm trying to add a field to an existing table and I'm getting the error:
INSERT INTO sys_metadata
...
java.sql.BatchUpdateException: Duplicate entry '-1' for key 'PRIMARY'
The full error indicates that the value '-1' is being inserted (or trying) into the 'sys_id' field and this is breaching the primary key. From what I've read, the '-1' value is supposed to cause a new value to be assigned but that's clearly not happening in this case.
Can anyone advise what's occurring and, more importantly, how to fix it?
