Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ArcSDE
-
Labels:None
-
Environment:ArcSDE 8.3
-
Number of attachments :
Description
I am getting an exception when performing a delete on ARCSde Datastore. I am posting the following request
<wfs:Transaction service="WFS" version="1.0.0" xmlns:cdf="http://www.opengis.net/cite/data" xmlns:ogc="http://www.opengis.net/ogc" xmlns:wfs="http://www.opengis.net/wfs" xmlns:land="http://www.oriongis.com/land">
<wfs:Delete typeName="land:SCHEMA1.TABLE1">
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>land.TABLE1ID</ogc:PropertyName>
<ogc:Literal>5000006</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
</wfs:Delete>
</wfs:Transaction>
I tried to debug ArcSDEFeatureWriter.java where the error is occurring in remove()method. It is trying to give the where clause as 'FID=SCHEMA.TABLE1.43520' to seDelete.fromTable Operation. I tried using java SDE API for delete using the same where clause and I am getting the same exception message there. However, ESRI MapObjects deleted successfully with the where clause as 'FID=43520'.
I am getting the following exception:
Delete Feature Request
feature type:land:SCHEMA1.TABLE1
filter:[ TABLE1ID = 5000006 ]
release:true
cause: DATABASE LEVEL ERROR OCCURRED.
106453 [FINE] org.geotools.data.arcsde.ArcSDEConnectionPool - trying to release
a seconnection: com.esri.sde.sdk.client.SeConnection@1bbdd48
106453 [FINER] org.geotools.data.arcsde.ArcSDEConnectionPool - used is: [com.es
ri.sde.sdk.client.SeConnection@1bbdd48]
available is [com.esri.sde.sdk.client.SeConnection@dc1f04]
106500 [FINE] org.geotools.data.arcsde.ArcSDEConnectionPool - com.esri.sde.sdk.
client.SeConnection@1bbdd48freed, after release used is: []
available is [com.esri.sde.sdk.client.SeConnection@dc1f04, com.esri.sde.sdk.clie
nt.SeConnection@1bbdd48]
106500 [WARNING] org.vfny.geoserver.ServiceException - encountered error: DATAB
ASE LEVEL ERROR OCCURRED.
StackTrace: org.vfny.geoserver.responses.wfs.WfsTransactionException: DATABASE L
EVEL ERROR OCCURRED.
at org.vfny.geoserver.responses.wfs.TransactionResponse.execute(Transact
ionResponse.java:385)
at org.vfny.geoserver.responses.wfs.TransactionResponse.execute(Transact
ionResponse.java:104)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService
.java:362)
at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.ja
va:300)
at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDispatche
r.java:245)
at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doPost(WfsDispatcher.ja
va:134)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358
)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicati
onHandler.java:294)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:5
67)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplication
Context.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:
197)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)
Issue Links
- depends upon
-
GEOT-389
ArcSDE Delete not working
-
Punting this to you Brock, if you and Gabriel have a chance to debug it that'd be great.