11 Replies Latest reply: Jul 8, 2016 11:26 AM by Jonas Melo RSS

    QVX_UNEXPECTED_END_OF_DATA: DNS error

    Jessica Tung

      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.

        • Re: QVX_UNEXPECTED_END_OF_DATA: DNS error
          Jessica Tung

          Is this related to Proxy setting?

          • Re: QVX_UNEXPECTED_END_OF_DATA: DNS error
            Peter Cammaert

            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

              • Re: QVX_UNEXPECTED_END_OF_DATA: DNS error
                Jessica Tung
                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:

                  • Re: QVX_UNEXPECTED_END_OF_DATA: DNS error
                    Peter Cammaert

                    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

                • Re: QVX_UNEXPECTED_END_OF_DATA: DNS error
                  Jonas Melo

                  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!