Solved: Re: reload license monitor : QVX_UNEXPECTED_END_OF... - Page 2 - Qlik Community

Anonymous · ‎2016-07-19

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

Report Inappropriate Content · ‎2016-10-05

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 · ‎2016-10-13

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.

Report Inappropriate Content · ‎2016-10-21

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

grangerats · ‎2016-10-24

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 · ‎2016-11-25

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

Emmanuelle__Bustos · ‎2016-11-25

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.

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.
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.

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 · ‎2017-02-01

This article cannot be reached by my valid Partner account

sofiene_1920 · ‎2017-02-23

Cooooooool it's work thx

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

Thing you

praveenak · ‎2017-03-16

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 · ‎2017-03-16

Hi Jenny,

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