Notebook R : Error in reading dataset with dkuReadDataSet

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker

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)
Tagged:

Best Answer

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer Posts: 753 Dataiker
    Answer ✓
    Options
    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.

Answers

  • opiechow
    opiechow Registered Posts: 1 ✭✭✭✭
    Options
    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
    MarkPundurs Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 26 ✭✭✭✭
    Options

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

Setup Info
    Tags
      Help me…