Thanks for your reply and time ,appreciate it.
It does has the rights to save documents to destination folder. Funny enought that if I create a bookmark and use that book mark as the initial selection than it works fine and generate PDF reports and distribute them but it does not work on simple field as the initial selection....
Plesae,find the below few lines of the Log files where it hangs and does nothing after the last long line.
I did tried to create and replace the document bookmark with marco and see if it does generate PDF reports but it looks like it does not work.
Information Number of rule combinations was calculated successfully. Rounds=1
Information Empty rules
Information Rules resulted in distribution.
Information ROUND: 0 of 1. WarningCount=0
Information Building filename
Information Destination name: CXReporting_backup2.qvw
Information Set script
Information Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear
Information Offer resources
Information Commencing ReduceData
Information Allocating new QlikView Engine. Current usagecount=3 of 4
Information Max retries:5
Information Allocated QlikView Engine successfully. Current usagecount=3 of 4, Ticket=4
Information Loading document "C:\ProgramData\QlikTech\DistributionService\1\temp\4551af56-5ea9-4060-a9e5-29ef33953bf2\document.qvw" (6.70 Mb)
Information Loading. LoadTime=00:00:01
Information Loading. LoadTime=00:00:03
Information Physical FileSize=6.70 Mb. Memory Allocation Delta for this file=47.92 Mb. Available Physical Memory Before Open=23887.74 Mb. Available Physical Memory After Open=24327.11 Mb. Total Physical Memory=30715.61 Mb.
Information Attempted to load the document with data.
Information The document was loaded successfully.
Information Document was opened successfully
Information Completed ReduceData
Information Memory Allocation Delta for this file=5.67 Mb. Available Physical Memory Before Reduce=23892.67 Mb. Available Physical Memory After Reduce=24327.11 Mb. Total Physical Memory=24327.11 Mb.