Question

MS SQL Server Non-Spatial Writer issues

  • 11 June 2020
  • 1 reply
  • 31 views
A
Badge +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
Badge +1

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


Community Stats

28,698
Posts
109,446
Replies
36,547
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.