5 Replies Latest reply: Dec 5, 2014 5:58 AM by Steen Schlüter Persson RSS

    Automatic update of document on easyjob server

      Hi Experts

       

      Once I put a document on a Qlikview Server. How can I automatically get the data updated, say on a dayly basis? We have the documents on the server and installed the ODBC client on the server. But we are not able to update... Please not that we do not have a publisher licence.

       

      Thank you for your help!

       

      Jan

        • Re: Automatic update of document on easyjob server
          Alkesh Sharma

          Just schedule an auto re-load from the server itself.

            • Re: Automatic update of document on easyjob server

              Yes, we did that. But the document fails to update...

                • Re: Automatic update of document on easyjob server
                  Alkesh Sharma

                  Check in the log file for the reason for failed reload.

                    • Re: Automatic update of document on easyjob server

                      Hi Alkesh

                       

                      this is the log file:

                       

                      04.12.2014 09:33:09.5855000 Information Starting task 'Auftragseingänge 32.qvw'. Id:dfdd81cf-4e74-4e06-9407-eaaacd28750c. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

                      04.12.2014 09:33:09.6167500 Information Entering Task Execution.

                      04.12.2014 09:33:09.6167500 Information ClusterID=1

                      04.12.2014 09:33:09.6167500 Information QDSID=b4bd7e87-bfd8-9be6-783a-9314dde076c8

                      04.12.2014 09:33:09.6167500 Information TaskID=dfdd81cf-4e74-4e06-9407-eaaacd28750c

                      04.12.2014 09:33:09.6167500 Information MaxRunTime=06:00:00

                      04.12.2014 09:33:09.6167500 Information MachineName=TSCHURI

                      04.12.2014 09:33:09.6167500 Information Max attempts:1

                      04.12.2014 09:33:09.6167500 Information Current Attempt=0

                      04.12.2014 09:33:09.6167500 Information Task Dependencies are OK

                      04.12.2014 09:33:10.7417500 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

                      04.12.2014 09:33:10.7730000 Information Opening "C:\ProgramData\QlikTech\Documents\Auftragseingänge 32.qvw"

                      04.12.2014 09:33:10.7730000 Information Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

                      04.12.2014 09:33:10.7730000 Information Max retries:5

                      04.12.2014 09:33:10.7730000 Information Attempt:01

                      04.12.2014 09:33:14.5308125 Information Opened the QlikView Engine successfully. ProcessID=2472

                      04.12.2014 09:33:14.5464375 Information Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=2.

                      04.12.2014 09:33:14.5620625 Information Loading document "C:\ProgramData\QlikTech\Documents\Auftragseingänge 32.qvw" (2.65 Mb)

                      04.12.2014 09:33:15.2026875 Information Physical FileSize=2.65 Mb. Memory Allocation Delta for this file=25.33 Mb. Available Physical Memory Before Open=628.46 Mb. Available Physical Memory After Open=600.40 Mb. Total Physical Memory=2047.55 Mb.

                      04.12.2014 09:33:15.2183125 Information Attempted to load the document without data.

                      04.12.2014 09:33:15.2183125 Information The document was loaded successfully.

                      04.12.2014 09:33:15.2183125 Information Document was opened successfully

                      04.12.2014 09:33:15.2183125 Information Starting reload

                      04.12.2014 09:33:15.2339375 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

                      04.12.2014 09:33:15.2339375 Information The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\Auftragseingänge 32.qvw

                      04.12.2014 09:33:15.2339375 Information The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\Auftragseingänge 32.qvw

                      04.12.2014 09:33:15.2339375 Information Memory Allocation Delta for this file=0.89 Mb. Available Physical Memory Before Reload=600.42 Mb. Available Physical Memory After Reload=599.80 Mb. Total Physical Memory=599.80 Mb.

                      04.12.2014 09:33:15.4839375 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Auftragseingänge 32.qvw.

                      04.12.2014 09:33:15.5464375 Information Closing the document.

                      04.12.2014 09:33:16.1714375 Information Closed the QlikView Engine successfully. ProcessID=2472

                      04.12.2014 09:33:16.2183125 Error The task "Auftragseingänge 32.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Auftragseingänge 32.qvw.  ||    bei QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) ||    bei QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) ||    --- Ende der internen Ausnahmestapelüberwachung --- ||    bei QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) ||    bei QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) ||    --- Ende der internen Ausnahmestapelüberwachung --- ||    bei QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) ||    bei QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

                      04.12.2014 09:33:16.2183125 Information Task Execute Duration=00:00:06.6015625

                      04.12.2014 09:33:16.2183125 Information TaskResult.status=Finished

                      04.12.2014 09:33:16.2183125 Information Notifying all triggers of new state:FinishedWithErrors

                      04.12.2014 09:33:16.2339375 Information Notifying all triggers of new state:FinishedWithErrors - completed

                      04.12.2014 09:33:16.2495625 Information Saving Task Result

                       

                      Does that tell anything to you?

                        • Re: Automatic update of document on easyjob server
                          Steen Schlüter Persson

                          Hi,

                           

                          First of all, you need to ensure that the account running your QV server service has access to the source data your ODBC connection points to.

                          Secondly, if you have set up an ODBC connection on the server, then it's best to create it as a SystemDSN so all users logging on to the server can use the connection.

                           

                          If you haven't tried it already, then a good tip is to log on to the server as the user running your QV service and then try reloading the document. That will tell you if the ODBC connection is ok and if the user has access to the data.

                           

                          /Steen