3 Replies Latest reply: Mar 10, 2017 3:42 AM by David Barcza RSS

    QlikSense Server Data Loading above a number of records does not work

    David Barcza

      Hi guys,

       

      we use the QlikSense Server at one of our client with Windows Server 2008 Operations System.

      QlikSense version is 3.1 RS3. ODBC driver version: Open Edge 10.1B (32 bit)

       

      I connect to the database via ODBC.

       

      A very simple script with few records works:

      Here is the script:

      LOAD "pt_part",

        "pt_um";

      SQL SELECT TOP 8000

        "pt_part",

        "pt_um"

      FROM PUB."pt_mstr";

       

      Here is the result:

      Started loading data

      Connecting to TEKA-QADDB (mofemws_mfg) Connected pt_mstr Lines fetched: 8 000

      Creating search index Search index creation completed successfully

      App saved

      Finished successfully

      0 forced error(s)

      0 synthetic key(s)

       

      But above 9000 records the script does not work any more and the number of lines fetched is zero.

      Here is the script:

      LOAD "pt_part",

        "pt_um";

      SQL SELECT TOP 9000

        "pt_part",

        "pt_um"

      FROM PUB."pt_mstr";

       

      Here is the result:

      Started loading data

      Connecting to TEKA-QADDB (mofemws_mfg) Connected

      pt_mstr Lines fetched: 0 Creating search index Search index creation completed successfully

      App saved

      Finished successfully

      0 forced error(s)

      0 synthetic key(s)

       

      I tried to load other tables, but the results were the same.

       

      However it worked just fine using Qlik Sense Desktop software on my own computer (Windows 7 OS) via VPN connection.

       

      I checked the followings:

      • The Server Memory and Processor Usage looks OK
      • The network wide to the Database Server looks OK
      • The ODBC driver was tested with other tools and it looks OK

       

      Does anybody have any idea?

       

      Thank you in advance!

       

      David Barcza