OSSOS / MOP

The Moving Object Pipeline: discovery & tracking of trans-Neptunian objects
GNU General Public License v3.0
4 stars 9 forks source link

[MOP] ObsStatus.py not working with new Advanced Search schema #322

Closed mtbannister closed 10 years ago

mtbannister commented 10 years ago

The TAP query has broken. Couldn't see any terms that it has in common with the search corrected in 8e79296fc8e3de4b15406b374e6b225e16474b46 that are now incorrect; must be one of the additional terms in the query that's changed in the new API. Submitted a helpdesk ticket for the API page as I can't find the API page we looked at to make 8e79296fc8e3de4b15406b374e6b225e16474b46.

Apache Tomcat/5.5.20 - Error report

HTTP Status 404 - /tap/syncLANG=ADQL&QUERY=SELECT+Observation.target_name+as+TargetName,+COORD1(CENTROID(Plane.position_bounds))+AS+RA,COORD2(CENTROID(Plane.position_bounds))+AS+DEC,+Plane.time_bounds_cval1+AS+StartDate,+Plane.time_exposure+AS+ExposureTime,+Observation.instrument_name+AS+Instrument,+Plane.energy_bandpassName+AS+Filter,+Observation.observationID+AS+dataset_name,+Observation.proposal_id+AS+ProposalID,+Observation.proposal_pi+AS+PI+FROM+caom2.Observation+AS+Observation+JOIN+caom2.Plane+AS+Plane+ON+Observation.obsID+=+Plane.obsID+WHERE++(+Observation.collection+=+'CFHT'+)+AND+Plane.time_bounds_cval1+%3E+56293+AND+Plane.calibrationLevel=1+AND+Observation.proposal_id+IN+('13AP05',+'13AP06',+'13BP05',+'13BP06',+'14AP05',+'14AP06',+'14BP05',+'14BP06')+&REQUEST=doQuery&FORMAT=votable


type Status report

message /tap/syncLANG=ADQL&QUERY=SELECT+Observation.target_name+as+TargetName,+COORD1(CENTROID(Plane.position_bounds))+AS+RA,COORD2(CENTROID(Plane.position_bounds))+AS+DEC,+Plane.time_bounds_cval1+AS+StartDate,+Plane.time_exposure+AS+ExposureTime,+Observation.instrument_name+AS+Instrument,+Plane.energy_bandpassName+AS+Filter,+Observation.observationID+AS+dataset_name,+Observation.proposal_id+AS+ProposalID,+Observation.proposal_pi+AS+PI+FROM+caom2.Observation+AS+Observation+JOIN+caom2.Plane+AS+Plane+ON+Observation.obsID+=+Plane.obsID+WHERE++(+Observation.collection+=+'CFHT'+)+AND+Plane.time_bounds_cval1+%3E+56293+AND+Plane.calibrationLevel=1+AND+Observation.proposal_id+IN+('13AP05',+'13AP06',+'13BP05',+'13BP06',+'14AP05',+'14AP06',+'14BP05',+'14BP06')+&REQUEST=doQuery&FORMAT=votable

description The requested resource (/tap/syncLANG=ADQL&QUERY=SELECT+Observation.target_name+as+TargetName,+COORD1(CENTROID(Plane.position_bounds))+AS+RA,COORD2(CENTROID(Plane.position_bounds))+AS+DEC,+Plane.time_bounds_cval1+AS+StartDate,+Plane.time_exposure+AS+ExposureTime,+Observation.instrument_name+AS+Instrument,+Plane.energy_bandpassName+AS+Filter,+Observation.observationID+AS+dataset_name,+Observation.proposal_id+AS+ProposalID,+Observation.proposal_pi+AS+PI+FROM+caom2.Observation+AS+Observation+JOIN+caom2.Plane+AS+Plane+ON+Observation.obsID+=+Plane.obsID+WHERE++(+Observation.collection+=+'CFHT'+)+AND+Plane.time_bounds_cval1+%3E+56293+AND+Plane.calibrationLevel=1+AND+Observation.proposal_id+IN+('13AP05',+'13AP06',+'13BP05',+'13BP06',+'14AP05',+'14AP06',+'14BP05',+'14BP06')+&REQUEST=doQuery&FORMAT=votable) is not available.


Apache Tomcat/5.5.20

mtbannister commented 10 years ago

Checked query terms against http://www.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/tap/tables and can't find anything that doesn't match. Hmm.

mtbannister commented 10 years ago

Seems to have been resolved by 963aa69cd76b7285d7bb09cc10587e89e6982d1a: query now functional. No data showing up from CFHT from this run as yet though.