Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

nihalbuddy09
Contributor II

NPrinting Error: Error during copy file

Hi All,

Please help me on this issue, from last couple of months we are getting this error in NPrinting.

Error    Error during copy file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx.


We are not sure why this error is popping up. All we have is 4 recipients for each task to receive success/failure email notifications, if you see the log the error occurring during copying the file. The same error message we got for another task a week ago.

Someone please advise what we are doing wrong here; is there any issue with adding the recipients/permissions to the task or missing something else.

We are using the option "custom folder' to store the final output XLSX files, so that users can access the folder and get the files from there.

Below is the log.

Service 13/11/2017         12:45:00               Message              QlikView NPrinting file opened: D:\QlikView\xxxxxx\xxxxxx Extracts.nsq

Service 13/11/2017         12:45:00               Message              Service: event started

Service 13/11/2017         12:45:00               Message              Run Schedule: Reload Schedule for xxxxxx at midday

Service 13/11/2017         12:45:00               Message              Run Job: xxxxxx Task

Service 13/11/2017         12:45:00               Message              Run Task: xxxxxx Extract Task

Service 13/11/2017         12:45:03               Message              Open file: D:\QlikView\xxxxxx\xxxxxx.qvw

Service 13/11/2017         12:45:10               Information        QlikView version: 11.20.12742.0

Service 13/11/2017         12:45:10               Message              Creating output folder: C:\Users\xxxxxx\NPrinting_Temporary_56E25A9C61F34619AFD2410390EBB426\

Service 13/11/2017         12:45:10               Message              Output folder created: C:\Users\xxxxxx\NPrinting_Temporary_56E25A9C61F34619AFD2410390EBB426\

Service 13/11/2017         12:45:10               Message              Creating output folder: C:\Users\xxxxxx\NPrinting_Temporary_Distribution_BF2B72D6320A433D8252EFD70246DDFB\

Service 13/11/2017         12:45:10               Message              Output folder created: C:\Users\xxxxxx\NPrinting_Temporary_Distribution_BF2B72D6320A433D8252EFD70246DDFB\

Service 13/11/2017         12:45:10               Message              Start Load Task

Service 13/11/2017         12:45:10               Message              End Load Task

Service 13/11/2017         12:45:10               Message              Start Execute Task

Service 13/11/2017         12:45:10               Message              Start xxxxxx_LIVE_XLSX

Service 13/11/2017         12:45:10               Message              Report type: Excel Workbook (Excel Workbook)

Service 13/11/2017         12:45:10               Message              The condition "ISQVReloaded" for the report "xxxxxx_LIVE_XLSX" was met

Service 13/11/2017         12:45:10               Message              Producing report: xxxxxx_LIVE_XLSX

Service 13/11/2017         12:51:47               Message              Report produced: xxxxxx_LIVE_XLSX

Service 13/11/2017         12:51:47               Message              Creating report: xxxxxx_LIVE_XLSX (C:\Users\xxxxxx\NPrinting_Temporary_56E25A9C61F34619AFD2410390EBB426\O00001-F00001_2017-11-13_12-45-10.xlsx)

Service 13/11/2017         12:52:14               Message              Report created : xxxxxx_LIVE_XLSX (C:\Users\xxxxxx\NPrinting_Temporary_56E25A9C61F34619AFD2410390EBB426\O00001-F00001_2017-11-13_12-45-10.xlsx)

Service 13/11/2017         12:52:14               Message              End xxxxxx_LIVE_XLSX

Service 13/11/2017         12:52:14               Message              End Execute Task

Service 13/11/2017         12:52:14               Message              Start Output Distribution

Service 13/11/2017         12:52:14               Message              Copying file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:14               Message              Copied file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:14               Message              Creating Message

Service 13/11/2017         12:52:14               Message              From: xxxxxx@xxxxxx

Service 13/11/2017         12:52:14               Message              Recipient: xxxxxx1@xxxxxx

Service 13/11/2017         12:52:14               Message              Subject: xxxxxx Extract

Service 13/11/2017         12:52:14               Message              Building Message...

Service 13/11/2017         12:52:14               Message              Message Built

Service 13/11/2017         12:52:14               Message              Connecting to 10.192.142.1

Service 13/11/2017         12:52:15               Message              Connected to 10.192.142.1

Service 13/11/2017         12:52:15               Message              Sending Message...

Service 13/11/2017         12:52:15               Message              Message Sent!

Service 13/11/2017         12:52:15               Message              Copying file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:15               Message             Copied file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:15               Message              Creating Message

Service 13/11/2017         12:52:15               Message              From: xxxxxx@xxxxxx

Service 13/11/2017         12:52:15               Message              Recipient: xxxxxx2@xxxxxx

Service 13/11/2017         12:52:15               Message              Subject: xxxxxx Extract

Service 13/11/2017         12:52:15               Message              Building Message...

Service 13/11/2017         12:52:15               Message              Message Built

Service 13/11/2017         12:52:15               Message              Sending Message...

Service 13/11/2017         12:52:15               Message              Message Sent!

Service 13/11/2017         12:52:15               Message              Copying file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:15               Error      Error during copy file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:15               Message              Creating Message

Service 13/11/2017         12:52:15               Message              From: xxxxxx@xxxxxx

Service 13/11/2017         12:52:15               Message              Recipient: xxxxxx3@xxxxxx

Service 13/11/2017         12:52:15               Message              Subject: xxxxxx Extract

Service 13/11/2017         12:52:15               Message              Building Message...

Service 13/11/2017         12:52:15               Message              Message Built

Service 13/11/2017         12:52:15               Message              Sending Message...

Service 13/11/2017         12:52:16               Message              Message Sent!

Service 13/11/2017         12:52:16               Message              Copying file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:16               Message              Copied file: D:\QlikView\xxxxxx\xxxxxx_R12_2017-11-13_12-45-10.xlsx

Service 13/11/2017         12:52:16               Message              Creating Message

Service 13/11/2017         12:52:16               Message              From: xxxxxx@xxxxxx

Service 13/11/2017         12:52:16               Message              Recipient: xxxxxx4@xxxxxx

Service 13/11/2017         12:52:16               Message              Subject: xxxxxx Extract

Service 13/11/2017         12:52:16               Message              Building Message...

Service 13/11/2017         12:52:16               Message              Message Built

Service 13/11/2017         12:52:16               Message              Sending Message...

Service 13/11/2017         12:52:16               Message              Message Sent!

Service 13/11/2017         12:52:16               Message              Disconnecting from 10.192.142.1

Service 13/11/2017         12:52:16               Message              Disconnected from 10.192.142.1

Service 13/11/2017         12:52:16               Message              End Output Distribution

Service 13/11/2017         12:52:16               Message              Close file: D:\xxxxxx\xxxxxx.qvw

Service 13/11/2017         12:52:16               Message              Terminate Task: xxxxxx Extract Task

Service 13/11/2017         12:52:16               Message              This task took 436 seconds to execute

Service 13/11/2017         12:52:16               Message              -------------------

Service 13/11/2017         12:52:16               Message              Terminate Job: xxxxxx Task

Service 13/11/2017         12:52:16               Message              Terminate Schedule: Reload Schedule for xxxxxx at midday

Service 13/11/2017         12:52:16               Message              Service: event terminated

Service 13/11/2017         12:52:16               Message              Closing connections

Service 13/11/2017         12:52:16               Message              Connections closed

Service 13/11/2017         12:52:16               Message              Start verify notification alerts

Service 13/11/2017         12:52:16               Message              Send mail for notification alerts

Service 13/11/2017         12:52:19               Message              End verify notification alerts

Service 13/11/2017         12:52:19               Message              ===================

Thank you,

Nihal

Tags (1)
9 Replies
Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting Error: Error during copy file

Is it possible that this particular repcipient has a character which is not allowed in files names? or custom folder does not exist, because it cannot be created or overwritten ?

I would try to look for restricted characters like " \ ' " etc...

I would try to see whether for this user custom path can be created or if it exists in this location?

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
nihalbuddy09
Contributor II

Re: NPrinting Error: Error during copy file

Thank you Lech for your reply.

I have verified again there are no such characters used for this recipient and also we have set the custom folder path and recipients like below.

Custom_Folder_NP.PNG

Recipients.PNG

As you mentioned it cannot be overwritten the file multiple times, BUT in my case it's overwriting the files based on multiple recipients, is it the normal process?

Moreover this error alert we are not receiving on daily. 

Regards,

Nihal

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting Error: Error during copy file

Hi,

I used to create individual folders for indivisual users - so the each user had its own copy of report.

At the same time users should not open reports from the location where NPrinting stores them. It may be possible, that files are opened by someone and therefore cannot be overwritten by NPrinting service running report generation

regarding your question if the file has to be overwritten based on multiple recipients - i am not sure how it is setup for you as you have hidden the most critical part on screenshots...

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
nihalbuddy09
Contributor II

Re: NPrinting Error: Error during copy file

Hi Lech,

We are storing the files in one location and this is how we setup the path

D:\QlikView\QlikViewProduction\XLS\MasterExtracts\Master_2017-11-15.xlsx. For all 4 recipients we have the same path.


NPrinting storing the files here and Users have the access to this folder.


Thanks,

Nihal

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting Error: Error during copy file

Hi,

Is the following scenario possible?

  • user A report gets generated and stored in X path
  • user B report gets generated and stored in X path
    • user A opens a report and looks at it (XLS file cannot be overwritten then)
  • user C report gets generated and cannot be stored as user A is already using it?

if this can be a case i suggest you test it with subfolders for each user (this can be done automaticly using variable  subfolders based on user names)

cheers

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
nihalbuddy09
Contributor II

Re: NPrinting Error: Error during copy file

Thank you for your advise and time Lech.

We were thinking on the same scenario, as you suggested will try to change the existing "Custom Folder" option and see the result.

I will update if any, Thanks again.

Regards,

Nihal

Lech_Miszkiewicz
Honored Contributor III

Re: NPrinting Error: Error during copy file

no worries - enjoy

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
markp201
Contributor III

Re: NPrinting Error: Error during copy file

We're having the same issue with FTP copies.  It appears for each recipient, nprinting attempts to copy the xls files to ftp so it copies the same file multiple times.  This does not occur when using the standard output folder - only when we're using custom folders which would indicate a bug with nprinting.  We're going to test this out by using a single email. We're using nprinting 16.5

markp201
Contributor III

Re: NPrinting Error: Error during copy file

This may not solve other's issue but we rebooted our FTP server and now everything is working perfectly - well, so far.

Community Browser