[GeoNetwork-devel] Oracle connection problems

ByronCinNZ1 · October 18, 2011, 5:56am

Hi,

I am trying to set up GeoNetwork with a Oracle database for a client. But I
am not having much luck. I resolved the first error thanks to Francois patch
(HarvestHistory issue) but now it seems that there are greater difficulties
with this particular installation. I have attached the log file below. It
seems to only happen with Oracle. The database connection seems to execute
okay but when the "Start GeoNetwork" process gets to the lucene indexing
section, it bails as shown below. This happens when I run GeoNettwork 2.6 or
2.7 and if I run it in Tomcat or Jetty. And it only happens with Oracle. Of
course the Oracle DBA's say all looks good on their end and it is not their
problem. I need ot tell them something more specific and I am stumped. Any
help would be greatly appreciated. (Oracle version 11g1).

Cheers,
Byron Cochrane
LISASoft

2011-10-18 10:36:24,620 DEBUG [org.jzkit.search.impl.StatelessQueryService]
- new StatelessQueryService(50,180000)
2011-10-18 10:36:24,620 DEBUG [org.jzkit.search.impl.StatelessQueryService]
- init()
2011-10-18 10:36:24,635 DEBUG
[org.jzkit.search.util.RecordBuilder.RecordBuilderService] -
onApplicationEvent
org.springframework.context.event.ContextRefreshedEvent[source=org.springframework.context.support.ClassPathXmlApplicationContext@anonymised.com:
display name
[org.springframework.context.support.ClassPathXmlApplicationContext@anonymised.com];
startup date [Tue Oct 18 10:36:23 NZDT 2011]; root of context hierarchy]
2011-10-18 10:36:24,635 INFO [jeeves.apphand] - Server is Disabled.
2011-10-18 10:36:24,635 INFO [jeeves.apphand] - - Schema manager...
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Search...
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Log spatial object:
false
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Log in asynch mode:
true
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Lucene configuration
is:
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - Lucene configuration:
* Version: LUCENE_30
* RAMBufferSize: 48.0
* MergeFactor: 10
* Default analyzer: org.fao.geonet.kernel.search.GeoNetworkAnalyzer
* Field analyzers:
{parentUuid=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
subject=org.apache.lucene.analysis.KeywordAnalyzer,
operatesOnIdentifier=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
operatesOn=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
_uuid=org.fao.geonet.kernel.search.GeoNetworkAnalyzer}
* Tokenized fields: [abstract, keywordType, inspiretheme, title, subject,
any, levelName, altTitle, specificationTitle, orgName]
* Numeric fields: [eastBL, southBL, northBL, westBL, denominator]
* Search boost query: null
* Score:
  * trackDocScores: false
  * trackMaxScore: false
  * docsScoredInOrder: false

2011-10-18 10:36:25,979 INFO [jeeves.apphand] - Using shapefile D:\Apache
Software Foundation\Tomcat
6.0\webapps\geonetwork\WEB-INF\lucene\spatialindex.shp
2011-10-18 10:36:26,620 INFO [jeeves.apphand] - NOTE: Using shapefile for
spatial index, this can be slow for larger catalogs
2011-10-18 10:36:26,667 WARN [geonetwork.search] - Error on analyzer
initialization: null. Check your Lucene configuration. Default analyzer will
be used for field null
2011-10-18 10:36:26,667 WARN [geonetwork.search] - Creating analyzer has
failed, defaulting to GeoNetworkAnalyzer
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Raised exception while
starting appl handler. Skipped.
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Handler :
org.fao.geonet.Geonetwork
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Exception :
java.lang.NullPointerException
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Message : null
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Stack :
java.lang.NullPointerException
      at
org.fao.geonet.kernel.setting.SettingInfo.getSelectedIndexLanguages(SettingInfo.java:178)
      at
org.fao.geonet.kernel.search.SearchManager.findStopwords(SearchManager.java:187)
      at
org.fao.geonet.kernel.search.SearchManager.createGeoNetworkAnalyzer(SearchManager.java:157)
      at
org.fao.geonet.kernel.search.SearchManager.createAnalyzerFromLuceneConfig(SearchManager.java:277)
      at
org.fao.geonet.kernel.search.SearchManager.createAnalyzer(SearchManager.java:301)
      at
org.fao.geonet.kernel.search.SearchManager.<init>(SearchManager.java:345)
      at org.fao.geonet.Geonetwork.start(Geonetwork.java:323)
      at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:525)
      at jeeves.server.JeevesEngine.init(JeevesEngine.java:161)
      at
jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:76)
      at javax.servlet.GenericServlet.init(GenericServlet.java:212)
      at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
      at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
      at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
      at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
      at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
      at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
      at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
      at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
      at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
      at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
      at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      at
org.apache.catalina.core.StandardService.start(StandardService.java:525)
      at
org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6903348.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

sppigot · October 18, 2011, 6:12am

Hi Byron,

This line from your log fragment maybe indicates that the problem is somewhere else in the config and its tripping a problem when going to get the index languages from the database?:

2011-10-18 10:36:26,667 WARN [geonetwork.search] - Error on analyzer
initialization: null. Check your Lucene configuration. Default analyzer will
be used for field null

Can we see the output.log file to see this or any other stacktraces? I'd also like to see the earlier part of the geonetwork.log file to see what the database did on initialization. If you try opening the webapp from your browser do you see the first stacktrace and problem displayed there? (These should be displayed on an error page there so that the webapp doesn't look like it has started ok and then behave oddly).

Cheers,
Simon

________________________________________
From: ByronCinNZ [cochranes4@anonymised.com]
Sent: Tuesday, 18 October 2011 4:56 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: [GeoNetwork-devel] Oracle connection problems

Hi,

I am trying to set up GeoNetwork with a Oracle database for a client. But I
am not having much luck. I resolved the first error thanks to Francois patch
(HarvestHistory issue) but now it seems that there are greater difficulties
with this particular installation. I have attached the log file below. It
seems to only happen with Oracle. The database connection seems to execute
okay but when the "Start GeoNetwork" process gets to the lucene indexing
section, it bails as shown below. This happens when I run GeoNettwork 2.6 or
2.7 and if I run it in Tomcat or Jetty. And it only happens with Oracle. Of
course the Oracle DBA's say all looks good on their end and it is not their
problem. I need ot tell them something more specific and I am stumped. Any
help would be greatly appreciated. (Oracle version 11g1).

Cheers,
Byron Cochrane
LISASoft

2011-10-18 10:36:24,620 DEBUG [org.jzkit.search.impl.StatelessQueryService]
- new StatelessQueryService(50,180000)
2011-10-18 10:36:24,620 DEBUG [org.jzkit.search.impl.StatelessQueryService]
- init()
2011-10-18 10:36:24,635 DEBUG
[org.jzkit.search.util.RecordBuilder.RecordBuilderService] -
onApplicationEvent
org.springframework.context.event.ContextRefreshedEvent[source=org.springframework.context.support.ClassPathXmlApplicationContext@anonymised.com:
display name
[org.springframework.context.support.ClassPathXmlApplicationContext@anonymised.com..];
startup date [Tue Oct 18 10:36:23 NZDT 2011]; root of context hierarchy]
2011-10-18 10:36:24,635 INFO [jeeves.apphand] - Server is Disabled.
2011-10-18 10:36:24,635 INFO [jeeves.apphand] - - Schema manager...
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Search...
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Log spatial object:
false
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Log in asynch mode:
true
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Lucene configuration
is:
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - Lucene configuration:
* Version: LUCENE_30
* RAMBufferSize: 48.0
* MergeFactor: 10
* Default analyzer: org.fao.geonet.kernel.search.GeoNetworkAnalyzer
* Field analyzers:
{parentUuid=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
subject=org.apache.lucene.analysis.KeywordAnalyzer,
operatesOnIdentifier=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
operatesOn=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
_uuid=org.fao.geonet.kernel.search.GeoNetworkAnalyzer}
* Tokenized fields: [abstract, keywordType, inspiretheme, title, subject,
any, levelName, altTitle, specificationTitle, orgName]
* Numeric fields: [eastBL, southBL, northBL, westBL, denominator]
* Search boost query: null
* Score:
  * trackDocScores: false
  * trackMaxScore: false
  * docsScoredInOrder: false

2011-10-18 10:36:25,979 INFO [jeeves.apphand] - Using shapefile D:\Apache
Software Foundation\Tomcat
6.0\webapps\geonetwork\WEB-INF\lucene\spatialindex.shp
2011-10-18 10:36:26,620 INFO [jeeves.apphand] - NOTE: Using shapefile for
spatial index, this can be slow for larger catalogs
2011-10-18 10:36:26,667 WARN [geonetwork.search] - Error on analyzer
initialization: null. Check your Lucene configuration. Default analyzer will
be used for field null
2011-10-18 10:36:26,667 WARN [geonetwork.search] - Creating analyzer has
failed, defaulting to GeoNetworkAnalyzer
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Raised exception while
starting appl handler. Skipped.
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Handler :
org.fao.geonet.Geonetwork
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Exception :
java.lang.NullPointerException
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Message : null
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Stack :
java.lang.NullPointerException
      at
org.fao.geonet.kernel.setting.SettingInfo.getSelectedIndexLanguages(SettingInfo.java:178)
      at
org.fao.geonet.kernel.search.SearchManager.findStopwords(SearchManager.java:187)
      at
org.fao.geonet.kernel.search.SearchManager.createGeoNetworkAnalyzer(SearchManager.java:157)
      at
org.fao.geonet.kernel.search.SearchManager.createAnalyzerFromLuceneConfig(SearchManager.java:277)
      at
org.fao.geonet.kernel.search.SearchManager.createAnalyzer(SearchManager.java:301)
      at
org.fao.geonet.kernel.search.SearchManager.<init>(SearchManager.java:345)
      at org.fao.geonet.Geonetwork.start(Geonetwork.java:323)
      at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:525)
      at jeeves.server.JeevesEngine.init(JeevesEngine.java:161)
      at
jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:76)
      at javax.servlet.GenericServlet.init(GenericServlet.java:212)
      at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
      at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
      at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
      at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
      at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
      at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
      at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
      at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
      at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
      at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
      at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      at
org.apache.catalina.core.StandardService.start(StandardService.java:525)
      at
org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6903348.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.

_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net

GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Francois_Prunayre · October 18, 2011, 6:49am

Hello Byron,

2011/10/18 ByronCinNZ <cochranes4@anonymised.com>:

Hi,

I am trying to set up GeoNetwork with a Oracle database for a client. But I
am not having much luck. I resolved the first error thanks to Francois patch
(HarvestHistory issue) but now it seems that there are greater difficulties
with this particular installation. I have attached the log file below. It
seems to only happen with Oracle. The database connection seems to execute
okay but when the "Start GeoNetwork" process gets to the lucene indexing
section, it bails as shown below. This happens when I run GeoNettwork 2.6 or
2.7 and if I run it in Tomcat or Jetty. And it only happens with Oracle. Of

I made installations on Oracle with trunk last week without much
trouble (only the HarvestHistory create statement).

course the Oracle DBA's say all looks good on their end and it is not their
problem. I need ot tell them something more specific and I am stumped. Any
help would be greatly appreciated. (Oracle version 11g1).

Cheers,
Byron Cochrane
LISASoft

2011-10-18 10:36:24,620 DEBUG [org.jzkit.search.impl.StatelessQueryService]
- new StatelessQueryService(50,180000)
2011-10-18 10:36:24,620 DEBUG [org.jzkit.search.impl.StatelessQueryService]
- init()
2011-10-18 10:36:24,635 DEBUG
[org.jzkit.search.util.RecordBuilder.RecordBuilderService] -
onApplicationEvent
org.springframework.context.event.ContextRefreshedEvent[source=org.springframework.context.support.ClassPathXmlApplicationContext@anonymised.com:
display name
[org.springframework.context.support.ClassPathXmlApplicationContext@anonymised.com0...];
startup date [Tue Oct 18 10:36:23 NZDT 2011]; root of context hierarchy]
2011-10-18 10:36:24,635 INFO [jeeves.apphand] - Server is Disabled.
2011-10-18 10:36:24,635 INFO [jeeves.apphand] - - Schema manager...
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Search...
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Log spatial object:
false
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Log in asynch mode:
true
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - - Lucene configuration
is:
2011-10-18 10:36:25,979 INFO [jeeves.apphand] - Lucene configuration:
* Version: LUCENE_30
* RAMBufferSize: 48.0
* MergeFactor: 10
* Default analyzer: org.fao.geonet.kernel.search.GeoNetworkAnalyzer
* Field analyzers:
{parentUuid=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
subject=org.apache.lucene.analysis.KeywordAnalyzer,
operatesOnIdentifier=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
operatesOn=org.fao.geonet.kernel.search.GeoNetworkAnalyzer,
_uuid=org.fao.geonet.kernel.search.GeoNetworkAnalyzer}
* Tokenized fields: [abstract, keywordType, inspiretheme, title, subject,
any, levelName, altTitle, specificationTitle, orgName]
* Numeric fields: [eastBL, southBL, northBL, westBL, denominator]
* Search boost query: null
* Score:
* trackDocScores: false
* trackMaxScore: false
* docsScoredInOrder: false

2011-10-18 10:36:25,979 INFO [jeeves.apphand] - Using shapefile D:\Apache
Software Foundation\Tomcat
6.0\webapps\geonetwork\WEB-INF\lucene\spatialindex.shp
2011-10-18 10:36:26,620 INFO [jeeves.apphand] - NOTE: Using shapefile for
spatial index, this can be slow for larger catalogs
2011-10-18 10:36:26,667 WARN [geonetwork.search] - Error on analyzer
initialization: null. Check your Lucene configuration. Default analyzer will
be used for field null
2011-10-18 10:36:26,667 WARN [geonetwork.search] - Creating analyzer has
failed, defaulting to GeoNetworkAnalyzer
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Raised exception while
starting appl handler. Skipped.
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Handler :
org.fao.geonet.Geonetwork
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Exception :
java.lang.NullPointerException
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Message : null
2011-10-18 10:36:26,667 ERROR [jeeves.engine] - Stack :
java.lang.NullPointerException
at
org.fao.geonet.kernel.setting.SettingInfo.getSelectedIndexLanguages(SettingInfo.java:178)

I would say check the settings table, you're probably updating from an
older version which does not have the indexlanguages values in it (ids
800 to 839).

HTH.

Francois

org.fao.geonet.kernel.search.SearchManager.findStopwords(SearchManager.java:187)
at
org.fao.geonet.kernel.search.SearchManager.createGeoNetworkAnalyzer(SearchManager.java:157)
at
org.fao.geonet.kernel.search.SearchManager.createAnalyzerFromLuceneConfig(SearchManager.java:277)
at
org.fao.geonet.kernel.search.SearchManager.createAnalyzer(SearchManager.java:301)
at
org.fao.geonet.kernel.search.SearchManager.<init>(SearchManager.java:345)
at org.fao.geonet.Geonetwork.start(Geonetwork.java:323)
at jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:525)
at jeeves.server.JeevesEngine.init(JeevesEngine.java:161)
at
jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:76)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at
org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at
org.apache.catalina.core.StandardService.start(StandardService.java:525)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6903348.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

ByronCinNZ1 · October 18, 2011, 6:59am

Hi,

I do not have access to the server at the moment but I can post the full
geonetwork.log as I have it.

Cheers,
Byron

http://osgeo-org.1803224.n2.nabble.com/file/n6903488/geonetwork.log
geonetwork.log

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6903488.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

sppigot · October 18, 2011, 7:42am

Not sure if I'm seeing things here but this log seems to indicate that GeoNetwork is config'd for the h2 db instead of oracle? It has a different error about not finding the htmlCache directory.

Cheers,
Simon
________________________________________
From: ByronCinNZ [cochranes4@anonymised.com]
Sent: Tuesday, 18 October 2011 5:59 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Oracle connection problems

Hi,

I do not have access to the server at the moment but I can post the full
geonetwork.log as I have it.

Cheers,
Byron

http://osgeo-org.1803224.n2.nabble.com/file/n6903488/geonetwork.log
geonetwork.log

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6903488.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.

_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net

GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

ByronCinNZ1 · October 18, 2011, 8:18am

Simon,

I stand corrected. I thought it was only failing on Oracle, so I grabbed a
log with the failure. I will get the correct log in the morning. But now I
see it failing on h2??? Hmmm, I think it is time for a clean install.

Cheers,
Byron

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6903688.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

ByronCinNZ1 · October 20, 2011, 9:04pm

Francois and Simon,

Thanks for your help. Your pointers got me to the right solution. The Oracle
database was not being populated with the data (lookup tables and such) that
GeoNetwork needed on startup. I ran these two sql scripts from the
geonetwork\WEB-INF\classes\setup\sql\data directory in Oracle,
data-db-default.sql and loc-en-default.sql. This populated the tables
adequately for the system to start. I assume that it is unnecessary to load
the other language sql scripts like loc-fr-default.sql if they are only
interested in supporting English?

One minor bug I encountered when doing this is that Oracle saw anything
proceeded by an ampersand "&" as a variable even if it was quoted. This was
a problem for maybe a dozen placenames. I would assume escaping the "&"
would correct this - or maybe just using the word "and" would be better. It
was not a concern for the organisation I was supporting so I left it as it
was.

About my process steps: I did not use GAST to setup the database. This was
GAST took a terribly long time to load, it made the IT dept nervous since it
did not create log files they could find, and because it seems that GAST is
being deprecated. I configured the config.xml to point to the newly created
(and empty) "geonetwork" data base in Oracle. On starting GeoNetwork (with
Tomcat) it created the tables in this database then stopped apparently
because it did not call the two additional scripts I mentioned above.

After some testing it turns out that this issue was not limited to Oracle
but appeared in other databases as well - including PostgreSQL and at least
once with H2 as the log snippet I sent earlier showed. (H2 worked fine ever
other time.)

Once again thanks for your help. It quickly got me out of a tough spot.

Cheers,
Byron

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Oracle-connection-problems-tp6903348p6914855.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.