Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ayuda. Problema con Recarga Automática en servidor

Hola que tal?, estoy tratando de recargar en el server el QVW que se conecta por ODBC a SQL y genera los QVD necesarios. El problema es que en TASK el status de este archivo es FAILED.

Agradezco su ayuda.

Este es el log que entrega:

(2015-10-29 16:49:44) Information: Starting task 'Carga/Caracterizacion/1 Carga Caracterizacion.qvw'. Id:3a3294d8-1301-4676-8bf4-ef85a7edb493. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2015-10-29 16:49:44) Information: Entering Task Execution.

(2015-10-29 16:49:44) Information: ClusterID=1

(2015-10-29 16:49:44) Information: QDSID=f5de5171-2818-e181-9f8d-f9e5e1e850fa

(2015-10-29 16:49:44) Information: TaskID=3a3294d8-1301-4676-8bf4-ef85a7edb493

(2015-10-29 16:49:44) Information: MaxRunTime=08:46:00

(2015-10-29 16:49:44) Information: MachineName=WIN-8I26KPCHN42

(2015-10-29 16:49:44) Information: Max attempts:1

(2015-10-29 16:49:44) Information: Current Attempt=0

(2015-10-29 16:49:44) Information: Task Dependencies are OK

(2015-10-29 16:49:44) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2015-10-29 16:49:44) Information: Opening "D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw"

(2015-10-29 16:49:44) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2015-10-29 16:49:44) Information: Max retries:5

(2015-10-29 16:49:44) Information: Attempt:01

(2015-10-29 16:49:46) Information: Opened the QlikView Engine successfully. ProcessID=15200

(2015-10-29 16:49:46) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=4.

(2015-10-29 16:49:46) Information: Loading document "D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw" (0.23 Mb)

(2015-10-29 16:49:46) Information: Physical FileSize=0.23 Mb. Memory Allocation Delta for this file=4.20 Mb. Available Physical Memory Before Open=20291.02 Mb. Available Physical Memory After Open=20283.77 Mb. Total Physical Memory=32722.54 Mb.

(2015-10-29 16:49:46) Information: Attempted to load the document without data.

(2015-10-29 16:49:46) Information: The document was loaded successfully.

(2015-10-29 16:49:46) Information: Document was opened successfully

(2015-10-29 16:49:46) Information: Starting reload

(2015-10-29 16:49:46) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2015-10-29 16:49:46) Information: The Source Document is being reloaded. DocumentPath=D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw

(2015-10-29 16:49:46) Information: Waiting for the document log "D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw" to become available.. Check until 29/10/2015 16:49:50

(2015-10-29 16:49:46) Information: Found a document log. FileName=D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw.log

(2015-10-29 16:49:46) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20151029\164944 - Carga_Caracterizacion_1 Carga Caracterizacion.qvw\DocumentLog.txt

(2015-10-29 16:49:46) Information: The Source Document reload complete. DocumentPath=D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw

(2015-10-29 16:49:46) Information: Memory Allocation Delta for this file=1.77 Mb. Available Physical Memory Before Reload=20283.76 Mb. Available Physical Memory After Reload=20273.68 Mb. Total Physical Memory=20273.68 Mb.

(2015-10-29 16:49:46) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw.

(2015-10-29 16:49:47) Information: Closing the document.

(2015-10-29 16:49:47) Information: Closed the QlikView Engine successfully. ProcessID=15200

(2015-10-29 16:49:47) Error: The task "Carga/Caracterizacion/1 Carga Caracterizacion.qvw" failed. Exception:

(2015-10-29 16:49:47) 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=D:\QLIKVIEWUV\MODELO DE CARGA\Caracterizacion\1 Carga Caracterizacion.qvw.

(2015-10-29 16:49:47) Error: en QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-10-29 16:49:47) Error: en QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-10-29 16:49:47) Error: --- Fin del seguimiento de la pila de la excepción interna ---

(2015-10-29 16:49:47) Error: en QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-10-29 16:49:47) Error: en QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-10-29 16:49:47) Error: --- Fin del seguimiento de la pila de la excepción interna ---

(2015-10-29 16:49:47) Error: en QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-10-29 16:49:47) Error: en QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-10-29 16:49:47) Information: Task Execute Duration=00:00:02.9484052

(2015-10-29 16:49:47) Information: TaskResult.status=Finished

(2015-10-29 16:49:47) Information: Notifying all triggers of new state:FinishedWithErrors

(2015-10-29 16:49:47) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2015-10-29 16:49:47) Information: Saving Task Result

1 Solution

Accepted Solutions
Joaquin_Lazaro
Partner - Specialist II
Partner - Specialist II

Hola JOB:

En la pestaña General de las propiedades del documento (Ctrl + Alt + D) marca la opción generar log y recarga el documento otra vez.

Esto generará un fichero txt en la misma carpeta del documento donde tendrás más información

Saludos

Joaquín

View solution in original post

4 Replies
Joaquin_Lazaro
Partner - Specialist II
Partner - Specialist II

Hola JOB:

En la pestaña General de las propiedades del documento (Ctrl + Alt + D) marca la opción generar log y recarga el documento otra vez.

Esto generará un fichero txt en la misma carpeta del documento donde tendrás más información

Saludos

Joaquín

Joaquin_Lazaro
Partner - Specialist II
Partner - Specialist II

Hola JOB:

Aquí tienes un enlace Script Diagnostics using Qlikview Components | Qlikview Cookbook donde explica unas cuantas alternativas para pulir/mejorar las técnicas de anotación y depuración del script.

Saludos

Joaquín

Not applicable
Author

Muchas Gracias Joaquín, en el Log aparece que es problema de la conexión a SQL. Faltaba crear con perfil de administrador, una ODBC de sistema en el servidor.

Nuevamente gracias

Saludos

Joaquin_Lazaro
Partner - Specialist II
Partner - Specialist II

Perfecto.

Los permisos de acceso a datos son una fuente de problemas.

Saludos

Joaquín