Hi François,
I did not see any error at startup but Tomcat is not stopping correctly when I use the catalina.sh script (Apache Tomcat/6.0.29 under Debian Lenny). I have to kill it.
By logging all transactions made to postgresql, I identified the issue.
2011-05-25 16:53:33 CEST 4ddd1798.7aad LOG: execute S_1: BEGIN
2011-05-25 16:53:33 CEST 4ddd1798.7aad ERROR: relation "customelementset" does not exist
2011-05-25 16:53:33 CEST 4ddd1798.7aad STATEMENT: SELECT * FROM CustomElementSet
2011-05-25 16:53:33 CEST 4ddd1798.7aad ERROR: current transaction is aborted, commands ignored until end of transaction block
2011-05-25 16:53:33 CEST 4ddd1798.7aad STATEMENT: SELECT id FROM Groups
2011-05-25 16:53:33 CEST 4ddd1798.7aad LOG: execute S_2: COMMIT
The table CustomElementSet did not exist. Looking at the db scripts provided with GeoNetwork, the creation of the table is foreseen in the create-db-xxx.sql scripts but not in the migration scripts.
With this table created, I can search for existing feature catalogues without getting an error!
Unfortunately my problem is not completely solved as I get this error message "Error / status undefined text: undefined - Try again later" when I click on "Create relation" after having selected a feature catalogue. I was already receiving this error with GN2.6.2 but at that time, I did not investigate further as I did not need this functionality.
Corresponding log from postgresql:
2011-05-25 17:32:12 CEST 4ddd2055.7d8e LOG: execute S_1: BEGIN
2011-05-25 17:32:12 CEST 4ddd2055.7d8e LOG: execute <unnamed>: SELECT id FROM Metadata WHERE uuid=$1
2011-05-25 17:32:12 CEST 4ddd2055.7d8e DETAIL: parameters: $1 = '411cd05b-9a79-45f2-b39f-0b344a9f35af'
2011-05-25 17:32:12 CEST 4ddd2055.7d8e ERROR: syntax error at or near "exist" at character 17
2011-05-25 17:32:12 CEST 4ddd2055.7d8e STATEMENT: Select count(*) exist from Relations where id=$1 and relatedId=$2
2011-05-25 17:32:12 CEST 4ddd2055.7d8e LOG: execute S_3: ROLLBACK
Log from geonetwork:
2011-05-25 17:32:12,028 INFO [jeeves.request] - ==========================================================
2011-05-25 17:32:12,029 INFO [jeeves.request] - HTML Request (from 192.168.62.135) : /geonetwork/srv/en/xml.relation.insert
2011-05-25 17:32:12,029 DEBUG [jeeves.request] - Method : GET
2011-05-25 17:32:12,029 DEBUG [jeeves.request] - Content type : null
2011-05-25 17:32:12,029 DEBUG [jeeves.request] - Accept : text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
2011-05-25 17:32:12,029 DEBUG [jeeves.request] - Session id is 64ACBC23D092B6D6D04BB5FE950EE8CC
2011-05-25 17:32:12,029 INFO [jeeves.service] - Dispatching : xml.relation.insert
2011-05-25 17:32:12,030 DEBUG [jeeves.service] - -> parameters are :
<request>
<childUuid>411cd05b-9a79-45f2-b39f-0b344a9f35af</childUuid>
<_dc>1306337899980</_dc>
<parentId>25</parentId>
</request>
2011-05-25 17:32:12,038 ERROR [jeeves.service] - Exception when executing service
2011-05-25 17:32:12,038 ERROR [jeeves.service] - (C) Exc : org.postgresql.util.PSQLException: ERROR: syntax error at or near "exist"
Position: 17
2011-05-25 17:32:12,039 DEBUG [jeeves.service] - Raised exception while executing service
<error id="error">
<message>ERROR: syntax error at or near "exist"
Position: 17</message>
<class>PSQLException</class>
<stack>
<at class="org.postgresql.core.v3.QueryExecutorImpl" file="QueryExecutorImpl.java" line="2062" method="receiveErrorResponse" />
<at class="org.postgresql.core.v3.QueryExecutorImpl" file="QueryExecutorImpl.java" line="1795" method="processResults" />
<at class="org.postgresql.core.v3.QueryExecutorImpl" file="QueryExecutorImpl.java" line="257" method="execute" />
<at class="org.postgresql.jdbc2.AbstractJdbc2Statement" file="AbstractJdbc2Statement.java" line="479" method="execute" />
<at class="org.postgresql.jdbc2.AbstractJdbc2Statement" file="AbstractJdbc2Statement.java" line="367" method="executeWithFlags" />
<at class="org.postgresql.jdbc2.AbstractJdbc2Statement" file="AbstractJdbc2Statement.java" line="271" method="executeQuery" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="214" method="selectFull" />
<at class="jeeves.resources.dbms.Dbms" file="Dbms.java" line="186" method="select" />
<at class="org.fao.geonet.services.relations.Insert" file="Insert.java" line="71" method="exec" />
<at class="jeeves.server.dispatchers.ServiceInfo" file="ServiceInfo.java" line="238" method="execService" />
</stack>
<request>
<language>en</language>
<service>xml.relation.insert</service>
</request>
</error>
2011-05-25 17:32:12,039 INFO [jeeves.service] - -> dispatching to error for : xml.relation.insert
2011-05-25 17:32:12,042 DEBUG [jeeves.engine] - TransformerFactoryFactory: de.fzi.dbs.xml.transform.CachingTransformerFactory
2011-05-25 17:32:12,042 DEBUG [jeeves.engine] - TransformerFactoryFactory: produces transformer implementation net.sf.saxon.IdentityTransformer
2011-05-25 17:32:12,044 INFO [jeeves.service] - -> transforming with stylesheet : /usr/local/tomcat/webapps/geonetwork/xsl/error.xsl
2011-05-25 17:32:12,044 DEBUG [jeeves.engine] - TransformerFactoryFactory: de.fzi.dbs.xml.transform.CachingTransformerFactory
2011-05-25 17:32:12,044 DEBUG [jeeves.engine] - TransformerFactoryFactory: produces transformer implementation net.sf.saxon.IdentityTransformer
2011-05-25 17:32:12,062 INFO [jeeves.service] - -> end error transformation for : xml.relation.insert
2011-05-25 17:32:12,062 INFO [jeeves.service] - -> error ended for : xml.relation.insert
Thanks for your help!
Ciao,
Paul
-----Original Message-----
From: Francois Prunayre [mailto:fx.prunayre@…54…]
Sent: Wednesday, May 25, 2011 8:42 AM
To: Paul Hasenohr
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Error when linking a spatial dataset to a feature catalogue
Hi Paul,
2011/5/24 Paul Hasenohr <Paul.Hasenohr@...751...>:
Hi François,
The following tests fail:
csw-GetRecords | no filter | outputSchema: fra:IsoRecord
(exceptionCode="InvalidParameterValue")
csw-GetRecords | no filter | outputSchema: own
(exceptionCode="InvalidParameterValue")
csw-GetRecords | filter ogc:Equals+bbox -90,-180 0,0 csw-GetRecordById
| outputSchema: fra:IsoRecord (exceptionCode="InvalidParameterValue")
Normal failure due to tests for ISO profils not included in default installation pack.
csw-Transactions not tested.
I get the error I reported also when I search for existing services after having selected "Link service metadata" from within a dataset metadata record in edit mode.
I made some tests and I get the same error if I replace in the second test called csw-GetRecords | SortBy title <csw:ElementSetName>summary</csw:ElementSetName> by <csw:ElementSetName>full</csw:ElementSetName> .
If I replace "summary" by "brief", it is working fine.
I can't reproduce this error (2.6.4 or trunk with sample data). Could you check if you don't have other errors on startup ?
You could also set DEBUG level in log4j.cfg for:
log4j.logger.geonetwork.search
log4j.logger.geonetwork.csw
log4j.logger.geonetwork.csw.search
and see if you get more info.
Ciao.
Francois
Thanks for your help.
Best regards,
Paul
-----Original Message-----
From: Francois Prunayre [mailto:fx.prunayre@…54…]
Sent: Tuesday, May 24, 2011 11:04 AM
To: Paul Hasenohr
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] Error when linking a spatial dataset
to a feature catalogue
Hi Paul,
2011/5/23 Paul Hasenohr <Paul.Hasenohr@...751...>:
Hello,
I just upgraded from v2.6.3 to 2.6.4. In order to do this, I deployed the new geonetwork.war and edited the few xml/xsl files that I had customized in the previous version. I had also to run manually the SQL update script (I took all statements after --2.6.4 changes in WEB-INF/classes/setup/sql/migrate/2.6.0-to-2.6.4/postgis.sql).
Within a dataset metadata record, clicking on "Link feature catalogue" opens a window in which I try to search for related metadata without any success. An error is logged.
2011-05-23 16:17:10,613 INFO [jeeves.request] -
2011-05-23 16:17:10,613 INFO [jeeves.request] - HTML Request (from
192.168.62.134) : /geonetwork/srv/en/csw
2011-05-23 16:17:10,613 DEBUG [jeeves.request] - Method : POST
2011-05-23 16:17:10,613 DEBUG [jeeves.request] - Content type :
application/xml; charset=UTF-8
2011-05-23 16:17:10,613 DEBUG [jeeves.request] - Accept :
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
2011-05-23 16:17:10,613 DEBUG [jeeves.request] - Session id is
0C1E0193B59714D63B171F5DAFD17F62
2011-05-23 16:17:10,615 INFO [jeeves.service] - Dispatching : csw
2011-05-23 16:17:10,615 DEBUG [jeeves.service] - -> parameters are :
<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2"
service="CSW" version="2.0.2" resultType="results" startPosition="1"
maxRecords="20">
<csw:Query typeNames="csw:Record">
<csw:ElementSetName>full</csw:ElementSetName>
<csw:Constraint version="1.0.0">
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:And>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>_schema</ogc:PropertyName>
<ogc:Literal>iso19110</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:And>
</ogc:Filter>
</csw:Constraint>
</csw:Query>
</csw:GetRecords>
2011-05-23 16:17:10,615 INFO [jeeves.webapp.csw] - Received:
<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2"
service="CSW" version="2.0.2" resultType="results" startPosition="1"
maxRecords="20">
<csw:Query typeNames="csw:Record">
<csw:ElementSetName>full</csw:ElementSetName>
<csw:Constraint version="1.0.0">
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
<ogc:And>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>_schema</ogc:PropertyName>
<ogc:Literal>iso19110</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:And>
</ogc:Filter>
</csw:Constraint>
</csw:Query>
</csw:GetRecords>
2011-05-23 16:17:10,616 DEBUG [jeeves.engine] -
TransformerFactoryFactory:
de.fzi.dbs.xml.transform.CachingTransformerFactory
2011-05-23 16:17:10,616 DEBUG [jeeves.engine] -
TransformerFactoryFactory: produces transformer implementation
net.sf.saxon.IdentityTransformer
2011-05-23 16:17:10,619 INFO [jeeves.service] - -> dispatching to
output for : csw
2011-05-23 16:17:10,619 INFO [jeeves.service] - -> writing xml
for : csw
2011-05-23 16:17:10,619 DEBUG [jeeves.service] - Service xml is :
<ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0"
xsi:schemaLocation="http://www.opengis.net/ows
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">
<ows:Exception exceptionCode="NoApplicableCode">
<ows:ExceptionText>Raised exception while searching metadata :
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction
block</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>
2011-05-23 16:17:10,620 INFO [jeeves.service] - -> output ended
for : csw
2011-05-23 16:17:10,620 INFO [jeeves.service] - -> dispatch ended
for : csw
Does anyone know what is happening?
I tried using default clean install with mckoi and PostgreSQL but I can't reproduce the issue when linking records.
Could you try to run CSW sample queries from http://localhost:8080/geonetwork/srv/en/test.csw to see if the issue is related to CSW or to linking iso19110 record to iso19139 ?
Cheers.
Francois
Thanks.
Best regards,
Paul
Paul Hasenohr
European Environment Agency
Kongens Nytorv 6
DK-1050 Copenhagen
Denmark
Tel: +45 33 36 72 58
paul.hasenohr@...751...
---------------------------------------------------------------------
-
-------- What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
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
! I created a ticket