Question

SDE (Sql Server) Truncate Issues - FME fails to truncate table

  • 25 June 2018
  • 1 reply
  • 14 views
E

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.

1 reply

david_r
Rank
Userlevel 4

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

Reply


Community Stats

28,731
Posts
109,530
Replies
36,565
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.