error getting default geometry attribute

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

error getting default geometry attribute

Henriksen, Jonas F
Hi,

we are having a problem creating a featuretype with a postgis datasource. We have a setup on windows using geoserver 1.3.0 RC1 where everythin works fine. However, on our server, which is linux red hat enterprise and geoserver 1.3.0 RC2, we get the following error when trying to generate the bounding box from the postgis-datasource:
>The FeatureType 'positions' has a NULL extent.
>HINT: the dataset is empty or has no default geometry attribute.

The setup of the datasource is exactly the same on the two machines, and the connection to postgis works fine.

Any suggestions on what's wrong?

Regards Jonas:)))

--
Jonas F Henriksen
Institute of Marine Research
Norsk Marint Datasenter
PO Box 1870 Nordnes
5817 Bergen
Norway
 
Phone: +47 55238441


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: error getting default geometry attribute

Chris Holmes-2
Quoting "Henriksen, Jonas F" <[hidden email]>:

> Hi,
>
> we are having a problem creating a featuretype with a postgis
> datasource. We have a setup on windows using geoserver 1.3.0 RC1
> where everythin works fine. However, on our server, which is linux
> red hat enterprise and geoserver 1.3.0 RC2, we get the following
> error when trying to generate the bounding box from the
> postgis-datasource:
> >The FeatureType 'positions' has a NULL extent.
> >HINT: the dataset is empty or has no default geometry attribute.
>
> The setup of the datasource is exactly the same on the two machines,
> and the connection to postgis works fine.
>
> Any suggestions on what's wrong?
Are you using the exact same postgis database?  Like connecting to the
same machine?  Or did you to a dump of the db and copy it over to the
linux server?  If the latter than it may be that the 'geometry_columns'
row for your positions featureType is not declared, which would give
that kind of error.  GeoTools/server needs the proper geometry_columns
row to figure out what geometry to use.

Chris

>
> Regards Jonas:)))
>
> --
> Jonas F Henriksen
> Institute of Marine Research
> Norsk Marint Datasenter
> PO Box 1870 Nordnes
> 5817 Bergen
> Norway
>
> Phone: +47 55238441
>
>
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing
> & QA
> Security * Process Improvement & Measurement *
> http://www.sqe.com/bsce5sf
> _______________________________________________
> Geoserver-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>




----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: error getting default geometry attribute

Henriksen, Jonas F
In reply to this post by Henriksen, Jonas F
Hi,

still having the same problem. Have tried a few things:
WFS getfeature seems to work just fine, no errors here.
WMS  - This is where the trouble started. When calling the WMS getMap nothing is rendered, and in the catalina-log (logging level FINE) we get:

167705054 [FINE] org.vfny.geoserver.util.requests.readers.KvpRequestReader - clean request is bbox=0,60,60,85&styles=point&Format=image/png&request=GetMap&layers=rls:geom_test&width=550&height=250&srs=EPSG:4326
167705054 [FINE] org.vfny.geoserver.util.requests.readers.KvpRequestReader - returning parsed {SRS=EPSG:4326, LAYERS=rls:geom_test, BBOX=0,60,60,85, HEIGHT=250, REQUEST=GetMap, STYLES=point, WIDTH=550, FORMAT=image/png}
167705054 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses' strategy
167705055 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy SPEED
167705055 [FINE] org.vfny.geoserver.servlets.AbstractService - verifying configured strategy
167705055 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.SpeedStrategy
167705055 [FINE] org.vfny.geoserver.servlets.AbstractService - reading request: bbox=0,60,60,85&styles=point&Format=image/png&request=GetMap&layers=rls:geom_test&width=550&height=250&srs=EPSG:4326
167705056 [FINE] org.vfny.geoserver.global.Data - getting type rls:geom_test
167705056 [FINE] org.geotools.data.postgis.PostgisDataStore - get Feature source called on geom_test
167705056 [FINE] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking
167705057 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
167705057 [FINE] org.vfny.geoserver.wms.requests.GetMapKvpReader - establishing point style for rls:geom_test
167705057 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request: org.vfny.geoserver.wms.requests.GetMapRequest@8845df8b
167705057 [FINE] org.vfny.geoserver.servlets.AbstractService - strategy is: org.vfny.geoserver.servlets.SpeedStrategy@4b929fb6
167705059 [FINE] DefaultFactory - Unavailable factory: European Petroleum Survey Group
167705061 [FINE] org.vfny.geoserver.wms.responses.GetMapResponse - setting up map
167705061 [FINE] org.geotools.data.postgis.PostgisDataStore - get Feature source called on geom_test
167705061 [FINE] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking
167705062 [FINE] org.vfny.geoserver.wms.responses.DefaultRasterMapProducer - setting up 550x250 image
167705062 [FINE] org.vfny.geoserver.wms.responses.DefaultRasterMapProducer - calling renderer
167705063 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Affine Transform is AffineTransform[[9.166666666666666, 0.0, -0.0], [0.0, -10.0, 850.0]]
167705064 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
167705065 [SEVERE] org.geotools.renderer.lite.LiteRenderer2$DefaultRenderListener - Error transforming bbox
167705065 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
167705065 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
167705066 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Got a tranform exception while trying to de-project the current envelope, falling back on full data loading (no bbox query)
167705066 [SEVERE] org.geotools.renderer.lite.LiteRenderer2$DefaultRenderListener - Exception rendering layer org.geotools.map.DefaultMapLayer@3db29fb6
167705066 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Style cache hit ratio: NaN , hits 0, requests 0
167705067 [FINE] org.vfny.geoserver.servlets.AbstractService - mime type is: image/png
167705078 [INFO] org.vfny.geoserver.servlets.AbstractService - Service handled

For some reason there is an error transforming the bounding-box.
When trying to generate the bounding-box in the web config interface we get the following entries in catalina.out:
168574409 [FINE] org.geotools.data.arcsde.ArcSDEDataStoreFactory - com.esri.sde.sdk.client.SeConnection is in place.
168574409 [FINE] org.geotools.data.arcsde.ArcSDEDataStoreFactory - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
168574412 [FINE] org.geotools.data.postgis.PostgisConnectionFactory - looking up pool key jdbc:postgresql://fluen.imr.no:5432/rlsrlsrls.123
168574413 [FINE] org.geotools.data.postgis.PostgisConnectionFactory - pool is org.postgresql.jdbc2.optional.ConnectionPool@414cdf89
168574413 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574414 [FINE] org.geotools.data.postgis.PostgisDataStore - version is 1.0 USE_GEOS=0 USE_PROJ=0 USE_STATS=1
168574415 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574415 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574423 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574423 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574431 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574431 [FINE] org.geotools.data.postgis.PostgisDataStore - geometry sql statement is SELECT type FROM GEOMETRY_COLUMNS WHERE f_table_name='geom_test' AND f_geometry_column='currentpoint';
168574433 [FINE] org.geotools.data.postgis.PostgisDataStore - geometry type is: POINT
168574433 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574435 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574435 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574436 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574437 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574437 [WARNING] org.geotools.data.jdbc.JDBCDataStore - Error building attribute type. The column will be ignored
168574438 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574438 [FINE] org.geotools.data.postgis.PostgisDataStore - get Feature source called on geom_test
168574439 [FINE] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking
168574439 [FINE] org.vfny.geoserver.action.data.TypesEditorAction - calculating bbox for their dataset
168574439 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574439 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574440 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574440 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574440 [FINE] org.vfny.geoserver.action.data.TypesEditorAction - FeatureType 'geom_test' has a null bounding box


The table geom_test contains two rows of data:
OID time (varchar) name (varchar) currentpoint (geometry)
2260377 "Mon 10:53:44" "Johan Hjort" "0101000020E6100000F15420A0E845414075A4CA1D23645240"
2260378 "Mon 10:53:57" "G. O. Sars" "0101000020E6100000AC90F2936ACD4140E381987140F85240"

and the geometry-columns-table contains:
2260373 "''" "public" "geom_test" "currentpoint" "2" "4326" "POINT" "2260368" "3" ""

As I said before, everything works fine on the windows-box that fetches data from the same database-server. The server running geoserver (version 1.3 RC2) is a linux red-hat enterprise, with IBM java 1.4.2 and tomcat 5.0.28.

Any help on this issue will be much appreciated,

thanks, regards Jonas:)))

--
Jonas F Henriksen
Institute of Marine Research
Norsk Marint Datasenter
PO Box 1870 Nordnes
5817 Bergen
Norway
 
Phone: +47 55238441



-----Opprinnelig melding-----
Fra: Chris Holmes [mailto:[hidden email]]
Sendt: 7. september 2005 14:20
Til: Henriksen, Jonas F
Kopi: [hidden email]
Emne: Re: SV: [Geoserver-users] error getting default geometry attribute


Quoting "Henriksen, Jonas F" <[hidden email]>:

> Hi Chris,
>
> Yes, I'm connecting to the same database, I've created my table like
> this:
>
> create table geom_test (
> time varchar,
> name varchar);
>
> SELECT AddGeometryColumn('geom_test', 'currentpoint', 4326, 'POINT',
> 2 );
>
> and everything looks fine in the geometry_columns-table, and as I
> said it works fine on the test-machine wich is windows,

Darn.  Was hoping this would be easy...

This is in the web admin tool that you're getting this?

How about you try just entering the values by hand - can use the ones
from your test server, or just put some random numbers in - it
shouldn't break anything.

See if it will add things then, and if it does, then do a GetFeature
request on your data.  See if things look right there, if it returns
data at all, if the data has geometries, ect.  It maybe could be some
permissions thing?  Are you connecting with a different user or
something?

But try things out with just entering a bounding box manually, see what
you get.

Chris

>
> regards Jonas:)))
>
>
> --
> Jonas F Henriksen
> Institute of Marine Research
> Norsk Marint Datasenter
> PO Box 1870 Nordnes
> 5817 Bergen
> Norway
>
> Phone: +47 55238441
>
>
> -----Opprinnelig melding-----
> Fra: Chris Holmes [mailto:[hidden email]]
> Sendt: 7. september 2005 13:40
> Til: Henriksen, Jonas F
> Kopi: [hidden email]
> Emne: Re: [Geoserver-users] error getting default geometry attribute
>
>
> Quoting "Henriksen, Jonas F" <[hidden email]>:
>
> > Hi,
> >
> > we are having a problem creating a featuretype with a postgis
> > datasource. We have a setup on windows using geoserver 1.3.0 RC1
> > where everythin works fine. However, on our server, which is linux
> > red hat enterprise and geoserver 1.3.0 RC2, we get the following
> > error when trying to generate the bounding box from the
> > postgis-datasource:
> > >The FeatureType 'positions' has a NULL extent.
> > >HINT: the dataset is empty or has no default geometry attribute.
> >
> > The setup of the datasource is exactly the same on the two
> machines,
> > and the connection to postgis works fine.
> >
> > Any suggestions on what's wrong?
> Are you using the exact same postgis database?  Like connecting to
> the
> same machine?  Or did you to a dump of the db and copy it over to the
> linux server?  If the latter than it may be that the
> 'geometry_columns'
> row for your positions featureType is not declared, which would give
> that kind of error.  GeoTools/server needs the proper
> geometry_columns
> row to figure out what geometry to use.
>
> Chris
>
> >
> > Regards Jonas:)))
> >
> > --
> > Jonas F Henriksen
> > Institute of Marine Research
> > Norsk Marint Datasenter
> > PO Box 1870 Nordnes
> > 5817 Bergen
> > Norway
> >
> > Phone: +47 55238441
> >
> >
> > -------------------------------------------------------
> > SF.Net email is Sponsored by the Better Software Conference & EXPO
> > September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> > Practices
> > Agile & Plan-Driven Development * Managing Projects & Teams *
> Testing
> > & QA
> > Security * Process Improvement & Measurement *
> > http://www.sqe.com/bsce5sf
> > _______________________________________________
> > Geoserver-users mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>
>
>
>
> ----------------------------------------------------------
> This mail sent through IMP: https://webmail.limegroup.com/
>




----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Reply | Threaded
Open this post in threaded view
|

Re: error getting default geometry attribute: fixed

Jonas Henriksen
Hi,

managed to find the error by adding some more debug info from function:   
protected FeatureType buildSchema(String typeName, FIDMapper mapper)

in class JDBCDataStore. It turns out an sql-error was thrown from the postgis database, giving permission denied whe trying to alter/acces something in table spatial_ref_sys, which was owned by the postgres user. Changing the owner of this table to the tomcat user fixed the problem. I dont know why the problem occured in linux only and not in windows. Should this be filed as a bug?

regards, Jonas:))))



On 9/8/05, Henriksen, Jonas F <[hidden email]> wrote:
Hi,

still having the same problem. Have tried a few things:
WFS getfeature seems to work just fine, no errors here.
WMS  - This is where the trouble started. When calling the WMS getMap nothing is rendered, and in the catalina-log (logging level FINE) we get:

167705054 [FINE] org.vfny.geoserver.util.requests.readers.KvpRequestReader - clean request is bbox=0,60,60,85&styles=point&Format=image/png&request=GetMap&layers=rls:geom_test&width=550&height=250&srs=EPSG:4326
167705054 [FINE] org.vfny.geoserver.util.requests.readers.KvpRequestReader - returning parsed {SRS=EPSG:4326, LAYERS=rls:geom_test, BBOX=0,60,60,85, HEIGHT=250, REQUEST=GetMap, STYLES=point, WIDTH=550, FORMAT=image/png}
167705054 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service responses' strategy
167705055 [INFO] org.vfny.geoserver.servlets.AbstractService - Looking for configured service strategy SPEED
167705055 [FINE] org.vfny.geoserver.servlets.AbstractService - verifying configured strategy
167705055 [INFO] org.vfny.geoserver.servlets.AbstractService - Using service strategy class org.vfny.geoserver.servlets.SpeedStrategy
167705055 [FINE] org.vfny.geoserver.servlets.AbstractService - reading request: bbox=0,60,60,85&styles=point&Format=image/png&request=GetMap&layers=rls:geom_test&width=550&height=250&srs=EPSG:4326
167705056 [FINE] org.vfny.geoserver.global.Data - getting type rls:geom_test
167705056 [FINE] org.geotools.data.postgis.PostgisDataStore - get Feature source called on geom_test
167705056 [FINE] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking
167705057 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
167705057 [FINE] org.vfny.geoserver.wms.requests.GetMapKvpReader - establishing point style for rls:geom_test
167705057 [INFO] org.vfny.geoserver.servlets.AbstractService - handling request: org.vfny.geoserver.wms.requests.GetMapRequest@8845df8b
167705057 [FINE] org.vfny.geoserver.servlets.AbstractService - strategy is: org.vfny.geoserver.servlets.SpeedStrategy@4b929fb6
167705059 [FINE] DefaultFactory - Unavailable factory: European Petroleum Survey Group
167705061 [FINE] org.vfny.geoserver.wms.responses.GetMapResponse - setting up map
167705061 [FINE] org.geotools.data.postgis.PostgisDataStore - get Feature source called on geom_test
167705061 [FINE] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking
167705062 [FINE] org.vfny.geoserver.wms.responses.DefaultRasterMapProducer - setting up 550x250 image
167705062 [FINE] org.vfny.geoserver.wms.responses.DefaultRasterMapProducer - calling renderer
167705063 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Affine Transform is AffineTransform[[9.166666666666666, 0.0, - 0.0], [0.0, -10.0, 850.0]]
167705064 [FINE] org.geotools.styling.StyleImpl - number of fts set 1
167705065 [SEVERE] org.geotools.renderer.lite.LiteRenderer2$DefaultRenderListener - Error transforming bbox
167705065 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
167705065 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
167705066 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Got a tranform exception while trying to de-project the current envelope, falling back on full data loading (no bbox query)
167705066 [SEVERE] org.geotools.renderer.lite.LiteRenderer2$DefaultRenderListener - Exception rendering layer org.geotools.map.DefaultMapLayer@3db29fb6
167705066 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Style cache hit ratio: NaN , hits 0, requests 0
167705067 [FINE] org.vfny.geoserver.servlets.AbstractService - mime type is: image/png
167705078 [INFO] org.vfny.geoserver.servlets.AbstractService - Service handled

For some reason there is an error transforming the bounding-box.
When trying to generate the bounding-box in the web config interface we get the following entries in catalina.out:
168574409 [FINE] org.geotools.data.arcsde.ArcSDEDataStoreFactory - com.esri.sde.sdk.client.SeConnection is in place.
168574409 [FINE] org.geotools.data.arcsde.ArcSDEDataStoreFactory - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
168574412 [FINE] org.geotools.data.postgis.PostgisConnectionFactory - looking up pool key jdbc:<a href="postgresql://fluen.imr.no:5432/rlsrlsrls.123">postgresql://fluen.imr.no:5432/rlsrlsrls.123
168574413 [FINE] org.geotools.data.postgis.PostgisConnectionFactory - pool is org.postgresql.jdbc2.optional.ConnectionPool@414cdf89
168574413 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574414 [FINE] org.geotools.data.postgis.PostgisDataStore - version is 1.0 USE_GEOS=0 USE_PROJ=0 USE_STATS=1
168574415 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574415 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574423 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574423 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574431 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574431 [FINE] org.geotools.data.postgis.PostgisDataStore - geometry sql statement is SELECT type FROM GEOMETRY_COLUMNS WHERE f_table_name='geom_test' AND f_geometry_column='currentpoint';
168574433 [FINE] org.geotools.data.postgis.PostgisDataStore - geometry type is: POINT
168574433 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574435 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574435 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574436 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574437 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574437 [WARNING] org.geotools.data.jdbc.JDBCDataStore - Error building attribute type. The column will be ignored
168574438 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574438 [FINE] org.geotools.data.postgis.PostgisDataStore - get Feature source called on geom_test
168574439 [FINE] org.geotools.data.postgis.PostgisDataStore - returning pg feature locking
168574439 [FINE] org.vfny.geoserver.action.data.TypesEditorAction - calculating bbox for their dataset
168574439 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574439 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574440 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting available connection.
168574440 [FINE] org.geotools.data.jdbc.ConnectionPool$ConnectionListManager - Connection closed - adding to available connections.
168574440 [FINE] org.vfny.geoserver.action.data.TypesEditorAction - FeatureType 'geom_test' has a null bounding box


The table geom_test contains two rows of data:
OID     time (varchar)  name (varchar)  currentpoint (geometry)
2260377 "Mon 10:53:44"  "Johan Hjort"   "0101000020E6100000F15420A0E845414075A4CA1D23645240"
2260378 "Mon 10:53:57"  "G. O. Sars"    "0101000020E6100000AC90F2936ACD4140E381987140F85240"

and the geometry-columns-table contains:
2260373 "''"    "public"        "geom_test"     "currentpoint"  "2"     "4326"  "POINT" "2260368"       "3"     ""

As I said before, everything works fine on the windows-box that fetches data from the same database-server. The server running geoserver (version 1.3 RC2) is a linux red-hat enterprise, with IBM java 1.4.2 and tomcat 5.0.28.

Any help on this issue will be much appreciated,

thanks, regards Jonas:)))

--
Jonas F Henriksen
Institute of Marine Research
Norsk Marint Datasenter
PO Box 1870 Nordnes
5817 Bergen
Norway

Phone: +47 55238441



-----Opprinnelig melding-----
Fra: Chris Holmes [mailto:[hidden email]]
Sendt: 7. september 2005 14:20
Til: Henriksen, Jonas F
Kopi: [hidden email]
Emne: Re: SV: [Geoserver-users] error getting default geometry attribute


Quoting "Henriksen, Jonas F" <[hidden email]>:

> Hi Chris,
>
> Yes, I'm connecting to the same database, I've created my table like
> this:
>
> create table geom_test (
> time varchar,
> name varchar);
>
> SELECT AddGeometryColumn('geom_test', 'currentpoint', 4326, 'POINT',
> 2 );
>
> and everything looks fine in the geometry_columns-table, and as I
> said it works fine on the test-machine wich is windows,

Darn.  Was hoping this would be easy...

This is in the web admin tool that you're getting this?

How about you try just entering the values by hand - can use the ones
from your test server, or just put some random numbers in - it
shouldn't break anything.

See if it will add things then, and if it does, then do a GetFeature
request on your data.  See if things look right there, if it returns
data at all, if the data has geometries, ect.  It maybe could be some
permissions thing?  Are you connecting with a different user or
something?

But try things out with just entering a bounding box manually, see what
you get.

Chris

>
> regards Jonas:)))
>
>
> --
> Jonas F Henriksen
> Institute of Marine Research
> Norsk Marint Datasenter
> PO Box 1870 Nordnes
> 5817 Bergen
> Norway
>
> Phone: +47 55238441
>
>
> -----Opprinnelig melding-----
> Fra: Chris Holmes [mailto:[hidden email]]
> Sendt: 7. september 2005 13:40
> Til: Henriksen, Jonas F
> Kopi: [hidden email]
> Emne: Re: [Geoserver-users] error getting default geometry attribute
>

>
> Quoting "Henriksen, Jonas F" <[hidden email]>:
>
> > Hi,
> >
> > we are having a problem creating a featuretype with a postgis
> > datasource. We have a setup on windows using geoserver 1.3.0 RC1
> > where everythin works fine. However, on our server, which is linux
> > red hat enterprise and geoserver 1.3.0 RC2, we get the following
> > error when trying to generate the bounding box from the
> > postgis-datasource:
> > >The FeatureType 'positions' has a NULL extent.
> > >HINT: the dataset is empty or has no default geometry attribute.
> >
> > The setup of the datasource is exactly the same on the two
> machines,
> > and the connection to postgis works fine.
> >
> > Any suggestions on what's wrong?
> Are you using the exact same postgis database?  Like connecting to

> the
> same machine?  Or did you to a dump of the db and copy it over to the
> linux server?  If the latter than it may be that the
> 'geometry_columns'
> row for your positions featureType is not declared, which would give
> that kind of error.  GeoTools/server needs the proper
> geometry_columns
> row to figure out what geometry to use.
>
> Chris
>
> >
> > Regards Jonas:)))
> >
> > --
> > Jonas F Henriksen
> > Institute of Marine Research
> > Norsk Marint Datasenter
> > PO Box 1870 Nordnes
> > 5817 Bergen
> > Norway
> >
> > Phone: +47 55238441
> >
> >
> > -------------------------------------------------------
> > SF.Net email is Sponsored by the Better Software Conference & EXPO
> > September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> > Practices
> > Agile & Plan-Driven Development * Managing Projects & Teams *
> Testing
> > & QA
> > Security * Process Improvement & Measurement *
> > http://www.sqe.com/bsce5sf
> > _______________________________________________
> > Geoserver-users mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>
>
>
>
> ----------------------------------------------------------
> This mail sent through IMP: https://webmail.limegroup.com/
>




----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply | Threaded
Open this post in threaded view
|

Re: error getting default geometry attribute: fixed

Chris Holmes-2
Quoting Jonas Henriksen <[hidden email]>:

> Hi,
>
> managed to find the error by adding some more debug info from
> function:
> protected FeatureType buildSchema(String typeName, FIDMapper mapper)
>
> in class JDBCDataStore. It turns out an sql-error was thrown from the
> postgis database, giving permission denied whe trying to alter/acces
> something in table spatial_ref_sys, which was owned by the postgres
> user.
> Changing the owner of this table to the tomcat user fixed the
> problem. I
> dont know why the problem occured in linux only and not in windows.
> Should
> this be filed as a bug?
No, I don't think there's really much we can do in the code side of
things, if the user doesn't have access we can't over ride, afaik.

Instead of filing a bug can you make a note of it here:
http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore ?  Put it
under 'troubleshooting', and report the error that you got and how you
got it, and what the work around is.  That should be sufficient to help
future users with the same problem.

best regards,

Chris

>
> regards, Jonas:))))
>
>
>
> On 9/8/05, Henriksen, Jonas F <[hidden email]> wrote:
> >
> > Hi,
> >
> > still having the same problem. Have tried a few things:
> > WFS getfeature seems to work just fine, no errors here.
> > WMS - This is where the trouble started. When calling the WMS
> getMap
> > nothing is rendered, and in the catalina-log (logging level FINE)
> we get:
> >
> > 167705054 [FINE]
> org.vfny.geoserver.util.requests.readers.KvpRequestReader- clean
> request is
> >
>
bbox=0,60,60,85&styles=point&Format=image/png&request=GetMap&layers=rls:geom_test&width=550&height=250&srs=EPSG:4326

> > 167705054 [FINE]
> org.vfny.geoserver.util.requests.readers.KvpRequestReader- returning
> parsed {SRS=EPSG:4326, LAYERS=rls:geom_test, BBOX=0,60,60,85,
> > HEIGHT=250, REQUEST=GetMap, STYLES=point, WIDTH=550,
> FORMAT=image/png}
> > 167705054 [INFO] org.vfny.geoserver.servlets.AbstractService -
> Looking for
> > configured service responses' strategy
> > 167705055 [INFO] org.vfny.geoserver.servlets.AbstractService -
> Looking for
> > configured service strategy SPEED
> > 167705055 [FINE] org.vfny.geoserver.servlets.AbstractService -
> verifying
> > configured strategy
> > 167705055 [INFO] org.vfny.geoserver.servlets.AbstractService -
> Using
> > service strategy class org.vfny.geoserver.servlets.SpeedStrategy
> > 167705055 [FINE] org.vfny.geoserver.servlets.AbstractService -
> reading
> > request:
> >
>
bbox=0,60,60,85&styles=point&Format=image/png&request=GetMap&layers=rls:geom_test&width=550&height=250&srs=EPSG:4326

> > 167705056 [FINE] org.vfny.geoserver.global.Data - getting type
> > rls:geom_test
> > 167705056 [FINE] org.geotools.data.postgis.PostgisDataStore - get
> Feature
> > source called on geom_test
> > 167705056 [FINE] org.geotools.data.postgis.PostgisDataStore -
> returning pg
> > feature locking
> > 167705057 [FINE] org.geotools.styling.StyleImpl - number of fts set
> 1
> > 167705057 [FINE] org.vfny.geoserver.wms.requests.GetMapKvpReader -
> > establishing point style for rls:geom_test
> > 167705057 [INFO] org.vfny.geoserver.servlets.AbstractService -
> handling
> > request: org.vfny.geoserver.wms.requests.GetMapRequest@8845df8b
> > 167705057 [FINE] org.vfny.geoserver.servlets.AbstractService -
> strategy
> > is: org.vfny.geoserver.servlets.SpeedStrategy@4b929fb6
> > 167705059 [FINE] DefaultFactory - Unavailable factory: European
> Petroleum
> > Survey Group
> > 167705061 [FINE] org.vfny.geoserver.wms.responses.GetMapResponse -
> setting
> > up map
> > 167705061 [FINE] org.geotools.data.postgis.PostgisDataStore - get
> Feature
> > source called on geom_test
> > 167705061 [FINE] org.geotools.data.postgis.PostgisDataStore -
> returning pg
> > feature locking
> > 167705062 [FINE]
> org.vfny.geoserver.wms.responses.DefaultRasterMapProducer- setting up
> 550x250 image
> > 167705062 [FINE]
> org.vfny.geoserver.wms.responses.DefaultRasterMapProducer- calling
> renderer
> > 167705063 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Affine
> > Transform is AffineTransform[[9.166666666666666, 0.0, -0.0], [0.0,
> -10.0,
> > 850.0]]
> > 167705064 [FINE] org.geotools.styling.StyleImpl - number of fts set
> 1
> > 167705065 [SEVERE]
> > org.geotools.renderer.lite.LiteRenderer2$DefaultRenderListener -
> Error
> > transforming bbox
> > 167705065 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 167705065 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 167705066 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Got a
> tranform
> > exception while trying to de-project the current envelope, falling
> back on
> > full data loading (no bbox query)
> > 167705066 [SEVERE]
> > org.geotools.renderer.lite.LiteRenderer2$DefaultRenderListener -
> Exception
> > rendering layer org.geotools.map.DefaultMapLayer@3db29fb6
> > 167705066 [FINE] org.geotools.renderer.lite.LiteRenderer2 - Style
> cache
> > hit ratio: NaN , hits 0, requests 0
> > 167705067 [FINE] org.vfny.geoserver.servlets.AbstractService - mime
> type
> > is: image/png
> > 167705078 [INFO] org.vfny.geoserver.servlets.AbstractService -
> Service
> > handled
> >
> > For some reason there is an error transforming the bounding-box.
> > When trying to generate the bounding-box in the web config
> interface we
> > get the following entries in catalina.out:
> > 168574409 [FINE] org.geotools.data.arcsde.ArcSDEDataStoreFactory -
> > com.esri.sde.sdk.client.SeConnection is in place.
> > 168574409 [FINE] org.geotools.data.arcsde.ArcSDEDataStoreFactory -
> > com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
> > 168574412 [FINE] org.geotools.data.postgis.PostgisConnectionFactory
> -
> > looking up pool key
> jdbc:postgresql://fluen.imr.no:5432/rlsrlsrls.123
> > 168574413 [FINE] org.geotools.data.postgis.PostgisConnectionFactory
> - pool
> > is org.postgresql.jdbc2.optional.ConnectionPool@414cdf89
> > 168574413 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574414 [FINE] org.geotools.data.postgis.PostgisDataStore -
> version is
> > 1.0 USE_GEOS=0 USE_PROJ=0 USE_STATS=1
> > 168574415 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574415 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574423 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574423 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574431 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574431 [FINE] org.geotools.data.postgis.PostgisDataStore -
> geometry sql
> > statement is SELECT type FROM GEOMETRY_COLUMNS WHERE
> > f_table_name='geom_test' AND f_geometry_column='currentpoint';
> > 168574433 [FINE] org.geotools.data.postgis.PostgisDataStore -
> geometry
> > type is: POINT
> > 168574433 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574435 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574435 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574436 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574437 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574437 [WARNING] org.geotools.data.jdbc.JDBCDataStore - Error
> building
> > attribute type. The column will be ignored
> > 168574438 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574438 [FINE] org.geotools.data.postgis.PostgisDataStore - get
> Feature
> > source called on geom_test
> > 168574439 [FINE] org.geotools.data.postgis.PostgisDataStore -
> returning pg
> > feature locking
> > 168574439 [FINE] org.vfny.geoserver.action.data.TypesEditorAction -
> > calculating bbox for their dataset
> > 168574439 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574439 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574440 [FINE] org.geotools.data.jdbc.ConnectionPool - Getting
> available
> > connection.
> > 168574440 [FINE]
> > org.geotools.data.jdbc.ConnectionPool$ConnectionListManager -
> Connection
> > closed - adding to available connections.
> > 168574440 [FINE] org.vfny.geoserver.action.data.TypesEditorAction -
> > FeatureType 'geom_test' has a null bounding box
> >
> >
> > The table geom_test contains two rows of data:
> > OID time (varchar) name (varchar) currentpoint (geometry)
> > 2260377 "Mon 10:53:44" "Johan Hjort"
> > "0101000020E6100000F15420A0E845414075A4CA1D23645240"
> > 2260378 "Mon 10:53:57" "G. O. Sars"
> > "0101000020E6100000AC90F2936ACD4140E381987140F85240"
> >
> > and the geometry-columns-table contains:
> > 2260373 "''" "public" "geom_test" "currentpoint" "2" "4326" "POINT"
> > "2260368" "3" ""
> >
> > As I said before, everything works fine on the windows-box that
> fetches
> > data from the same database-server. The server running geoserver
> (version
> > 1.3 RC2) is a linux red-hat enterprise, with IBM java 1.4.2 and
> tomcat
> > 5.0.28.
> >
> > Any help on this issue will be much appreciated,
> >
> > thanks, regards Jonas:)))
> >
> > --
> > Jonas F Henriksen
> > Institute of Marine Research
> > Norsk Marint Datasenter
> > PO Box 1870 Nordnes
> > 5817 Bergen
> > Norway
> >
> > Phone: +47 55238441
> >
> >
> >
> > -----Opprinnelig melding-----
> > Fra: Chris Holmes [mailto:[hidden email]]
> > Sendt: 7. september 2005 14:20
> > Til: Henriksen, Jonas F
> > Kopi: [hidden email]
> > Emne: Re: SV: [Geoserver-users] error getting default geometry
> attribute
> >
> >
> > Quoting "Henriksen, Jonas F" <[hidden email]>:
> >
> > > Hi Chris,
> > >
> > > Yes, I'm connecting to the same database, I've created my table
> like
> > > this:
> > >
> > > create table geom_test (
> > > time varchar,
> > > name varchar);
> > >
> > > SELECT AddGeometryColumn('geom_test', 'currentpoint', 4326,
> 'POINT',
> > > 2 );
> > >
> > > and everything looks fine in the geometry_columns-table, and as I
> > > said it works fine on the test-machine wich is windows,
> >
> > Darn. Was hoping this would be easy...
> >
> > This is in the web admin tool that you're getting this?
> >
> > How about you try just entering the values by hand - can use the
> ones
> > from your test server, or just put some random numbers in - it
> > shouldn't break anything.
> >
> > See if it will add things then, and if it does, then do a
> GetFeature
> > request on your data. See if things look right there, if it returns
> > data at all, if the data has geometries, ect. It maybe could be
> some
> > permissions thing? Are you connecting with a different user or
> > something?
> >
> > But try things out with just entering a bounding box manually, see
> what
> > you get.
> >
> > Chris
> >
> > >
> > > regards Jonas:)))
> > >
> > >
> > > --
> > > Jonas F Henriksen
> > > Institute of Marine Research
> > > Norsk Marint Datasenter
> > > PO Box 1870 Nordnes
> > > 5817 Bergen
> > > Norway
> > >
> > > Phone: +47 55238441
> > >
> > >
> > > -----Opprinnelig melding-----
> > > Fra: Chris Holmes [mailto:[hidden email]]
> > > Sendt: 7. september 2005 13:40
> > > Til: Henriksen, Jonas F
> > > Kopi: [hidden email]
> > > Emne: Re: [Geoserver-users] error getting default geometry
> attribute
> > >
> > >
> > > Quoting "Henriksen, Jonas F" <[hidden email]>:
> > >
> > > > Hi,
> > > >
> > > > we are having a problem creating a featuretype with a postgis
> > > > datasource. We have a setup on windows using geoserver 1.3.0
> RC1
> > > > where everythin works fine. However, on our server, which is
> linux
> > > > red hat enterprise and geoserver 1.3.0 RC2, we get the
> following
> > > > error when trying to generate the bounding box from the
> > > > postgis-datasource:
> > > > >The FeatureType 'positions' has a NULL extent.
> > > > >HINT: the dataset is empty or has no default geometry
> attribute.
> > > >
> > > > The setup of the datasource is exactly the same on the two
> > > machines,
> > > > and the connection to postgis works fine.
> > > >
> > > > Any suggestions on what's wrong?
> > > Are you using the exact same postgis database? Like connecting to
> > > the
> > > same machine? Or did you to a dump of the db and copy it over to
> the
> > > linux server? If the latter than it may be that the
> > > 'geometry_columns'
> > > row for your positions featureType is not declared, which would
> give
> > > that kind of error. GeoTools/server needs the proper
> > > geometry_columns
> > > row to figure out what geometry to use.
> > >
> > > Chris
> > >
> > > >
> > > > Regards Jonas:)))
> > > >
> > > > --
> > > > Jonas F Henriksen
> > > > Institute of Marine Research
> > > > Norsk Marint Datasenter
> > > > PO Box 1870 Nordnes
> > > > 5817 Bergen
> > > > Norway
> > > >
> > > > Phone: +47 55238441
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > SF.Net email is Sponsored by the Better Software Conference &
> EXPO
> > > > September 19-22, 2005 * San Francisco, CA * Development
> Lifecycle
> > > > Practices
> > > > Agile & Plan-Driven Development * Managing Projects & Teams *
> > > Testing
> > > > & QA
> > > > Security * Process Improvement & Measurement *
> > > > http://www.sqe.com/bsce5sf
> > > > _______________________________________________
> > > > Geoserver-users mailing list
> > > > [hidden email]
> > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > > >
> > >
> > >
> > >
> > >
> > > ----------------------------------------------------------
> > > This mail sent through IMP: https://webmail.limegroup.com/
> > >
> >
> >
> >
> >
> > ----------------------------------------------------------
> > This mail sent through IMP: https://webmail.limegroup.com/
> >
> >
> > -------------------------------------------------------
> > SF.Net email is Sponsored by the Better Software Conference & EXPO
> > September 19-22, 2005 * San Francisco, CA * Development Lifecycle
> > Practices
> > Agile & Plan-Driven Development * Managing Projects & Teams *
> Testing & QA
> > Security * Process Improvement & Measurement *
> http://www.sqe.com/bsce5sf
> > _______________________________________________
> > Geoserver-users mailing list
> > [hidden email]
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>




----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Geoserver-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geoserver-users