Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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: 😧\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
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
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.
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
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
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
Hi,
Is the following scenario possible?
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
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
no worries - enjoy
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
This may not solve other's issue but we rebooted our FTP server and now everything is working perfectly - well, so far.