Skip to main content
  • EN

Hi,

I have a client that is experiencing some odd behavior when it comes to truncating feature classes and tables in a SQL Server SDE environment. The writer is set to 'Yes' for Truncate table however when fme writes out the features heading to the writer it does not truncate the data first but merely inserts data records.

If i add a new reader, move the feature types over, configure it exactly the same and rerun the writer functions as expected (Truncate and Load data).

Why do i have to add a new reader that is configured exactly the same to get FME to truncate properly. Do FME writers go stale?

FME 2015.1

SDE (10.4.1)

Any help will be apprecaited.

Have you verified that the database user has sufficient grants for performing the truncate?

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
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.