Skip to main content
Question

Hi, I get an error message because of a permission. Had anyone a similar error?

S

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

3 replies

evieatsafe
Safer
  • evieatsafeSafer
  • Safer
  • July 6, 2023

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!

Happy to help - Evie
S
  • sknaps
  • Author
  • July 7, 2023

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.

S
  • sknaps
  • Author
  • July 7, 2023

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

 

Thanks

Reply


Helpful Members This Week

Community Stats

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