Console error

[#1]

Hi.

I'm trying to run automatically some qvw on the Qlikview console, but the system is generating an error that I don't understand. The message is (the error is in red words):

(2014-07-16 10:04:16) Information: Entering Task Execution.

(2014-07-16 10:04:16) Information: ClusterID=1

(2014-07-16 10:04:16) Information: QDSID=615eecd9-4e61-2401-5d26-173c04fc065f

(2014-07-16 10:04:16) Information: TaskID=1870a113-e346-40e3-839b-1ccbe0c03c1c

(2014-07-16 10:04:16) Information: MaxRunTime=06:00:00

(2014-07-16 10:04:16) Information: MachineName=SRVQLIKLVIEW

(2014-07-16 10:04:16) Information: Max attempts:1

(2014-07-16 10:04:16) Information: Current Attempt=0

(2014-07-16 10:04:16) Information: Task Dependencies are OK

(2014-07-16 10:04:16) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2014-07-16 10:04:16) Information: Opening "C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw"

(2014-07-16 10:04:16) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

(2014-07-16 10:04:16) Information: Max retries:5

(2014-07-16 10:04:16) Information: Attempt:01

(2014-07-16 10:04:17) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=81

(2014-07-16 10:04:17) Information: Loading document "C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw" (1.60 Mb)

(2014-07-16 10:04:17) Information: Physical FileSize=1.60 Mb. Memory Allocation Delta for this file=15.91 Mb. Available Physical Memory Before Open=237488.18 Mb. Available Physical Memory After Open=237460.85 Mb. Total Physical Memory=262080.57 Mb.

(2014-07-16 10:04:17) Information: Attempted to load the document without data.

(2014-07-16 10:04:17) Information: The document was loaded successfully.

(2014-07-16 10:04:17) Information: Document was opened successfully

(2014-07-16 10:04:17) Information: Starting reload

(2014-07-16 10:04:17) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2014-07-16 10:04:17) Information: Waiting for the document log "C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw" to become available..

(2014-07-16 10:04:17) Information: The Source Document is being reloaded. DocumentPath=C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw

(2014-07-16 10:04:17) Information: Found a document log. FileName=C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw.log

(2014-07-16 10:04:17) Information: Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20140716\100416 - CT_GIROS.Qvw_3. ExtracionaGiros.qvw\DocumentLog.txt

(2014-07-16 10:04:18) Information: Reloading.

(2014-07-16 10:04:19) Information: The Source Document reload complete. DocumentPath=C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw

(2014-07-16 10:04:19) Information: Memory Allocation Delta for this file=75.25 Mb. Available Physical Memory Before Reload=237460.84 Mb. Available Physical Memory After Reload=237427.05 Mb. Total Physical Memory=237427.05 Mb.

(2014-07-16 10:04:19) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw.

(2014-07-16 10:04:19) Information: Closing the document.

(2014-07-16 10:04:20) Information: Closed the QlikView Engine successfully. ProcessID=9672

(2014-07-16 10:04:20) Error: The task "CT_GIROS.Qvw/3. ExtracionaGiros.qvw" failed. Exception:

(2014-07-16 10:04:20) 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=C:\1F_3 GIROS CT\QVW\3. ExtracionaGiros.qvw.

(2014-07-16 10:04:20) Error:    en QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-07-16 10:04:20) Error:    en QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-07-16 10:04:20) Error:    --- Fin del seguimiento de la pila de la excepción interna ---

(2014-07-16 10:04:20) Error:    en QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-07-16 10:04:20) Error:    en QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-07-16 10:04:20) Error:    --- Fin del seguimiento de la pila de la excepción interna ---

(2014-07-16 10:04:20) Error:    en QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-07-16 10:04:20) Error:    en QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-07-16 10:04:20) Information: Task Execute Duration=00:00:03.5077574

(2014-07-16 10:04:20) Information: TaskResult.status=Finished

(2014-07-16 10:04:20) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-07-16 10:04:20) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-07-16 10:04:20) Information: Saving Task Result

This error appear when I try the automatic reload only. I'm going to attach images to console. Thank you very much for your help.

Jairo Medina.

[Giuseppe_Novello]

Jairo,

First, to reload a data you dont need the configurable ODBC unless you are using that as Directory services. I think you are confusing the Configurable ODBC as the database OBDC driver to retrieve data from the database to your Qlikview Document. That should have been establish a connection string within the load script of the document. Now, the problem is maybe the service account doesn't have rights to the database. One way to test it, is to log into the server as the service account and reload the document with developer and see if it fails and then see for the document script log, for the error with a permission error.  Attached is a document that explain how to enable Script log.

Gio

[#3]

Giuseppe,

Thank you for your answer. I'm going to try to do this.

Thank you again!

Jairo Medina