HSTbanner

Visit Status Report for 14909

Sun Dec 8 19:00:24 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 = '14909' 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 = '14909' and pdq.pdq_obset_id in () and pdq.pdq_quality != ''
Visit
Status
Targets
Configs
Orbits
Start UT
End UT
Repeat
01 Executed
Collecting
EPSILON-ERI COS/FUV
COS/NUV
4 Mar 7, 2017 06:15:26 Mar 7, 2017 12:04:15
02 Executed
Collecting
EPSILON-ERI COS/FUV
COS/NUV
4 Mar 12, 2017 03:54:59 Mar 12, 2017 09:39:05
3A Executed
Collecting
AV75 COS/FUV 1 Apr 4, 2017 13:25:58 Apr 4, 2017 16:22:37 Repeat of visit(s) 03 in this program by HOPR 9999
03 Failed
Collecting
AV75 COS/FUV
COS/NUV
1 Mar 16, 2017 18:23:24 Mar 16, 2017 20:05:38 Rescheduled by HOPR 9999 as visit 3A in this program