[Geoserver-users] unpredictable ArcSDE behaviour

GeoServer GeoServer User
1

Hi Andrea,

Thank you for your reply.

I have just tried the geoserver1.6.3. and it was working (Please note that the feature is created based on the ArcSDE table). Although I must say it took a long time to extract 1000 features (118329ms).

By using the new geoserver1.6.3 and the new arcSDE extension plugin, I found another issue with the ArcSDE layers. When I want to create a new ArcSde layer based on a view it did not allow me to create one and gave me the following error message:

GeoServer - Exception

The following exception was thrown:

java.lang.IllegalArgumentException: ArcSDE registered views can’t be writable

From the error message, it seems to indicate that the “ArcSDE View” is the issue. Is this correct?

Thank you again for your kind help.

Kind regards, Dv

Deavi Purnomo

SLIP GIS Team

Information Management Division

Address: 1 Midland Square

Midland WA 6056

Phone: 08 9273 0786

Email: Deavi.Purnomo@anonymised.com

Website: http://www.landgate.wa.gov.au

-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: Wednesday, 9 April 2008 5:04 PM
To: Deavi Purnomo
Cc: geoserver-users@lists.sourceforge.net; Gabriel Roldán
Subject: Re: [Geoserver-users] unpredictable ArcSDE behaviour

Dv_LGATE ha scritto:

Hi list,

I have been having a similar issue with the SDE layers. Does anyone know why

this happens? Please help.

These are the things that I have tried:

Gabriel may provide better answers, but in the meantime, have you tried

out GeoServer 1.6.3 and the associated ArcSDE extensions?

It should have quite a bit of significant ArcSDE improvements.

(oh, rememeber you have to grab the extension distributed with 1.6.3,

the older ones won’t work, extensions datastores do work only with

the geoserver version they are built for).

Cheers

Andrea

This e-mail and any files transmitted with it are intended only for the use of the addressee(s). It may contain information that is confidential and privileged, in which case neither is intended to be waived or lost by mistaken delivery to you. If you are not an intended recipient, any use, interference with, disclosure, distribution or copying of this material is unauthorised and prohibited. If you receive this e-mail in error, please notify the sender by return e-mail and delete the message and any attachments from your system. Unless specifically indicated, this e-mail does not constitute formal advice or commitment by the sender or the Western Australian Land Information Authority (Landgate). Information in this message not relating to the official business of Landgate shall be understood as neither given nor endorsed by it. It is your responsibility to check any attachments for viruses and defects before opening or sending them on. Landgate’s liability is limited to re-supplying affected attachments.

2

Deavi Purnomo ha scritto:

Hi Andrea,

Thank you for your reply.

I have just tried the geoserver1.6.3. and it was working (Please note that the feature is created based on the ArcSDE table). Although I must say it took a long time to extract 1000 features (118329ms).

Ouch!

By using the new geoserver1.6.3 and the new arcSDE extension plugin, I found another issue with the ArcSDE layers. When I want to create a new ArcSde layer based on a view it did not allow me to create one and gave me the following error message:

*GeoServer - Exception*

*The following exception was thrown: *

*java.lang.IllegalArgumentException: ArcSDE registered views can't be writable*

Do you have the full stack trace? (from the GeoServer logs).
This may help Gabriel work this out. But don't expect a swift solution... he's out for a conference.

Cheers
Andrea

3

Hi Deavi,

sorry for the late answer, and thanks Andrea for stepping in.

On Thursday 10 April 2008 03:04:38 am Deavi Purnomo wrote:

Hi Andrea,

Thank you for your reply.

I have just tried the geoserver1.6.3. and it was working (Please note that
the feature is created based on the ArcSDE table). Although I must say it
took a long time to extract 1000 features (118329ms).

okay, that's good (that it worked, I mean)... the time is horrible and makes
me think if for some reason we would be doing a full table scan to get the
bounds or something like that...
Before digging into that, can you confirm that table performs well with other
software? just to discard a screwed up spatial index and so.

By using the new geoserver1.6.3 and the new arcSDE extension plugin, I
found another issue with the ArcSDE layers. When I want to create a new
ArcSde layer based on a view it did not allow me to create one and gave me
the following error message:

you spotted a bug here. I've already found and fixed it. I'll send you a jar
by private mail for you to try out.

Cheers,

Gabriel

GeoServer - Exception

The following exception was thrown:

java.lang.IllegalArgumentException: ArcSDE registered views can't be
writable

From the error message, it seems to indicate that the "ArcSDE View" is the
issue. Is this correct?

Thank you again for your kind help.

Kind regards, Dv

Deavi Purnomo

SLIP GIS Team

Information Management Division

Address: 1 Midland Square

Midland WA 6056

Phone: 08 9273 0786

Email: Deavi.Purnomo@anonymised.com

Website: http://www.landgate.wa.gov.au

-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: Wednesday, 9 April 2008 5:04 PM
To: Deavi Purnomo
Cc: geoserver-users@lists.sourceforge.net; Gabriel Roldán
Subject: Re: [Geoserver-users] unpredictable ArcSDE behaviour

Dv_LGATE ha scritto:
> Hi list,
>
>
>
> I have been having a similar issue with the SDE layers. Does anyone know
> why
>
> this happens? Please help.
>
>
>
> These are the things that I have tried:

Gabriel may provide better answers, but in the meantime, have you tried

out GeoServer 1.6.3 and the associated ArcSDE extensions?

It should have quite a bit of significant ArcSDE improvements.

(oh, rememeber you have to grab the extension distributed with 1.6.3,

the older ones won't work, extensions datastores do work only with

the geoserver version they are built for).

Cheers

Andrea

This e-mail and any files transmitted with it are intended only for the use
of the addressee(s). It may contain information that is confidential and
privileged, in which case neither is intended to be waived or lost by
mistaken delivery to you. If you are not an intended recipient, any use,
interference with, disclosure, distribution or copying of this material is
unauthorised and prohibited. If you receive this e-mail in error, please
notify the sender by return e-mail and delete the message and any
attachments from your system. Unless specifically indicated, this e-mail
does not constitute formal advice or commitment by the sender or the
Western Australian Land Information Authority (Landgate). Information in
this message not relating to the official business of Landgate shall be
understood as neither given nor endorsed by it. It is your responsibility
to check any attachments for viruses and defects before opening or sending
them on. Landgate’s liability is limited to re-supplying affected
attachments.

!DSPAM:4045,47fd67b1108446491211187!