Hello,
I'm using FME Workbench 2006 with ArcSDE 9.1. I'am trying to create a
cleaning process to delete all datas related with a specific feature
(cleaning the mess if something went went wrong in a several step
process!).
To achieve that goal, I try to use the ARCSDEQUERIER transformer. As
data I want to remove are all related to the source with an attribute,
I use the SDE_NONE search method, then specified
FK_NAME='&ATTRIBUTE_NAME' as WHERE Clause, ATTRIBUTE_FIRST as search
order and DELETE as Query mode.
Every thing worked fine on one sample table, the data I wanted was
deleted but on most other tables I got this error :
Error while performing delete row on table 'VOIE':SDE_ERROR_CODE(-22)
Shape or row not found. SDE_STREAM_ERROR_CODE(-51) SDE_EXT_ERROR(1403)
SDE_ERROR_MSG1(No Data Found) SDE_EXT_ERROR_MSG2()
Program Terminating
And there's a dump of one of the object I want to delete in the log
just before the error message.
When the ArcSDE table is empty, of course everything work fine, but
that doesn't allow me to perform a suitable cleaning process.
Any clue?
Thank's in advance.
Regards.
C. Basset
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/