Skip to main content
  • EN

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.

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

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.

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 😞

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


Community Stats

30,180
Posts
114,562
Replies
37,845
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.