Skip to main content
Question

Disappearing features written to MS/SQL

lifalin2016
Contributor
Forum|alt.badge.img+29

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.

4 replies

itay
Supporter
Forum|alt.badge.img+17
  • itaySupporter
  • Supporter
  • May 20, 2020

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

lifalin2016
Contributor
Forum|alt.badge.img+29
  • lifalin2016Contributor
  • Author
  • Contributor
  • 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
Contributor
Forum|alt.badge.img+29
  • lifalin2016Contributor
  • Author
  • Contributor
  • May 20, 2020
itay wrote:

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

 

Reply


Helpful Members This Week

Community Stats

31,358
Posts
118,944
Replies
38,974
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.