11 Replies Latest reply on Aug 24, 2016 1:49 AM by Daryl Jones

    Web Data Connector Error: The user has not yet visited the url on this machine.

    Daryl Jones

      Hi All,

       

      I keep getting the above error when using the web data connector.  I have contacted Tableau tech support and the advice they offered was to post something on the community forum, so here it is...

       

      I have been trying to use the Web Data Connector to access data on an intranet page that I have set up.  I worked through the stock quote tutorial using the simulator and importing into Tableau desktop and it all worked fine.  I then wrote some new html pages to access my data and ran them through the simulator successfully.  However, when I try to access the data via the web data connector I get the error: "The user has not yet visited the url 'http://xxx.xxx.xxx/xxx.html' on this machine.".  Obviously I have visited the url on my machine.

       

      As a bit of background I am trying to pull data from Lotus Notes databases into Tableau.  Now, Tableau cannot read Lotus Notes databases (as far as I know, at least not easily) so I have set up a Notes client and a web server on a Linux node and then wrote some Java to open the database, extract the data that I need and write it out to a JSON file on the server.  I can then access this file from an html page and use this with the web data connector.

       

      If I modify the stockQuote.html page to point to my json file rather than the Yahoo stock data then it all works fine but as soon as I change the name of stockQuote.html (for example to myData.html) then I get the error.  Also, if I change stockQuote.html to pull in a different data source then it still pulls in the old data, but I'm sure this is just a caching issue.

       

       

      As I mentioned all of these new files work with the simulator but none of them work with Tableau desktop.  So, my code is correct and my data is correct but for some reason Tableau does not like it when I change the url.

       

      Any help would be greatly appreciated.

       

      Many thanks,

       

      Daryl

        • 1. Re: Web Data Connector Error: The user has not yet visited the url on this machine.

          Hi Daryl Jones,

           

          This looks quite complicated to me. I unfortunately haven't the the rights skills for this case, but I do have the right contacts for you.

           

          I'm summoning the fantastic Toby Erkson for this one, he might be able to help you solve this. If not no worries, we'll support you!

          • 2. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
            Toby Erkson

            Thanks Lenny for the ping but, alas, I have no idea what to do   I have never used a WDC nor created one

             

            I don't know who else to ping but I'll move this to the Developer's forum as there are folks there who are knowledgeable and may be able to help out

            • 3. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
              Tamas Foldi

              Just a few questions in advance:

               

              1. Does your new WDC work from Simulator?
              2. Do you try your WDC from your local web server? Or from file location?
              3. Are you trying your modifications from Desktop?
              • 4. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                Daryl Jones

                1. Yes, my WDC works from the simulator

                2. WDC is on my web server

                3. I'm not sure what you mean.  Having got the WDC to work through the simulator and show the correct data I then wish to access this via Tableau desktop (or rather other users would like to access the data via Tableau desktop through WDC). This is when I get the error.

                 

                I've attached a couple of screenshots showing the simulator (you'll have to trust me that the data loaded in correctly), and also the error message when I try to connect through Tableau.

                 

                Thanks for taking a look at this, I really appreciate your time to look at this.

                 

                Thanks,

                 

                Daryl

                • 5. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                  Tamas Foldi

                  can you paste here the related logs from your Tableau Desktop logs?

                  • 6. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                    Daryl Jones

                    The last 18 lines of log.txt:

                     

                    {"ts":"2016-08-22T16:07:12.576","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"web-data-connector","v":"Web view loading finished. Result was not cached."}

                    {"ts":"2016-08-22T16:07:12.628","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"web-data-connector","v":"ConnectWebDataDialog: End"}

                    {"ts":"2016-08-22T16:07:12.698","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"ds-parser-connect","v":{"attr":{":locale":"1024","authentication":"yes","caption":"","channel":"http","class":"webdata-direct","filename":"ADQ_0.html","lastRecord":"","name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","password":"********","path":"/KC/Tableau_WDC/","port":"80","server":"css.ecorp.cat.com","urlQuery":""},"caption":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo"}}

                    {"ts":"2016-08-22T16:07:12.698","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"ds-connect","v":{"attr":{":locale":"1024","authentication":"yes","caption":"","channel":"http","class":"webdata-direct","filename":"ADQ_0.html","lastRecord":"","name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","password":"********","path":"/KC/Tableau_WDC/","port":"80","server":"css.ecorp.cat.com","urlQuery":""},"caption":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo"}}

                    {"ts":"2016-08-22T16:07:12.698","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"ds-connect-data-connection","v":{"attr":{":locale":"1024","authentication":"yes","caption":"","channel":"http","class":"webdata-direct","filename":"ADQ_0.html","lastRecord":"","name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","password":"********","path":"/KC/Tableau_WDC/","port":"80","server":"css.ecorp.cat.com","urlQuery":""},"caption":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo"}}

                    {"ts":"2016-08-22T16:07:12.708","pid":11444,"tid":"2a68","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"construct-protocol-group","v":{"attributes":{"APIVersion":"","authentication":"yes","caption":"","channel":"http","class":"webdata-direct","filename":"ADQ_0.html","increment-key":"","password":"********","path":"/KC/Tableau_WDC/","port":"80","scriptVersion":"","server":"css.ecorp.cat.com","username":""},"closed-protocols-count":"0","connection-limit":"1","group-id":"0","in-construction-count":"0","protocols-count":"0","this":"0x00000000107142e0"}}

                    {"ts":"2016-08-22T16:07:12.738","pid":11444,"tid":"2658","sev":"warn","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"throw DataSourceException (type=WDCPromptRequiresResponse): The user has not yet visited the url 'http://css.ecorp.cat.com:80/KC/Tableau_WDC/ADQ_0.html' on this machine.\n"}

                    {"ts":"2016-08-22T16:07:12.828","pid":11444,"tid":"2658","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"destruct-protocol","v":{"attributes":{"APIVersion":"","authentication":"yes","caption":"","channel":"http","class":"webdata-direct","filename":"ADQ_0.html","increment-key":"","password":"********","path":"/KC/Tableau_WDC/","port":"80","scriptVersion":"","server":"css.ecorp.cat.com","username":""},"created":"22/08/2016 16:07:12","created-elapsed":0.114,"disconnected":false,"id":0,"this":"0x000000001106a010"}}

                    {"ts":"2016-08-22T16:07:12.828","pid":11444,"tid":"2a68","sev":"warn","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"throw DataSourceException (type=WDCPromptRequiresResponse): The user has not yet visited the url 'http://css.ecorp.cat.com:80/KC/Tableau_WDC/ADQ_0.html' on this machine.\n"}

                    {"ts":"2016-08-22T16:07:12.878","pid":11444,"tid":"2f54","sev":"warn","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"throw DataSourceException (type=WDCPromptRequiresResponse): The user has not yet visited the url 'http://css.ecorp.cat.com:80/KC/Tableau_WDC/ADQ_0.html' on this machine.\n"}

                    {"ts":"2016-08-22T16:07:12.878","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"end-ds-connect-data-connection","v":{"caption":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","elapsed":0.185,"name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo"}}

                    {"ts":"2016-08-22T16:07:12.878","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"end-ds-connect","v":{"caption":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","elapsed":0.185,"name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo"}}

                    {"ts":"2016-08-22T16:07:12.888","pid":11444,"tid":"2f54","sev":"info","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"end-ds-parser-connect","v":{"caption":"webdata-direct.1gxb0011vi035t17swihg09f0lmo","elapsed":0.204,"name":"webdata-direct.1gxb0011vi035t17swihg09f0lmo"}}

                    {"ts":"2016-08-22T16:07:12.928","pid":11444,"tid":"2f54","sev":"warn","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"throw DataSourceException (type=Unknown): The user has not yet visited the url 'http://css.ecorp.cat.com:80/KC/Tableau_WDC/ADQ_0.html' on this machine.\n\n"}

                    {"ts":"2016-08-22T16:07:13.048","pid":11444,"tid":"2f54","sev":"warn","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"NotifyOfException::DataSourceException"}

                    {"ts":"2016-08-22T16:07:13.048","pid":11444,"tid":"2f54","sev":"error","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"Error Dialog:"}

                    {"ts":"2016-08-22T16:07:13.048","pid":11444,"tid":"2f54","sev":"error","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"An error occurred while communicating with data source 'webdata-direct.1gxb0011vi035t17swihg09f0lmo'.\n"}

                    {"ts":"2016-08-22T16:07:13.048","pid":11444,"tid":"2f54","sev":"error","req":"-","sess":"-","site":"{CBB24BE3-E212-48DE-A6B5-7069269C2DC7}","user":"-","k":"msg","v":"    The user has not yet visited the url 'http://css.ecorp.cat.com:80/KC/Tableau_WDC/ADQ_0.html' on this machine.\n\n"}

                     

                    Please let me know if you need anything else.

                    • 7. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                      Tamas Foldi

                      First of all open an issue here:

                       

                      Issues · tableau/webdataconnector · GitHub

                       

                      From the error messages I see one relevant error type: type=WDCPromptRequiresResponse. But frankly I have no idea what it is

                      • 8. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                        Patrick A Van Der Hyde

                        I have moved this to the Web Data Connector section of the community where you are likely to get more help.

                         

                        Patrick

                        • 9. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                          Jeff D

                          Hi Daryl, while not a direct answer to your question, you might want to look at the Tableau SDK rather than the web connector.  From what you've described,it might be a better fit.  Tableau SDK

                          • 10. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                            Samm Desmond

                            Hi Daryl, sorry to hear you're having some issues.

                             

                            I'm curious, does your connector automatically submit itself? Or is there user interaction needed before the javascript calls tableau.submit()?

                             

                            The warning message you're seeing means that Tableau does not believe you have visited this connector in the "interactive" phase of the connector (when the UI is showing). We only add urls to the list of visited connectors after the page has completely loaded and the connector has made a call to initCallback (after the connector's init() function has been called).

                             

                            You'll want to make sure that the connector completely loads before calling submit. You can verify that it has completely loaded by looking at the title of the WDC dialog.

                             

                            Hope that helps!

                            Samm

                            1 of 1 people found this helpful
                            • 11. Re: Web Data Connector Error: The user has not yet visited the url on this machine.
                              Daryl Jones

                              Yes!!! Thank you Samm.

                               

                              I had modified the code to prevent any user interaction so that data could be loaded straight into Tableau.  In doing so I had commented out initCallback - it seems so obvious now but I would never have thought of it.

                               

                              Many thanks for your (and everyone elses) help, I really appreciate your time and effort on this.

                               

                              Thanks,

                               

                              Daryl