Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is this related to Proxy setting?
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
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!
EventID | Date and Time | Username | Severity | Message |
000000 | 2016-07-06T08:42:23.987-04:00 | DOMAIN\QlikView | Error | Error occurred reading data from server: |
000001 | 2016-07-06T08:42:23.994-04:00 | DOMAIN\QlikView | Error | DNS error |
000002 | 2016-07-06T08:42:24.005-04:00 | DOMAIN\QlikView | Error | QVX_UNEXPECTED_END_OF_DATA: DNS error |
000004 | 2016-07-06T08:50:36.590-04:00 | DOMAIN\QlikView | Error | Error occurred reading data from server: |
000005 | 2016-07-06T08:50:36.596-04:00 | DOMAIN\QlikView | Error | DNS error |
000006 | 2016-07-06T08:50:36.600-04:00 | DOMAIN\QlikView | Error | QVX_UNEXPECTED_END_OF_DATA: DNS error |
000007 | 2016-07-06T08:51:54.825-04:00 | DOMAIN\QlikView | Error | Error occurred reading data from server: |
000008 | 2016-07-06T08:51:54.831-04:00 | DOMAIN\QlikView | Error | DNS error |
000009 | 2016-07-06T08:51:54.835-04:00 | DOMAIN\QlikView | Error | QVX_UNEXPECTED_END_OF_DATA: DNS error |
000010 | 2016-07-06T09:13:00.404-04:00 | DOMAIN\QlikView | Error | Error occurred reading data from server: |
000011 | 2016-07-06T09:13:00.411-04:00 | DOMAIN\QlikView | Error | DNS error |
000012 | 2016-07-06T09:13:00.420-04:00 | DOMAIN\QlikView | Error | QVX_UNEXPECTED_END_OF_DATA: DNS error |
000013 | 2016-07-06T09:37:16.778-04:00 | DOMAIN\QlikView | Error | Error occurred reading data from server: |
000014 | 2016-07-06T09:37:16.784-04:00 | DOMAIN\QlikView | Error | DNS error |
000015 | 2016-07-06T09:37:16.788-04:00 | DOMAIN\QlikView | Error | QVX_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:
HI Jonas,
I am connecting to a website. What configuration can I ask the website admin to check? Thanks.
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
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!
Hi Jonas, what do I do after pinging the ip? What should I check? Thanks!
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.
Otherwise, the reply will be like image extraction on web.
If return equal to last image, call your network administrator.
Hope this helps!