[GeoNetwork-devel] [GeoNetwork opensource Developer website] #796: New user gave Oracle error

#796: New user gave Oracle error
------------------------+---------------------------------------------------
Reporter: osjonathan | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: major | Milestone: v2.6.5
Component: General | Version: v2.6.4
Keywords: |
------------------------+---------------------------------------------------
Hi,
I tried adding a new user and got this error:

SQLException : ORA-00001: unique constraint (GEONETWORK.SYS_C0011916)
violated

Using an Oracle database. The user appears to have been added, though some
googling suggestions that maybe the user already existed, but I don't
remember adding them before so.... :-S

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/796&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.

#796: New user gave Oracle error
------------------------+---------------------------------------------------
Reporter: osjonathan | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: major | Milestone: v2.6.5
Component: General | Version: v2.6.4
Keywords: |
------------------------+---------------------------------------------------

Comment(by osjonathan):

If I try and delete the user I get this error:

SQLException : ORA-02292: integrity constraint (GEONETWORK.SYS_C0011968)
violated - child record found

Editing the user and changing the user password work fine.

After further investigation, the user did already exist. The bug therefore
is that geonetwork should handle re-registration of the same user much
better than it currently does.

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/796#comment:1&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.

#796: New user gave Oracle error
-------------------------+--------------------------------------------------
  Reporter: osjonathan | Owner: geonetwork-devel@…
      Type: defect | Status: closed
  Priority: major | Milestone: v2.6.5
Component: General | Version: v2.6.4
Resolution: fixed | Keywords:
-------------------------+--------------------------------------------------
Changes (by simonp):

  * status: new => closed
  * resolution: => fixed

Comment:

Added a check to make sure that a new user can't be registered with an
existing username - svn revision 8747 - thanks

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/796#comment:2&gt;
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/&gt;
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.