Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ArcSDE
    • Labels:
      None
    • Environment:
      ArcSDE 8.3
    • Number of attachments :
      0

      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

          Activity

          Hide
          Chris Holmes added a comment -

          Punting this to you Brock, if you and Gabriel have a chance to debug it that'd be great.

          Show
          Chris Holmes added a comment - Punting this to you Brock, if you and Gabriel have a chance to debug it that'd be great.
          Hide
          Gabriel Roldan added a comment -

          please try now

          Show
          Gabriel Roldan added a comment - please try now
          Hide
          Gabriel Roldan added a comment -

          Sorry Brock, I just hit "assign to me" as I seen it was unresolved and is arcsde related.
          I think you can test the delete stuff and just close this issue (as long as I upload the latest geotools jars)

          Show
          Gabriel Roldan added a comment - Sorry Brock, I just hit "assign to me" as I seen it was unresolved and is arcsde related. I think you can test the delete stuff and just close this issue (as long as I upload the latest geotools jars)
          Hide
          Chris Holmes added a comment -

          I haven't heard complaints about arcsde delete not working, so I'm going to assume this is done.

          Show
          Chris Holmes added a comment - I haven't heard complaints about arcsde delete not working, so I'm going to assume this is done.

            People

            • Assignee:
              brock anderson
              Reporter:
              Nishma Shukla
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: