NASA-NAVO / navo-workshop

Tutorial notebooks for how to use PyVO to access NASA and other data in Python.
https://NASA-NAVO.github.io/navo-workshop
BSD 3-Clause "New" or "Revised" License
41 stars 27 forks source link

BUG: error in heasarc query #146

Closed bsipocz closed 11 months ago

bsipocz commented 11 months ago

I see this exception in the catalog_queries notebook. Given that there is also the commented out line, I would like someone from heasarc having a look at it and say a verdict of whether there is a bug, misusage, or just an issue with the server.

https://output.circle-artifacts.com/output/job/3076990a-a36b-40a8-bb38-f0cdb85a59fc/artifacts/0/_build/html/content/reference_notebooks/catalog_queries.html

query="""
    SELECT cat.ra, cat.dec, Radial_Velocity, bmag, morph_type
    FROM zcat cat, tap_upload.mysources mt
    WHERE
    contains(point('ICRS',cat.ra,cat.dec),circle('ICRS',mt.ra,mt.dec,0.01))=1
    and Radial_Velocity > 0
    ORDER by cat.ra"""
zcattable = heasarc.service.run_async(query, uploads={'mysources': 'data/my_sources.xml'})
#zcattable = heasarc.search(query, uploads={'mysources': 'data/my_sources.xml'})
mytable = zcattable.to_table()
mytable
---------------------------------------------------------------------------
DALQueryError                             Traceback (most recent call last)
Cell In[16], line 8
      1 query="""
      2     SELECT cat.ra, cat.dec, Radial_Velocity, bmag, morph_type
      3     FROM zcat cat, tap_upload.mysources mt
   (...)
      6     and Radial_Velocity > 0
      7     ORDER by cat.ra"""
----> 8 zcattable = heasarc.service.run_async(query, uploads={'mysources': 'data/my_sources.xml'})
      9 #zcattable = heasarc.search(query, uploads={'mysources': 'data/my_sources.xml'})
     10 mytable = zcattable.to_table()

File ~/project/.tox/py310-buildhtml/lib/python3.10/site-packages/pyvo/dal/tap.py:303, in TAPService.run_async(self, query, language, maxrec, uploads, **keywords)
    301 job = job.run().wait()
    302 job.raise_if_error()
--> 303 result = job.fetch_result()
    304 job.delete()
    306 return result

File ~/project/.tox/py310-buildhtml/lib/python3.10/site-packages/pyvo/dal/tap.py:984, in AsyncTAPJob.fetch_result(self)
    980     raise DALServiceError.from_except(ex, self.url)
    982 response.raw.read = partial(
    983     response.raw.read, decode_content=True)
--> 984 return TAPResults(votableparse(response.raw.read), url=self.result_uri, session=self._session)

File ~/project/.tox/py310-buildhtml/lib/python3.10/site-packages/pyvo/dal/adhoc.py:111, in AdhocServiceResultsMixin.__init__(self, votable, url, session)
    110 def __init__(self, votable, url=None, session=None):
--> 111     super().__init__(votable, url=url, session=session)
    113     self._adhocservices = list(
    114         resource for resource in votable.resources
    115         if resource.type == "meta" and resource.utype == "adhoc:service"
    116     )

File ~/project/.tox/py310-buildhtml/lib/python3.10/site-packages/pyvo/dal/query.py:322, in DALResults.__init__(self, votable, url, session)
    320 self._status = self._findstatus(votable)
    321 if self._status[0].lower() not in ("ok", "overflow"):
--> 322     raise DALQueryError(self._status[1], self._status[0], url)
    324 if self._status[0].lower() == "overflow":
    325     warn("Partial result set. Potential causes MAXREC, async storage space, etc.",
    326          category=DALOverflowWarning)

DALQueryError: Error[s] detected in query preprocessing