Notebook R : Error in reading dataset with dkuReadDataSet

UserBird · April 2017

Hello

When I try to read a dataset in my R notebook, I get the following error:


Error in dku__check_api_error(resp, "Failed to read dataset"): Failed to read dataset (HTTP code 503): <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//en" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta charset="utf-8">
<base href="http://www.mailcontrol.com">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
<link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/bootstrap/css/bootstrap.css" type="text/css">
<link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/bootstrap/css/bootstrap-responsive.css" type="text/css">
<link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/notification-pages/notification.css" type="text/css">
<!--[if IE ]>
           <link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/notification-pages/notification-ie.css" type="text/css">
           <script src="http://www.mailcontrol.com/http-resources/head.js"></script>
        <![endif]--><!--[if IE 6]>
            <link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/bootstrap/css/bootstrap-ie6.min.css" type="text/css">
            <link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/bootstrap/css/ie.css" type="text/css">
            <link rel="stylesheet" href="http://www.mailcontrol.com/http-resources/notification-pages/notification-ie6.css" type="text/css">

            <script src="http://www.mailcontrol.com/http-resources/notification-pages/jquery-1.4.2.min.js"></script>
            <script src="http://www.mailcontrol.com/http-resources/ie6_joined_classes.js"></script>
            <script>
              var IEPNGFix = window.IEPNGFix || {};
              IEPNGFix.blankImg = "http://www.mailcontrol.com/http-resources/iepngfix/blank.gif";
            </script>
            <script src="http://www.mailcontrol.com/http-resources/iepngfix/jquery.iepngfix.js"></script>
        <![endif]--><style id=""></style>
<title id="">Cannot Connect</title>
</head>
<body class="loading" id="_PAGE_INNER_ID_">
        <div class="container" id="container">
            <div class="row">
                <div class="span10 offset1" id="notify">
                    <div class="notify-title-box">
                        <img id="title_icon" src="http://www.mailcontrol.com/http-resources/notification-pages/icons60/error.png" height="60" width="60" class=""><span id="notify-title" class="">Cannot Connect</span>
                        <div id="titleBlink"></div>
                    </div>
                    <div class="notify-box">
                        <div id="notify-content" class="">
<div class="row">
            <div class="span8 explanation">The requested URL is not available.</div>
      </div>
      <div class="row firstName">
          <div class="span2 name">Requested URL:</div>
          <div class="span6 explanation">http://127.0.0.1:11001/dip/api/tintercom/datasets/get-schema/</div&gt;
      </div>
      <div class="row lastName">
          <div class="span2 name">Recommendations</div>
          <div class="span6 explanation wrapURL">
              <ul>
<li>Ensure the URL is entered correctly.</li>
                <li>Refresh your browser window.</li>
                <li>Try again later.</li>
              </ul>
</div>
      </div>
</div>
                    </div>
                    <div class="" id="footerRow">
                        <div id="footer" class="">
                           <img src="https://cra.gfi.fr/common/images/logo_login.jpg" height="66" width="156" id="bottom-logo" class=""><span id="footer-text" class=""></span>
                           <div class="clear-float"></div>
                        </div>
                        <div class="clear-float"></div>
                    </div>
                </div>
            </div>
        </div>
        <div class="clear-float"></div>
        <script src="http://www.mailcontrol.com/http-resources/notification-pages/empty.js"></script><!--[if !(IE 6)]>
            <script src="http://www.mailcontrol.com/http-resources/notification-pages/respond.src.js"></script>
         <![endif]--><!-- Technical information: Invalid internal server -->
</body>
</html>

Traceback:

1. dkuReadDataset("Education", samplingMethod = "head", nbRows = 1e+05)
2. dku__check_api_error(resp, "Failed to read dataset")
3. stop(error)

Clément_Stenac · April 2017

Hi,

This error is caused by a proxy which intercepts localhost connections.

You can try adding the following line at the beginning of your script:
Sys.unsetenv("http_proxy")

If that does not work, it means it's a transparent proxy and you'll have to see with your system administrator to ask about disabling the proxy on localhost.

opiechow · March 2019

Hello Clément,

i face the same problem and wonder if you can advice me how to solve it in more detail?

I am trying to load a dataset that i have uploaded:
morevars<-dkuReadDataset("Sales_PA_GER_added", samplingMethod="head", nbRows=100000)<BR />
and am getting the error:
Error in dku__check_api_error(resp, "Failed to read dataset"): Failed to read dataset (HTTP code 403): Ticket not given or unrecognized. Unload and reload the notebook.
Traceback:

1. dkuReadDataset("Sales_PA_GER_decomp_prep_joined2", samplingMethod = "head",
. nbRows = 1e+05)
2. dku__check_api_error(resp, "Failed to read dataset")
3. stop(error)

This error hinders me from continuing to work with my R codes in Dataiku, therefore I would very appreciate if we could troubleshoot here.

Thank you and kind regards,
Oliver

MarkPundurs · November 2022

@Clément_Stenac
is localhost the client machine on which the browser is running, or the server on which DSS is running?

Notebook R : Error in reading dataset with dkuReadDataSet

Best Answer

Answers

Categories

Setup Info

Tags