TOPCAT not finding tap table: Service Error

Question

I'm getting this message when I try to connect TOPCAT to the NOAO tap table, any ideas?

java.io.IOException: Service Error: "IllegalArgumentException: net.sf.jsqlparser.JSQLParserException JSQLParserException:  ParseException: Encountered "LEFT" at line 1, column 257.
Was expecting one of:
    "JOIN" ...
    "INNER" ...
    "OUTER" ...
    "," ..."
    at uk.ac.starlink.vo.RegTapRegistryQuery.getQueryResources(RegTapRegistryQuery.java:213)
    at uk.ac.starlink.vo.RegTapRegistryQuery.getQueryIterator(RegTapRegistryQuery.java:237)
    at uk.ac.starlink.vo.RegistryPanel$6.run(RegistryPanel.java:364)
Caused by: org.xml.sax.SAXParseException; lineNumber: 9; columnNumber: 19; Service Error: "IllegalArgumentException: net.sf.jsqlparser.JSQLParserException JSQLParserException:  ParseException: Encountered "LEFT" at line 1, column 257.
Was expecting one of:
    "JOIN" ...
    "INNER" ...
    "OUTER" ...
    "," ..."
    at uk.ac.starlink.vo.DalResultStreamer.endElement(DalResultStreamer.java:124)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1776)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2964)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:504)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:643)
    at uk.ac.starlink.vo.DalResultStreamer.streamResultTable(DalResultStreamer.java:225)
    at uk.ac.starlink.vo.TapQuery.streamResultVOTable(TapQuery.java:692)
    at uk.ac.starlink.vo.TapQuery.executeSync(TapQuery.java:240)
    at uk.ac.starlink.vo.RegTapRegistryQuery.getQueryResources(RegTapRegistryQuery.java:210)
    ... 2 more

Answer 1

Hi there,

Can you elaborate on when the error occurs?  If it occurs when you are issuing a query, what is the query?  It looks like TOPCAT is encountering an error in the query that you are submitting.  You might try one of the simple example queries, e.g. SELECT TOP 1000 ra, dec FROM nsc_dr1.object; this appears to be returning results in my test.

Comments

I should clarify, this is prior to doing any search.
This error comes after I put in the location of the TAP table "http:://datalab.noao.edu/tap" then click "find services".
I want to crossmatch my catalogues with DES and Topcat is the easiest, but I'm not even getting that far.

---

Hi Blair,

Do you mean "Use service"?  I'm afraid I cannot reproduce the error, if I enter "http://datalab.noao.edu/tap" in the TAP URL box and click Use service, I get the list of our tables.

Was your plan to query the DES catalog through datalab TAP service, transfer the results, and do the crossmatch locally?

Note that you can do a crossmatch through Data Lab by uploading your catalog to mydb and then running a crossmatch query.  But this would need to be done through Python as an authenticated user, we don't yet have anonymous TAP upload.  If you want to do this, login to Data Lab and launch the Jupyter notebook server, your notebooks directory should contain an example of running crossmatches in the HowTos folder.  If you can't find it, you may need to copy the latest notebook set.  To do this, open a Terminal window through the Jupyter interface and type 'getlatest' at the prompt.

---

ok so I was trying to avoid that, but I guess I can do it.

The problem arises when I try to do a "Multicone search" in TOPCAT GUI version 4.3-2, and I put in the TAP table address in the "Available Cone Search Services : Registry" with regTAP selected and then I get the above error message.

---

Found myself trying to do the same thing.

Are Multi-Cone Searches (e.g. via the stilts/topcat interface) possible on the data lab's tables?

In Topcat that would mean being able to specify a

Topcat --> VO --> Multicone --> Cone Search URL