Notebook R : Error in reading dataset with dkuReadDataSet

Solved!
UserBird
Dataiker
Notebook R : Error in reading dataset with dkuReadDataSet

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)
0 Kudos
1 Solution
Clément_Stenac
Dataiker
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.

View solution in original post

0 Kudos
3 Replies
Clément_Stenac
Dataiker
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.
0 Kudos
opiechow
Level 1
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)

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
0 Kudos
MarkPundurs
Level 3

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

0 Kudos

Labels

?
Labels (1)
A banner prompting to get Dataiku