Notebook R : Error in reading dataset with dkuReadDataSet
![UserBird](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar12.png)
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>
</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
-
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
-
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 -
@Clément_Stenac
is localhost the client machine on which the browser is running, or the server on which DSS is running?