Skip to main content
Question

MS SQL Server Non-Spatial Writer issues

  • June 11, 2020
  • 1 reply
  • 227 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!

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

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!

Community Stats

32,182
Posts
122,178
Replies
39,856
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.