HSTbanner

Visit Status Report for 14935

Tue Dec 10 09:24:44 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 = '14935' 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 = '14935' and pdq.pdq_obset_id in () and pdq.pdq_quality != ''
Visit
Status
Targets
Configs
Orbits
Start UT
End UT
Repeat
51 Executed
Collecting
AV75
NONE
COS
COS/FUV
COS/NUV
1 Jun 26, 2017 05:26:59 Jun 26, 2017 06:27:08 Repeat of visit(s) 01 in this program by HOPR 9999
52 Executed
Collecting
AV75
NONE
COS
COS/FUV
COS/NUV
1 Jul 2, 2017 21:00:00 Jul 2, 2017 22:45:54
01 Failed
Collecting
AV75
NONE
COS
COS/FUV
COS/NUV
1 Jun 20, 2017 17:45:49 Jun 20, 2017 18:45:58 Rescheduled by HOPR 9999 as visit 51 in this program