Skip to main content
Question

MS SQL Server Non-Spatial Writer issues

  • June 11, 2020
  • 1 reply
  • 174 views
A
Forum|alt.badge.img+1

Hi,

I am trying to write to a MS SQL Server Non-Spatial Writer but I keep getting the following error:

Microsoft SQL Server Non-Spatial Writer: Failed to write attribute `PK_ID' of feature type `dbo.Txxxx'. Provider Error `(-2147467261) Invalid pointer'

I have read through a number of posts on this forum about similar issues and have tried the following:

  • Set the 'Command Timeout (seconds)'  in the writer parameters to 600 seconds.
  • Set Bulk Insert to 'No'.
  • Installed Microsoft SQL Server 2012 Native client (64bit)

0684Q00000ArBg4QAF.png

However none of these things have helped.

I am using FME Desktop version: FME(R) 2019.1.0.0 (20190710 - Build 19608 - WIN64).

Does anyone have any other ideas on what could be causing this? This is my first time writing to MS SQL Server but I have read from MS SQL Server in the past with no issues.

Thanks!

 

1 reply

A
Forum|alt.badge.img+1
  • aquamarine
  • Author
  • June 11, 2020

I just solved this myself. The issue was actually because I was trying to write NULL to a column which had a constraint set that mean it had to be non-NULL!

Reply


Helpful Members This Week

Community Stats

31,105
Posts
117,920
Replies
38,856
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.