Skip to main content
Question

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

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.

3 replies

david_r
Celebrity
  • david_rCelebrity
  • June 26, 2018

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

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
laddysmurf19
Contributor
Forum|alt.badge.img+1

I am currently having this same issue and would love some help.
 

-Swinson
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
evieatsafe
Safer
  • evieatsafeSafer
  • Safer
  • March 17, 2025

Hi ​@laddysmurf19 thanks for your reply. Could you post a new thread with some additional details as well as link this thread for reference? This will get more eyes on your issue. 
Some additional details to include that would be helpful:

  • what version of FME are you using?
  • what user permissions does your user have on your database? 
  • are you getting any errors?
  • have you tried adding another writer, or updating your current writer to see if this improves the issue?
Happy to help - Evie
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme

Reply


Helpful Members This Week

Community Stats

31,139
Posts
118,062
Replies
38,758
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.