[Geoserver-users] Can not add ArcSDE Raster Format Coverage Store

Gregory_Rabenold · November 12, 2008, 2:10pm

When trying to create a coverage store for an ArcSDE raster I get the
following exception:

GeoServer - Exception
The following exception was thrown:
    * class org.vfny.geoserver.global.ConfigurationException: Could not
obtain a reader for the CoverageDataSet. Please check the CoverageDataSet
configuration!
Details:
org.vfny.geoserver.global.ConfigurationException: Could not obtain a reader
for the CoverageDataSet. Please check the CoverageDataSet configuration!
  at
org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:111)
  at
org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
  at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
  at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
  at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
  at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

I also see the following in the GeoServer log file:

2008-11-12 08:25:43,647 ERROR [arcsde.gce] - Unable to creata
ArcSDERasterReader for sde:/mapdata:mapdata@anonymised.com:5151/#MAPDATA.N46.
org.geotools.data.DataSourceException: Error fetching raster connection data
from MAPDATA.N46: THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD.
        at
org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.setupConnectionPool(ArcSDERasterGridCoverage2DReader.java:695)
        at
org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.<init>(ArcSDERasterGridCoverage2DReader.java:168)
        at
org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.java:85)
        at
org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.java:79)
        at
org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:107)
        at
org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)

I am using GeoServer 1.7.0 and ArcSDE 9.3

--
View this message in context: http://www.nabble.com/Can-not-add-ArcSDE-Raster-Format-Coverage-Store-tp20461034p20461034.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Alain_Camus · January 9, 2009, 9:40am

Same error as grabenold below.

I'm using geoserver 1.7.1, Tomcat 6.0.18, ArcSDE 9.2.0.11 (SP6).

When I try to create a coveragestore for an ArcSDE raster using
sde://umn_Mapserver:******@ora-SDE:5161/#ITGI_ADM.RD_TOP50R
I get the error message "THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD"
(taken from the geoserver log).

I'm monitoring the ArcSDE connections, and I see that 2 connections come
alive at the same time. If I stop geoserver, they remain alive.

Creating a datastore on ora-SDE, port 5161, no instance, user and pass same
as for the coveragestore works fine. I can even create a featureType on
another (vector) table using this datastore.

After creating this featureType, 4 ArcSDE connections are alive.

New trial for the ArcSDE coveragestore, same error message, 6 connections
are alive.

I shutdown geoserver and halt the machine on which it's running, the 2
connections coming from the datastore disappear, but the 4 from the
coveragestores remain alive.

Any idea how I could get this coveragestore working ? And how I can kill
those zombie connections from geoserver ?

Any help appreciated,

Alain

grabenold wrote:

When trying to create a coverage store for an ArcSDE raster I get the
following exception:

GeoServer - Exception
The following exception was thrown:
    * class org.vfny.geoserver.global.ConfigurationException: Could not
obtain a reader for the CoverageDataSet. Please check the CoverageDataSet
configuration!
Details:
org.vfny.geoserver.global.ConfigurationException: Could not obtain a
reader for the CoverageDataSet. Please check the CoverageDataSet
configuration!
  at
org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:111)
  at
org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
  at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
  at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
  at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
  at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

I also see the following in the GeoServer log file:

2008-11-12 08:25:43,647 ERROR [arcsde.gce] - Unable to creata
ArcSDERasterReader for sde:/mapdata:mapdata@anonymised.com:5151/#MAPDATA.N46.
org.geotools.data.DataSourceException: Error fetching raster connection
data from MAPDATA.N46: THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD.
        at
org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.setupConnectionPool(ArcSDERasterGridCoverage2DReader.java:695)
        at
org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.<init>(ArcSDERasterGridCoverage2DReader.java:168)
        at
org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.java:85)
        at
org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.java:79)
        at
org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:107)
        at
org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)

I am using GeoServer 1.7.0 and ArcSDE 9.3

--
View this message in context: http://www.nabble.com/Can-not-add-ArcSDE-Raster-Format-Coverage-Store-tp20461034p21369074.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Alain_Camus · January 14, 2009, 1:22pm

Bug reported on : http://jira.codehaus.org/browse/GEOS-2570
http://jira.codehaus.org/browse/GEOS-2570

Alain

acangi wrote:

Same error as grabenold below.

I'm using geoserver 1.7.1, Tomcat 6.0.18, ArcSDE 9.2.0.11 (SP6).

When I try to create a coveragestore for an ArcSDE raster using
sde://umn_Mapserver:******@ora-SDE:5161/#ITGI_ADM.RD_TOP50R
I get the error message "THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD"
(taken from the geoserver log).

I'm monitoring the ArcSDE connections, and I see that 2 connections come
alive at the same time. If I stop geoserver, they remain alive.

Creating a datastore on ora-SDE, port 5161, no instance, user and pass
same as for the coveragestore works fine. I can even create a featureType
on another (vector) table using this datastore.

After creating this featureType, 4 ArcSDE connections are alive.

New trial for the ArcSDE coveragestore, same error message, 6 connections
are alive.

I shutdown geoserver and halt the machine on which it's running, the 2
connections coming from the datastore disappear, but the 4 from the
coveragestores remain alive.

Any idea how I could get this coveragestore working ? And how I can kill
those zombie connections from geoserver ?

Any help appreciated,

Alain

grabenold wrote:

When trying to create a coverage store for an ArcSDE raster I get the
following exception:

GeoServer - Exception
The following exception was thrown:
    * class org.vfny.geoserver.global.ConfigurationException: Could not
obtain a reader for the CoverageDataSet. Please check the CoverageDataSet
configuration!
Details:
org.vfny.geoserver.global.ConfigurationException: Could not obtain a
reader for the CoverageDataSet. Please check the CoverageDataSet
configuration!
  at
org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:111)
  at
org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)
  at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
  at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
  at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
  at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
  at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

I also see the following in the GeoServer log file:

2008-11-12 08:25:43,647 ERROR [arcsde.gce] - Unable to creata
ArcSDERasterReader for sde:/mapdata:mapdata@anonymised.com:5151/#MAPDATA.N46.
org.geotools.data.DataSourceException: Error fetching raster connection
data from MAPDATA.N46: THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD.
        at
org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.setupConnectionPool(ArcSDERasterGridCoverage2DReader.java:695)
        at
org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.<init>(ArcSDERasterGridCoverage2DReader.java:168)
        at
org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.java:85)
        at
org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.java:79)
        at
org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(DataCoveragesNewAction.java:107)
        at
org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(CoverageStoresEditorAction.java:90)

I am using GeoServer 1.7.0 and ArcSDE 9.3

--
View this message in context: http://www.nabble.com/Can-not-add-ArcSDE-Raster-Format-Coverage-Store-tp20461034p21455824.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Gabriel_Roldan2 · January 14, 2009, 3:51pm

Hi,
closed the issue since I just fixed that in the last few days.

Gabriel

On Wednesday 14 January 2009 11:22:39 acangi wrote:

Bug reported on : http://jira.codehaus.org/browse/GEOS-2570
http://jira.codehaus.org/browse/GEOS-2570

Alain

acangi wrote:
> Same error as grabenold below.
>
> I'm using geoserver 1.7.1, Tomcat 6.0.18, ArcSDE 9.2.0.11 (SP6).
>
> When I try to create a coveragestore for an ArcSDE raster using
> sde://umn_Mapserver:******@ora-SDE:5161/#ITGI_ADM.RD_TOP50R
> I get the error message "THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD"
> (taken from the geoserver log).
>
> I'm monitoring the ArcSDE connections, and I see that 2 connections come
> alive at the same time. If I stop geoserver, they remain alive.
>
> Creating a datastore on ora-SDE, port 5161, no instance, user and pass
> same as for the coveragestore works fine. I can even create a featureType
> on another (vector) table using this datastore.
>
> After creating this featureType, 4 ArcSDE connections are alive.
>
> New trial for the ArcSDE coveragestore, same error message, 6 connections
> are alive.
>
> I shutdown geoserver and halt the machine on which it's running, the 2
> connections coming from the datastore disappear, but the 4 from the
> coveragestores remain alive.
>
> Any idea how I could get this coveragestore working ? And how I can kill
> those zombie connections from geoserver ?
>
> Any help appreciated,
>
> Alain
>
> grabenold wrote:
>> When trying to create a coverage store for an ArcSDE raster I get the
>> following exception:
>>
>> GeoServer - Exception
>> The following exception was thrown:
>> * class org.vfny.geoserver.global.ConfigurationException: Could not
>> obtain a reader for the CoverageDataSet. Please check the
>> CoverageDataSet configuration!
>> Details:
>> org.vfny.geoserver.global.ConfigurationException: Could not obtain a
>> reader for the CoverageDataSet. Please check the CoverageDataSet
>> configuration!
>> at
>> org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(
>>DataCoveragesNewAction.java:111) at
>> org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(Covera
>>geStoresEditorAction.java:90) at
>> org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101) at
>> org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
>>ocessor.java:431) at
>> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
>>236) at
>> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
>> at
>> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
>>
>>
>> I also see the following in the GeoServer log file:
>>
>> 2008-11-12 08:25:43,647 ERROR [arcsde.gce] - Unable to creata
>> ArcSDERasterReader for sde:/mapdata:mapdata@anonymised.com:5151/#MAPDATA.N46.
>> org.geotools.data.DataSourceException: Error fetching raster connection
>> data from MAPDATA.N46: THIS CONNECTION IS LOCKED TO A DIFFERENT THREAD.
>> at
>> org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.setupConnection
>>Pool(ArcSDERasterGridCoverage2DReader.java:695) at
>> org.geotools.arcsde.gce.ArcSDERasterGridCoverage2DReader.<init>(ArcSDERa
>>sterGridCoverage2DReader.java:168) at
>> org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.
>>java:85) at
>> org.geotools.arcsde.gce.ArcSDERasterFormat.getReader(ArcSDERasterFormat.
>>java:79) at
>> org.vfny.geoserver.action.data.DataCoveragesNewAction.newCoverageConfig(
>>DataCoveragesNewAction.java:107) at
>> org.vfny.geoserver.action.data.CoverageStoresEditorAction.execute(Covera
>>geStoresEditorAction.java:90)
>>
>>
>>
>> I am using GeoServer 1.7.0 and ArcSDE 9.3