[GeoNetwork-users] GN fails to start after binding to an oracle DB

Lars_Moller · October 28, 2020, 6:17pm

Good evening fellow GN users,

yesterday I tried to switch to another database system after successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the dedicated RHEL VM - but failed miserably. The initial startup of GN (still with the default H2 db) worked well and as expected. However, the local database is no option in our case.

So I followed the instructions found in the official documentation <https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html> and

  * altered the node configuration file |WEB-INF/config-node/srv.xml to
    refer to /WEB-INF/config-db/oracle.xml, then
    |
  * ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
  * and set hibernate related logging to DEBUG level
    (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after this modifications, however, failed due to a missing ojdbc driver. So I downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted its permissions. But now I am confronted with another series of errors, kind of pointing to a non-functional database connection (full log is attached).

It reads something like:

>2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception during init
>2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception : org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'openAPIBuilder' … Factory method 'OpenApiConfig' threw exception; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

>Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no luck. The error is similar.

Earlier I read <http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>, that databases do not need to be instantiated by scripts in the latest releases, but especially the last quoted line sort of implies that there is a table expected that doesn't seem to exist. I tried to google this specific errors at lengths today, but weren't able to make any use of the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@anonymised.com
www.hzg.de

Helmholtz-Zentrum Geesthacht Zentrum für Material- und Küstenforschung GmbH Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke Simon Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board: Ministerialdirigent Engelbert Beyer Amtsgericht Lübeck HRB 285 GE (Register Court) Internet: http://www.hzg.de

(attachments)

geonetwork.log (38.8 KB)

Francois_Prunayre · October 29, 2020, 7:28am

Hi,

Do you have 3.x working with the oracle server?
In 4, we updated JPA and Hibernate libraries so that may explain the
difference. You could try to change log level to DEBUG for
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
and restart to see if you can get the first exception which is raised.

Cheers
Francois

Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@anonymised.com.> a écrit :

Good evening fellow GN users,

yesterday I tried to switch to another database system after
successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
dedicated RHEL VM - but failed miserably. The initial startup of GN
(still with the default H2 db) worked well and as expected. However, the
local database is no option in our case.

So I followed the instructions found in the official documentation
<
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html>

and

  * altered the node configuration file |WEB-INF/config-node/srv.xml to
    refer to /WEB-INF/config-db/oracle.xml, then
    |
  * ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
  * and set hibernate related logging to DEBUG level
    (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after
this modifications, however, failed due to a missing ojdbc driver. So I
downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
its permissions. But now I am confronted with another series of errors,
kind of pointing to a non-functional database connection (full log is
attached).

It reads something like:

>2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception
during init
>2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'openAPIBuilder' … Factory method
'OpenApiConfig' threw exception; nested exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

>Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no
luck. The error is similar.

Earlier I read
<
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>,

that databases do not need to be instantiated by scripts in the latest
releases, but especially the last quoted line sort of implies that there
is a table expected that doesn't seem to exist. I tried to google this
specific errors at lengths today, but weren't able to make any use of
the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@anonymised.com
www.hzg.de

Helmholtz-Zentrum Geesthacht
Zentrum für Material- und Küstenforschung GmbH
Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
Simon
Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
Ministerialdirigent Engelbert Beyer
Amtsgericht Lübeck HRB 285 GE (Register Court)
Internet: http://www.hzg.de
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Paul_van_Genuchten · October 29, 2020, 7:36am

A suggestion, are you using the default oracle schema for the user? If not, you need to set the alternative schema also in config-spring-geonetwork.xml (see the commented section).

Groet Paul van Genuchten

Op 29 okt. 2020 om 08:29 heeft Francois Prunayre <fx.prunayre@anonymised.com> het volgende geschreven:

Hi,

Do you have 3.x working with the oracle server?
In 4, we updated JPA and Hibernate libraries so that may explain the
difference. You could try to change log level to DEBUG for
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
and restart to see if you can get the first exception which is raised.

Cheers
Francois

Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@anonymised.com6...> a écrit :

Good evening fellow GN users,

yesterday I tried to switch to another database system after
successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
dedicated RHEL VM - but failed miserably. The initial startup of GN
(still with the default H2 db) worked well and as expected. However, the
local database is no option in our case.

So I followed the instructions found in the official documentation
<
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html>

and

* altered the node configuration file |WEB-INF/config-node/srv.xml to
   refer to /WEB-INF/config-db/oracle.xml, then
   |
* ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
* and set hibernate related logging to DEBUG level
   (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after
this modifications, however, failed due to a missing ojdbc driver. So I
downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
its permissions. But now I am confronted with another series of errors,
kind of pointing to a non-functional database connection (full log is
attached).

It reads something like:

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception

during init

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :

org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'openAPIBuilder' … Factory method
'OpenApiConfig' threw exception; nested exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no
luck. The error is similar.

Earlier I read
<
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>,

that databases do not need to be instantiated by scripts in the latest
releases, but especially the last quoted line sort of implies that there
is a table expected that doesn't seem to exist. I tried to google this
specific errors at lengths today, but weren't able to make any use of
the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@anonymised.com
www.hzg.de

Helmholtz-Zentrum Geesthacht
Zentrum für Material- und Küstenforschung GmbH
Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
Simon
Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
Ministerialdirigent Engelbert Beyer
Amtsgericht Lübeck HRB 285 GE (Register Court)
Internet: http://www.hzg.de
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Oscar_Diago_Alonso · October 29, 2020, 1:40pm

Good morning

We are facing the same issue. Changing the config-spring-geonetwork.xml as suggested hasn't solved it.

Any idea abiout it would be welcome!

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <paul.vangenuchten@...444...>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <fx.prunayre@...54...>
Cc: geonetwork-users@lists.sourceforge.net <geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

A suggestion, are you using the default oracle schema for the user? If not, you need to set the alternative schema also in config-spring-geonetwork.xml (see the commented section).

Groet Paul van Genuchten

Op 29 okt. 2020 om 08:29 heeft Francois Prunayre <fx.prunayre@...54...> het volgende geschreven:

Hi,

Do you have 3.x working with the oracle server?
In 4, we updated JPA and Hibernate libraries so that may explain the
difference. You could try to change log level to DEBUG for
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
and restart to see if you can get the first exception which is raised.

Cheers
Francois

Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@...1876...> a écrit :

Good evening fellow GN users,

yesterday I tried to switch to another database system after
successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
dedicated RHEL VM - but failed miserably. The initial startup of GN
(still with the default H2 db) worked well and as expected. However, the
local database is no option in our case.

So I followed the instructions found in the official documentation
<
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html>

and

* altered the node configuration file |WEB-INF/config-node/srv.xml to
   refer to /WEB-INF/config-db/oracle.xml, then
   |
* ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
* and set hibernate related logging to DEBUG level
   (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after
this modifications, however, failed due to a missing ojdbc driver. So I
downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
its permissions. But now I am confronted with another series of errors,
kind of pointing to a non-functional database connection (full log is
attached).

It reads something like:

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception

during init

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :

org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'openAPIBuilder' … Factory method
'OpenApiConfig' threw exception; nested exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no
luck. The error is similar.

Earlier I read
<
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>,

that databases do not need to be instantiated by scripts in the latest
releases, but especially the last quoted line sort of implies that there
is a table expected that doesn't seem to exist. I tried to google this
specific errors at lengths today, but weren't able to make any use of
the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@...1876...
www.hzg.de

Helmholtz-Zentrum Geesthacht
Zentrum für Material- und Küstenforschung GmbH
Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
Simon
Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
Ministerialdirigent Engelbert Beyer
Amtsgericht Lübeck HRB 285 GE (Register Court)
Internet: http://www.hzg.de
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Oscar_Diago_Alonso · October 30, 2020, 7:36am

Good morning.

More data about that issue. We have found the following error in the log:

java.sql.SQLSyntaxErrorException: ORA-00920: operador relacional no v⭩do.

Error: ORA-00920: invalid relational operator
Causa: A search condition was entered with an invalid or missing relational operator.
Acción: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.

I hope it gives a hint about what could be hapenning during the deployment.

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <Oscar.Diago@...1602...>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: Geonetwork-Users@...638... <geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

Good morning

We are facing the same issue. Changing the config-spring-geonetwork.xml as suggested hasn't solved it.

Any idea abiout it would be welcome!

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <paul.vangenuchten@...444...>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <fx.prunayre@...54...>
Cc: geonetwork-users@lists.sourceforge.net <geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

A suggestion, are you using the default oracle schema for the user? If not, you need to set the alternative schema also in config-spring-geonetwork.xml (see the commented section).

Groet Paul van Genuchten

Op 29 okt. 2020 om 08:29 heeft Francois Prunayre <fx.prunayre@...54...> het volgende geschreven:

Hi,

Do you have 3.x working with the oracle server?
In 4, we updated JPA and Hibernate libraries so that may explain the
difference. You could try to change log level to DEBUG for
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
and restart to see if you can get the first exception which is raised.

Cheers
Francois

Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@...1876...> a écrit :

Good evening fellow GN users,

yesterday I tried to switch to another database system after
successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
dedicated RHEL VM - but failed miserably. The initial startup of GN
(still with the default H2 db) worked well and as expected. However, the
local database is no option in our case.

So I followed the instructions found in the official documentation
<
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html>

and

* altered the node configuration file |WEB-INF/config-node/srv.xml to
   refer to /WEB-INF/config-db/oracle.xml, then
   |
* ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
* and set hibernate related logging to DEBUG level
   (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after
this modifications, however, failed due to a missing ojdbc driver. So I
downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
its permissions. But now I am confronted with another series of errors,
kind of pointing to a non-functional database connection (full log is
attached).

It reads something like:

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception

during init

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :

org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'openAPIBuilder' … Factory method
'OpenApiConfig' threw exception; nested exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no
luck. The error is similar.

Earlier I read
<
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>,

that databases do not need to be instantiated by scripts in the latest
releases, but especially the last quoted line sort of implies that there
is a table expected that doesn't seem to exist. I tried to google this
specific errors at lengths today, but weren't able to make any use of
the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@...1876...
www.hzg.de

Helmholtz-Zentrum Geesthacht
Zentrum für Material- und Küstenforschung GmbH
Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
Simon
Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
Ministerialdirigent Engelbert Beyer
Amtsgericht Lübeck HRB 285 GE (Register Court)
Internet: http://www.hzg.de
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Francois_Prunayre · October 30, 2020, 8:28am

Hi Oscar, if you turn on debug level for SQL you may be able to get the
query which is causing this and it will help a bit more.
Can you also send the full exception if there is any stack trace with more
details on the location.

Thanks

Francois

Le ven. 30 oct. 2020 à 08:37, Oscar Diago Alonso <Oscar.Diago@anonymised.com..>
a écrit :

Good morning.

More data about that issue. We have found the following error in the log:

java.sql.SQLSyntaxErrorException: ORA-00920: operador relacional no v⭩do.

Error: ORA-00920: invalid relational operator
Causa: A search condition was entered with an invalid or missing
relational operator.
Acción: Include a valid relational operator such as =, !=, ^=, <>, >, <,
>=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT]
LIKE in the condition.

I hope it gives a hint about what could be hapenning during the deployment.

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@anonymised.com<mailto:oscar.diago@anonymised.com>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <Oscar.Diago@anonymised.com>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: Geonetwork-Users@anonymised.com <
geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an
oracle DB

Good morning

We are facing the same issue. Changing the config-spring-geonetwork.xml as
suggested hasn't solved it.

Any idea abiout it would be welcome!

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@anonymised.com<mailto:oscar.diago@anonymised.com>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <paul.vangenuchten@anonymised.com>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <fx.prunayre@anonymised.com>
Cc: geonetwork-users@lists.sourceforge.net <
geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an
oracle DB

A suggestion, are you using the default oracle schema for the user? If
not, you need to set the alternative schema also in
config-spring-geonetwork.xml (see the commented section).

Groet Paul van Genuchten

> Op 29 okt. 2020 om 08:29 heeft Francois Prunayre <fx.prunayre@anonymised.com>
het volgende geschreven:
>
> Hi,
>
> Do you have 3.x working with the oracle server?
> In 4, we updated JPA and Hibernate libraries so that may explain the
> difference. You could try to change log level to DEBUG for
>
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
> and restart to see if you can get the first exception which is raised.
>
> Cheers
> Francois
>
>> Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@anonymised.com876...> a
écrit :
>>
>> Good evening fellow GN users,
>>
>> yesterday I tried to switch to another database system after
>> successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
>> dedicated RHEL VM - but failed miserably. The initial startup of GN
>> (still with the default H2 db) worked well and as expected. However, the
>> local database is no option in our case.
>>
>> So I followed the instructions found in the official documentation
>> <
>>
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html
>
>>
>> and
>>
>> * altered the node configuration file |WEB-INF/config-node/srv.xml to
>> refer to /WEB-INF/config-db/oracle.xml, then
>> |
>> * ||adjusted |WEB-INF/config-db/jdbc.properties| according to our
setup,
>> * and set hibernate related logging to DEBUG level
>> (WEB-INF/classes/log4j.xml)
>>
>> The oracle db was tested and found untouched. The initial startup after
>> this modifications, however, failed due to a missing ojdbc driver. So I
>> downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
>> its permissions. But now I am confronted with another series of errors,
>> kind of pointing to a non-functional database connection (full log is
>> attached).
>>
>> It reads something like:
>>
>>> 2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception
>> during init
>>> 2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :
>> org.springframework.beans.factory.UnsatisfiedDependencyException: Error
>> creating bean with name 'openAPIBuilder' … Factory method
>> 'OpenApiConfig' threw exception; nested exception is
>> org.springframework.dao.InvalidDataAccessResourceUsageException: could
>> not extract ResultSet; SQL [n/a]; nested exception is
>> org.hibernate.exception.SQLGrammarException: could not extract
ResultSet…
>>
>> …and…
>>
>>> Caused by: java.sql.SQLException: ORA-00942: table or view does not
exist
>>
>> …
>>
>> Later I tried another version of the ojdbc driver (14), but still no
>> luck. The error is similar.
>>
>> Earlier I read
>> <
>>
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html
>,
>>
>> that databases do not need to be instantiated by scripts in the latest
>> releases, but especially the last quoted line sort of implies that there
>> is a table expected that doesn't seem to exist. I tried to google this
>> specific errors at lengths today, but weren't able to make any use of
>> the information I found.
>>
>> Hence, any help would be highly appreciated!
>>
>> Best of regards,
>> Lars
>>
>> --
>> Dr. Lars Möller
>> HCDC Metadatenadministration
>>
>> Helmholtz-Zentrum Geesthacht
>> Zentrum für Material und Küstenforschung
>> -Modellierung zur Bewertung von Küstensystemen (KBS)
>> Max-Planck-Straße 1
>>
>> 21502 Geesthacht
>> Germany
>>
>> Fon +49 (0) 4152- 87 - 1849
>> Fax +49 (0) 4152- 87 - 41849
>> E-mail: lars.moeller@anonymised.com
>> www.hzg.de
>>
>> Helmholtz-Zentrum Geesthacht
>> Zentrum für Material- und Küstenforschung GmbH
>> Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany
>>
>> Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
>> Simon
>> Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
>> Ministerialdirigent Engelbert Beyer
>> Amtsgericht Lübeck HRB 285 GE (Register Court)
>> Internet: http://www.hzg.de
>> _______________________________________________
>> GeoNetwork-users mailing list
>> GeoNetwork-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Oscar_Diago_Alonso · October 30, 2020, 9:24am

Hi.

According to the log:

Caused by: Error : 604, Position : 0, Sql = INSERT INTO IsoLanguages (id, code, shortcode) VALUES (280,'mis', NULL), OriginalSql = INSERT INTO IsoLanguages (id, code, shortcode) VALUES (280,'mis', NULL), Error Msg = ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Francois Prunayre <fx.prunayre@...54...>
Enviado: viernes, 30 de octubre de 2020 9:28
Para: Oscar Diago Alonso <Oscar.Diago@...1602...>
Cc: Geonetwork-Users@...638... <geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

Hi Oscar, if you turn on debug level for SQL you may be able to get the query which is causing this and it will help a bit more.
Can you also send the full exception if there is any stack trace with more details on the location.

Thanks

Francois

Le ven. 30 oct. 2020 à 08:37, Oscar Diago Alonso <Oscar.Diago@...1602...<mailto:Oscar.Diago@…1602…>> a écrit :
Good morning.

More data about that issue. We have found the following error in the log:

java.sql.SQLSyntaxErrorException: ORA-00920: operador relacional no v⭩do.

Error: ORA-00920: invalid relational operator
Causa: A search condition was entered with an invalid or missing relational operator.
Acción: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.

I hope it gives a hint about what could be hapenning during the deployment.

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…><mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <Oscar.Diago@...1602...<mailto:Oscar.Diago@…1602…>>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: Geonetwork-Users@...638...<mailto:Geonetwork-Users@…638…> <geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@lists.sourceforge.net>>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

Good morning

We are facing the same issue. Changing the config-spring-geonetwork.xml as suggested hasn't solved it.

Any idea abiout it would be welcome!

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…><mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <paul.vangenuchten@...444...<mailto:paul.vangenuchten@…444…>>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <fx.prunayre@...54...<mailto:fx.prunayre@…54…>>
Cc: geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@lists.sourceforge.net> <geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@lists.sourceforge.net>>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

A suggestion, are you using the default oracle schema for the user? If not, you need to set the alternative schema also in config-spring-geonetwork.xml (see the commented section).

Groet Paul van Genuchten

Op 29 okt. 2020 om 08:29 heeft Francois Prunayre <fx.prunayre@...54...<mailto:fx.prunayre@…54…>> het volgende geschreven:

Hi,

Do you have 3.x working with the oracle server?
In 4, we updated JPA and Hibernate libraries so that may explain the
difference. You could try to change log level to DEBUG for
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
and restart to see if you can get the first exception which is raised.

Cheers
Francois

Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@...1876...<mailto:lars.moeller@…1876…>> a écrit :

Good evening fellow GN users,

yesterday I tried to switch to another database system after
successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
dedicated RHEL VM - but failed miserably. The initial startup of GN
(still with the default H2 db) worked well and as expected. However, the
local database is no option in our case.

So I followed the instructions found in the official documentation
<
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html>

and

* altered the node configuration file |WEB-INF/config-node/srv.xml to
   refer to /WEB-INF/config-db/oracle.xml, then
   |
* ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
* and set hibernate related logging to DEBUG level
   (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after
this modifications, however, failed due to a missing ojdbc driver. So I
downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
its permissions. But now I am confronted with another series of errors,
kind of pointing to a non-functional database connection (full log is
attached).

It reads something like:

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception

during init

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :

org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'openAPIBuilder' … Factory method
'OpenApiConfig' threw exception; nested exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no
luck. The error is similar.

Earlier I read
<
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>,

that databases do not need to be instantiated by scripts in the latest
releases, but especially the last quoted line sort of implies that there
is a table expected that doesn't seem to exist. I tried to google this
specific errors at lengths today, but weren't able to make any use of
the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@...1876...<mailto:lars.moeller@…1876…>
www.hzg.de<http://www.hzg.de>

Helmholtz-Zentrum Geesthacht
Zentrum für Material- und Küstenforschung GmbH
Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
Simon
Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
Ministerialdirigent Engelbert Beyer
Amtsgericht Lübeck HRB 285 GE (Register Court)
Internet: http://www.hzg.de
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Oscar_Diago_Alonso · November 3, 2020, 10:46am

Hi.

We are still unable to point out the issue with GeoNetworl 4.0 and Oracle.

I have attached the log of our last attempt.

The database version is: Oracle Database 11g Release 11.2.0.4.0 - 64bit.

We are using the library "ojdbc6.jar" to connect to that database.

We are also using OpenJDK: openjdk64_8.0.265

Anyone has any idea about what it could be happenning?

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Francois Prunayre <fx.prunayre@...54...>
Enviado: viernes, 30 de octubre de 2020 9:28
Para: Oscar Diago Alonso <Oscar.Diago@...1602...>
Cc: Geonetwork-Users@...638... <geonetwork-users@lists.sourceforge.net>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

Hi Oscar, if you turn on debug level for SQL you may be able to get the query which is causing this and it will help a bit more.
Can you also send the full exception if there is any stack trace with more details on the location.

Thanks

Francois

Le ven. 30 oct. 2020 à 08:37, Oscar Diago Alonso <Oscar.Diago@...1602...<mailto:Oscar.Diago@…1602…>> a écrit :
Good morning.

More data about that issue. We have found the following error in the log:

java.sql.SQLSyntaxErrorException: ORA-00920: operador relacional no v⭩do.

Error: ORA-00920: invalid relational operator
Causa: A search condition was entered with an invalid or missing relational operator.
Acción: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition.

I hope it gives a hint about what could be hapenning during the deployment.

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…><mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <Oscar.Diago@...1602...<mailto:Oscar.Diago@…1602…>>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: Geonetwork-Users@...638...<mailto:Geonetwork-Users@…638…> <geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@lists.sourceforge.net>>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

Good morning

We are facing the same issue. Changing the config-spring-geonetwork.xml as suggested hasn't solved it.

Any idea abiout it would be welcome!

Best regards.

Óscar Diago Alonso
Analista / Desarrollador GIS
oscar.diago@...1602...<mailto:oscar.diago@…1602…><mailto:oscar.diago@…1602…>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <paul.vangenuchten@...444...<mailto:paul.vangenuchten@…444…>>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <fx.prunayre@...54...<mailto:fx.prunayre@…54…>>
Cc: geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@lists.sourceforge.net> <geonetwork-users@lists.sourceforge.net<mailto:geonetwork-users@lists.sourceforge.net>>
Asunto: Re: [GeoNetwork-users] GN fails to start after binding to an oracle DB

A suggestion, are you using the default oracle schema for the user? If not, you need to set the alternative schema also in config-spring-geonetwork.xml (see the commented section).

Groet Paul van Genuchten

Op 29 okt. 2020 om 08:29 heeft Francois Prunayre <fx.prunayre@...54...<mailto:fx.prunayre@…54…>> het volgende geschreven:

Hi,

Do you have 3.x working with the oracle server?
In 4, we updated JPA and Hibernate libraries so that may explain the
difference. You could try to change log level to DEBUG for
https://github.com/geonetwork/core-geonetwork/blob/4.0.x/web/src/main/webapp/WEB-INF/classes/log4j.xml#L215-L229
and restart to see if you can get the first exception which is raised.

Cheers
Francois

Le mer. 28 oct. 2020 à 19:34, Lars Möller <lars.moeller@...1876...<mailto:lars.moeller@…1876…>> a écrit :

Good evening fellow GN users,

yesterday I tried to switch to another database system after
successfully deploying the latest release (GN 4.0.0) via Tomcat 9 on the
dedicated RHEL VM - but failed miserably. The initial startup of GN
(still with the default H2 db) worked well and as expected. However, the
local database is no option in our case.

So I followed the instructions found in the official documentation
<
https://www.geonetwork-opensource.org/manuals/4.0.x/en/install-guide/configuring-database.html>

and

* altered the node configuration file |WEB-INF/config-node/srv.xml to
   refer to /WEB-INF/config-db/oracle.xml, then
   |
* ||adjusted |WEB-INF/config-db/jdbc.properties| according to our setup,
* and set hibernate related logging to DEBUG level
   (WEB-INF/classes/log4j.xml)

The oracle db was tested and found untouched. The initial startup after
this modifications, however, failed due to a missing ojdbc driver. So I
downloaded ojdbc8 from oracle, placed it in |/WEB-INF/lib| and adjusted
its permissions. But now I am confronted with another series of errors,
kind of pointing to a non-functional database connection (full log is
attached).

It reads something like:

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Raised exception

during init

2020-10-28 16:25:35,194 FATAL [jeeves.engine] - Exception :

org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'openAPIBuilder' … Factory method
'OpenApiConfig' threw exception; nested exception is
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet…

…and…

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

…

Later I tried another version of the ojdbc driver (14), but still no
luck. The error is similar.

Earlier I read
<
http://osgeo-org.1560.x6.nabble.com/Where-are-the-SQL-scripts-to-create-tables-tp5448158.html>,

that databases do not need to be instantiated by scripts in the latest
releases, but especially the last quoted line sort of implies that there
is a table expected that doesn't seem to exist. I tried to google this
specific errors at lengths today, but weren't able to make any use of
the information I found.

Hence, any help would be highly appreciated!

Best of regards,
Lars

--
Dr. Lars Möller
HCDC Metadatenadministration

Helmholtz-Zentrum Geesthacht
Zentrum für Material und Küstenforschung
-Modellierung zur Bewertung von Küstensystemen (KBS)
Max-Planck-Straße 1

21502 Geesthacht
Germany

Fon +49 (0) 4152- 87 - 1849
Fax +49 (0) 4152- 87 - 41849
E-mail: lars.moeller@...1876...<mailto:lars.moeller@…1876…>
www.hzg.de<http://www.hzg.de>

Helmholtz-Zentrum Geesthacht
Zentrum für Material- und Küstenforschung GmbH
Max-Planck-Straße 1 I 21502 Geesthacht I Deutschland/Germany

Geschäftsführung/Board of Management: Prof. Dr. Matthias Rehahn, Silke
Simon
Vorsitzender des Aufsichtsrates/Chairman of the Supervisory Board:
Ministerialdirigent Engelbert Beyer
Amtsgericht Lübeck HRB 285 GE (Register Court)
Internet: http://www.hzg.de
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

(attachments)

geonetwork.log (39.8 KB)