Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

Could not run ReduceData : PDF Report Generation

Hi all,

We are using Publisher to distributute pdf reports. One of my Dashboard is scheduled to be reloaded once a week and thus the PDFs.

It was working fine till last week, but today it failed to distribute  PDFs throwing the following error in logs.

Has anyone faced such issue.

Please help me out with your suggestions.

Version Used:

QV 11.0 SR2

(2014-07-24 07:40:57) Information: Starting task 'Task for DMA Status Report_Region'. Id:64947200-e759-4d8f-8550-b2967d8830ac. Triggered by 'TaskCompletedTrigger'. Id:a39d96a5-44cd-4d9e-a1f6-0f5e6cddb5a2

(2014-07-24 07:40:57) Information: Entering Task Execution.

(2014-07-24 07:40:57) Information: ClusterID=1

(2014-07-24 07:40:57) Information: QDSID=d0b5a0ce-d2ac-02fb-2720-ad88f6f17c2c

(2014-07-24 07:40:57) Information: TaskID=64947200-e759-4d8f-8550-b2967d8830ac

(2014-07-24 07:40:57) Information: MaxRunTime=1.00:00:00

(2014-07-24 07:40:57) Information: MachineName=UATQLIK01

(2014-07-24 07:40:57) Information: Max attempts:1

(2014-07-24 07:40:57) Information: Current Attempt=0

(2014-07-24 07:40:57) Information: Task Dependencies are OK

(2014-07-24 07:40:57) Information: Start document distribution.

(2014-07-24 07:40:57) Information: Opening source document

(2014-07-24 07:40:57) Information: Opening document: "Marketing Dashboard.qvw"

(2014-07-24 07:40:57) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).

(2014-07-24 07:40:57) Information: Max retries:5

(2014-07-24 07:40:57) Information: Attempt:01

(2014-07-24 07:40:58) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=12.

(2014-07-24 07:40:58) Information: Loading document "E:\Apps\QlikView Applications\Development\Marketing Dashboard\Qvw_Files\Marketing Dashboard.qvw" (20.59 Mb)

(2014-07-24 07:40:59) Information: Loading. LoadTime=00:00:01.0140130

(2014-07-24 07:41:01) Information: Loading. LoadTime=00:00:03.0420390

(2014-07-24 07:41:05) Information: Loading. LoadTime=00:00:07.0980910

(2014-07-24 07:41:07) Information: Physical FileSize=20.59 Mb. Memory Allocation Delta for this file=3011.69 Mb. Available Physical Memory Before Open=55224.28 Mb. Available Physical Memory After Open=52311.00 Mb. Total Physical Memory=73717.80 Mb.

(2014-07-24 07:41:07) Information: Attempted to load the document with data.

(2014-07-24 07:41:07) Information: The document was loaded successfully.

(2014-07-24 07:41:10) Information: Reduce skipped, nothing is selected.

(2014-07-24 07:41:10) Information: Document was opened successfully

(2014-07-24 07:41:10) Information: Determined 1 static recipients spread over 1 Distribution Resources.

(2014-07-24 07:41:10) Information: Number of rule combinations was calculated successfully. Rounds=5

(2014-07-24 07:41:10) Information: Applying rules

(2014-07-24 07:41:10) Information: Commencing ClearSelections. FieldName=Region

(2014-07-24 07:41:10) Information: Adding selections for field Region. Values="Central"

(2014-07-24 07:41:10) Information: Applied rules:Region="Central"

(2014-07-24 07:41:10) Information: Rules resulted in distribution.

(2014-07-24 07:41:10) Information: ROUND: 1 of 5. WarningCount=0

(2014-07-24 07:41:10) Information: Building filename

(2014-07-24 07:41:10) Information: Destination name: DMA_Status_Report_ Central_24 07 2014.qvw

(2014-07-24 07:41:10) Information: Set script

(2014-07-24 07:41:10) Information: Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

(2014-07-24 07:41:10) Information: Offer resources

(2014-07-24 07:41:10) Information: Commencing ReduceData

(2014-07-24 07:46:43) Error: Could not run ReduceData. Exception=QVBWrapper.Exceptions.ReduceAndSaveFailedException: Failed to reduce and save document: C:\ProgramData\QlikTech\DistributionService\1\temp\ca020312-2e39-42f0-87e5-9f7ffa838050\document.qvw

(2014-07-24 07:46:43) Error: at QVBWrapper.Document.ReduceAndSave(ILogBucket logBucket, String savePath, Boolean checkoutReducedDocument)

(2014-07-24 07:46:43) Error: at QVBWrapper.Document.ReduceData(ILogBucket logBucket, Boolean reduce, String savePath, Boolean checkoutReducedDocument, Boolean save)

(2014-07-24 07:46:43) Error: Could not save document stream to disk.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.

(2014-07-24 07:46:43) Error: at QVBWrapper.Document.GetStream(ILogBucket i_LogBucket, eDocumentType i_DocumentType, String i_URL, Boolean i_ShowToolBar, String i_ReportID)

(2014-07-24 07:46:43) Error: Failed to generate QVW File package.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.

(2014-07-24 07:46:43) Error: at QDSMain.DistributeHelper.GrabPDFFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document)

(2014-07-24 07:46:43) Information: Deleting temporary files.

(2014-07-24 07:46:43) Information: Closing the document.

(2014-07-24 07:46:44) Information: Closed the QlikView Engine successfully. ProcessID=24272

(2014-07-24 07:46:44) Error: The task "Task for DMA Status Report_Region" failed. Exception:

(2014-07-24 07:46:44) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Failed to generate QVW File package.. Exception=System.NullReferenceException: Object reference not set to an instance of an object.

(2014-07-24 07:46:44) Error: at QDSMain.DistributeHelper.GrabPDFFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document)

(2014-07-24 07:46:44) Error: at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument)

(2014-07-24 07:46:44) Error: at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument)

(2014-07-24 07:46:44) Error: at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

(2014-07-24 07:46:44) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-07-24 07:46:44) Error: --- End of inner exception stack trace ---

(2014-07-24 07:46:44) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-07-24 07:46:44) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-07-24 07:46:44) Information: Task Execute Duration=00:05:47.6504570

(2014-07-24 07:46:44) Information: TaskResult.status=Finished

(2014-07-24 07:46:44) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-07-24 07:46:44) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-07-24 07:46:44) Information: Saving Task Result

10 Replies
erikadvectas
Valued Contributor

Re: Could not run ReduceData : PDF Report Generation

Hi Mona,

Could be a few different things. Performance, there was another task using the same files, Antivirus scanning those very files (make exceptions in your AV program), some inconsistencies in that directory. It is fine to stop the QDS service, remove/backup the content of C:\ProgramData\QlikTech\DistributionService\ and start QDS again. The folder content will be automatically recreated and any temporary files would be cleared. The directory holds temp files, reference files for the repository and logfiles. No task settings would be lost, only task history.

Regards,

Erik

Not applicable

Re: Could not run ReduceData : PDF Report Generation

Hi Erik,

Thanks for the reply.

I have tried removing the folders & files under Distribution Service folder but its still not resolved.

There is no other task running/using this same application. However, I had a backup of this Dashboard which is of around 1Mb, I have tried the same task on it, its running fine for that but the current file (21 Mb) is having issue.


erikadvectas
Valued Contributor

Re: Could not run ReduceData : PDF Report Generation

Hi Mona,

Are you saying that the task has continuous failures? Is it continuing to fail even if you re-run it? If so, you might want to look into the script or the users that the task is loop and reducing for.

Regards,

Erik

Employee
Employee

Re: Could not run ReduceData : PDF Report Generation

Hi,

When you removed the files from C:\ProgramData\QlikTech\DistributionService did you delete all files and folders?

Bill

Not applicable

Re: Could not run ReduceData : PDF Report Generation

Yes Britt, I did remove all the files and folders.

Not applicable

Re: Could not run ReduceData : PDF Report Generation

Erik,

Yes it has continuous failures with the same error.

Pdf distribution task was working fine earlier, there are no changes in the script from long.

Mona

Not applicable

Re: Could not run ReduceData : PDF Report Generation

Hi,

Did your task having any data reduction based on some field ?

Sampath

Not applicable

Re: Could not run ReduceData : PDF Report Generation

Yes , document is suppose to reduced on a field.

Not applicable

Re: Could not run ReduceData : PDF Report Generation

Check whether the value which you provided in the QMC is available in the application. if not the task will fail.

Community Browser