Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.

[samantha92]

Hiya,

I am trying to use a REST connector and am able to bring back data when reloading manually. However, when reloading on the server I get the following error message:

Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.

I have ran the script on the server without bringing the data back and just the connection string and it reloads fine with no errors.

I have tried with and without authentication, skipping server certificate validation and it still fails on the server.

Do I need to do anything server side to allow for REST connections?

Does anyone have any ideas on what I might be doing wrong?

TIA.

Full error log:

2019-03-11 11:27:40      Execution started.
2019-03-11 11:27:40      QVB Version                   12.20.20900+2018-11-27 14:46:56+566945a
2019-03-11 11:27:40      CPU Target                    x64
2019-03-11 11:27:40      Operating System              Windows Server 2012 R2 Standard  (64 bit edition)
2019-03-11 11:27:40      Wow64 mode                    Not using Wow64
2019-03-11 11:27:40      Language                      0809 English (United Kingdom) English
2019-03-11 11:27:40      Country                       44 United Kingdom United Kingdom
2019-03-11 11:27:40      MDAC Version                  6.3.9600.16384
2019-03-11 11:27:40      MDAC Full Install Version     6.3.9600.16384
2019-03-11 11:27:40      PreferredCompression          2
2019-03-11 11:27:40      EnableParallelReload          1
2019-03-11 11:27:40      ParallelizeQvdLoads           1
2019-03-11 11:27:40      AutoSaveAfterReload           0
2019-03-11 11:27:40      BackupBeforeReload            0
2019-03-11 11:27:40      EnableFlushLog                0
2019-03-11 11:27:40      SaveInfoWhenSavingFile        0
2019-03-11 11:27:40      UserLogfileCharset            65001
2019-03-11 11:27:40      OdbcLoginTimeout              -1
2019-03-11 11:27:40      OdbcConnectionTimeout         -1
2019-03-11 11:27:40      LongestPossibleLine           1048576
2019-03-11 11:27:40      MaxCoreMask                   -1
2019-03-11 11:27:40      ScriptWantsDbWrite            false
2019-03-11 11:27:40      ScriptWantsExe                false
2019-03-11 11:27:40      LogFile CodePage Used:        65001
2019-03-11 11:27:40      UseMemoryFillPattern          1
2019-03-11 11:27:40      ScriptMode                    Legacy (gives greater system access) (aka qv11 mode)
2019-03-11 11:27:40      SequentialThreadCount         16
2019-03-11 11:27:40      NumberOfCores (effective)     4
2019-03-11 11:27:40      ReloadCodebase                Bnf
2019-03-11 11:27:40      Reload Executed By            KMBC\qlik
2019-03-11 11:27:40      Process Executing             QVB
2019-03-11 11:27:40      Process ID                    3208
2019-03-11 11:27:40 0002 SET ThousandSep=','
2019-03-11 11:27:40 0003 SET DecimalSep='.'
2019-03-11 11:27:40 0004 SET MoneyThousandSep=','
2019-03-11 11:27:40 0005 SET MoneyDecimalSep='.'
2019-03-11 11:27:40 0006 SET MoneyFormat='£#,##0.00;-£#,##0.00'
2019-03-11 11:27:40 0007 SET TimeFormat='hh:mm:ss'
2019-03-11 11:27:40 0008 SET DateFormat='DD/MM/YYYY'
2019-03-11 11:27:40 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'
2019-03-11 11:27:40 0010 SET FirstWeekDay=0
2019-03-11 11:27:40 0011 SET BrokenWeeks=0
2019-03-11 11:27:40 0012 SET ReferenceDay=4
2019-03-11 11:27:40 0013 SET FirstMonthOfYear=1
2019-03-11 11:27:40 0014 SET CollationLocale='en-GB'
2019-03-11 11:27:40 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2019-03-11 11:27:40 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
2019-03-11 11:27:40 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2019-03-11 11:27:40 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
2019-03-11 11:27:40 0020 CUSTOM CONNECT TO ***
2019-03-11 11:28:02 0022 RestConnectorMasterTable:
2019-03-11 11:28:02 0023 SQL SELECT
2019-03-11 11:28:02 0024  "PreferredMethodOfContact",
2019-03-11 11:28:02 0025  "RequestType",
2019-03-11 11:28:02 0026  "AreaType",
2019-03-11 11:28:02 0027  "Title",
2019-03-11 11:28:02 0028  "FirstName",
2019-03-11 11:28:02 0029  "Surname",
2019-03-11 11:28:02 0030  "PhoneNumber",
2019-03-11 11:28:02 0031  "__KEY_root"
2019-03-11 11:28:02 0032 FROM JSON (wrap on) "root" PK "__KEY_root"
2019-03-11 11:28:44       9 fields found: PreferredMethodOfContact, RequestType, AreaType, Title, FirstName, Surname, PhoneNumber, __KEY_root, __extra_,
2019-03-11 11:28:44      Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.
2019-03-11 11:28:44      Execution Failed
2019-03-11 11:28:44      Execution finished.

[samantha92 · Accepted solution]

Figured out the problem!

The QlikView account needed IE permission in order for us to hit an external URL.

[Chip_Matejowsky]

Hi Samantha,

Have you had a look at the REST connector log? By default the log is stored in %ProgramData%\Qlik\Custom Data\QvRestConnector\Log.

If you are able to reload successfully manually but not when running from QVS/Publisher, the likely difference is the account being used to run the reload. When you run the reload manually, you are using your own account? When you run the reload from QVS/Publisher, the account being used is the QlikView service account running the QlikView Distribution Services. A test you can try is to login to a computer which has QlikView Desktop installed as this QlikView service account and attempt to run the reload. If it fails, you are likely experiencing a permissions issue with the account. 

Hope this helps.

-Chip 

[RaajeshNagarajan]

Hi Samantha,

I am running into a similar issue, can you please elaborate the solution please? Thanks.

Thanks & Regards,

Raajesh N

[kavita25]

Hello,

Please elaborate the solution.

It would be great help, as I am facing the same issue since a long time.

Regards,

Kavita

[rklaytonmb]

Hi Samantha

How can i configure IE permission

Thanks a lot

[kavita25]

Hello,

I was facing with the same issue and it got solved by changing the proxy settings in Rest Connector.

Regards,

Kavita

[zekazak]

Hello,

Could you please share a bit more info about how to change these permissions? Thank you in advance.

Best Regards,

~Sergejs

[rklaytonmb]

In my case, the Use TSL 1.0, 1.1 and 1.2 options were released in IE