Error when trying to change the system configuration

[johnh]

Hi,

I am running GeoNetwork 2.7.0 on Linux debian platform with amd64. I have logged in as 'admin' and selected the 'Administration' menu option. If I select "System configuration" the input form is shown but when I try to save any changes to the form I get the error:

"Unable to save the system configuration Error : operation-aborted Message : Cannot set all values Class : OperationAbortedEx " I get the same error even if I don't make any changes and select the "save" button.

Thanks.

johnh

[johnh]

catalina.out errors

[fxp]

This is a configuration error. You probably have missing settings. Check the settings table.

2011-11-28 11:14:04,167 DEBUG [geonetwork.settings] - Set path: system/metadata/defaultView, value: simple
2011-11-28 11:14:04,167 DEBUG [geonetwork.settings] - Unable to find Settings row.

If you could update to (at least) revision 8121, the debug info contains the missing settings path now : "Unable to find Settings row for: " + path and helps solving that type of issue.

[heikki]

Just to explain a bit more:

the settings table represents a hierarchical, tree structure, of the settings. So each setting has a 'parent' setting.

If any ancestor setting is missing, settings can't be saved and you get this message.

In my opinion this implementation is unnecessarily prone to error and we'd be better off replacing it with simple key-value pair settings. The hierarchy is not very useful, and to retain some kind of grouping we could simply use a field 'type' or so.

[josegar74]

Related to #431

[simonp]

Move settings changes proposed here to enhancement in ticket #677 and close this ticket as invalid because in this case the database was actually out of date with respect to the settings - see comment by fxp above.

[simonp]

Ticket #759 is the ticket with the settings enhancement