Back to YQL Forum
0

Open Table only returns results when debug=true

Hi,

I'm having an issue with an open data table. Sometimes it returns results but then sometimes it just stops working. I don't understand why it is not consistent. When it is not working, the response is

CODE
<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
    yahoo:count="0" yahoo:created="2011-05-27T14:40:08Z" yahoo:lang="en-US">
    <diagnostics>
        <publiclyCallable>true</publiclyCallable>
        <redirect from="http://datatables.org/alltables.env" status="301"><![CDATA[http://www.datatables.org/alltables.env]]></redirect>
        <url execution-time="5" proxy="DEFAULT"><![CDATA[http://datatables.org/alltables.env]]></url>
        <url execution-time="1" proxy="DEFAULT"><![CDATA[http://www.datatables.org/yahoo/finance/yahoo.finance.options.xml]]></url>
        <url
            error="Redirected to a robots.txt restricted URL: http://finance.yahoo.com/q/op?s=GOOG&amp;m=2011-06"
            execution-time="1" http-status-code="403"
            http-status-message="Forbidden" proxy="DEFAULT"><![CDATA[http://finance.yahoo.com/q/op?s=GOOG&m=2011-06]]></url>
        <javascript><![CDATA[Exception: Requesting a robots.txt restricted URL: http://finance.yahoo.com/q/op?s=GOOG&m=2011-06, url: http://finance.yahoo.com/q/op?s=GOOG&m=2011-06]]></javascript>
        <javascript execution-time="2" instructions-used="2000" table-name="yahoo.finance.options"/>
        <user-time>24</user-time>
        <service-time>7</service-time>
        <build-version>17991</build-version>
    </diagnostics> 
    <results/>
</query>



However, if I add "debug=true", I get results as expected

CODE
<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
    yahoo:count="1" yahoo:created="2011-05-27T15:27:17Z" yahoo:lang="en-US">
    <diagnostics>
        <publiclyCallable>true</publiclyCallable>
        <redirect from="http://datatables.org/alltables.env" status="301"><![CDATA[http://www.datatables.org/alltables.env]]></redirect>
        <url execution-time="17"
            id="da360a16-a8d8-4324-bea7-c5fe1b665e65" proxy="DEFAULT"><![CDATA[http://datatables.org/alltables.env]]></url>
        <url execution-time="5"
            id="dc22f785-615b-40a2-973a-cbdb2e8cf846" proxy="DEFAULT"><![CDATA[http://www.datatables.org/yahoo/finance/yahoo.finance.options.xml]]></url>
        <url execution-time="2291"
            id="e9208216-d68f-40a2-ad92-470eead36f81" proxy="DEFAULT"><![CDATA[http://finance.yahoo.com/robots.txt]]></url>
        <url execution-time="3629"
            id="1937b0e6-a8c7-48f9-9bec-32bd11940f65" proxy="DEFAULT"><![CDATA[http://finance.yahoo.com/q/op?s=GOOG&m=2011-06]]></url>
        <log>results.length(): 2</log>
        <javascript execution-time="3939" instructions-used="1357158" table-name="yahoo.finance.options"/>
        <user-time>3981</user-time>
        <service-time>5942</service-time>
        <build-version>17991</build-version>
    </diagnostics> 
    <results>
        <optionsChain expiration="2011-06-17" symbol="GOOG">
            ... EXPECTED DATA...
        </optionsChain>
    </results>
</query>


Any ideas what is going on here?

by
Report Abuse
9 Replies
  • I am having the same issue.
    I have posted on other threads and am waiting for a decent response as we are not the only people with this issue - it is a YQL problem of some description.
    Report Abuse
    0
  • I thought that perhaps the issue was too many requests from the same ip...however, I was doing very few requests so that probably is not the reason.
    Report Abuse
    0
  • Can you please post the queries where you are seeing this.


    Thanks -Paul
    YQL Team
    Report Abuse
    0

  • Its doing it with this query NOW!:
    select * from html where url = 'http://www.fabstuff.net/products/682';
    Report Abuse
    0
  • Ashley,

    Can you post the results and query where you see the issue here?

    Thanks -Paul
    YQL Team
    Report Abuse
    0
  • See here also: &nbsp;http://developer.yahoo.com/forum/YQL/robots-txt-error-is-back/1279292947000-9cd7873e-67cc-33b1-b6c5-872aaa2b5496
    Report Abuse
    0
  • I will file a bug on this.


    Thanks -Paul
    YQL Team
    Report Abuse
    0
  • Any news as to progress with this?  How do you check the status of YQL bugs?
    Thanks ;-)
    Report Abuse
    0

  • Is there any progress on this bug? I am experiencing it right now.

    Report Abuse
    0
Ask a Question

Recent Posts

in YQL