22 Replies Latest reply: Apr 25, 2014 3:39 AM by Stéphane PRIN RSS

    Online Dashboard not reloaded

      Hello,

       

      Since last week, i can't see my dashboard modification on Chrome ? (same things for others navigators)

      Here is what i do :

      - I open a .qvw document

      - I do modification

      - I reload the document by pressing Ctrl+R

      - I save the document by pressing Ctrl+S

      - I open the management console and i reload the dashboard

      - I open the document with Chrome but i don't see my modifications ?

      - I reboot QV server => nothing changes

      - i delete the Chrome cache => nothing changes

       

      I always can't see modifications.

       

      Any ideas of my problem ?

       

      Thanks for help.

       

      Stéphane

        • Re: Online Dashboard not reloaded
          Amit Saini

          Hi Stephane,

           

          Did you try  this with other browsers like IE or Mozilla???

           

          Thanks,

          AS

          • Re: Online Dashboard not reloaded
            sivaraj seeman

            Check the qvw document properties,you can find tab called server. Select "server performs refresh automatically" under refresh mode.

            If it not resolved generate log file and check.

            Check your qvw able to connect to database using the provider via console.

            • Re: Online Dashboard not reloaded
              Magnus Larsson

              What is the document path of the document where you make the modification, and what is the folder path where you have your server documents (QMC > System > Setup > QVS > Folders)?


              It's a really strange problem and the only possible explanation I can think of is that you are making the modifcation to one copy of the document, but it might be another copy that is published by the server.

                • Re: Online Dashboard not reloaded

                  Sure it's strange ... some fews days ago everything work fine ...

                  Capture d’écran 2014-04-01 à 10.52.03.pngCapture d’écran 2014-04-01 à 10.51.26.png

                    • Re: Online Dashboard not reloaded
                      Magnus Larsson

                      If you make the change directly in the qvw, and then don't reload from the QMC, does the modifcation then go through?
                      I'm thinking that the change might be overwritten when you reload and distribute the document.

                       

                      When you run the task it will reload the document from the source folder (QMC > System > Setup > Distribution Services > General > Source folder) and if it's set to distribute, it might then overwrite the document that you just edited.

                        • Re: Online Dashboard not reloaded

                          I did a simple modification in my document, then i saved it.

                          when i try to look at it in Chrome i've got an error message because i use restrited access file.

                          so i can't see the result, i need to reopen it and reload and save to see it.

                           

                          and the source folder seems to be ok

                           

                          Capture d’écran 2014-04-01 à 12.03.54.png

                            • Re: Online Dashboard not reloaded

                              But you have mounted a Document folder and are using the same one as a source folder?

                              What if you modify so you have a separate source folder, reload and distribute the document to the mounted folder, that is not source folder

                               

                              And you are using that folder as application data folder as well?

                              You should change that so that you have a isolated Application datafolder that you don´t store qvw at all in.

                               

                              I would start with getting a proper setup so you have everything in order so you know what file is being modifed to what folder.

                               

                              As now, you modify source documents that are also being hosted to Accesspoint

                      • Re: Online Dashboard not reloaded
                        Gino Matteoni

                        Hello I had the same problem a while ago,

                        I changed a dashboard and the change has not appeared online.

                        Also, if I removed a dimension from a table, online I took it off and if I tried to add it again, online did not see me.

                        Solution: Ctrl + C on the modified object-> Removing the object-> Ctrl + V-> Save-> Reload the document from a task on server-> ALL APPEARS MAGICALLY!!!

                        • Re: Online Dashboard not reloaded
                          Bill Britt

                          Hi,

                           

                          Can you post the document log and the task log?

                           

                          Bill

                            • Re: Online Dashboard not reloaded

                              Task Log :

                              04/04/2014 14:00:54.0225117 Information Starting task 'Reload of ROCHE MSM\ROCHE MSM.qvw'. Id:65961ccf-aa77-4678-bc1c-fc9a748b3ed6. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

                              04/04/2014 14:00:54.0225117 Information Entering Task Execution.

                              04/04/2014 14:00:54.0225117 Information ClusterID=1

                              04/04/2014 14:00:54.0225117 Information QDSID=74a8f721-72b2-be00-d6da-5fb9c521a91f

                              04/04/2014 14:00:54.0225117 Information TaskID=65961ccf-aa77-4678-bc1c-fc9a748b3ed6

                              04/04/2014 14:00:54.0225117 Information MaxRunTime=1.00:00:00

                              04/04/2014 14:00:54.0225117 Information MachineName=315411-WEB04

                              04/04/2014 14:00:54.0225117 Information Max attempts:1

                              04/04/2014 14:00:54.0225117 Information Current Attempt=0

                              04/04/2014 14:00:54.0225117 Information Task Dependencies are OK

                              04/04/2014 14:00:54.0225117 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

                              04/04/2014 14:00:54.0225117 Information Opening "C:\QLIKVIEW\Published-Applications\ROCHE MSM\ROCHE MSM.qvw"

                              04/04/2014 14:00:54.0225117 Information Allocating new QlikView Engine. Current usagecount=1 of 4

                              04/04/2014 14:00:54.0225117 Information Max retries:5

                              04/04/2014 14:00:54.0225117 Information Attempt:01

                              04/04/2014 14:00:54.9117133 Information Allocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=417

                              04/04/2014 14:00:54.9117133 Information Loading document "C:\QLIKVIEW\Published-Applications\ROCHE MSM\ROCHE MSM.qvw" (2.32 Mb)

                              04/04/2014 14:00:55.9257151 Information Loading. LoadTime=00:00:01.0140018

                              04/04/2014 14:00:57.9537186 Information Loading. LoadTime=00:00:03.0420053

                              04/04/2014 14:00:58.1565189 Information Physical FileSize=2.32 Mb. Memory Allocation Delta for this file=45.33 Mb. Available Physical Memory Before Open=9359.04 Mb. Available Physical Memory After Open=9310.43 Mb. Total Physical Memory=16378.38 Mb.

                              04/04/2014 14:00:58.1721190 Information Attempted to load the document without data.

                              04/04/2014 14:00:58.1721190 Information The document was loaded successfully.

                              04/04/2014 14:00:58.1721190 Information Document was opened successfully

                              04/04/2014 14:00:58.1721190 Information Starting reload

                              04/04/2014 14:00:58.1877190 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

                              04/04/2014 14:00:58.1877190 Information The Source Document is being reloaded. DocumentPath=C:\QLIKVIEW\Published-Applications\ROCHE MSM\ROCHE MSM.qvw

                              04/04/2014 14:00:58.2189191 Information The Source Document reload complete. DocumentPath=C:\QLIKVIEW\Published-Applications\ROCHE MSM\ROCHE MSM.qvw

                              04/04/2014 14:00:58.2189191 Information Memory Allocation Delta for this file=3.31 Mb. Available Physical Memory Before Reload=9310.41 Mb. Available Physical Memory After Reload=9309.50 Mb. Total Physical Memory=9309.50 Mb.

                              04/04/2014 14:00:58.6089197 Error The Source Document was NOT reloaded successfully. DocumentPath=C:\QLIKVIEW\Published-Applications\ROCHE MSM\ROCHE MSM.qvw.

                              04/04/2014 14:00:58.6245198 Information Closing the document.

                              04/04/2014 14:00:59.2641209 Information Closed the QlikView Engine successfully. ProcessID=7112

                              04/04/2014 14:00:59.2641209 Error The task "Reload of ROCHE MSM\ROCHE MSM.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=C:\QLIKVIEW\Published-Applications\ROCHE MSM\ROCHE MSM.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)

                              04/04/2014 14:00:59.2641209 Information Task Execute Duration=00:00:05.2416092

                              04/04/2014 14:00:59.2641209 Information TaskResult.status=Finished

                              04/04/2014 14:00:59.2641209 Information Notifying all triggers of new state:FinishedWithErrors

                              04/04/2014 14:00:59.2641209 Information Notifying all triggers of new state:FinishedWithErrors - completed

                              04/04/2014 14:00:59.2641209 Information Saving Task Result

                                • Re: Online Dashboard not reloaded
                                  Bill Britt

                                  Hi,

                                   

                                  The reload has failed and that is the reason the document is not being updated.

                                   

                                  6089197 Error The Source Document was NOT reloaded successfully.

                                   

                                  Need to log at the document log to see where the failure happen in the script. If there is section access applied to the document you need to make sure the service account has full rights to all the data.

                                   

                                  Bill

                                    • Re: Online Dashboard not reloaded

                                      Hi,

                                       

                                      I configure dashboard to generate log by setting QV -> "Paramètres" -> "Propriété du document" -> Général -> "Générer un fichier journal" (my version is a french version)

                                       

                                      When i reload the document from QV it generate a log file (and there is no error reported)

                                      but when i reload the document from QMC that failed but not log file generated

                                       

                                      Did i made a mistake somewhere ?

                                       

                                      Stéphane

                                        • Re: Online Dashboard not reloaded
                                          Bill Britt

                                          HI,

                                           

                                          Make sure you enable the logging in the document that is under the source folder and not the one in the root folder.

                                           

                                          Bill

                                            • Re: Online Dashboard not reloaded

                                              Here is the log (i cut some line about some qvd loaded because it's always the same things)

                                              25/04/2014 09:13:50:      Execution started.

                                              25/04/2014 09:13:50:      QlikView Version:11.00.11282.0

                                              25/04/2014 09:13:50:      CPU Target                    x64

                                              25/04/2014 09:13:50:      Operating System              Windows Server 2008 R2 Standard  (64 bit edition)

                                              25/04/2014 09:13:50:      Wow64 mode                    Not using Wow64

                                              25/04/2014 09:13:50:      MDAC Version                  6.1.7600.16385

                                              25/04/2014 09:13:50:      MDAC Full Install Version     6.1.7600.16385

                                              25/04/2014 09:13:50:      PreferredCompression          2

                                              25/04/2014 09:13:50:      EnableParallelReload          1

                                              25/04/2014 09:13:50:      ParallelizeQvdLoads           1

                                              25/04/2014 09:13:50:      AutoSaveAfterReload           0

                                              25/04/2014 09:13:50:      BackupBeforeReload            0

                                              25/04/2014 09:13:50:      EnableFlushLog                0

                                              25/04/2014 09:13:50:      SaveInfoWhenSavingFile        0

                                              25/04/2014 09:13:50:      UserLogfileCharset            0

                                              25/04/2014 09:13:50:      OdbcLoginTimeout              -1

                                              25/04/2014 09:13:50:      OdbcConnectionTimeout         -1

                                              25/04/2014 09:13:50:      ScriptWantsDbWrite            false

                                              25/04/2014 09:13:50:      ScriptWantsExe                false

                                              25/04/2014 09:13:50:      LogFile CodePage Used:        1252

                                              25/04/2014 09:13:50: 0002  SET ThousandSep=' '

                                              25/04/2014 09:13:50: 0003  SET DecimalSep=','

                                              25/04/2014 09:13:50: 0004  SET MoneyThousandSep=' '

                                              25/04/2014 09:13:50: 0005  SET MoneyDecimalSep=','

                                              25/04/2014 09:13:50: 0006  SET MoneyFormat='# ##0,00 €;-# ##0,00 €'

                                              25/04/2014 09:13:50: 0007  SET TimeFormat='hh:mm:ss'

                                              25/04/2014 09:13:50: 0008  SET DateFormat='DD/MM/YYYY'

                                              25/04/2014 09:13:50: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

                                              25/04/2014 09:13:50: 0010  SET MonthNames='jan.;feb.;mar.;apr.;may;jun.;jul.;aug.;sept.;oct.;nov.;dec.'

                                              25/04/2014 09:13:50: 0011  SET DayNames='mon.;tue.;wed.;thu.;fri.;sat.;sun.'

                                              25/04/2014 09:13:50: 0014  SET vQVD = qvd

                                              25/04/2014 09:13:50: 0015  SET vFileMap = ..\Map\France\MapFrance.qvd

                                              25/04/2014 09:13:50: 0018  SET vFileUserColors = qvd\UserColors_LILLY_SP.qvd

                                              25/04/2014 09:13:50: 0019  SET vFileCountryColors = qvd\CountryColors_LILLY_SP.qvd

                                              25/04/2014 09:13:50: 0020  SET vFileQualifColors = qvd\QualifColors_LILLY_SP.qvd

                                              25/04/2014 09:13:50: 0044  SET vFileVariables = C:\scripts\qlikview\WCC_Formulas.xls

                                              25/04/2014 09:13:50: 0048  SET vFileAccess = Section_Access.xlsx

                                              25/04/2014 09:13:50: 0050  Section Access

                                              25/04/2014 09:13:50: 0051  Access:

                                              25/04/2014 09:13:50: 0052  LOAD * INLINE [

                                              25/04/2014 09:13:50: 0053      ACCESS, NTNAME, GROUP_TAB, GROUP_PRODUIT

                                              25/04/2014 09:13:50: 0054      ADMIN, XXX, ALL, ALL

                                              25/04/2014 09:13:50: 0055      ADMIN, XXX, ALL, ALL

                                              25/04/2014 09:13:50: 0056      ADMIN, XXX, ALL, ALL

                                              25/04/2014 09:13:50: 0057      ADMIN, XXX, ALL, ALL

                                              25/04/2014 09:13:50: 0058  ]

                                              25/04/2014 09:13:50:        4 fields found: ACCESS, NTNAME, GROUP_TAB, GROUP_PRODUIT, 4 lines fetched

                                              25/04/2014 09:13:50: 0060  CONCATENATE (Access)

                                              25/04/2014 09:13:50: 0061  LOAD

                                              25/04/2014 09:13:50: 0062  'USER' AS ACCESS,

                                              25/04/2014 09:13:50: 0063  NTNAME,

                                              25/04/2014 09:13:50: 0064  upper(TAB) AS GROUP_TAB,

                                              25/04/2014 09:13:50: 0065  upper(PRODUIT) as GROUP_PRODUIT

                                              25/04/2014 09:13:50: 0066  FROM

                                              25/04/2014 09:13:50: 0067  [Section_Access.xlsx]

                                              25/04/2014 09:13:50: 0068  (ooxml, embedded labels, table is Acces)

                                              25/04/2014 09:13:50:        4 fields found: ACCESS, NTNAME, GROUP_TAB, GROUP_PRODUIT, 9 lines fetched

                                              25/04/2014 09:13:50: 0070  Section Application

                                              25/04/2014 09:13:50: 0071  star is *

                                              25/04/2014 09:13:50: 0073  GROUP_TAB:

                                              25/04/2014 09:13:50: 0074  LOAD

                                              25/04/2014 09:13:50: 0075   DISTINCT GROUP_TAB,

                                              25/04/2014 09:13:50: 0076   SubField(GROUP_TAB, ';') AS GROUP_TAB_ITEM

                                              25/04/2014 09:13:50: 0077  RESIDENT Access

                                              25/04/2014 09:13:50:        2 fields found: GROUP_TAB, GROUP_TAB_ITEM, 2 lines fetched

                                              25/04/2014 09:13:50: 0079  GROUP_PRODUIT:

                                              25/04/2014 09:13:50: 0080  LOAD

                                              25/04/2014 09:13:50: 0081   GROUP_PRODUIT,

                                              25/04/2014 09:13:50: 0082   SubField(GROUP_PRODUIT, ';') AS ProduitFilter

                                              25/04/2014 09:13:50: 0083  RESIDENT Access

                                              25/04/2014 09:13:50: 0084  WHERE upper(GROUP_PRODUIT) <> 'ALL'

                                              25/04/2014 09:13:50:        2 fields found: GROUP_PRODUIT, ProduitFilter, 10 lines fetched

                                              25/04/2014 09:13:50: 0087  CONCATENATE(GROUP_PRODUIT)

                                              25/04/2014 09:13:50: 0088  LOAD * INLINE [

                                              25/04/2014 09:13:50: 0089   GROUP_PRODUIT, ProduitFilter

                                              25/04/2014 09:13:50: 0090   ALL, *

                                              25/04/2014 09:13:50: 0091  ]

                                              25/04/2014 09:13:50:        2 fields found: GROUP_PRODUIT, ProduitFilter, 11 lines fetched

                                              25/04/2014 09:13:50: 0103  UserColors:

                                              25/04/2014 09:13:50: 0104  LOAD Red_User,

                                              25/04/2014 09:13:50: 0105       UserColor

                                              25/04/2014 09:13:50: 0106  FROM

                                              25/04/2014 09:13:50: 0107  [qvd\UserColors_LILLY_SP.qvd]

                                              25/04/2014 09:13:50: 0108  (qvd)

                                              25/04/2014 09:13:50:        2 fields found: Red_User, UserColor, 3 lines fetched

                                              25/04/2014 09:13:50: 0110  CountryColors:

                                              25/04/2014 09:13:50: 0111  LOAD Country,

                                              25/04/2014 09:13:50: 0112       CountryColor

                                              25/04/2014 09:13:50: 0113  FROM

                                              25/04/2014 09:13:50: 0114  [qvd\CountryColors_LILLY_SP.qvd]

                                              25/04/2014 09:13:50: 0115  (qvd)

                                              25/04/2014 09:13:50:        2 fields found: Country, CountryColor, 1 lines fetched

                                              25/04/2014 09:13:50: 0117  QualifColors:

                                              25/04/2014 09:13:51: 0459  Variables:

                                              25/04/2014 09:13:51: 0460  LOAD Variable,

                                              25/04/2014 09:13:51: 0461       Expression,

                                              25/04/2014 09:13:51: 0462       Usage

                                              25/04/2014 09:13:51: 0463  FROM

                                              25/04/2014 09:13:51: 0464  [C:\scripts\qlikview\WCC_Formulas.xls]

                                              25/04/2014 09:13:51: 0465  (biff, embedded labels, table is Sheet1$)

                                              25/04/2014 09:13:51:        3 fields found: Variable, Expression, Usage, 40 lines fetched

                                              25/04/2014 09:13:51: 0467  Let vNumberOfRows = NoOfRows('Variables')

                                              25/04/2014 09:13:51: 0469  For vI = 0 to vNumberOfRows - 1

                                              25/04/2014 09:13:51: 0470    Let vVariable_Name = Peek('Variable',vI,'Expression')

                                              25/04/2014 09:13:51: 0471    Let [vNbUsersEquipped] = Peek('Expression',vI,'Expression')

                                              25/04/2014 09:13:51: 0472  Next

                                              25/04/2014 09:13:51: 0470    Let vVariable_Name = Peek('Variable',vI,'Expression')

                                              25/04/2014 09:13:51: 0471    Let [vObjSummary] = Peek('Expression',vI,'Expression')

                                              25/04/2014 09:13:51: 0472  Next

                                              25/04/2014 09:13:51:       $Syn 1 = IdClient+VisitId

                                              25/04/2014 09:13:51:       $Syn 2 = IdProduit+VisitId

                                              25/04/2014 09:13:51:       $Syn 3 = IdProduit+IdClient

                                              25/04/2014 09:13:51:       $Syn 4 = IdProduit+IdClient+VisitId+IdDelegue

                                              25/04/2014 09:13:51:       $Syn 5 = $Syn 1+$Syn 2+$Syn 3+$Syn 4

                                              25/04/2014 09:13:52:      Execution finished.

                                               

                                              so everything seems to be OK no ?