HSTbanner

Visit Status Report for 14929

Sun Dec 8 19:14:10 GMT 2019

DATABASE COMMUNICATION ERROR:
Traceback (most recent call last): File "/grp/websites/sylvester.stsci.edu/cgi-bin/lib/python/ops_utilities.py", line 1562, in Database pyodbcResult = db.execute(sql) pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect syntax near ')'. (102) (SQLExecDirectW)")
in the following statement sent to database dadsops_rep on server HARPO:
select count(*) from pdq_summary pdq, sogs_rep.dbo.qobservation qob where pdq.pdq_program_id collate Latin1_General_100_BIN = qob.program_id and pdq.pdq_obset_id collate Latin1_General_100_BIN = qob.obset_id and pdq.pdq_obsnum collate Latin1_General_100_BIN = qob.ob_number and qob.proposal_id = '14929' and pdq.pdq_obset_id in () and pdq.pdq_quality = 'OK'
DATABASE COMMUNICATION ERROR:
Traceback (most recent call last): File "/grp/websites/sylvester.stsci.edu/cgi-bin/lib/python/ops_utilities.py", line 1562, in Database pyodbcResult = db.execute(sql) pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Incorrect syntax near ')'. (102) (SQLExecDirectW)")
in the following statement sent to database dadsops_rep on server HARPO:
select count(*) from pdq_summary pdq, sogs_rep.dbo.qobservation qob where pdq.pdq_program_id collate Latin1_General_100_BIN = qob.program_id and pdq.pdq_obset_id collate Latin1_General_100_BIN = qob.obset_id and pdq.pdq_obsnum collate Latin1_General_100_BIN = qob.ob_number and qob.proposal_id = '14929' and pdq.pdq_obset_id in () and pdq.pdq_quality != ''
Visit
Status
Targets
Configs
Orbits
Start UT
End UT
Repeat
51 Executed
Collecting
NONE
V-KL-UMA
COS
COS/FUV
COS/NUV
2 May 23, 2017 17:18:02 May 23, 2017 21:10:24 Repeat of visit(s) 01 in this program by HOPR 87879
01 Failed
Collecting
NONE
V-KL-UMA
COS
COS/FUV
COS/NUV
2 May 8, 2017 21:34:07 May 8, 2017 23:57:17 Rescheduled by HOPR 87879 as visit 51 in this program