[GeoNetwork-devel] metadata visible problem

Khrizart · February 28, 2007, 10:33pm

We have a GeoNetwork 2.0.3 running over Windows 2000 and we have installed
Oracle Express and MySQL to make some tests

We imported the metadata with the batch method and we would want to make
them visible to the Intranet and All groups, we executed some queries * to
add the records in the operationallowed table but even when the privileges
are checked the metadata still cant be viewed
Do I need to make another change beside adding the records?

Thanks in advance
Iván Israel

INSERT INTO OPERATIONALLOWED ( METADATAID, GROUPID, OPERATIONID )
SELECT ID, 1, 0 FROM METADATA WHERE ID NOT IN
(SELECT METADATAID FROM OPERATIONALLOWED WHERE GROUPID=1 AND OPERATIONID=0);

INSERT INTO OPERATIONALLOWED ( METADATAID, GROUPID, OPERATIONID )
SELECT ID, 0, 0 FROM METADATA WHERE ID NOT IN
(SELECT METADATAID FROM OPERATIONALLOWED WHERE GROUPID=0 AND OPERATIONID=0);

–
Saludos…

ticheler · February 28, 2007, 10:40pm

Hi Ivan,
You'll have to stop the server and remove the Lucene index files. These have to be rebuild (this will happen on restart of the server) in order for the server to take them into account. The Lucene indexes are located in ../web/WEB-INF/lucene/
Ciao,
Jeroen

On Feb 28, 2007, at 11:33 PM, Khrizart wrote:

We have a GeoNetwork 2.0.3 running over Windows 2000 and we have installed
Oracle Express and MySQL to make some tests

We imported the metadata with the batch method and we would want to make
them visible to the Intranet and All groups, we executed some queries * to
add the records in the operationallowed table but even when the privileges
are checked the metadata still cant be viewed
Do I need to make another change beside adding the records?

Thanks in advance
Iván Israel

*
INSERT INTO OPERATIONALLOWED ( METADATAID, GROUPID, OPERATIONID )
SELECT ID, 1, 0 FROM METADATA WHERE ID NOT IN
(SELECT METADATAID FROM OPERATIONALLOWED WHERE GROUPID=1 AND OPERATIONID=0);

INSERT INTO OPERATIONALLOWED ( METADATAID, GROUPID, OPERATIONID )
SELECT ID, 0, 0 FROM METADATA WHERE ID NOT IN
(SELECT METADATAID FROM OPERATIONALLOWED WHERE GROUPID=0 AND OPERATIONID=0);

--
Saludos....
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Walter_Barbera · March 1, 2007, 9:14am

Hi,

I´ve got a question related to an exception rised when using dct:spatial.
(I´ve also tried BBOX with no luck). I was wondering if anyone could bring
any light into this as I am quite new in spatial queries and csw and I might
be stuck in something not supported or a bug. Thanks in advance.

Query:

<?xml version="1.0" encoding="UTF-8"?>
<GetRecords service="CSW" version="2.0.1"
  xmlns="http://www.opengis.net/cat/csw"
  xmlns:csw="http://www.opengis.net/cat/csw"
  xmlns:ogc="http://www.opengis.net/ogc"
  xmlns:gml="http://www.opengis.net/gml" startPosition='1'
  maxRecords='10' resultType="results">
  <Query>
    <ElementSetName>summary</ElementSetName>
    <Constraint version='1.1.0'>
      <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
        <ogc:And>
          <ogc:PropertyIsLike wildCard="*"
singleChar="?"
            escape="\">

<ogc:PropertyName>dc:title</ogc:PropertyName>

<ogc:Literal>*polar*</ogc:Literal>
          </ogc:PropertyIsLike>
          <dct:spatial

xmlns:dct="http://purl.org/dc/terms/">
            northlimit=41.256215
southlimit=38.154466
            eastlimit=-1.085282
westlimit=-5.372859
          </dct:spatial>
        </ogc:And>
      </ogc:Filter>
    </Constraint>
  </Query>
</GetRecords>

Exception rised:

<ows:ExceptionReport version='1.0.0' xmlns:ows='http://www.opengis.net/ows’>
<ows:Exception exceptionCode='NoApplicableCode'>
<ows:ExceptionText>Rised exception while searching metadata :
java.lang.IndexOutOfBoundsException: Index: 0 Size: 0</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>

Walter Barbera.

Andrea_Carboni1 · March 1, 2007, 11:30am

Hi Walter,

the dct:spatial property is a string and is not intended to be queried that way.
You need to query a bbox and the format is this:

<BBOX>
    <PropertyName>ows:BoundingBox</PropertyName>
    <gml:Envelope srsName="http://www.opengis.net/gml/srs/epsg.xml#63266405">
      <gml:lowerCorner>100 100</gml:lowerCorner>
      <gml:upperCorner>200 200</gml:upperCorner>
    </gml:Envelope>
</BBOX>

Cheers,
Andrea

Hi,

I´ve got a question related to an exception rised when using dct:spatial.
(I´ve also tried BBOX with no luck). I was wondering if anyone could bring
any light into this as I am quite new in spatial queries and csw and I might
be stuck in something not supported or a bug. Thanks in advance.

Query:

<?xml version="1.0" encoding="UTF-8"?>
<GetRecords service="CSW" version="2.0.1"
  xmlns="http://www.opengis.net/cat/csw"
  xmlns:csw="http://www.opengis.net/cat/csw"
  xmlns:ogc="http://www.opengis.net/ogc"
  xmlns:gml="http://www.opengis.net/gml" startPosition='1'
  maxRecords='10' resultType="results">
  <Query>
    <ElementSetName>summary</ElementSetName>
    <Constraint version='1.1.0'>
      <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
        <ogc:And>
          <ogc:PropertyIsLike wildCard="*"
singleChar="?"
            escape="\">

<ogc:PropertyName>dc:title</ogc:PropertyName>

<ogc:Literal>*polar*</ogc:Literal>
          </ogc:PropertyIsLike>
          <dct:spatial

xmlns:dct="http://purl.org/dc/terms/">
            northlimit=41.256215
southlimit=38.154466
            eastlimit=-1.085282
westlimit=-5.372859
          </dct:spatial>
        </ogc:And>
      </ogc:Filter>
    </Constraint>
  </Query>
</GetRecords>

Exception rised:

<ows:ExceptionReport version='1.0.0' xmlns:ows='http://www.opengis.net/ows’>
<ows:Exception exceptionCode='NoApplicableCode'>
<ows:ExceptionText>Rised exception while searching metadata :
java.lang.IndexOutOfBoundsException: Index: 0 Size: 0</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>

Walter Barbera.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Walter_Barbera · March 1, 2007, 12:49pm

Hi,

Thanks for your quick response. I've got a similar problem related to dates
and probably is due to the same mistake as dct:spatial (I am having
difficulties to know when to use string/non-string properties and how). I'm
using dct:modified to query data within date intervals and I get the same
exception error (java.lang.IndexOutOfBoundsException: Index: 0 Size: 0).

      <ogc:PropertyIsGeaterThan>

<ogc:PropertyName>dct:modified</ogc:PropertyName>
        <ogc:Literal>2004-03-26</ogc:Literal>
      </ogc:PropertyIsGeaterThan>

Any idea? Thanks in advance,

Walter.

-----Mensaje original-----
De: geonetwork-devel-bounces@lists.sourceforge.net
[mailto:geonetwork-devel-bounces@lists.sourceforge.net] En nombre de Andrea
Carboni
Enviado el: jueves, 01 de marzo de 2007 12:31
Para: geonetwork-devel@lists.sourceforge.net
Asunto: Re: [GeoNetwork-devel] dct:spatial coordinates query problem

Hi Walter,

the dct:spatial property is a string and is not intended to be queried that
way.
You need to query a bbox and the format is this:

<BBOX>
    <PropertyName>ows:BoundingBox</PropertyName>
    <gml:Envelope
srsName="http://www.opengis.net/gml/srs/epsg.xml#63266405">
      <gml:lowerCorner>100 100</gml:lowerCorner>
      <gml:upperCorner>200 200</gml:upperCorner>
    </gml:Envelope>
</BBOX>

Cheers,
Andrea

Hi,

I´ve got a question related to an exception rised when using dct:spatial.
(I´ve also tried BBOX with no luck). I was wondering if anyone could

bring

any light into this as I am quite new in spatial queries and csw and I

might

be stuck in something not supported or a bug. Thanks in advance.

Query:

<?xml version="1.0" encoding="UTF-8"?>
<GetRecords service="CSW" version="2.0.1"
  xmlns="http://www.opengis.net/cat/csw"
  xmlns:csw="http://www.opengis.net/cat/csw"
  xmlns:ogc="http://www.opengis.net/ogc"
  xmlns:gml="http://www.opengis.net/gml" startPosition='1'
  maxRecords='10' resultType="results">
  <Query>
    <ElementSetName>summary</ElementSetName>
    <Constraint version='1.1.0'>
      <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
        <ogc:And>
          <ogc:PropertyIsLike wildCard="*"
singleChar="?"
            escape="\">

<ogc:PropertyName>dc:title</ogc:PropertyName>

<ogc:Literal>*polar*</ogc:Literal>
          </ogc:PropertyIsLike>
          <dct:spatial

xmlns:dct="http://purl.org/dc/terms/">
            northlimit=41.256215
southlimit=38.154466
            eastlimit=-1.085282
westlimit=-5.372859
          </dct:spatial>
        </ogc:And>
      </ogc:Filter>
    </Constraint>
  </Query>
</GetRecords>

Exception rised:

<ows:ExceptionReport version='1.0.0'

xmlns:ows='http://www.opengis.net/ows’>

<ows:Exception exceptionCode='NoApplicableCode'>
<ows:ExceptionText>Rised exception while searching metadata :
java.lang.IndexOutOfBoundsException: Index: 0 Size: 0</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>

Walter Barbera.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share

your

opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at

http://sourceforge.net/projects/geonetwork

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Andrea_Carboni1 · March 1, 2007, 1:17pm

Hi Walter,

I got a different error on Crisalis (the reference implementation for now):

Error during Filter to Lucene conversion : java.lang.IllegalStateException: Root element not set

This is due to the wrong element: PropertyIsGeaterThan -> PropertyIsGreaterThan
(i.e. a 'r' is missing). After this change, the query should work.

Cheers,
Andrea

Hi,

Thanks for your quick response. I've got a similar problem related to dates
and probably is due to the same mistake as dct:spatial (I am having
difficulties to know when to use string/non-string properties and how). I'm
using dct:modified to query data within date intervals and I get the same
exception error (java.lang.IndexOutOfBoundsException: Index: 0 Size: 0).

      <ogc:PropertyIsGeaterThan>

<ogc:PropertyName>dct:modified</ogc:PropertyName>
        <ogc:Literal>2004-03-26</ogc:Literal>
      </ogc:PropertyIsGeaterThan>

Any idea? Thanks in advance,

Walter.

-----Mensaje original-----
De: geonetwork-devel-bounces@lists.sourceforge.net
[mailto:geonetwork-devel-bounces@lists.sourceforge.net] En nombre de Andrea
Carboni
Enviado el: jueves, 01 de marzo de 2007 12:31
Para: geonetwork-devel@lists.sourceforge.net
Asunto: Re: [GeoNetwork-devel] dct:spatial coordinates query problem

Hi Walter,

the dct:spatial property is a string and is not intended to be queried that
way.
You need to query a bbox and the format is this:

<BBOX>
    <PropertyName>ows:BoundingBox</PropertyName>
    <gml:Envelope
srsName="http://www.opengis.net/gml/srs/epsg.xml#63266405">
      <gml:lowerCorner>100 100</gml:lowerCorner>
      <gml:upperCorner>200 200</gml:upperCorner>
    </gml:Envelope>
</BBOX>

Cheers,
Andrea

> Hi,
>
> I´ve got a question related to an exception rised when using dct:spatial.
> (I´ve also tried BBOX with no luck). I was wondering if anyone could
bring
> any light into this as I am quite new in spatial queries and csw and I
might
> be stuck in something not supported or a bug. Thanks in advance.
>
> Query:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <GetRecords service="CSW" version="2.0.1"
> xmlns="http://www.opengis.net/cat/csw"
> xmlns:csw="http://www.opengis.net/cat/csw"
> xmlns:ogc="http://www.opengis.net/ogc"
> xmlns:gml="http://www.opengis.net/gml" startPosition='1'
> maxRecords='10' resultType="results">
> <Query>
> <ElementSetName>summary</ElementSetName>
> <Constraint version='1.1.0'>
> <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
> <ogc:And>
> <ogc:PropertyIsLike wildCard="*"
> singleChar="?"
> escape="\">
>
> <ogc:PropertyName>dc:title</ogc:PropertyName>
>
> <ogc:Literal>*polar*</ogc:Literal>
> </ogc:PropertyIsLike>
> <dct:spatial
>
> xmlns:dct="http://purl.org/dc/terms/">
> northlimit=41.256215
> southlimit=38.154466
> eastlimit=-1.085282
> westlimit=-5.372859
> </dct:spatial>
> </ogc:And>
> </ogc:Filter>
> </Constraint>
> </Query>
> </GetRecords>
>
> Exception rised:
>
> <ows:ExceptionReport version='1.0.0'
xmlns:ows='http://www.opengis.net/ows’>
> <ows:Exception exceptionCode='NoApplicableCode'>
> <ows:ExceptionText>Rised exception while searching metadata :
> java.lang.IndexOutOfBoundsException: Index: 0 Size: 0</ows:ExceptionText>
> </ows:Exception>
> </ows:ExceptionReport>
>
>
> Walter Barbera.
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> GeoNetwork-devel mailing list
> GeoNetwork-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Ivan_Renteria_Toledo · March 1, 2007, 3:28pm

Hi Jeroen,

It works fine and have saved us a lot of time

Thanks
Ivan Israel

From: Jeroen Ticheler <Jeroen.Ticheler@anonymised.com>
To: Khrizart <khrizart@anonymised.com>
CC: geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] metadata visible problem
Date: Wed, 28 Feb:40:57 +0100

Hi Ivan,
You'll have to stop the server and remove the Lucene index files.
These have to be rebuild (this will happen on restart of the server)
in order for the server to take them into account. The Lucene indexes
are located in ../web/WEB-INF/lucene/
Ciao,
Jeroen

On Feb 28, 2007, at 11:33 PM, Khrizart wrote:

> We have a GeoNetwork 2.0.3 running over Windows 2000 and we have
> installed
> Oracle Express and MySQL to make some tests
>
> We imported the metadata with the batch method and we would want to
> make
> them visible to the Intranet and All groups, we executed some
> queries * to
> add the records in the operationallowed table but even when the
> privileges
> are checked the metadata still cant be viewed
> Do I need to make another change beside adding the records?
>
> Thanks in advance
> Iván Israel
>
> *
> INSERT INTO OPERATIONALLOWED ( METADATAID, GROUPID, OPERATIONID )
> SELECT ID, 1, 0 FROM METADATA WHERE ID NOT IN
> (SELECT METADATAID FROM OPERATIONALLOWED WHERE GROUPID=1 AND
> OPERATIONID=0);
>
> INSERT INTO OPERATIONALLOWED ( METADATAID, GROUPID, OPERATIONID )
> SELECT ID, 0, 0 FROM METADATA WHERE ID NOT IN
> (SELECT METADATAID FROM OPERATIONALLOWED WHERE GROUPID=0 AND
> OPERATIONID=0);
>
> --
> Saludos....
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> GeoNetwork-devel mailing list
> GeoNetwork-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
> GeoNetwork OpenSource is maintained at http://sourceforge.net/
> projects/geonetwork

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/