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

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

• There may be an instance where a .dll must be installed  - if all else fails download and install the MSVC  runtime libraries at:
  
  http://download.microsoft.com/download/d/d/9/dd9a82d0-52ef-40db-8dab-795376989c03/vcredist_x86.exe

• 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

[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)

Thanks

Mike T

[Anonymous]

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:

Best Regards,   Bill

[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

[Anonymous]

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>

[Michael_Tarallo]

Great I will review with our team and get back to you.

Regards,

Mike T

[Anonymous]

Mike

We get a few dozen entries like this in the Windows Application Event Log:

Log Name:      Application

Source:        SideBySide

Date:          16/10/2012 10:09:08

Event ID:      33

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      LHR-EM-QVAPP1.emea.menzies.net

Description:

Activation context generation failed for "C:\ProgramData\QlikTech\Governance_1.0Beta\engine\bin\LIBEAY32.dll". Dependent Assembly Microsoft.VC90.CRT,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="9.0.21022.8" could not be found. Please use sxstrace.exe for detailed diagnosis.

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="SideBySide" />

    <EventID Qualifiers="49409">33</EventID>

    <Level>2</Level>

    <Task>0</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2012-10-16T10:09:08.000000000Z" />

    <EventRecordID>3348</EventRecordID>

    <Channel>Application</Channel>

    <Computer>LHR-EM-QVAPP1.emea.menzies.net</Computer>

    <Security />

  </System>

  <EventData>

    <Data>Microsoft.VC90.CRT,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="9.0.21022.8"</Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>C:\ProgramData\QlikTech\Governance_1.0Beta\engine\bin\LIBEAY32.dll</Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

    <Data>

    </Data>

  </EventData>

</Event>

Best Regards,   Bill

[Michael_Tarallo]

Bill -

Thank you very much for this.

This explains why your operator DLLs are not loading.

All of the failed operators were datascript operators.  Datascript has a relatively recently added dependency on SSL (libeay32.dll and ssleay32.dll).   

It looks like the build of the OpenSSL DLL that is distributed with the engine (and hence the Governance Dashboard) is based on MSVCR90.DLL.

My guess is that the your system lacks that MSVC90.DLL and I’m not certain but I think the MS C runtime DLL we package with the Governance Dashboard is a later version but I need  to confirm this with engineering.

This has been escalated and I hope to have an additional update shortly.

Regards,

Mike T

[Michael_Tarallo]

OK Bill - I have something for you to try.

I'd like you to install the following DLL pack from Microsoft:

The Microsoft downloads for the 32-bit installer linked below. (QlikView Expressor currently is a 32-bit application)

http://download.microsoft.com/download/d/d/9/dd9a82d0-52ef-40db-8dab-795376989c03/vcredist_x86.exe

Please let me know how it goes.

Regards,

Mike T

[Anonymous]

Mike

Good News !!! 

The <Scan> [Reload] button now works ok to completion & the qvw is populated with data from my QlikView Server.

Now I need add the log locations and suss out how to use it.

Best Regards,  Bill

[#11]

Hi,

I am only trying to use the QVGD but get exactly the same problem as described in this thread so I will tag along.

I have tried installing the DLL-pack from Microsoft. I have uninstalled and reinstalled QVGD. I have only installed it to default folder (C:\Documents and Settings\All Users\Application Data\QlikTech\Governance_1.0Beta).

QVGD is installed on the QV Publisher server.

Best Regards,

Xerxes