NPrinting Import task failed

anuj_sharma — Mon, 30 Apr 2018 06:35:01 GMT

What can be the reason for getting following contents in the log generated for NPrinting's failed reload task?

Importing filters and recipients for file with path \\Path\File.xlsx

ERROR message : importing USER : ERROR: 23503: update or delete on table "email_address" violates foreign key constraint "fk5a28dad2b0368053" on table "smtp_destination_to_cc"

ERROR message : Import task execution failed. No data was saved.

Please advise/help if someone has already encountered such an issue.

Thanks, Regards

Re: NPrinting Import task failed

blaise — Thu, 03 May 2018 22:45:32 GMT

I've started a case with qlik support earlier today, will update this thread when I have something to share.

I believe that the issue is that the import task tries to remove a user that is used as a recipient for a report/task, and that's why the task execution throws a fk violation.

I have the same error message but my fk violarion is on table smtp_destination. How many tasks do you have with a cc recipeint? Go through all tasks and remove the recipients on cc one by one and try running the import task in between would be my suggestion .

On my case, the issue goes away if I unmark the "remove users.." checkbox on the import task .Try removing that setting if you need your task to suceed.

topic NPrinting Import task failed in Qlik NPrinting

NPrinting Import task failed

Re: NPrinting Import task failed