37 Replies Latest reply: Oct 23, 2012 8:23 AM by Torben Seebach RSS

    QlikView Governance Dashboard Beta - Pre-Installation Steps

    Michael Tarallo

      Thank you all so far for participating in the download and testing of the QlikView Governance Dashboard 1.0 Beta. To date we have collected a few issues which are currently being investigated and addressed for future versions of the QVGD. In the mean-time I suggested you keep these steps in mind.

       

      The following steps are recommended instructions when installing the QlikView Governance Dashboard Beta 1.0.

       

      • If installing on Windows XP or Windows 2003 server
        • Create the following Directory: C:\ProgramData\QlikTech\Governance_1.0Beta
        • Run the installation wizard and change the default install location to: C:\ProgramData\QlikTech\Governance_1.0Beta

       

      • Ensure that QlikView Desktop is not running - check task manager for QV.exe and ensure the process is not running

       

      • Do not use a VM - install on a physical machine

       

      • Do not use directory names that contain spaces for the 'Install Directory’ and ‘Profile Directory’ (see first bullet)

       

      • Uninstall any previous version of the QlikView Governance Dashboard by using the Uninstall utility found in the Add / Remove Programs list

       

      unin.PNG

       

      • If you have installed a Pre-Beta version please remove the Governance folder from: C:\ProgramData\QlikTech

       

       

      • Install the QlikView Governance Dashboard

        Software and instructions found here:

       

      http://market.qlik.com/qlikview-governance-dashboard.html

       

      • Restart the system

       

      • Load the QlikView Governance Dashboard,configure and scan according to the instructions
        • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
          Nick Gan

          Hi Michael,

           

          How do we fix the below?

          Thanks.

           

          Table not found

          DateIsland:

          LOAD

                    1 as MaxID,

                    Max(LoadDate) as MaxLoadDt

          Resident FileList

           

           

          Nick

            • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
              Michael Tarallo

              Hello Nick - this is an issue that has been discovered to effect virtual machines mostly.

               

              We believe that we have isolated the cause of this defect in executing the (QlikView Expressor) QVE Connector.  The defect is believed to be in the QVX protocol’s reply handling logic of QVSR2 and earlier (so it is not a Governance Dashboard or QVE Connector bug).  The QV11 R&D team is looking into this and believes that the fix can possibly be incorporated into a QV11SR2 Update to be released shortly.

               

              We have noticed that the problem is more prevalent on machines with 2 or fewer cores available to QlikView and, in particular, VMs.  Machines with 4 to 8 (or more) cores tend not to create the conditions under which the defective code path is executed.

               

              Hope this helps.

               

              Regards,

               

              Mike T

            • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
              Nick Gan

              Another question, is it ok if we install it in the folder of source folder of QVW? or the installation folder has to be out of the source folder?

                • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                  Michael Tarallo

                  The installation folder for QVGD should be put in its own root or sub-folder structure OUTSIDE of any source folders tthat contain QlikView files (QVD, QVX, QVW) -  if that is what you are referring to.

                   

                  Mike T

                    • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                      Nick Gan

                      Hi Mike,

                       

                      Thanks for the info.

                       

                      I fixed the problem by installing it again OUTSIDE of the source folder.

                      It works fine now. very useful info.

                       

                      Just a comment, the problem i had was from the production server which has 24 cores and 64Gb memory.

                      In contrary, theVM works fine for this dashboard which has 2 cores and 4 Gb.

                       

                      Thanks.

                        • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                          Michael Tarallo

                          Hey Nick - good to know - I will let the PM know this ASAP.

                           

                          So for my clarity:

                           

                          • you experienced the "DateIsland" script error after installing on a "PHYSICAL" machine NOT a VM - when installing the QVGD in the actual folder used for sourcing QV documents? - Correct?

                           

                          • you did not experience the error when installing it on a VM (with less cores) while installing it in the default location provided by the installation wizard: C:\ProgramData\QlikTech\Governance_1.0Beta?  - Correct?

                           

                          If all of this is correct - as you stated - this is contrary to the original thinking.

                           

                          Thanks

                            • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                              Nick Gan

                              Hi Mike,

                               

                              Yes for both. VM works fine for me, just that it takes longer time to complete the load.

                               

                              The issue I had was because i installed it INSIDE the source folder.

                              So normally, it should work perfectly on the first installation.

                               

                              Should share this with your R&D team.

                                • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                                  Bill Markham

                                  Mike

                                   

                                  I am getting the "Table not found.  DateIsland:" error as well with the QlikView Governance Dashboard Beta 1.0.  which was installed as per the installation defaults.

                                   

                                  On a 64 core physical server with 192 GB RAM.

                                   

                                  MS Windows Server 2008 R2 Enterprise Server Service Pack 1.

                                   

                                  QlikView Server 11 SR1

                                   

                                  Any ideas what to do ?

                                   

                                  I can supply any more information / diagnostics on request.

                                   

                                   

                                   

                                  Best Regards,  Bill

                                    • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                                      Michael Tarallo

                                      Thanks Bill. I will investigate. That is now going against all the suspicions in which we originally found this error to occur.

                                       

                                      Mike T

                                      • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                                        Michael Tarallo

                                        Hello Bill - can you check:

                                         

                                        C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\QVX_LastRun

                                         

                                        and look for:

                                         

                                        FullScan.messages.log and/or qvs.log  files.

                                         

                                        See if it/they was/were generated and if so attach it to this discussion?

                                         

                                        Also to verify - you installed QVGD in the default locations such as:

                                         

                                        C:\ProgramData\QlikTech\Governance_1.0Beta

                                         

                                        You did not change the installation paths correct?

                                         

                                        And scanning  paths - look like this: (except your documents directory may be different than mine)

                                         

                                        db1.PNG

                                        Thanks

                                         

                                        Mike T

                                          • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                                            Bill Markham

                                            Mike

                                             

                                             

                                            Two log files attached, from location below which also shows QVGD installed to default location:

                                             

                                            C:\>cd C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\QVX_LastRun

                                             

                                            C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\QVX_LastRun>dir

                                            Volume in drive C has no label.

                                            Volume Serial Number is 74F1-4164

                                             

                                            Directory of C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default\QVX_LastRun

                                             

                                            13/10/2012  11:18    <DIR>          .

                                            13/10/2012  11:18    <DIR>          ..

                                            14/10/2012  08:38            24,486 FullScan.messages.log

                                            14/10/2012  08:38               305 FullScan.statistics.log

                                                           2 File(s)         24,791 bytes

                                                           2 Dir(s)  122,836,922,368 bytes free

                                             

                                             

                                             

                                            Screen shot of configuration below:

                                            QVGD.JPG

                                             

                                            Best Regards,   Bill

                                              • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                                                Michael Tarallo

                                                Hi Bill - I have engineering looking at this - can you please try a few more things?

                                                 

                                                For some reason the etool processes of the Expressor Engine are all failing to load their respective, operator-specific DLLs (e.g. in-datascript.dll).

                                                 

                                                This may have something to do with the configuration of your system but it is hard to tell for certain.  It is possible that the installation encountered errors.

                                                 

                                                We have logged a case in our system.

                                                 

                                                In the mean-time:

                                                 

                                                • provide the 'Governance Dashboard.qvw.log' file from C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default
                                                  (to verify that the CUSTOM CONNECT statement is being properly formulated (i.e. that this is not an issue in the load script's logic that formulates the CUSTOM CONNECT property list))
                                                • provide the 'expressorQlikViewConnector.log' file in the user's C:\Users\<user_account_name>\AppData\Roaming\expressor directory
                                                • confirm that the DLLs (e.g. in-datascript.dll, copy.dll, filter.dll) are actually present in his C:\ProgramData\QlikTech\Governance_1.0Beta\engine\lib directory.
                                                • let us know whether you also has Expressor Studio installed
                                                • check your Windows EventViewer logs for DLL load violations that might have been generated by the operator DLLs
                                                • attempt to uninstall all Expressor software and the Governance Dashboard and reinstall the Governance Dashboard, reboot and re-try the scan AFTER doing the steps above

                                                Thanks

                                                 

                                                Mike T

                                                  • Re: QlikView Governance Dashboard Beta - Pre-Installation Steps
                                                    Bill Markham

                                                    Mike

                                                     

                                                    In answer to your questions:

                                                     

                                                    • provide the 'Governance Dashboard.qvw.log' file from C:\ProgramData\QlikTech\Governance_1.0Beta\profiles\default
                                                      (to verify that the CUSTOM CONNECT statement is being properly formulated (i.e. that this is not an issue in the load script's logic that formulates the CUSTOM CONNECT property list))
                                                      • Attached


                                                    • provide the 'expressorQlikViewConnector.log' file in the user's C:\Users\<user_account_name>\AppData\Roaming\expressor directory
                                                      • Attached

                                                    • confirm that the DLLs (e.g. in-datascript.dll, copy.dll, filter.dll) are actually present in his C:\ProgramData\QlikTech\Governance_1.0Beta\engine\lib directory.
                                                      • C:\ProgramData\QlikTech\Governance_1.0Beta\engine\lib>dir

                                                      • Volume in drive C has no label.

                                                      • Volume Serial Number is 74F1-4164

                                                      • Directory of C:\ProgramData\QlikTech\Governance_1.0Beta\engine\lib

                                                      • 13/10/2012  11:14    <DIR>          .

                                                      • 13/10/2012  11:14    <DIR>          ..

                                                      • 04/10/2012  02:04         2,289,152 buffer.dll

                                                      • 04/10/2012  01:51           256,812 cacert.pem

                                                      • 04/10/2012  01:51             7,168 charset.dll

                                                      • 04/10/2012  02:04         2,640,384 collate.dll

                                                      • 04/10/2012  02:05         2,251,264 consolidate.dll

                                                      • 04/10/2012  02:04         2,252,800 copy.dll

                                                      • 04/10/2012  02:04            17,848 copy.lib

                                                      • 04/10/2012  01:53           545,792 ds.dll

                                                      • 04/10/2012  01:52           203,224 edecimal.lib

                                                      • 04/10/2012  01:51           137,728 eexpat.dll

                                                      • 04/10/2012  01:51         1,061,260 exml.lib

                                                      • 04/10/2012  02:06         2,579,968 filter.dll

                                                      • 04/10/2012  02:06         2,255,872 funnel.dll

                                                      • 04/10/2012  01:51           910,848 iconv.dll

                                                      • 04/10/2012  01:51             3,026 iconv.lib

                                                      • 04/10/2012  02:15         2,610,176 in-datascript.dll

                                                      • 04/10/2012  02:07         2,337,280 in-file.dll

                                                      • 04/10/2012  02:07         2,336,768 in-table.dll

                                                      • 04/10/2012  02:08            17,408 joiner-multi.dll

                                                      • 04/10/2012  02:08         2,649,088 joiner.dll

                                                      • 04/10/2012  01:51           237,568 libcurl.dll

                                                      • 04/10/2012  02:13         2,246,144 null.dll

                                                      • 04/10/2012  02:01            21,372 odbcMDAdaptor.lib

                                                      • 04/10/2012  02:01             4,812 odbcMDWrapper.lib

                                                      • 04/10/2012  02:19         2,600,448 out-datascript.dll

                                                      • 04/10/2012  02:14         2,303,488 out-file.dll

                                                      • 04/10/2012  02:14         2,415,104 out-table.dll

                                                      • 04/10/2012  02:17         2,462,208 out-teradatapt.dll

                                                      • 04/10/2012  02:15         2,295,296 partition.dll

                                                      • 04/10/2012  02:01           124,928 pcre.dll

                                                      • 04/10/2012  02:01             6,476 pcre.lib

                                                      • 04/10/2012  01:52            33,764 qdbm.lib

                                                      • 04/10/2012  02:15         2,244,096 read-lookup.dll

                                                      • 04/10/2012  02:16         2,366,464 sorter.dll

                                                      • 04/10/2012  02:17         2,685,440 transform.dll

                                                      • 04/10/2012  02:18         2,272,768 unique.dll

                                                      • 04/10/2012  02:19         2,297,344 write-lookup.dll

                                                      • 04/10/2012  02:19         2,260,480 write-parameters.dll

                                                      • 04/10/2012  01:40         1,823,744 xerces-c_3_1.dll

                                                      • 04/10/2012  01:51            60,416 z.dll

                                                      • 04/10/2012  01:51            11,664 z.lib

                                                      •               41 File(s)     58,137,890 bytes

                                                      •                2 Dir(s)  122,810,306,560 bytes free

                                                     

                                                    • let us know whether you also has Expressor Studio installed
                                                      • QlikView Expressor not installed & never has been


                                                    • check your Windows EventViewer logs for DLL load violations that might have been generated by the operator DLLs
                                                      • I'll have a look & advise later


                                                    • attempt to uninstall all Expressor software and the Governance Dashboard and reinstall the Governance Dashboard, reboot and re-try the scan AFTER doing the steps above
                                                      • Re-installing  the Governance Dashboard & rebooting made no difference
                                                      • QlikView Expressor not installed so nothing to de-install

                                                     

                                                    Best Regards,  Bill


                                                     

                                                     

                                                     

                                                     

                                                     

                                                     

                                                     

                                                     

                                                    C:\ProgramData\QlikTech\Governance_1.0Beta\engine\lib>