DALQueryError question

[tahumada]

Hi,
I am trying to use your notebook PS1_DR2_TAP.ipynb
and I am running into an error while trying a simple query like

job = TAP_service.run_async(""" SELECT objID, RAMean, DecMean, nDetections, ng, nr, ni, nz, ny, gMeanPSFMag, rMeanPSFMag, iMeanPSFMag, zMeanPSFMag, yMeanPSFMag FROM dbo.MeanObjectView WHERE CONTAINS(POINT('ICRS', RAMean, DecMean),CIRCLE('ICRS',187.706,12.391,.2))=1 AND nDetections > 1 """)

or

TAP_service.run_async(TAP_service.examples[0])

I am using the 1.4.1 version of pyvo (and python3.10) and the error I get for both queries is

`---------------------------------------------------------------------------
DALQueryError Traceback (most recent call last)
Cell In[69], line 1
----> 1 TAP_service.run_async(TAP_service.examples[0])

File ~/miniconda3/envs/geminiconda/lib/python3.10/site-packages/pyvo/dal/tap.py:302, in TAPService.run_async(self, query, language, maxrec, uploads, **keywords)
299 job = AsyncTAPJob.create(
300 self.baseurl, query, language, maxrec, uploads, self._session, **keywords)
301 job = job.run().wait()
--> 302 job.raise_if_error()
303 result = job.fetch_result()
304 job.delete()

File ~/miniconda3/envs/geminiconda/lib/python3.10/site-packages/pyvo/dal/tap.py:958, in AsyncTAPJob.raise_if_error(self)
956 msg = self._job.errorsummary.message.content
957 msg = msg or ""
--> 958 raise DALQueryError("Query Error: " + msg, self.url)

DALQueryError: Query Error: Error executing underlying query
`

I managed to run successfully the TAP_service.run_sync() query, but is there a way to avoid this issue?

Cheers,
Tomás

[scfleming]

Hi, this is the deprecated notebooks repository. First, can you try running the notebook that is in the current repository:
https://github.com/spacetelescope/mast_notebooks

If that still fails, can you please open an issue over in that repo?

Thanks!