38 Replies Latest reply: Nov 9, 2017 6:56 PM by Manoj Ramachandran RSS

    reload license monitor : QVX_UNEXPECTED_END_OF_DATA

    Ricardo Santos

      I'm on 3.0 server qliksense

      when i create a new application inadvertently i have deleted some connections (ArchivedLogFolder, ServerLogFolder, and others).

       

      So when i run License Monitor and Operations Monitor i got error missing that connections. i read in community to restore that using import qvf and publish them.

       

      but now when i run task scheduler to refresh data i got the error : QVX_UNEXPECTED_END_OF_DATA

       

      can you help me ? in attach the log error.

       

       

      P.S. if i run at hub i have qrs_user/qrs_useraccess lib error

       

        • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
          Daniel Sonda

          I have the same issue after upgrading from Qlik Sense 2.3 to 3.0.

            • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
              Paul Nowicki

              Same issue here,  I just upgraded from 2.2.4 to 3.0 and noticed the license monitor and operations monitor are no longer working.  Not sure what to do to resolve it, would like to get these working again.  I didn't actually make any changes to the archived logs folder and can still see that as a data connection in the QMC.  I'm searching the community for ideas on how to go about it.

               

              The error I get is QVX Unexpected end of data, which is tied to the QRS call.  Looks like a 403 forbidden error, which I'm guessing is some security issue.

               

              2016-07-22 08:26:52 0457 CALL qrs_userAccess

                  2016-07-22 08:26:52 0458

                    2016-07-22 08:26:52 0478 *** CONNECT TO ***

                    2016-07-22 08:26:53 0480 RestConectorMasterTable:

                    2016-07-22 08:26:53 0481   SQL SELECT

                    2016-07-22 08:26:53 0482       "id" AS "id_u0",

                    2016-07-22 08:26:53 0483       "createdDate",

                    2016-07-22 08:26:53 0484       "modifiedDate",

                    2016-07-22 08:26:53 0485       "modifiedByUserName",

                    2016-07-22 08:26:53 0486       "lastUsed",

                    2016-07-22 08:26:53 0487       "quarantined",

                    2016-07-22 08:26:53 0488       "quarantineEnd",

                    2016-07-22 08:26:53 0489       "__KEY_root",

                    2016-07-22 08:26:53 0490       (SELECT

                    2016-07-22 08:26:53 0491           "id",

                    2016-07-22 08:26:53 0492           "userId",

                    2016-07-22 08:26:53 0493           "userDirectory",

                    2016-07-22 08:26:53 0494           "name",

                    2016-07-22 08:26:53 0495           "__FK_user"

                    2016-07-22 08:26:53 0496       FROM "user" FK "__FK_user")

                    2016-07-22 08:26:53 0497   FROM JSON (wrap on) "root" PK "__KEY_root"

                    2016-07-22 08:26:53       14 fields found: id, userId, userDirectory, name, __FK_user, id_u0, createdDate, modifiedDate, modifiedByUserName, lastUsed, quarantined, quarantineEnd, __KEY_root, __extra_,

                    2016-07-22 08:26:53      Error: QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 403 (Forbidden):

                    2016-07-22 08:26:53     

                    2016-07-22 08:26:53      The server refused to fulfill the request.

                    2016-07-22 08:26:53      Execution Failed

                    2016-07-22 08:26:53      Execution finished.

            • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
              Yousef Amarneh

              Hello,

               

              Did you solve this issue? I am facing the same here.

              • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                Jenny Hellstr�m

                Hi,

                 

                I get the same error message. Have you solved the issue?

                 

                Jenny

                • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                  Thijs Verhoef

                  I'm also having the exact same issue. I was working in 3.0.0 and secretly hoped the upgrade to 3.1.0 would resolve the issue but no. Unfortunately the link isn't working for me either so I'm anxious to find out the solution.

                   

                  2016-10-04 16:49:19 1044 CALL QRS
                  2016-10-04 16:49:19 1045
                    2016-10-04 16:49:19 0457 LET NumRowsQRS = 0
                    2016-10-04 16:49:19 0458 SET QRS_RowCounts = 'QRS Row Counts: '
                    2016-10-04 16:49:19 0460 For each endpoint in
                  'qrs_userAccess','qrs_loginAccess','qrs_user','qrs_licenseSummary','qrs_stream'   2016-10-04 16:49:19 0461
                       2016-10-04 16:49:19 0461 CALL qrs_userAccess
                      2016-10-04 16:49:19 0462
                         2016-10-04 16:49:19 0482 *** CONNECT TO ***
                        2016-10-04 16:49:20 0484 RestConectorMasterTable:
                        2016-10-04 16:49:20 0485   SQL SELECT
                         2016-10-04 16:49:20 0486       "id" AS "id_u0",
                        2016-10-04 16:49:20 0487       "createdDate",
                        2016-10-04 16:49:20 0488       "modifiedDate",
                        2016-10-04 16:49:20 0489       "modifiedByUserName",
                        2016-10-04 16:49:20 0490       "lastUsed",
                        2016-10-04 16:49:20 0491       "quarantined",
                        2016-10-04 16:49:20 0492       "quarantineEnd",
                        2016-10-04 16:49:20 0493       "__KEY_root",
                        2016-10-04 16:49:20 0494       (SELECT
                        2016-10-04 16:49:20 0495           "id",
                        2016-10-04 16:49:20 0496           "userId",
                        2016-10-04 16:49:20 0497           "userDirectory",
                        2016-10-04 16:49:20 0498           "name",
                        2016-10-04 16:49:20 0499           "__FK_user"
                        2016-10-04 16:49:20 0500       FROM "user" FK "__FK_user")
                        2016-10-04 16:49:20 0501   FROM JSON (wrap on) "root" PK "__KEY_root"
                        2016-10-04 16:49:20      14 fields found: id, userId, userDirectory, name, __FK_user, id_u0, createdDate, modifiedDate, modifiedByUserName, lastUsed, quarantined, quarantineEnd, __KEY_root, __extra_,
                         2016-10-04 16:49:20      Error: QVX_UNEXPECTED_END_OF_DATA: Unexpected character encountered while parsing value:       2016-10-04 16:49:20      Execution Failed
                        2016-10-04 16:49:20      Execution finished.

                  • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                    Chinna Reddy

                    The link is not working can anyone provide me the alternate solution.

                    • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                      Emanuel bustos

                      Hi the link for the fix is not working how can we solve this issue?

                      • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                        Emanuel bustos

                        I found the solution:

                         

                        Resolution
                        Operations Monitor and License Monitor apps use the Qlik REST Connector to fetch data. The connector requires Windows Authentication to be successful in fetching data. This issue occurs when no virtual proxy in the Qlik Sense deployment utilizes Windows authentication.

                         

                        The issue can be resolved by enabling Windows Authentication for example by adding a secondary virtual proxy using Windows authentication.
                        1. Create a secondary virtual proxy and use standard windows authentication. In this example "win" is used as prefix, but this prefix can be any text value.User-added image
                        2. Edit all data connections prefixed with qrs_ to use the new virtual proxy. Change the connector URL path to contain the Windows authenticated virtual proxy. User-added image

                         

                        OR in my case just switch the Form Authentication to Windows and the Tasks run succesfully. this while the developers make a release fix for this.

                         

                        • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                          Praveena Kumar

                          Hi,

                           

                          Am new to Qliksense and the discussion gave me good inputs.

                          But still please help me to solve with below error (bolded below) that occurred when trying to fetch data using REST Connector.

                          1. Please provide some inputs of when this usually occurs because am loading three tables using the same rest connection but the last one failed while other first two tables loaded successfully.

                          2. And how it can be resolved.

                           

                          2017-03-16 04:29:31 0171 *** CONNECT TO ***

                          2017-03-16 04:29:32 0173 RestConnectorMasterTable:

                          2017-03-16 04:29:32 0174 SQL SELECT

                          2017-03-16 04:29:32 0175 "__KEY_root",

                          2017-03-16 04:29:32 0176 (SELECT

                          2017-03-16 04:29:32 0177 "level",

                          2017-03-16 04:29:32 0178 "metricsCategory",

                          2017-03-16 04:29:32 0179 "metricsId",

                          2017-03-16 04:29:32 0180 "metricsName",

                          2017-03-16 04:29:32 0181 "__FK_metricsLevelList"

                          2017-03-16 04:29:32 0182 FROM "metricsLevelList" FK "__FK_metricsLevelList")

                          2017-03-16 04:29:32 0183 FROM JSON (wrap on) "root" PK "__KEY_root"

                          2017-03-16 04:29:32       7 fields found: level, metricsCategory, metricsId, metricsName, __FK_metricsLevelList, __KEY_root, __extra_,

                          2017-03-16 04:29:32      Error: QVX_UNEXPECTED_END_OF_DATA: The remote server returned an error: (404) Not Found.

                          2017-03-16 04:29:32      Execution Failed

                          2017-03-16 04:29:32      Execution finished.

                           

                          Thanks in Advance,

                          Praveen

                          • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                            Calvin Wee

                            Thanks to grangerats resolution to issue #2, I created a new Virtual Proxy (with addition prefix in URL) for processes that cannot use Form Authentication, and

                            Thanks to sofiene_1920  Linking to Central Proxy.

                             

                            Now we are able to use Form authentication for our users while keeping the License & Operation Monitors running without issue.

                            • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                              alexander korsikov

                              i solve my issue - edit all qrs_* connection change https to http.

                              I use domain SSL cert to verify https connection for my domain users. And REST connector don't like this.

                                • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                                  Persevierance Musaka

                                  This Worked for me and l also included in the URL connection strings for qrs_* DataConnections an option fo skip SSL selection server certificate verification by using, skipServerCertificateValidation=true;    Also making sure that Qlik Sense Services use a local user with administrative privileges preferably one used for the initial installation of QlikSense. It is important to make sure that the all qrs_* users are set up with appropriate privileges and that the Qlik Sense Service User is not set as inactive, removed externally or blocked in the QMC

                                • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                                  Thomas Pike

                                  Hi guys, just upgraded to 3.2.2 (from 3.1.x)

                                   

                                  First I was getting errors regarding missing attributes in the archived log files. So I move all of the archived log files (as per some other threads.) Now I'm getting an error like that mentioned here (see snippet below)

                                   

                                  I've tried reading through what people have explained above

                                  # We are using default ports for SSL 443

                                  # Our default virtual proxy uses windows authentication

                                  # I don't really understand what is meant by "The account used as the admin during the installation was accidentally removed when the user directory connector updated." But I don't think that is the case with us either

                                   

                                  I get that the problem is probably the connector being unable to get access. Is there a way to test just that connection and/or see a better log of what went wrong with it?

                                   

                                  Matt

                                   

                                   

                                   

                                  2017-04-25 16:07:56 2024 CALL QRS

                                  2017-04-25 16:07:56 2025

                                    2017-04-25 16:07:56 1031 LET NumRowsQRS = 0

                                    2017-04-25 16:07:56 1032 SET QRS_RowCounts = 'QRS Row Counts: '

                                    2017-04-25 16:07:56 1034 For each endpoint in 'qrs_user','qrs_app','qrs_appobject','qrs_task'

                                    2017-04-25 16:07:56 1035

                                      2017-04-25 16:07:56 1035 CALL qrs_user

                                      2017-04-25 16:07:56 1036

                                        2017-04-25 16:07:56 1057 LIB CONNECT TO ***

                                        2017-04-25 16:07:57 1059 RestConnectorMasterTable:

                                        2017-04-25 16:07:57 1060   SQL SELECT

                                        2017-04-25 16:07:57 1061       "id" AS "id_u2",

                                        2017-04-25 16:07:57 1062       "createdDate" AS "createdDate_u1",

                                        2017-04-25 16:07:57 1063       "modifiedDate" AS "modifiedDate_u1",

                                        2017-04-25 16:07:57 1064       "modifiedByUserName" AS "modifiedByUserName_u1",

                                        2017-04-25 16:07:57 1065       "userId",

                                        2017-04-25 16:07:57 1066       "userDirectory",

                                        2017-04-25 16:07:57 1067        "name" AS "name_u0",

                                        2017-04-25 16:07:57 1068       "inactive",

                                        2017-04-25 16:07:57 1069       "removedExternally",

                                        2017-04-25 16:07:57 1070       "blacklisted",

                                        2017-04-25 16:07:57 1071       "__KEY_root",

                                        2017-04-25 16:07:57 1072       (SELECT

                                        2017-04-25 16:07:57 1073           "@Value" AS "@Value_u0",

                                        2017-04-25 16:07:57 1074           "__FK_roles"

                                        2017-04-25 16:07:57 1075       FROM "roles" FK "__FK_roles" ArrayValueAlias "@Value_u0"),

                                        2017-04-25 16:07:57 1076       (SELECT

                                        2017-04-25 16:07:57 1077           "id" AS "id_u1",

                                        2017-04-25 16:07:57 1078           "createdDate" AS "createdDate_u0",

                                        2017-04-25 16:07:57 1079           "modifiedDate" AS "modifiedDate_u0",

                                        2017-04-25 16:07:57 1080           "modifiedByUserName" AS "modifiedByUserName_u0",

                                        2017-04-25 16:07:57 1081           "attributeType",

                                        2017-04-25 16:07:57 1082           "attributeValue",

                                        2017-04-25 16:07:57 1083           "externalId",

                                        2017-04-25 16:07:57 1084           "__FK_attributes"

                                        2017-04-25 16:07:57 1085       FROM "attributes" FK "__FK_attributes")

                                        2017-04-25 16:07:57 1086   FROM JSON (wrap on) "root" PK "__KEY_root"

                                        2017-04-25 16:07:57     22 fields found: @Value_u0, __FK_roles, id_u1, createdDate_u0, modifiedDate_u0, modifiedByUserName_u0, attributeType, attributeValue, externalId, __FK_attributes, id_u2, createdDate_u1, modifiedDate_u1, modifiedByUserName_u1, userId, userDirectory, name_u0, inactive, removedExternally, blacklisted, __KEY_root, __extra_,

                                        2017-04-25 16:07:57      Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server

                                        2017-04-25 16:07:57      Execution Failed

                                        2017-04-25 16:07:57      Execution finished.

                                  • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                                    Calvin Wee

                                    The clue to this is either qrs* connections or Virtual Proxy.

                                    Go to QMC Data Connections and check the URL within the connection string.

                                    Go to Virtual Proxy Advanced and entered server name in the white list. More white list needed using HTTPS.

                                    This should work.

                                    Good Luck

                                    • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                                      Calvin Wee

                                      The clue to this is either qrs* connections or Virtual Proxy.

                                      Go to QMC Data Connections and check the URL within the connection string.

                                      Go to Virtual Proxy Advanced and entered server name in the white list. More white list needed using HTTPS.

                                      This should work.

                                      Good Luck

                                        • Re: reload license monitor : QVX_UNEXPECTED_END_OF_DATA
                                          Ricardo Prata

                                          Hello,

                                           

                                          Our License Monitor works, however Operations Monitor no.

                                           

                                          Operations Monitor runs 3 minutes, does all qrs connections and stop as below.

                                           

                                          We have a virtual proxy just for Windows Autentication

                                           

                                          Thanks for any help,

                                          Ricardo

                                           

                                               2017-05-16 02:16:09 1254 ENDIF

                                                2017-05-16 02:16:09 1255

                                                2017-05-16 02:16:09 1258 *** CONNECT TO ***

                                                2017-05-16 02:16:10 1260 RestConnectorMasterTable:

                                                2017-05-16 02:16:10 1261   SQL SELECT

                                                2017-05-16 02:16:10 1262       "createdDate" AS "createdDate_u1",

                                                2017-05-16 02:16:10 1263       "modifiedDate" AS "modifiedDate_u1",

                                                2017-05-16 02:16:10 1264       "modifiedByUserName" AS "modifiedByUserName_u1",

                                                2017-05-16 02:16:10 1265       "name" AS "name_u2",

                                                2017-05-16 02:16:10 1266       "enabled" AS "enabled_u2",

                                                2017-05-16 02:16:10 1267       "eventType",

                                                2017-05-16 02:16:10 1268       "startDate",

                                                2017-05-16 02:16:10 1269       "expirationDate",

                                                2017-05-16 02:16:10 1270       "incrementDescription",

                                                2017-05-16 02:16:10 1271       "incrementOption",

                                                2017-05-16 02:16:10 1272       "__KEY_root",

                                                2017-05-16 02:16:10 1273 

                                                2017-05-16 02:16:10 1274       (SELECT

                                                2017-05-16 02:16:10 1275"id" AS "id_u5",

                                                2017-05-16 02:16:10 1276           "__KEY_compositeRules",

                                                2017-05-16 02:16:10 1277           "__FK_compositeRules",

                                                2017-05-16 02:16:10 1278           (SELECT

                                                2017-05-16 02:16:10 1279               "id" AS "id_u3",

                                                2017-05-16 02:16:10 1280               "__FK_reloadTask",

                                                2017-05-16 02:16:10 1281               "__KEY_reloadTask"

                                                2017-05-16 02:16:10 1282           FROM "reloadTask" PK "__KEY_reloadTask" FK "__FK_reloadTask")

                                                2017-05-16 02:16:10 1283       FROM "compositeRules" PK "__KEY_compositeRules" FK "__FK_compositeRules"),

                                                2017-05-16 02:16:10 1284

                                                2017-05-16 02:16:10 1285       (SELECT

                                                2017-05-16 02:16:10 1286           "id" AS "id_u10",

                                                2017-05-16 02:16:10 1287           "__FK_reloadTask_u0",

                                                2017-05-16 02:16:10 1288           "__KEY_reloadTask_u0"

                                                2017-05-16 02:16:10 1289       FROM "reloadTask" PK "__KEY_reloadTask_u0" FK "__FK_reloadTask_u0"),

                                                2017-05-16 02:16:10 1290       (SELECT

                                                2017-05-16 02:16:10 1291           "id" AS "id_u14",

                                                2017-05-16 02:16:10 1292           "__FK_userSyncTask",

                                                2017-05-16 02:16:10 1293           "__KEY_userSyncTask"

                                                2017-05-16 02:16:10 1294       FROM "userSyncTask" PK "__KEY_userSyncTask" FK "__FK_userSyncTask")

                                                2017-05-16 02:16:10 1295   FROM JSON (wrap on) "root" PK "__KEY_root"

                                                2017-05-16 02:16:12      24 fields found: id_u3, __FK_reloadTask, __KEY_reloadTask, id_u5, __KEY_compositeRules, __FK_compositeRules, id_u10, __FK_reloadTask_u0, __KEY_reloadTask_u0, id_u14, __FK_userSyncTask, __KEY_userSyncTask, createdDate_u1, modifiedDate_u1, modifiedByUserName_u1, name_u2, enabled_u2, eventType, startDate, expirationDate, incrementDescription, incrementOption, __KEY_root, __extra_,

                                                2017-05-16 02:16:12      Error: QVX_UNEXPECTED_END_OF_DATA: DNS error

                                                2017-05-16 02:16:12      Execution Failed