Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
importing USER : ERROR: 23503: update or delete on table "email_address" violates foreign key constraint "fk2845be5917196dd2" on table "smtp_destination" - Nprinting import task - OP-7491
Article Number: 000050880 | Last Modified: 2019/05/13Description
Running an import task in NPrinting ends in importing USER : ERROR: 23503: update or delete on table "email_address" violates foreign key constraint "fk2845be5917196dd2" on table "smtp_destination", that happens for Nprinting 17 and 18.
Environment:
Nprinting Version 17 and 18 (February 2018 / April 2018)
Environment:
Nprinting Version 17 and 18 (February 2018 / April 2018)
Cause
Users which are getting synced and marked as deleted in the import task are Sender or Default Email Sender of a task, and for that blocked for deletion, which breaks the import.
Defect ID: OP-7491
Defect ID: OP-7491
Resolution
Workaround:
As a workaround disable the option "Remove users added in a previous run of this task, if not present in the import file" when setting up the task, this will allow the task to run completely, but will not clean out all users!
Fix version:
Qlik NPrinting April 2019
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the ID (JIRA item here) for reference.
As a workaround disable the option "Remove users added in a previous run of this task, if not present in the import file" when setting up the task, this will allow the task to run completely, but will not clean out all users!
Fix version:
Qlik NPrinting April 2019
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the ID (JIRA item here) for reference.
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us