Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
samantha92
Contributor III
Contributor III

Error: QVX_UNEXPECTED_END_OF_DATA: Failed to connect to server.

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.

1 Solution

Accepted Solutions
samantha92
Contributor III
Contributor III
Author

Figured out the problem!

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

View solution in original post

8 Replies
samantha92
Contributor III
Contributor III
Author

Figured out the problem!

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

View solution in original post

Chip_Matejowsky
Support
Support

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 

Sr. Technical Support Engineer with Qlik Support
RaajeshNagarajan
Contributor
Contributor

Hi Samantha,

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

Thanks & Regards,

Raajesh N

kavita25
Partner
Partner

Hello,

Please elaborate the solution.

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

Regards,

Kavita

 

rklaytonmb
Partner
Partner

Hi Samantha

How can i configure IE permission

Thanks a lot

kavita25
Partner
Partner

Hello,

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

Regards,

Kavita

zekazak
Creator
Creator

Hello,

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

 

Best Regards,

~Sergejs

rklaytonmb
Partner
Partner

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