Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

QVX_UNEXPECTED_END_OF_DATA: DNS error

HI I am connecting via QVRestConnector. Manual reload on desktop worked but running it through QVS task came back with this wrror message:

2016-07-06 09:12:46 0022 CUSTOM*CONNECT*Provider*Connect*XUserId*XPassword*

2016-07-06 09:12:48 0023 RestConnectorMasterTable:

2016-07-06 09:12:48 0024 SQL SELECT

..

..

..

2016-07-06 09:13:00      76 fields found: field1, field2,....

2016-07-06 09:13:00      QVX_UNEXPECTED_END_OF_DATA: DNS error

2016-07-06 09:13:00      Error: Custom read failed

2016-07-06 09:13:00      General Script Error

2016-07-06 09:13:00      Execution Failed

2016-07-06 09:13:00      Execution finished.

How do I solve the issue? Thanks.

Tags (1)
11 Replies
Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Is this related to Proxy setting?

Peter_Cammaert
Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Seems like your server machine cannot resolve the supplied URL to make a connection. What data source are you trying to connect to (URL)?

Also, the REST Connector like any other Qlik Connector writes a log of its activities to a file somewhere in C:\ProgramData\QlikTech\Custom Data\... It often contains more detailss about the actual error. Can you post it here?

Best,

Peter

jonas_rezende
Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Hi, Jessica Tung.

Verify if:

I. driver of database is installed in server;

II. Case Oracle database, check configuration of the tnsnames.

Anyway, this message happens when not down or loses connection with the database.

Help this helps!

Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

EventIDDate and Time           UsernameSeverityMessage
0000002016-07-06T08:42:23.987-04:00DOMAIN\QlikViewError   Error occurred reading data from server:
0000012016-07-06T08:42:23.994-04:00DOMAIN\QlikViewError   DNS error
0000022016-07-06T08:42:24.005-04:00DOMAIN\QlikViewErrorQVX_UNEXPECTED_END_OF_DATA: DNS error
0000042016-07-06T08:50:36.590-04:00DOMAIN\QlikViewErrorError occurred reading data from server:
0000052016-07-06T08:50:36.596-04:00DOMAIN\QlikViewErrorDNS error
0000062016-07-06T08:50:36.600-04:00DOMAIN\QlikViewErrorQVX_UNEXPECTED_END_OF_DATA: DNS error
0000072016-07-06T08:51:54.825-04:00DOMAIN\QlikViewError   Error occurred reading data from server:
0000082016-07-06T08:51:54.831-04:00DOMAIN\QlikViewError   DNS error
0000092016-07-06T08:51:54.835-04:00DOMAIN\QlikViewError   QVX_UNEXPECTED_END_OF_DATA: DNS error
0000102016-07-06T09:13:00.404-04:00DOMAIN\QlikViewErrorError occurred reading data from server:
0000112016-07-06T09:13:00.411-04:00DOMAIN\QlikViewErrorDNS error
0000122016-07-06T09:13:00.420-04:00DOMAIN\QlikViewErrorQVX_UNEXPECTED_END_OF_DATA: DNS error
0000132016-07-06T09:37:16.778-04:00DOMAIN\QlikViewErrorError occurred reading data from server:
0000142016-07-06T09:37:16.784-04:00DOMAIN\QlikViewErrorDNS error
0000152016-07-06T09:37:16.788-04:00DOMAIN\QlikViewErrorQVX_UNEXPECTED_END_OF_DATA: DNS error

08:42:23,937 [4] - System.Net.WebException: The remote name could not be resolved: 'company.service-now.com'

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

08:42:54,900 [4] - System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

08:42:58,916 [4] - System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

08:43:03,486 [4] - System.Net.WebException: The remote server returned an error: (407) Proxy Authentication Required.

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

08:50:36,535 [4] - System.Net.WebException: The remote name could not be resolved: 'company.service-now.com'

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

08:51:54,775 [4] - System.Net.WebException: The remote name could not be resolved: 'company.service-now.com'

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

09:13:00,353 [4] - System.Net.WebException: The remote name could not be resolved: 'company.service-now.com'

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

09:14:11,552 [4] - System.Net.WebException: The remote server returned an error: (401) Unauthorized.

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

09:37:16,727 [4] - System.Net.WebException: The remote name could not be resolved: 'company.service-now.com'

  at System.Net.HttpWebRequest.GetResponse()

  at Qlik.Connectors.Rest.RestDataReader.Read(BlockingCollection`1 sourceDataRows)

Error processing data:

Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

HI Jonas,

I am connecting to a website. What configuration can I ask the website admin to check? Thanks. 

Peter_Cammaert
Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Aha, there you have it. Your initial guess may be the correct one: you'll need to configure a proxy to let the REST Connector pass through. As I'm not seeing any proxy fields in the connection dialog of the connector itself, you may want your sysadmin to configure an exception for your QlikView server in the proxy.

Alternatively, on your QlikView server you can try configuring your proxy settings in IE->Tools->Internet options->Connections->LAN settings...->Proxy server and see if that works. Your own PC probably has those settings already configured, so you can copy them if you want.

Not sure why a server has to pass through a proxy to get to the internet...

Peter

jonas_rezende
Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Hi, Jessica Tung.

Verify if the server is losing package. Maybe, the problem can be in proxy or firewall. Run the following command at the  MS-DOS prompt:

ping <server name or I.P> -t

Hope this helps!

Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Hi Jonas, what do I do after pinging the ip? What should I check? Thanks!

jonas_rezende
Not applicable

Re: QVX_UNEXPECTED_END_OF_DATA: DNS error

Hi, Jessica Tung.

Although language is in portuguese the logic is the same. Ex.: the image below apply ping in www.qlikcom.com, like work the reply is Ok, no loses package or timed out.

Ping_less_problem.png

Otherwise, the reply will be like image extraction on web.

Ping_with_problem.png

If return equal to last image, call your  network administrator.

Hope this helps!