No Data to Display in iQExplore

Owned by Conor McCann
Last updated: May 26, 2020 by Daniel Stuart-KellyVersion comment
2 min read

Problem

iQExplore shows message "No Data to Display" in each of the fields

Environment:
iQSonar Brendan R1
Windows 2012 R2 server, with SQL 2012 Standard Edition SP3
Installation is carried out using AD integrated user.

Expected Behaviour:
iQExplore to be populated with valid data and graphics
Actual Behaviour:
iQExplore shows message "No Data to Display" in each of the fields


Solution

iQExplore.ini is not configured correctly.

  1. Go to this folder open iQExplore,ini

  2. The Example below, make sure the highlighted are correct

    SET qf.version = 3.6;

    SET qf.global.os_function_mode = MACRO;

    SET qf.global.database.server = server;

    SET qf.global.database.integrated_authentication = 0;

    SET qf.global.database.user = 'username';

    SET qf.global.database.password = 'password';

    SET qf.global.database.name = iQDataHub_EDW;

    SET qf.global.database.schema = Explore_v2;

    SET qf.global.null = <n/a>;

    SET qf.global.export_tsv = 0;


Once you Click reload, you will see this window, followed by a populated iQExplore.


Example below