Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

reload license monitor : QVX_UNEXPECTED_END_OF_DATA

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

44 Replies
Not applicable
Author

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.

ingoginqo
Partner Ambassador Alumni
Partner Ambassador Alumni

I could not open the document link you provided.

I had changed the default port for Qlik Sense from 443 to 31443 and then the License Monitor and the Operations Monitor started to fail.

I was able to solve the issue by adding the port into the connection string for the Data Connections listed in the attached image.

2016-10-13_3-16-33.png

Not applicable
Author

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

grangerats
Partner - Contributor III
Partner - Contributor III

Thank you for pointing me to those data connections! That fixed part of my problem and led me to the fix for the other part. In my case, I made 2 customizations to Qlik Sense that caused both the "Operations Monitor" and "License Monitor" reload tasks to fail. No amount of re-installation or version upgrades fixed it (which makes perfect sense now that I know what happened). Now that I've corrected the data connections appropriately, the tasks work again. (And I did not need to grant any user accounts in Qlik the "RootAdmin" role to get things working again!)

The first issue was because I changed the https port ("Server listen port HTTPS (default)") on the default proxy from 443 to 4430. Manually updating all 8 of the "qrs_" data connections' Connection string values to use the new port solved that. In my case, before the fix was applied, the error at the end of the task's Script log was: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.

But after that fix, I got a new error in the script logs. QVX_UNEXPECTED_END_OF_DATA: Unexpected character encountered while parsing value: <. Path '', line 0, position 0.

The second issue was introduced because I changed the "Central Proxy (Default)" virtual proxy's "Windows authentication pattern" from "Windows" to "Forms". That caused a Http redirect, which the QvRestConnector.exe couldn't deal with (and even if it had, it certainly wouldn't have been able to fill out the login form). I fixed it by creating a new virtual proxy that uses the default "Windows" auth pattern, then I made a final update to those 8 "qrs_" data connections to change the URL to use the new virtual proxy.

E.g. I made a new VP like so

...then I changed the URLs to use the new VP instead of the default VP:

EDIT: typo

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

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.

fmarvnnt
Partner - Creator III
Partner - Creator III

This article cannot be reached by my valid Partner account

sofiene_1920
Partner - Contributor III
Partner - Contributor III

Cooooooool it's work thx

You miss that we should creat a link to the central proxy else it don't work link.PNG

Thing you

praveenak
Partner - Contributor II
Partner - Contributor II

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

praveenak
Partner - Contributor II
Partner - Contributor II

Hi Jenny,

Did u get the solution for this code? I got the same error like you.(refer below)

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,

Praveen