GN fails to start after binding to an oracle DB

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

GN fails to start after binding to an oracle DB

lmoeller
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: [hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

geonetwork.log (39K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Francois Prunayre
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 <[hidden email]> 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: [hidden email]
> 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Paul van Genuchten
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 <[hidden email]> 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 <[hidden email]> 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: [hidden email]
>> 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
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork


_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Oscar Diago Alonso
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
[hidden email]<mailto:[hidden email]>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <[hidden email]>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <[hidden email]>
Cc: [hidden email] <[hidden email]>
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 <[hidden email]> 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 <[hidden email]> 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: [hidden email]
>> 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
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork


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

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Oscar Diago Alonso
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
[hidden email]<mailto:[hidden email]>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <[hidden email]>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: [hidden email] <[hidden email]>
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
[hidden email]<mailto:[hidden email]>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <[hidden email]>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <[hidden email]>
Cc: [hidden email] <[hidden email]>
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 <[hidden email]> 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 <[hidden email]> 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: [hidden email]
>> 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
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork


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

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

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Francois Prunayre
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 <[hidden email]>
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
> [hidden email]<mailto:[hidden email]>
> Tfno.: +34 945 13 13 72
> C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava
>
> ________________________________
> De: Oscar Diago Alonso <[hidden email]>
> Enviado: jueves, 29 de octubre de 2020 14:40
> Para: [hidden email] <
> [hidden email]>
> 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
> [hidden email]<mailto:[hidden email]>
> Tfno.: +34 945 13 13 72
> C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava
>
> ________________________________
> De: Paul Van Genuchten <[hidden email]>
> Enviado: jueves, 29 de octubre de 2020 8:36
> Para: Francois Prunayre <[hidden email]>
> Cc: [hidden email] <
> [hidden email]>
> 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 <[hidden email]>
> 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 <[hidden email]> 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: [hidden email]
> >> 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
> >> [hidden email]
> >> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> >> GeoNetwork OpenSource is maintained at
> >> http://sourceforge.net/projects/geonetwork
> >>
> >
> > _______________________________________________
> > GeoNetwork-users mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> > GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
>

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Oscar Diago Alonso
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
[hidden email]<mailto:[hidden email]>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Francois Prunayre <[hidden email]>
Enviado: viernes, 30 de octubre de 2020 9:28
Para: Oscar Diago Alonso <[hidden email]>
Cc: [hidden email] <[hidden email]>
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 <[hidden email]<mailto:[hidden email]>> 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
[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <[hidden email]<mailto:[hidden email]>>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: [hidden email]<mailto:[hidden email]> <[hidden email]<mailto:[hidden email]>>
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
[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <[hidden email]<mailto:[hidden email]>>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <[hidden email]<mailto:[hidden email]>>
Cc: [hidden email]<mailto:[hidden email]> <[hidden email]<mailto:[hidden email]>>
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 <[hidden email]<mailto:[hidden email]>> 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 <[hidden email]<mailto:[hidden email]>> 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: [hidden email]<mailto:[hidden email]>
>> 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
>> [hidden email]<mailto:[hidden email]>
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]<mailto:[hidden email]>
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork


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

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

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

_______________________________________________
GeoNetwork-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Reply | Threaded
Open this post in threaded view
|

Re: GN fails to start after binding to an oracle DB

Oscar Diago Alonso
In reply to this post by Francois Prunayre
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
[hidden email]<mailto:[hidden email]>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Francois Prunayre <[hidden email]>
Enviado: viernes, 30 de octubre de 2020 9:28
Para: Oscar Diago Alonso <[hidden email]>
Cc: [hidden email] <[hidden email]>
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 <[hidden email]<mailto:[hidden email]>> 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
[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Oscar Diago Alonso <[hidden email]<mailto:[hidden email]>>
Enviado: jueves, 29 de octubre de 2020 14:40
Para: [hidden email]<mailto:[hidden email]> <[hidden email]<mailto:[hidden email]>>
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
[hidden email]<mailto:[hidden email]><mailto:[hidden email]<mailto:[hidden email]>>
Tfno.: +34 945 13 13 72
C/ Pintor Clemente Arráiz, 3 BJ (01008) Vitoria-Gasteiz, Álava

________________________________
De: Paul Van Genuchten <[hidden email]<mailto:[hidden email]>>
Enviado: jueves, 29 de octubre de 2020 8:36
Para: Francois Prunayre <[hidden email]<mailto:[hidden email]>>
Cc: [hidden email]<mailto:[hidden email]> <[hidden email]<mailto:[hidden email]>>
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 <[hidden email]<mailto:[hidden email]>> 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 <[hidden email]<mailto:[hidden email]>> 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: [hidden email]<mailto:[hidden email]>
>> 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
>> [hidden email]<mailto:[hidden email]>
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>>
>
> _______________________________________________
> GeoNetwork-users mailing list
> [hidden email]<mailto:[hidden email]>
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

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

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

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


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

geonetwork.log (54K) Download Attachment