Hello,
My reader is a MapInfo table and my writer is a PostGIS database. I tested the database and I was able to successfully connect to the database. However, when I run the workbench only 1 record goes through and I get the following error: Error executing SQL command ('select * from "databasename"."tablename" where false limit 0'):'
Writer failed in write() call
Any idea of what is going wrong?
+19Hi,
Is the log correct? are you trying the following SQL: select * from "databasename"."tablename" where false limit 0? or did you edit it for posting?
I edited it for posting. Instead of the real database name I wrote "databasename" and instead of the real table name I wrote "tablename". Then I edited the log and wherever there was the database name I wrote "Database". I didnd't edit anything else
+26Could it be that the table does not exist and the connecting user does not have "Create table" privileges?
Could it be that the table does not exist and the connecting user does not have "Create table" privileges?
Looks like FME is trying to truncate the table when the error occurs. Can you try disabling the truncating of "Database_test"."cal_suburbs" and try again?
You could also consider deleting (dropping) "Database_test"."cal_suburbs" using e.g. PgAdmin and let FME recreate the table for you and see if that makes a difference.
+19I edited it for posting. Instead of the real database name I wrote "databasename" and instead of the real table name I wrote "tablename". Then I edited the log and wherever there was the database name I wrote "Database". I didnd't edit anything else
Thanks for the answers David and Erik.
The workbench is now running. It was an issue with the PostgreSQL database.
The solution was in PgAdminIII to get the public schema changed to the owner of all the functions to PostGIS to which the user we are running has permissions.
