Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Error en recargas de reportes - QV 11 SR 2

Una consulta... Hace un par de dias actualice en el servidor del QV la version 11 del SR 1 al SR 2 (build 11414), desde ese momento estoy observando que algunas cargas se están cayendo aprox dejando 1 hora.

En el log del reporte se muestra lo sgte:

(2013-06-24 02:00:00) Information: Starting task 'Auditoria/Auditoria_Usuarios SAP.qvw'. Id:51719788-8a50-4b82-98af-5f97b1ab2a6a. Triggered by 'ScheduleTrigger'. Id:55d14ea6-f65b-4778-9dd7-439d5491edce

(2013-06-24 02:00:00) Information: Entering Task Execution.

(2013-06-24 02:00:00) Information: ClusterID=1

(2013-06-24 02:00:00) Information: QDSID=8e427b0b-8283-bb25-e455-c97f3aec87fa

(2013-06-24 02:00:00) Information: TaskID=51719788-8a50-4b82-98af-5f97b1ab2a6a

(2013-06-24 02:00:00) Information: MaxRunTime=06:00:00

(2013-06-24 02:00:00) Information: MachineName=PELILRAPEX003

(2013-06-24 02:00:00) Information: Max attempts:1

(2013-06-24 02:00:00) Information: Current Attempt=0

(2013-06-24 02:00:00) Information: Task Dependencies are OK

(2013-06-24 02:00:00) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2013-06-24 02:00:00) Information: Opening "E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw"

(2013-06-24 02:00:00) Information: Allocating new QlikView Engine. Current usage count=0 of 5 (of type non-reader).

(2013-06-24 02:00:00) Information: Max retries:5

(2013-06-24 02:00:00) Information: Attempt:01

(2013-06-24 02:00:01) Information: Allocated QlikView Engine successfully. Current usage count=1 of 5 (of type non-reader). Ticket number=243.

(2013-06-24 02:00:01) Information: Loading document "E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw" (2.24 Mb)

(2013-06-24 02:00:01) Information: Physical FileSize=2.24 Mb. Memory Allocation Delta for this file=8.38 Mb. Available Physical Memory Before Open=3507.59 Mb. Available Physical Memory After Open=3488.70 Mb. Total Physical Memory=6143.49 Mb.

(2013-06-24 02:00:01) Information: Attempted to load the document without data.

(2013-06-24 02:00:01) Information: The document was loaded successfully.

(2013-06-24 02:00:01) Information: Document was opened successfully

(2013-06-24 02:00:01) Information: Starting reload

(2013-06-24 02:00:01) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2013-06-24 02:00:01) Information: The Source Document is being reloaded. DocumentPath=E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw

(2013-06-24 02:00:02) Information: Reloading.

(2013-06-24 02:00:03) Information: Reloading..

(2013-06-24 02:00:05) Information: Reloading...

(2013-06-24 02:00:06) Information: Reloading....

(2013-06-24 02:00:07) Information: Reloading.....

(2013-06-24 02:00:10) Information: Reloading......

(2013-06-24 02:00:11) Information: Reloading.......

(2013-06-24 02:00:14) Information: Reloading........

(2013-06-24 02:00:16) Information: Reloading.........

(2013-06-24 02:00:17) Information: Reloading..........

(2013-06-24 02:00:19) Information: Slow down logging. Log every <2> seconds.

(2013-06-24 02:00:19) Information: Reloading

(2013-06-24 02:00:23) Information: Reloading.

(2013-06-24 02:00:26) Information: Reloading..

(2013-06-24 02:00:30) Information: Reloading...

(2013-06-24 02:00:34) Information: Reloading....

(2013-06-24 02:00:53) Information: Reloading.....

(2013-06-24 02:01:00) Information: Reloading......

(2013-06-24 02:01:05) Information: Reloading.......

(2013-06-24 02:01:11) Information: Reloading........

(2013-06-24 02:01:17) Information: Reloading.........

(2013-06-24 02:01:28) Information: Reloading..........

(2013-06-24 02:01:30) Information: Slow down logging. Log every <10> seconds.

(2013-06-24 02:01:30) Information: Reloading

(2013-06-24 02:01:44) Information: Reloading.

(2013-06-24 02:01:58) Information: Reloading..

(2013-06-24 02:02:10) Information: Reloading...

(2013-06-24 02:02:24) Information: Reloading....

(2013-06-24 02:02:42) Information: Reloading.....

(2013-06-24 02:02:56) Information: Reloading......

(2013-06-24 02:03:14) Information: Reloading.......

(2013-06-24 02:03:28) Information: Reloading........

(2013-06-24 02:03:43) Information: Reloading.........

(2013-06-24 02:03:59) Information: Reloading..........

(2013-06-24 02:04:08) Information: The Source Document reload complete. DocumentPath=E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw

(2013-06-24 02:04:08) Information: Memory Allocation Delta for this file=34.54 Mb. Available Physical Memory Before Reload=3487.85 Mb. Available Physical Memory After Reload=3418.63 Mb. Total Physical Memory=3418.63 Mb.

(2013-06-24 02:04:08) Error: The Source Document was NOT reloaded successfully. DocumentPath=E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw.

(2013-06-24 02:04:08) Information: Closing the document.

(2013-06-24 02:04:09) Information: Closed the QlikView Engine successfully. ProcessID=5584

(2013-06-24 02:04:09) Error: The task "Auditoria/Auditoria_Usuarios SAP.qvw" failed. Exception:

(2013-06-24 02:04:09) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw.

(2013-06-24 02:04:09) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2013-06-24 02:04:09) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-06-24 02:04:09) Error:    --- End of inner exception stack trace ---

(2013-06-24 02:04:09) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-06-24 02:04:09) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-06-24 02:04:09) Error:    --- End of inner exception stack trace ---

(2013-06-24 02:04:09) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-06-24 02:04:09) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-06-24 02:04:09) Information: Task Execute Duration=00:04:09.4218750

(2013-06-24 02:04:09) Information: Sending Alert mail

(2013-06-24 02:04:09) Information: TaskResult.status=Finished

(2013-06-24 02:04:09) Information: Notifying all triggers of new state:FinishedWithErrors

(2013-06-24 02:04:09) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2013-06-24 02:04:09) Information: Saving Task Result

Y en el log de Windows la caida se observa con el sgte error:

The task "Auditoria/Auditoria_Usuarios SAP.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\Qlikview Storage\Private Data\In Production\Auditoria\Auditoria_Usuarios SAP.qvw.

   at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

   at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

   --- End of inner exception stack trace ---

   at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   --- End of inner exception stack trace ---

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)


log application.jpg

Me podrian dar alguna idea del motivo de esta caidas??

Gracias!!!

Marcia