[GeoNetwork-devel] [GeoNetwork opensource Developer website] #381: Categories and groups

#381: Categories and groups
------------------------+---------------------------------------------------
Reporter: osjonathan | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: critical | Milestone: v2.6.2
Component: General | Version: v2.6.1
Keywords: |
------------------------+---------------------------------------------------
I've just installed 2.6.1., and had it create a new (Oracle) table-
structure. However I can't edit categories or groups. Both "group
management" and "category management" result in a 500 error:

HTTP ERROR: 500
The data "The data "@8<5@ 3@...443...??K" is not legal for a JDOM character
content: 0x1f is not a legal XML character." is not legal for a JDOM
character content: 0x1f is not a legal XML character.

RequestURI=/geonetwork/srv/en/group.list
Caused by:
org.jdom.IllegalDataException: The data "The data "@8<5@ 3@...443...??K" is not
legal for a JDOM character content: 0x1f is not a legal XML character." is
not legal for a JDOM character content: 0x1f is not a legal XML character.
         at org.jdom.Text.setText(Text.java:188)
         at org.jdom.Text.(Text.java:99)
         at org.jdom.Element.setText(Element.java:630)
         at
jeeves.exceptions.JeevesException.toElement(JeevesException.java:82)
         at
jeeves.server.dispatchers.ServiceManager.getError(ServiceManager.java:811)
         at
jeeves.server.dispatchers.ServiceManager.handleError(ServiceManager.java:440)
         at
jeeves.server.dispatchers.ServiceManager.dispatch(ServiceManager.java:429)
         at jeeves.server.JeevesEngine.dispatch(JeevesEngine.java:624)
         at
jeeves.server.sources.http.JeevesServlet.execute(JeevesServlet.java:185)
         at
jeeves.server.sources.http.JeevesServlet.doGet(JeevesServlet.java:98)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
         at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
         at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363)
         at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
         at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
         at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
         at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
         at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
         at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
         at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
         at org.mortbay.jetty.Server.handle(Server.java:324)
         at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
         at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864)
         at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:533)
         at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:207)
         at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
         at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
         at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522)

----------

Also, no categories nor groups are appearing anywhere within geonetwork
despite the defaults existing in the database.
The Mckoi database works fine.
I believe this has something to do with the cyrillic in the GROUPSDE and
CATEGORIESDE tables. namely the .ru. Deleting the RU language rows from
the database fixes the error.

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/381&gt;
GeoNetwork opensource Developer website <http://trac.osgeo.org/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.

#381: Categories and groups
------------------------+---------------------------------------------------
Reporter: osjonathan | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: critical | Milestone: v2.6.2
Component: General | Version: v2.6.1
Keywords: |
------------------------+---------------------------------------------------

Comment(by pmauduit):

Hello,

I had a similar problem in a different context ; it may be related of
local Oracle configuration, and not a geonetwork issue ;

What is the current value of your {{{NLS_LANG}}} environment variable ?
this should be coherent with your default database charset.

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/381#comment:1&gt;
GeoNetwork opensource Developer website <http://trac.osgeo.org/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.

#381: Categories and groups
------------------------+---------------------------------------------------
Reporter: osjonathan | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: critical | Milestone: v2.6.2
Component: General | Version: v2.6.1
Keywords: |
------------------------+---------------------------------------------------

Comment(by osjonathan):

I haven't got a clue where to find that variable. Anyone know?
Oracle was happy to show me the data in SQL Developer (as well as allow me
to delete it).

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/381#comment:2&gt;
GeoNetwork opensource Developer website <http://trac.osgeo.org/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.

#381: Categories and groups
------------------------+---------------------------------------------------
Reporter: osjonathan | Owner: geonetwork-devel@…
     Type: defect | Status: new
Priority: critical | Milestone: v2.6.2
Component: General | Version: v2.6.1
Keywords: |
------------------------+---------------------------------------------------

Comment(by pmauduit):

Replying to [comment:2 osjonathan]:
> I haven't got a clue where to find that variable. Anyone know?

something like {{{export | grep NLS_LANG}}} or {{{echo $NLS_LANG}}} under
Linux.

You can issue the following SQL query to check the current parameters of
your DB :

{{{SQL> select * from nls_database_parameters;}}}

Hth,

--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/381#comment:3&gt;
GeoNetwork opensource Developer website <http://trac.osgeo.org/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.