19 Replies Latest reply: May 13, 2011 9:26 AM by Erich Shiino

Monitoring a web QV document

pscorca69 May 11, 2011 6:29 AM

Hi,

I've published a QV document on the QV web server and I need to monitor his behaviour. Is there any log that I can see?

Thanks

Monitoring a web QV document

Ashfaq Mohammed May 11, 2011 6:46 AM (in response to pscorca69 )

Hi

you can see the logs forn the paths mentioned below

C:\ProgramData\QlikTech\QlikViewServer

or you can config a server moniter app to see the performance and app usage of all the documents you have in your qlikview server.

hope that helps

Regards
ASHFAQ
Like Show 0 Likes (0)

Actions
- Monitoring a web QV document
  
  pscorca69 May 11, 2011 6:55 AM (in response to Ashfaq Mohammed )
  
  Ok, I can see a log for the Sessions and another for the Performances.
  Where document execution info are saved?
  
  Thanks
  
  Like Show 0 Likes (0)
  
  Actions
  - Monitoring a web QV document
    
    Erich Shiino May 11, 2011 7:05 AM (in response to pscorca69 )
    
    For document reload execution, you need to enable it on your document.
    At QV Desktop go to settings -> Document Properties -> General Tab ->
    Check the box of generate log file on the right.
    
    After any reload (manually or by the server) a log file will be generated at the same folder as the .qvw the name will be the name of the .qvw but with the extension .log
    
    Rgds,
    
    Erich
    
    Like Show 0 Likes (0)
    
    Actions
    - Monitoring a web QV document
      
      pscorca69 May 11, 2011 7:28 AM (in response to Erich Shiino )
      
      Ok, on the QV server I cannot see any log files named as myQVDocument.log.
      
      Thanks
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: Monitoring a web QV document
        
        Erich Shiino May 11, 2011 7:39 AM (in response to pscorca69 )
        
        They are generated only during reload they will be together in the folder of the .qvw and sometimes windows will hide the extension and show this as a regular text file.
        
        EDIT: (if you don't reload at least once, there will be no log)
        
        Like Show 0 Likes (0)
        
        Actions
        
        Monitoring a web QV document
        
        pscorca69 May 11, 2011 7:59 AM (in response to Erich Shiino )
        
        Ok, I've reloaded data on my desktop and I can see the log file.
        I have again copied the qvw on the server and I have open the file from Access Point (with IE plugin) and I've execute the macro that reloads data but I cannot any log files on the server.
        
        Thanks
        
        Like Show 0 Likes (0)
        
        Actions
        
        Monitoring a web QV document
        
        Erich Shiino May 11, 2011 8:45 AM (in response to pscorca69 )
        
        Do you need to confirm if the macro is reloading?
        What kind of macro is it? Because I didn't know it was possible to call something like .doreload opening a file on qvserver. Are you using EDX?
        
        Like Show 0 Likes (0)
        
        Actions
        
        Monitoring a web QV document
        
        pscorca69 May 11, 2011 8:56 AM (in response to Erich Shiino )
        
        Hi Erich,
        
        I'm using a VBScript macro to reload data. I can use this macro with IE plugin. But, in general, I want to know how monitoring a web document execution.
        
        Thanks
        
        Like Show 0 Likes (0)
        
        Actions
        
        Monitoring a web QV document
        
        Erich Shiino May 11, 2011 8:59 AM (in response to pscorca69 )
        
        Did you call the reload on the server to generate the log of reload task there?
        
        Like Show 0 Likes (0)
        
        Actions
        
        Monitoring a web QV document
        
        pscorca69 May 11, 2011 9:12 AM (in response to Erich Shiino )
        
        I press on the button to reload on a sheet of my web document.
        But this is a specific issue. In general, I'd like to know how monitoring a web QV document.
        
        Thanks
        
        Like Show 0 Likes (0)
        
        Actions
Monitoring a web QV document

Clever Anjos May 11, 2011 8:35 AM (in response to pscorca69 )

I´ve sugest to use "Ops Monitor", it´s a free QV app (search in qlik.com) we use at our production enviroment and does a great job.
Like Show 0 Likes (0)

Actions
- Monitoring a web QV document
  
  pscorca69 May 11, 2011 8:53 AM (in response to Clever Anjos )
  
  Hi Clever,
  I've searched the OPS Monitor on qlik.com but unsuccessfully.
  
  Thanks
  
  Like Show 0 Likes (0)
  
  Actions
  - Monitoring a web QV document
    
    pscorca69 May 11, 2011 9:27 AM (in response to pscorca69 )
    
    Hi Clever,
    
    do you give me OPS monitor for QV 10, please?
    
    Many thanks
    
    Like Show 0 Likes (0)
    
    Actions
  - Re: Monitoring a web QV document
    
    Clever Anjos May 11, 2011 10:41 AM (in response to pscorca69 )
    
    Let´s see if i can attach a file.
    
    Just open the script, ajust to your log files
    
    Atenciosamente,
                                                                                    Cléver Anjos
                                                                     Assessoria
                                                              clever@swb.com.br
                                                                                    9992-8765 / 3291-6600
                                                                                    (See attached file: QlikView Ops Monitor v9 - local.qvw)
    From:     pscorca69 <qliktech@sgaur.hosted.jivesoftware.com>
    To:     Clever Anjos <clever@swb.com.br>
    Date:     11/05/2011 09:53
    Subject:      - Re: Monitoring a web QV document
    
    QlikView Ops Monitor v9 - local.qvw 445.2 K
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Monitoring a web QV document
      
      pscorca69 May 11, 2011 11:39 AM (in response to Clever Anjos )
      
      Thanks Clever.
      
      It seems that the qv monitors the performance statistics. I think to have a log register to captur run-time error.
      
      However, in the script I see these variables:
      LET QVPRpath = 'C:\Documents and Settings\All Users\Application Data\QlikTech\Publisher\CommandCenter\QVPR';
      //LET QVPLogPath = 'C:\Documents and Settings\All Users\Application Data\QlikTech\Publisher\Qlikview Distribution Service';
      LET QVPLogPath = 'C:\Documents and Settings\All Users\Application Data\QlikTech\DistributionService';
      LET QVSLogPath = 'C:\Documents and Settings\qlikview\Desktop\Logs';
      LET metaPath='D:\Qlikview\QVD\MONITOR';
      LET devmetaPath='D:\Qlikview\QVD\MONITOR';
      
      Why there are two QVPLogPath assignments?
      
      but on my server with Windows Server 2008 I have another folder structure in attach
      
      Moreover, I have the version 10 and not 9.
      
      Thanks
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: Monitoring a web QV document
        
        Clever Anjos May 11, 2011 12:16 PM (in response to pscorca69 )
        
        There´s no version 10 of this app, yet.
        Just set the variables according your app.
        
        Atenciosamente,
                                                                                        Cléver Anjos
                                                                         Assessoria
                                                                  clever@swb.com.br
                                                                                        9992-8765 / 3291-6600
                                                                                        (Embedded image moved to file:
                                        pic22520.gif)SWB
        SWB Soluções Integradas Ltda | Av. Cesário Alvim, 2258 - CEP: 38400-696
        - Uberlândia-MG Brasil - www.swb.com.br
        As informações contidas neste e-mail e quaisquer documentos nele anexados
        podem ser particulares e são propriedade confidencial da SWB Soluções
        Integradas. Se você não for o destinatário ou se recebeu esta mensagem
        irregularmente ou por erro, por favor, apague o e-mail e avise o
        remetente o mais rápido possível. Este e-mail não pode ser divulgado,
        armazenado, utilizado, publicado ou copiado por qualquer um que não o(s)
        seu(s) destinatário(s).
        From:     pscorca69 <qliktech@sgaur.hosted.jivesoftware.com>
        To:     Clever Anjos <clever@swb.com.br>
        Date:     11/05/2011 12:34
        Subject:      - Re: Monitoring a web QV document
        
        pic22520.gif 4.2 K
        
        Like Show 0 Likes (0)
        
        Actions
      - Re: Monitoring a web QV document
        
        Erich Shiino May 11, 2011 12:29 PM (in response to pscorca69 )
        
        Hi,
        It was here yesterday, earlier today is wasn`t here.
        
        It`s back now:
        http://community.qlik.com/qlikviews/1017
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Monitoring a web QV document
        
        Christian Conejero May 13, 2011 7:49 AM (in response to Erich Shiino )
        
        Hi:
        are you refering to one of these? Attached.
        
        VA QV9 Server Monitoring - Clean.qvw 973.5 K
        
        QlikView Server Performance.qvw 3.4 MB
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Monitoring a web QV document
        
        Erich Shiino May 13, 2011 9:26 AM (in response to Christian Conejero )
        
        Hi,
        I'm sorry it seems that they removed the post and put it back here.
        
        Your files were developed for version 9 (but I was using at least the server performance for v10).
        This is the v10 file (attached)
        
        Next time someone asks it I will post the file and the link...
        
        LINK (as 13/may/2011): http://community.qlik.com/qlikviews/1029
        Regards,
        
        Erich
        
        QV10SystemMonitor.qvw 3.2 MB
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post