23 Replies Latest reply: Mar 14, 2012 12:47 PM by Adam Abwat-Johnson RSS

    QV11 Server Logging

    Adam Abwat-Johnson

      Hi,

       

      I'm sure I'm missing something obvious but I could do with someone pointing it out!

       

      I am trying to find out why a document is failing to reload using the QlikView Server but succeeds in the full client. Ok, so the user account is different for the logged on user in the full client and the server service but I can't yet get to the bottom of the problem yet as I have one to get over first.

       

      I can't seem to generate a log file for the document that is failing to reload.

       

      I have enabled logging on the QV Server (System tab -> Server Name -> Logging tab -> Enable Audit Logging)

      I have enabled logging on the document itself (Document Properties)

       

      I look in the C:\ProgramData\QlikTech\QlikViewServer directory and no log files there and neither in the directory where the document itself is. One thing to note is that when I reload using the full client the logging works (although it is using a different user account to access the document I assume).

       

      Please help!

        • Re: QV11 Server Logging

          I am out of the office until 03/14/2012.

           

          I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

           

           

          Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - QV11 Server Logging" sent on 13.03.2012 16:55:47.

           

          This is the only notification you will receive while this person is away.

          --

           

          Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

           

          Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

            • QV11 Server Logging
              Adam Abwat-Johnson

              Legend.

                • Re: QV11 Server Logging

                  I am out of the office until 03/14/2012.

                   

                  I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

                   

                   

                  Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: QV11 Server Logging" sent on 13.03.2012 17:05:44.

                   

                  This is the only notification you will receive while this person is away.

                  --

                   

                  Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

                   

                  Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

              • QV11 Server Logging
                Gary Strader

                Are you using Server or Publisher to reload?  You might check in SourceDocuments if you're using Publisher.  Also, Publisher saves a copy of the document reload log in its log folder structure.

                 

                What version of QlikView Desktop/Server/Publisher are you using?

                  • Re: QV11 Server Logging

                    I am out of the office until 03/14/2012.

                     

                    I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

                     

                     

                    Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: QV11 Server Logging" sent on 13.03.2012 18:55:19.

                     

                    This is the only notification you will receive while this person is away.

                    --

                     

                    Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

                     

                    Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

                    • QV11 Server Logging
                      Adam Abwat-Johnson

                      A bit more info!

                       

                      Gary,

                       

                      In response to your post I'm using Server to reload the documents. The build number is 11.0.11154.0 on a Windows Server 2008 R2 Standard SP1 64-bit server.

                       

                      Bill,

                       

                      Have ticked the box generate log file and have opened the report in full client, for which I am using a seperate user account and the log file creates ok. I am going to assign the 1 full licence to the service account to see if this makes a difference.

                       

                      Rob,

                       

                      I wouldn't say it was a large document. I don't think it is a size issue though as this is an update to an existing report which is reloading fine (not sure if it is creating a log file though!!).

                        • QV11 Server Logging
                          Adam Abwat-Johnson

                          I'm thinking that maybe I'm not getting something right in my head.

                           

                          I have logged on using the account for server service that I have set up. When I open the QlikView client it opens as a Personal Edition. Is this correct? We have a server licence applied but does this have any effect over the account used for the service when opening the full QV client? I may well be getting the two mixed up.

                           

                          Chris

                            • QV11 Server Logging
                              Rob Wunderlich

                              If you open Qlikview Developer with the service account, that account will have to be assigned a User CAL and license lease just like when you use your personal userid.

                               

                              The Qlikview Server license only authorizes the server code, it does not apply to the Developer client.

                               

                              Reloads run through QV Server do not require a user CAL license be assigned to the service account.

                               

                              Check the TaskLog for the server reload to see if there are any useful messages. You can find the logs in

                              C:\ProgramData\QlikTech\DistributionService\1\Log

                               

                              -Rob

                              http://robwunderlich.com

                        • Re: QV11 Server Logging

                          I had similar problem in QV 10 SR3. I expand shared memory area in register.

                          I did:

                          1. run regedit

                          2. find SharedSection (edit--->find)

                          3. inside you have - SharedSection = 1024,20480,512)  --- (512 or more)

                          4. right click--->Modify

                          5. last value-512 (or what you have) multiply by 2   (512* 2 = 1024)

                          6. if needed multiplay by two again....or more, demends how much memory you have.

                           

                          Worked for me.

                            • Re: QV11 Server Logging

                              I am out of the office until 03/14/2012.

                               

                              I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

                               

                               

                              Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: QV11 Server Logging" sent on 13.03.2012 19:06:02.

                               

                              This is the only notification you will receive while this person is away.

                              --

                               

                              Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

                               

                              Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

                            • Re: QV11 Server Logging
                              Bill Britt

                              To start change the service accounts to your user account and see if that will allow the job to run. To get a document log you have to enable it in Document properties.

                               

                              log.jpg

                                • Re: QV11 Server Logging

                                  I am out of the office until 03/14/2012.

                                   

                                  I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

                                   

                                   

                                  Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: QV11 Server Logging" sent on 13.03.2012 19:32:23.

                                   

                                  This is the only notification you will receive while this person is away.

                                  --

                                   

                                  Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

                                   

                                  Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

                                • QV11 Server Logging
                                  Rob Wunderlich

                                  Is this a large document? There is an outstanding bug in qv11 where documents that take too long to load from disk timeout and fail. The symptom is a "document failed to load..." message in the tasklog.

                                   

                                  Rob

                                    • Re: QV11 Server Logging

                                      I am out of the office until 03/14/2012.

                                       

                                      I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

                                       

                                       

                                      Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: QV11 Server Logging" sent on 13.03.2012 21:22:28.

                                       

                                      This is the only notification you will receive while this person is away.

                                      --

                                       

                                      Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

                                       

                                      Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

                                      • QV11 Server Logging
                                        Bill Britt

                                        What is the BugID? I can't find a bug for this issue.

                                          • Re: QV11 Server Logging

                                            I am out of the office until 03/14/2012.

                                             

                                            I will be out of office today for CSR (Corporate Social Responsibility). For any urgent request or escalation, kindly contact  Nick-rcm Price or Jannette Lobemeier. Thanks

                                             

                                             

                                            Note: This is an automated response to your message  "[Deployment and Management (Server/Publisher/AJAX/IE/Web Parts)] - Re: QV11 Server Logging" sent on 13.03.2012 21:27:40.

                                             

                                            This is the only notification you will receive while this person is away.

                                            --

                                             

                                            Informationen (einschließlich Pflichtangaben) zu einzelnen, innerhalb der EU tätigen Gesellschaften und Zweigniederlassungen des Konzerns Deutsche Bank finden Sie unter http://www.deutsche-bank.de/de/content/pflichtangaben.htm. Diese E-Mail enthält vertrauliche und/ oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

                                             

                                            Please refer to http://www.db.com/en/content/eu_disclosures.htm for information (including mandatory corporate particulars) on selected Deutsche Bank branches and group companies registered or incorporated in the European Union. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

                                            • QV11 Server Logging
                                              Rob Wunderlich

                                              Bill,

                                               

                                              I may have overspoke when I said there was an outstanding bug. "Known issue" may be a more accurate description.

                                              http://community.qlik.com/message/185729#185729

                                               

                                              I have a customer with the same problem and he worked around it by loading a reduced copy as explained in the post. I sent the customer to QT support but don't know yet if he has a confirmed BugId.

                                               

                                              -Rob