Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
Perfecto.
Los permisos de acceso a datos son una fuente de problemas.
Saludos
Joaquín