Error import organization

  • Used Zammad version: 2.9.x
  • Operating system: Ubuntu 18.04.2

Hi guys,
i tried to import organizations csv but after a few organizations correctly imported system gave me this error :

PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block : SELECT “settings”.* FROM “settings” WHERE “settings”.“area” = $1 ORDER BY “settings”.“name” ASC

can you help me please?

this is an example of unaccepted record :

name,shared,active
ILCAS SPA,true,true

Quoting will help here, everything that contains spaces should have '' around this string to address this.

I am getting the same error, but I can not tell which records are not acceptable. Additionally, some have imported with spaces in the name and without quotes such as:

id,name,shared,domain,domain_assignment,active,note,members
,10th Ave Liquor & Food Mart,false,false,true,

id,name,shared,domain,domain_assignment,active,note,members
,10th Ave Liquor & Food Mart,false,false,true,

Works perfectly fine.

Maybe you might want check your logfiles and (to make it easier) not recycle old posts as we don’t know nothing about your instance. Also check the following link while you’re at it: https://community.zammad.org/t/asking-for-help-on-community/2262/2

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.