Skip to main content
Question

Disappearing features written to MS/SQL

  • May 20, 2020
  • 4 replies
  • 16 views
lifalin2016
Supporter
Forum|alt.badge.img+38

Hi.

I'm trying to write features to some MS/SQL tables, and my translation is apparently successful, and the log file shows lots of features written. No errors are reported.

However, the database tables in question are completely empty !

I have a few constraints on my tables, and some fields which may not be NULL, so that may be the cause, although I should have handled that. But where do I see what the actual problem is, since FME doesn't include any error message from the database in the log file at all.

Cheers.

-- Cheers, Lars I.
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.

4 replies

itay
Supporter
Forum|alt.badge.img+18
  • itaySupporter
  • Supporter
  • 1442 replies
  • May 20, 2020

Could it be that your database connection is pointing to another database or schema?

lifalin2016
Supporter
Forum|alt.badge.img+38
  • lifalin2016Supporter
  • Author
  • Supporter
  • 592 replies
  • May 20, 2020

Ah, as is often the case, the error was another entirely.

I had problems with some ill-formatted GUIDs.

Now I'm stuck on some MS/SQL antics about foreign keys and unique indexes on nullable fields !

Closing the question.

-- Cheers, Lars I.
lifalin2016
Supporter
Forum|alt.badge.img+38
  • lifalin2016Supporter
  • Author
  • Supporter
  • 592 replies
  • May 20, 2020

Could it be that your database connection is pointing to another database or schema?

No, I triple checked that :-) I found a remedy, which (of course) lead to some other issues :-(

-- Cheers, Lars I.
david_r
Celebrity
  • david_rCelebrity
  • 8392 replies
  • May 20, 2020

Generally speaking, if you think that important information about errors or warnings from the database is missing from the FME log, I would recommend that you flag this to Safe support. That way they can hopefully improve the logging in future versions.

 

Community Stats

32,076
Posts
121,791
Replies
39,702
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.