Hi Ash, the line of code the command is failing does: connection.getRasterColumns(); where connection is an SeConnection. I've no idea why the SeConnection (from the ESRI jsde_sdk.jar library) could fail like that on that method call. The network I/O operation failed error doesn't say much neither other than that _some_ network problem might be happening.
Assuming nothing in your environment changed other than the geoserver/arcsde plugin version and it worked fine for you on 2.0.1, what I can tell is that the geotools arcsde plugin at version 2.6.1 (the one used by geoserver 2.0.1) does not call connection.getRasterColumns() and hence it listed arcsde rasters as vector layers (since they're essentially that too with a vector polygon for the raster's bounding box, not sure why). In a later version that call was introduced in order to filter out the raster tables so that they don't show up as (vector) feature types. But it is the first time I hear of that failing. As it is so hard (almost impossible) to debug errors happening inside the ESRI ArcSDE Java API, I could suggest you that if you have access to the arcsde 9.3 jars you try with those inside geoserver's WEB-INF/lib (in some cases it solved a couple problems for me, despite ESRI's recommendation is for the jar and arcsde server versions to match exactly, including service packs). But yeah, you could either try that or make sure you have the latest service pack applied for your arcsde server 9.2 and also the latest arcsde 9.2 jars (might come with the service pack). Let me know if some of that solves the problem. Cheers, Gabriel On Wed, 2011-01-19 at 08:40 +1100, Ash Comer wrote: > Hey Gabriel, > > It doesn't look like the system accepts attachments. Below is the full stack > trace with the logging level set to geotools_developer. > > Hope this helps. > > Ash. > > > 18 Jan 16:26:40 INFO [org.geoserver] - Loaded data store 'gisvptst' > 18 Jan 16:26:42 ERROR [org.geotools.arcsde.data] - Updating TypeNameCache > failed. > org.geotools.arcsde.ArcSdeException: [SDE error -10 Error getting raster > layers][Error desc=NETWORK I/O OPERATION FAILED.][Extended desc=Error getting > raster layers > ] > at org.geotools.arcsde.session.Session.issue(Session.java:185) > at > org.geotools.arcsde.session.Session.getRasterColumns(Session.java:303) > at > org.geotools.arcsde.data.FeatureTypeInfoCache$FetchRegistrationsCommand.execute(FeatureTypeInfoCache.java:383) > at > org.geotools.arcsde.data.FeatureTypeInfoCache$FetchRegistrationsCommand.execute(FeatureTypeInfoCache.java:359) > at org.geotools.arcsde.session.Session.issue(Session.java:182) > at > org.geotools.arcsde.data.FeatureTypeInfoCache$CacheUpdater.fetchRegistrations(FeatureTypeInfoCache.java:351) > at > org.geotools.arcsde.data.FeatureTypeInfoCache$CacheUpdater.run(FeatureTypeInfoCache.java:305) > at > org.geotools.arcsde.data.FeatureTypeInfoCache.reset(FeatureTypeInfoCache.java:155) > at > org.geotools.arcsde.data.FeatureTypeInfoCache.<init>(FeatureTypeInfoCache.java:147) > at > org.geotools.arcsde.data.ArcSDEDataStore.<init>(ArcSDEDataStore.java:153) > at > org.geotools.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:322) > at > org.geotools.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:266) > at > org.geotools.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:255) > at > org.geotools.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:73) > at > org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:107) > at > org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:343) > at > org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37) > at > org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:353) > at > org.geoserver.config.GeoServerLoader.readCatalog(GeoServerLoader.java:220) > at > org.geoserver.config.DefaultGeoServerLoader.loadCatalog(DefaultGeoServerLoader.java:37) > at > org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(GeoServerLoader.java:116) > at > org.geoserver.config.GeoServerLoaderProxy.postProcessBeforeInitialization(GeoServerLoaderProxy.java:54) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCa > pableBeanFactory.java:350) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1330) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) > at java.security.AccessController.doPrivileged(Native Method) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) > at > org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) > at > org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) > at > org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495) > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:92 > 5) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835 > ) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) > at java.security.AccessController.doPrivileged(Native Method) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) > at > org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) > at > org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729) > at > org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381) > at > org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) > at > org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) > at > org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) > at > org.geoserver.platform.GeoServerContextLoaderListener.contextInitialized(GeoServerContextLoaderListener.java:18) > at > org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:540) > at org.mortbay.jetty.servlet.Context.startContext(Context.java:135) > at > org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1220) > at > org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:510) > at > org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:448) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) > at > org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152) > at > org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) > at > org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) > at > org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130) > at org.mortbay.jetty.Server.doStart(Server.java:222) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:39) > at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:977) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.mortbay.start.Main.invokeMain(Main.java:183) > at org.mortbay.start.Main.start(Main.java:497) > at org.mortbay.start.Main.main(Main.java:115) > Caused by: com.esri.sde.sdk.client.SeException: Error getting raster layers > at com.esri.sde.sdk.client.SeConnection.a(Unknown Source) > at com.esri.sde.sdk.client.SeConnection.getRasterColumns(Unknown > Source) > at org.geotools.arcsde.session.Commands$3.execute(Commands.java:385) > at org.geotools.arcsde.session.Commands$3.execute(Commands.java:382) > at org.geotools.arcsde.session.Session.issue(Session.java:182) > ... 76 more > > -----Original Message----- > From: Gabriel Roldan [mailto:[email protected]] On Behalf Of Gabriel > Roldán > Sent: Wednesday, 12 January 2011 11:57 AM > To: Ash Comer > Cc: [email protected] > Subject: Re: [Geoserver-users] Connecting to ArcSDE in versions 2.0.2 > > That is odd. Can you set the logging level to geotools_developer and > send back the full stack trace? > > Cheers, > Gabriel > On Thu, 2011-01-06 at 07:59 +1100, Ash Comer wrote: > > > > > > Hi, > > > > We have been using Geoserver version 2.0.1 with connections to ArcSDE > > 9.2 successfully, however we are having issues connecting to ArcSDE > > with geoserver version 2.0.2 and 2.1.x > > > > The log file is reporting: > > > > 2011-01-04 14:28:08,632 ERROR [arcsde.data] - Updating TypeNameCache > > failed. > > org.geotools.arcsde.ArcSdeException: [SDE error -10 Error getting > > raster layers][Error desc=NETWORK I/O OPERATION FAILED.][Extended > > desc=Error getting raster layers] > > > > > > We are running ArcSDE version 9.2 on Oracle 10g. > > > > Has anybody else experienced the same problems or have I missed > > something obvious? > > > > Thanks. > > > > Regards, > > > > Ash C > > > > This email is intended solely for the named addressee. > > If you are not the addressee indicated please delete it immediately. > > ------------------------------------------------------------------------------ > > Gaining the trust of online customers is vital for the success of any > > company > > that requires sensitive data to be transmitted over the Web. Learn how to > > best implement a security strategy that keeps consumers' information secure > > and instills the confidence they need to proceed with transactions. > > http://p.sf.net/sfu/oracle-sfdevnl > > _______________________________________________ Geoserver-users mailing > > list [email protected] > > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Gabriel Roldan [email protected] Expert service straight from the developers ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
