Question

Empty tables when writing

Forum|Forum|5 years ago
April 17, 2020
3 replies
192 views

C

chemichael

Hi FME Community

I have encountered an issue that I cannot find the solution for.

I have a Reader -> Writer setup. Reading from a MSSQL db and writing to a Postgres.

When reading the table and making a preview, everything looks as it should be.

Then I run the transport and looking at the preview of the writer after a successfull termination of the task.

And this is what I see

Even though I've made a Scheme called 'dbo'. and the DB-connection setup is successfully connected. The table isn't to be found in the PG-db.

I've encountered this a couple of times, especially when writing to databases, however I cannot find any consistency in when it will or won't populate the tables.

I've tried to make a transformer inbetween, sometimes it works, sometimes it won't.

Sincerely

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.