0 Replies Latest reply: Jun 24, 2013 10:04 AM by Marcia Orjeda Ramirez RSS

    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