Back to YQL Forum
0

YQL The current table 'yahoo.finance.quotes' has been blocked

Lately I have been receiving table locked message very often when running yql query. Sometimes this error starts coming back after 2-3 calls. I am sure I am no way close to hourly/daily limit of API calls.

Query:
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22BAC%22)&format=json&env=http://datatables.org/alltables.env&diagnostics=true
Result:
{"query":{"count":0,"created":"2012-03-24T17:55:25Z","lang":"en-US","diagnostics":{"publiclyCallable":"true","redirect":{"from":"http://datatables.org/alltables.env","status":"301","content":"http://www.datatables.org/alltables.env"},"url":[{"execution-start-time":"137","execution-stop-time":"441","execution-time":"304","proxy":"DEFAULT","content":"http://datatables.org/alltables.env"},{"execution-start-time":"459","execution-stop-time":"506","execution-time":"47","proxy":"DEFAULT","content":"http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml"}],"javascript":{"name":"yahoo.finance.quotes","verb":"select","content":"com.yahoo.platforms.pipes.model.ModuleException: Error Codes: js.blocked.execute.request Message: \"The current table 'yahoo.finance.quotes' has been blocked. It exceeded the allotted quotas of either time or instructions\""},"user-time":"509","service-time":"351","build-version":"26062"},"results":null}}Is there any known issue with yql and yahoo.finance.quotes? I will appreciate any help on this.

by
Report Abuse
11 Replies
    • Mar 24, 2012
    I just experienced the same thing happening. Mine was more than 2-3 calls, but it was OAuth signed, and no more than maybe 50 calls. This is very disruptive, what's going on?
    Report Abuse
    0
  • It started working for me wthin an hour this time. Sometimes it errors out for few hours. There seems to be a bug in yql query to Yahoo Finance tables. I have noticed that csv api works even when yql query returns error. I hope I don&#39;t have to switch to csv api due to this bug, yql is way cleaner approach &nbsp;<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>( @ 24 Mar 2012 12:58 PM)</cite><blockquote class="quotemain">I just experienced the same thing happening. Mine was more than 2-3 calls, but it was OAuth signed, and no more than maybe 50 calls. This is very disruptive, what&#39;s going on?</blockquote></div></div>
    Report Abuse
    0
  • This is happening again today. YQL is such a great service and its frustrating to see it not working due to this bug. Is anyone from Yahoo available to look into this issue?
    Report Abuse
    0
  • I am experiencing the same issue. See my thread called &quot;Finance Data Rate Limit&quot;
    Report Abuse
    0
  • Habib,<br>Did you receive any information from the forum about this issue?<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Habib @ 26 Mar 2012 11:02 AM)</cite><blockquote class="quotemain">I am experiencing the same issue. See my thread called &quot;Finance Data Rate Limit&quot;</blockquote></div></div>
    Report Abuse
    0
  • Habib,<br>Did you find any information from the forum about this issue?&nbsp;
    Report Abuse
    0
  • Happened again on 3/26/2012 @ 8:50pm.
    Report Abuse
    0
  • I am still waiting for an answer...<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Dipen @ 26 Mar 2012 3:24 PM)</cite><blockquote class="quotemain">Habib,<br>Did you find any information from the forum about this issue?&nbsp;</blockquote></div></div>
    Report Abuse
    0
  • Guys,<br><br>This is a community contributed table and used by multiple people. We mark a table as abusive if it seems to be hogging our resources, or consistently taking more than 30s to execute (this could also be due to a slow downstream source). This particular table seems to be getting marked as abusive more times than others. We also remove our blocks after a while, hence the sporadic working of the table.<br><br>I would advise that you wait for official tables from Yahoo! Finance if your application needs a stabler data source.<br><br>Sriram
    Report Abuse
    1
  • Sriram,<br>Thanks for your reply and providing information on this blocking. Are you aware of any plans and/or timeline for official Yahoo! Finance tables?<br><br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Sriram @ 27 Mar 2012 3:56 PM)</cite><blockquote class="quotemain">Guys,<br><br>This is a community contributed table and used by multiple people. We mark a table as abusive if it seems to be hogging our resources, or consistently taking more than 30s to execute (this could also be due to a slow downstream source). This particular table seems to be getting marked as abusive more times than others. We also remove our blocks after a while, hence the sporadic working of the table.<br><br>I would advise that you wait for official tables from Yahoo! Finance if your application needs a stabler data source.<br><br>Sriram</blockquote></div></div>
    Report Abuse
    0

  • Is there any word on when an official Yahoo! Finance table will be available? Please let me know if there is one available.

    Report Abuse
    0
Ask a Question

Recent Posts

in YQL