Skip to main content
  • EN

Error executing SQL command ('TRUNCATE TABLE "quali"."wa_hydrant"'): 'ERROR: permission denied for table wa_hydrant

'

Error truncating table 'quali.wa_hydrant'. Assuming table exists and attempting to append

Error executing SQL command ('COPY "quali"."wa_hydrant" ("gis_id", "gesellschaft_bd", "gemeinde", "standortwerk", "_rbe", "_fehler_nr", "_fehler", "_pruefdatum", "_fme_prozess", "_temptext1", "_temptext2", "_temptext3", "_temptext4", "_temptext5", "_temptext6", "_temp_num1", "_temp_num2", "_temp_num3", "_temp_num4", "_temp_num5", "_temp_num6", "fstatus_id", "geom_pt") FROM STDIN USING DELIMITERS ':' WITH NULL AS 'NULL''): 'ERROR: current transaction is aborted, commands ignored until end of transaction block

'

POSTGIS writer: A fatal error has occurred. Check the logfile above for details

NullAttributeMapper_OUTPUT_-1_337_Player (RecorderFactory): POSTGIS writer: A fatal error has occurred. Check the logfile above for details

Successfully closed POSTGIS database writer

Hi @sknaps​ thanks for your question! What version and build number of FME are you using? Are you able to write to the table without truncating as a test? (i.e. use existing?)

This does look like a permissions issue, any additional information you could provide would be helpful!

Hi @ EvieAtSafe

I use "FME Workbench 2021.1.1" I succesfully tested writing and truncating the table with pGAdmin.

In FMEwriting works, just truncating creates an error.

Problem is solved. It was an internal database permission problem.

 

Thanks

Reply


Community Stats

30,146
Posts
114,427
Replies
37,787
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.