[Geoserver-users] Geoserver and ArcSDE connection issues

Bruce.Bannerman@anonymised.com wrote:

IMO

Cameron,

Can you please forward this to the GeoServer-Users list for me please?

<snip>

Hi Albrecht,

Thank you for responding.

The ArcSDE instance is running fine from an ESRI point of view and has passed all of its functional tests that we have thrown at it.

It only has a couple of users (being a test instance), so the number of connections is not an issue.

Connects from ESRI clients to the designated port also works without problem.

When I attempted again with GeoServer, I was able to repeat the problem.

In checking the ArcSDE error log, I found:

[Wed Aug 20 10:35:06 2008] [0] [GIOMGR] Could Not Get XDR Request.

In checking ESRI help doco, this message is defined as:

In the message, "Could Not Get XDR Request" was returned because the giomgr was not able to accept or understand the connection request because the length was invalid.

Does this shed any light on the problem?

I still think that the GeoServer log gives a better indication of what the the problem may be:

2008-08-20 10:34:48,239 DEBUG [arcsde.pool] - populating ArcSDE connection pool
2008-08-20 10:34:48,248 INFO [arcsde.pool] - Created ArcSDE connection pool for org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde, server=<server>, port=<port>, instance=null, user=viewer, password=*****, minConnections=2, maxConnections=6, connTimeOut=500]
2008-08-20 10:34:48,351 WARN [arcsde.pool] - can't connect to org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde, server=<server>, port=<port>, instance=null, user=viewer, password=*****, minConnections=2, maxConnections=6, connTimeOut=500]
org.geotools.arcsde.ArcSdeException: [SDE error -1 Unknown Host - EDA058810: EDA058810][Error desc=GENERAL FAILURE OCCURRED.][Extended desc=Unknown Host - EDA058810: EDA058810
]
        at org.geotools.arcsde.pool.ArcSDEConnectionPool$SeConnectionFactory.makeObject(ArcSDEConnectionPool.java:372)

        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)

Could this be a licensing issue?

Bruce Bannerman

*<Albrecht.Weiser@anonymised.com>*
Sent by: geoserver-users-bounces@lists.sourceforge.net

19/08/08 05:12 PM

To
  <bruce@anonymised.com>
cc
  geoserver-users@lists.sourceforge.net
Subject
  Re: [Geoserver-users] Geoserver-users Digest, Vol 27, Issue 33

Hi Bruce,
this problem may be at ArcSDE side. Did you check if the maximum number of connections is reached? Did you try to reach the server where ArcSDE instance is running on with a ping? If that works, try with a telnet connection. What does the SDE log say? Did the connection trial reach the ArcSDE instance?
Kind regards
Albrecht

Albrecht Weiser,
E6, GIS Center

Hessische Zentrale für Datenverarbeitung (HZD)
Mainzer Straße 29, 65185 Wiesbaden
Tel.: 0611 340-3113
Fax: 0611 340-5113
E-Mail: albrecht.weiser@anonymised.com

> ------------------------------
>
> Message: 2
> Date: Thu, 14 Aug 2008 20:06:08 +1000
> From: Bruce Bannerman <bruce@anonymised.com>
> Subject: [Geoserver-users] [Fwd: GeoServer 1.6.4 and ArcSDE 9.2 SP6]
> To: geoserver-users@lists.sourceforge.net
> Message-ID: <1218708368.6533.7.camel@anonymised.com>
> Content-Type: text/plain; charset="us-ascii"
>
> I'm not sure if this got through to the list. Apologies if it did.
>
> I got a bounce back from my mail server at work.
>
> Bruce
>
> -------- Forwarded Message --------
> From: Bruce.Bannerman@anonymised.com
> To: geoserver-users@lists.sourceforge.net
> Cc: bruce@anonymised.com
> Subject: GeoServer 1.6.4 and ArcSDE 9.2 SP6
> Date: Thu, 14 Aug 2008 16:15:20 +1000
>
> Hello GeoServer Users,
>
> Well, I've finally stolen some time to play... sorry.... seriously
> evaluate, GeoServer :wink:
>
> I have a problem getting ArcSDE connectivity with GeoServer. Hopefully
> someone can point me in the right direction?
>
> I have a working installation of GeoServer 1.6.4, downloaded from
> geoserver.org.
>
> It is running under Ubuntu 8.04, Apache 2.2, Tomcat 5.5, Sun
> Java 1.6.
>
> I'm trying to set up a connection to our test ArcSDE 9.2 SP6
> (on Oracle)
> instance. This is set up as an ArcSDE application server.
>
> I have copied the following files into
> my /var/lib/tomcat5.5/webapps/geoserver/WEB-INF/lib directory:
>
> gt2-arcsde-2.4.3.jar - from geoserver.org
>
> Plus the following .jar files from my ArcSDE 9.2 SP6 sdk install:
>
> concurrent.jar
> icu4j_3_2.jar
> jpe92_sdk.jar
> jsde92_sdk.jar
>
> When I attempt to define a Datastore in GeoServer referencing
> a Feature
> Class in ArcSDE, I get the following error message when I attempt to
> define the ArcSDE connection parameters in the 'Feature Data Set
> Editor'.
>
> 'Connection Parameters are invalid'.
>
> The connection parameters that I'm using ARE valid.
>
> When I check the geoserver logfile I find the following error
> message:
>
> ==============================================================
> ========
> 2008-08-14 14:06:38,305 DEBUG [arcsde.pool] - No database name
> specified
> 2008-08-14 14:06:38,305 DEBUG [arcsde.pool] - No database name
> specified
> 2008-08-14 14:06:38,305 DEBUG [arcsde.pool] - populating ArcSDE
> connection pool
> 2008-08-14 14:06:38,306 INFO [arcsde.pool] - Created ArcSDE connection
> pool for
> org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde,
> server=<name>, port=60100, instance=null, user=<user>, password=*****,
> minConnections=2, maxConnections=6, connTimeOut=500]
> 2008-08-14 14:06:38,312 WARN [arcsde.pool] - can't connect to
> org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde,
> server=<name>, port=60100, instance=null, user=<user>, password=*****,
> minConnections=2, maxConnections=6, connTimeOut=500]
> org.geotools.arcsde.ArcSdeException: [SDE error -1 Unknown Host -
> EDA058810: EDA058810][Error desc=GENERAL FAILURE OCCURRED.][Extended
> desc=Unknown Host - EDA058810: EDA058810
> ]
> ==============================================================
> ========
>
> The 'No database name' is correct with an ArcSDE instance
> configured on
> Oracle. You don't use the database name.
>
> The 'unknown host' that is being referred to here is the PC
> that I have
> GeoServer installed on. This PC does not have ArcSDE installed.
>
> The server refered to has a valid ArcSDE license.
>
> The non-standard port number has not been a problem in the
> past in other
> environments.
>
> Does this sequence ring any bells with anyone?
>
> In the message, "Could Not Get XDR Request" was returned because the giomgr was not able to accept or understand the connection request because the length was invalid.
> Bruce Bannerman

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Notice:
This email and any attachments may contain information that is personal, confidential,
legally privileged and/or copyright. No part of it should be reproduced, adapted or communicated without the prior written consent of the copyright owner.

It is the responsibility of the recipient to check for and remove viruses.

If you have received this email in error, please notify the sender by return email, delete it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information contained in this email.

Please consider the environment before printing this email.

--
Cameron Shorter
Geospatial Systems Architect
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254

Think Globally, Fix Locally
Commercial Support for Geospatial Open Source Solutions
http://www.lisasoft.com/LISAsoft/SupportedProducts.html