Skip to main content
  • EN
Hello, I'm new to FME and have a workbench that does a dgn to ArcSDE geodatabase (SQL Server)  feature class conversion of points.  I have the "drop table" set to "yes" which I assume deletes all the features in the SDE geodatabase before writing to it.  To that end, when I run the workbench, I get the error below.  I can see that the geodatabase has locks from ArcGIS Server (we have three instances of ArcGIS Servers running).  I would have to manually stop each ArcGIS Server instance before running the workbench to get it to run correctly.  Is there a better way to run the workbench and update the data?

 

 

Unable to drop the table/feature class 'Bollard'. The error number from ArcObjects is: '-2147215875'. The error message from ArcObjects is: {Table is already locked aoc_gis.GISADMIN.Bollard]}

A fatal error has occurred. Check the logfile above for details.

 

 

Thank you

 

Steve
Hi Steve,

 

 

Some time ago I was also investigating how to run a FME script on a locked ESRI gdb. Unfortunatly the ESRI methodology of locking isnt very flexible or user friendly when interacting with outside applications.

 

 

In your situation, with 3 potential lockers, I would look into the possibility of using a versioned  db type, or  scheduale the script to run when locking doesnt takes place (if at all possible).

 

 

Cheers,

 

Itay

 

 

Hi Steve,

 

 

rather than dropping the table, consider truncating it instead. That is usually more lock-friendly and would have the same net effect, as long as the table schema is stable (doesn't change between translations).

 

 

Also have a look at this fmepedia article that uses an SDEQuerier to update records on a non-versioned SDE Geodatabase feature class, which might give you some further ideas.

 

 

David
David and Italy, thank you for the responses.  The truncate table option seems to be doing the trick!
Steve, 

 

     Yeah Droping table is the equivolent of deleting the table.  Truncate just deletes the features or rows.

 

 

Chris

Reply


Community Stats

30,157
Posts
114,473
Replies
37,802
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.