2012012181058-I-INFO-Running command-line mode. 2012012181058-D-DIAG-datasets=['j8y503011'] 2012012181058-D-DIAG-DEFAULT used for REF_SELECT_FILE: OPUS_DEFINITIONS_DIR:reference_file_defs.xml 2012012181059-D-DIAG-DEFAULT used for INPATH: /hstdev/project/mswam/opus/hlp 2012012181059-D-DIAG-DEFAULT used for TRLPATH: /hstdev/project/mswam/opus/hlp 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding FLASHCUR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding FW1OFFST 2012012181059-D-DIAG-get_restriction_keywords: adding FW1OFFST 2012012181059-D-DIAG-get_restriction_keywords: adding FW2OFFST 2012012181059-D-DIAG-get_restriction_keywords: adding FW2OFFST 2012012181059-D-DIAG-get_restriction_keywords: adding FWSOFFST 2012012181059-D-DIAG-get_restriction_keywords: adding FWSOFFST 2012012181059-D-DIAG-get_restriction_keywords: adding OBSTYPE 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding OBSTYPE 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-get_restriction_keywords: adding OBSTYPE 2012012181059-D-DIAG-get_restriction_keywords: adding DETECTOR 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'GRAPHTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_graphtab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'COMPTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_comptab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FLSHFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_flshfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FLSHCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_flshcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DETECTOR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_detector') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CCDAMP' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_ccdamp') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CCDGAIN' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_ccdgain') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FLASHCUR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_flashcur') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'SHUTRPOS' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_shutrpos') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'IDCTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_idctab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'BIASFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_biasfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'BIASCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_biascorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'XCORNER' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_a_data', 'aca_xcorner') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'YCORNER' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_a_data', 'aca_ycorner') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'NUMCOLS' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_a_data', 'aca_numcols') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'NUMROWS' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_a_data', 'aca_numrows') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'LTV1' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_chip', 'acc_ltv1') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'LTV2' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_chip', 'acc_ltv2') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CCDCHIP' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_ccdchip') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DARKFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_darkfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DARKCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_darkcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'PFLTFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_pfltfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FLATCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_flatcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FILTER1' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_filter1') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FILTER2' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_filter2') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'OBSTYPE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_obstype') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FW1OFFST' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_fw1offst') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FW2OFFST' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_fw2offst') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'FWSOFFST' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_fwsoffst') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'LFLTFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_lfltfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DFLTFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_dfltfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'SHADFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_shadfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'SHADCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_shadcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'ATODTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_atodtab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'ATODCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_atodcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'BPIXTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_bpixtab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DQICORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_dqicorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CCDTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_ccdtab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'OSCNTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_oscntab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CRREJTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_crrejtab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CRCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_crcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'MLINTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_mlintab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'GLINCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_glincorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'MDRIZTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_mdriztab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DRIZCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_drizcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'DGEOFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_dgeofile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'CFLTFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_cfltfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'SPOTTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_spottab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'IMPHTTAB' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_imphttab') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'PHOTCORR' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_photcorr') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'D2IMFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_d2imfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'NPOLFILE' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using adjusted source ('acs_ref_data', 'acr_best_npolfile') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'TARGNAME' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('science', 'sci_targname') 2012012181059-D-DIAG-SELECT dkw_fieldname, hda_tablename FROM dads_keywords d, hda_fields h WHERE dkw_fieldname = hda_fieldname and dkw_keyword = 'EXPSTART' and dkw_real_instrument = 'ACS' 2012012181059-D-DIAG-using source ('acs_ref_data', 'acr_expstart') 2012012181059-D-DIAG-self.dbsource={'FW1OFFST': ('acs_ref_data', 'acr_fw1offst'), 'LFLTFILE': ('acs_ref_data', 'acr_best_lfltfile'), 'GLINCORR': ('acs_ref_data', 'acr_best_glincorr'), 'D2IMFILE': ('acs_ref_data', 'acr_best_d2imfile'), 'PHOTCORR': ('acs_ref_data', 'acr_best_photcorr'), 'FLSHCORR': ('acs_ref_data', 'acr_best_flshcorr'), 'FILTER2': ('acs_ref_data', 'acr_filter2'), 'MLINTAB': ('acs_ref_data', 'acr_best_mlintab'), 'XCORNER': ('acs_a_data', 'aca_xcorner'), 'FWSOFFST': ('acs_ref_data', 'acr_fwsoffst'), 'BIASCORR': ('acs_ref_data', 'acr_best_biascorr'), 'DRIZCORR': ('acs_ref_data', 'acr_best_drizcorr'), 'OBSTYPE': ('acs_ref_data', 'acr_obstype'), 'PFLTFILE': ('acs_ref_data', 'acr_best_pfltfile'), 'EXPSTART': ('acs_ref_data', 'acr_expstart'), 'FLATCORR': ('acs_ref_data', 'acr_best_flatcorr'), 'BPIXTAB': ('acs_ref_data', 'acr_best_bpixtab'), 'BIASFILE': ('acs_ref_data', 'acr_best_biasfile'), 'SPOTTAB': ('acs_ref_data', 'acr_best_spottab'), 'CCDAMP': ('acs_ref_data', 'acr_ccdamp'), 'CFLTFILE': ('acs_ref_data', 'acr_best_cfltfile'), 'FW2OFFST': ('acs_ref_data', 'acr_fw2offst'), 'IMPHTTAB': ('acs_ref_data', 'acr_best_imphttab'), 'FLSHFILE': ('acs_ref_data', 'acr_best_flshfile'), 'DGEOFILE': ('acs_ref_data', 'acr_best_dgeofile'), 'IDCTAB': ('acs_ref_data', 'acr_best_idctab'), 'COMPTAB': ('acs_ref_data', 'acr_best_comptab'), 'DQICORR': ('acs_ref_data', 'acr_best_dqicorr'), 'FLASHCUR': ('acs_ref_data', 'acr_flashcur'), 'NPOLFILE': ('acs_ref_data', 'acr_best_npolfile'), 'FILTER1': ('acs_ref_data', 'acr_filter1'), 'DARKCORR': ('acs_ref_data', 'acr_best_darkcorr'), 'GRAPHTAB': ('acs_ref_data', 'acr_best_graphtab'), 'ATODCORR': ('acs_ref_data', 'acr_best_atodcorr'), 'CCDCHIP': ('acs_chip', 'acc_ccdchip'), 'SHADCORR': ('acs_ref_data', 'acr_best_shadcorr'), 'NUMCOLS': ('acs_a_data', 'aca_numcols'), 'MDRIZTAB': ('acs_ref_data', 'acr_best_mdriztab'), 'TARGNAME': ('science', 'sci_targname'), 'LTV2': ('acs_chip', 'acc_ltv2'), 'DARKFILE': ('acs_ref_data', 'acr_best_darkfile'), 'SHUTRPOS': ('acs_ref_data', 'acr_shutrpos'), 'LTV1': ('acs_chip', 'acc_ltv1'), 'DFLTFILE': ('acs_ref_data', 'acr_best_dfltfile'), 'NUMROWS': ('acs_a_data', 'aca_numrows'), 'ATODTAB': ('acs_ref_data', 'acr_best_atodtab'), 'CCDGAIN': ('acs_ref_data', 'acr_ccdgain'), 'CCDTAB': ('acs_ref_data', 'acr_best_ccdtab'), 'SHADFILE': ('acs_ref_data', 'acr_best_shadfile'), 'YCORNER': ('acs_a_data', 'aca_ycorner'), 'DETECTOR': ('acs_ref_data', 'acr_detector'), 'CRCORR': ('acs_ref_data', 'acr_best_crcorr'), 'CRREJTAB': ('acs_ref_data', 'acr_best_crrejtab'), 'OSCNTAB': ('acs_ref_data', 'acr_best_oscntab')} 2012012181059-D-DIAG-SELECT COUNT(*) FROM hda_fields WHERE hda_fieldname = 'acr_data_set_name' 2012012181059-D-DIAG-SELECT acr_fw1offst,acr_best_lfltfile,acr_best_glincorr,acr_best_photcorr,acr_best_flshcorr,acr_best_mlintab,acr_fwsoffst,acr_best_biascorr,acr_obstype,acr_best_pfltfile, convert(char(12),acr_expstart,102)+convert(char(12),acr_expstart,108),acr_best_flatcorr,acr_best_oscntab,acr_best_biasfile,acr_best_spottab,acr_ccdamp,acr_best_cfltfile,acr_fw2offst,acr_best_dqicorr,acr_best_flshfile,acr_shutrpos,acr_best_idctab,acr_best_dgeofile,acr_best_comptab,acr_flashcur,acr_best_npolfile,acr_filter1,acr_best_darkcorr,acr_filter2,acr_best_drizcorr,acr_best_imphttab,acr_best_shadcorr,acr_best_mdriztab,acr_best_atodcorr,acr_best_darkfile,acr_best_d2imfile,acr_best_dfltfile,acr_best_atodtab,acr_best_bpixtab,acr_ccdgain,acr_best_ccdtab,acr_best_shadfile,acr_best_graphtab,acr_detector,acr_best_crrejtab,acr_best_crcorr FROM acs_ref_data WHERE acr_data_set_name = 'J8Y503011' 2012012181059-D-DIAG-saving = 2004.09.26 19:52:18 2012012181059-D-DIAG-saving acr_ccdgain = None 2012012181059-D-DIAG-saving acr_best_atodtab = N/A 2012012181059-D-DIAG-saving acr_detector = SBC 2012012181059-D-DIAG-saving acr_best_crrejtab = N/A 2012012181059-D-DIAG-saving acr_best_drizcorr = PERFORM 2012012181059-D-DIAG-saving acr_best_lfltfile = N/A 2012012181059-D-DIAG-saving acr_best_oscntab = N/A 2012012181059-D-DIAG-saving acr_best_graphtab = V9N1603MM_TMG.FITS 2012012181059-D-DIAG-saving acr_best_shadcorr = OMIT 2012012181059-D-DIAG-saving acr_best_comptab = VB71653DM_TMC.FITS 2012012181059-D-DIAG-saving acr_best_biasfile = N/A 2012012181059-D-DIAG-saving acr_best_spottab = N/A 2012012181059-D-DIAG-saving acr_best_flatcorr = PERFORM 2012012181059-D-DIAG-saving acr_best_photcorr = PERFORM 2012012181059-D-DIAG-saving acr_obstype = IMAGING 2012012181059-D-DIAG-saving acr_best_bpixtab = U451251EJ_BPX.FITS 2012012181059-D-DIAG-saving acr_best_flshcorr = PERFORM 2012012181059-D-DIAG-saving acr_shutrpos = None 2012012181059-D-DIAG-saving acr_best_cfltfile = N/A 2012012181059-D-DIAG-saving acr_best_darkcorr = PERFORM 2012012181059-D-DIAG-saving acr_best_pfltfile = PBG1450LJ_PFL.FITS 2012012181059-D-DIAG-saving acr_best_glincorr = PERFORM 2012012181059-D-DIAG-saving acr_flashcur = None 2012012181059-D-DIAG-saving acr_best_flshfile = N/A 2012012181059-D-DIAG-saving acr_best_atodcorr = OMIT 2012012181059-D-DIAG-saving acr_best_dqicorr = PERFORM 2012012181059-D-DIAG-saving acr_best_biascorr = PERFORM 2012012181059-D-DIAG-saving acr_best_shadfile = N/A 2012012181059-D-DIAG-saving acr_ccdamp = ? 2012012181059-D-DIAG-saving acr_best_dgeofile = S5F20000J_DXY.FITS 2012012181059-D-DIAG-saving acr_best_mdriztab = UB215379J_MDZ.FITS 2012012181059-D-DIAG-saving acr_best_crcorr = OMIT 2012012181059-D-DIAG-saving acr_fwsoffst = 0 2012012181059-D-DIAG-saving acr_best_d2imfile = None 2012012181059-D-DIAG-saving acr_best_darkfile = U3O19557J_DRK.FITS 2012012181059-D-DIAG-saving acr_best_mlintab = K9C13374J_LIN.FITS 2012012181059-D-DIAG-saving acr_filter2 = N/A 2012012181059-D-DIAG-saving acr_filter1 = F140LP 2012012181059-D-DIAG-saving acr_best_imphttab = VBB18106J_IMP.FITS 2012012181059-D-DIAG-saving acr_fw2offst = 0 2012012181059-D-DIAG-saving acr_best_idctab = S5D1409DJ_IDC.FITS 2012012181059-D-DIAG-saving acr_best_dfltfile = N/A 2012012181059-D-DIAG-saving acr_best_npolfile = None 2012012181059-D-DIAG-saving acr_fw1offst = 0 2012012181059-D-DIAG-saving acr_best_ccdtab = N/A 2012012181059-D-DIAG-SELECT COUNT(*) FROM hda_fields WHERE hda_fieldname = 'aca_data_set_name' 2012012181059-D-DIAG-SELECT aca_xcorner,aca_ycorner,aca_numcols,aca_numrows FROM acs_a_data WHERE aca_data_set_name = 'J8Y503011' 2012012181059-D-DIAG-No rows found in acs_a_data 2012012181059-D-DIAG-SELECT * FROM assoc_member WHERE asm_asn_id = 'J8Y503010' ORDER BY asm_obsnum 2012012181059-D-DIAG-found product asn j8y503011 2012012181059-D-DIAG-found member J8Y503GMQ 2012012181059-D-DIAG-found member J8Y503GNQ 2012012181059-D-DIAG-found member J8Y503GOQ 2012012181059-D-DIAG-found member J8Y503GPQ 2012012181059-D-DIAG-found member J8Y503GQQ 2012012181059-D-DIAG-found member J8Y503GRQ 2012012181059-D-DIAG-found member J8Y503GSQ 2012012181059-D-DIAG-found member J8Y503GTQ 2012012181059-D-DIAG-SELECT aca_xcorner,aca_ycorner,aca_numcols,aca_numrows FROM acs_a_data WHERE aca_data_set_name = 'J8Y503GMQ' 2012012181059-D-DIAG-saving aca_xcorner = 0 2012012181059-D-DIAG-saving aca_ycorner = 0 2012012181059-D-DIAG-saving aca_numcols = 0 2012012181059-D-DIAG-saving aca_numrows = 0 2012012181059-D-DIAG-SELECT COUNT(*) FROM hda_fields WHERE hda_fieldname = 'acc_data_set_name' 2012012181059-D-DIAG-No archive catalog field called acc_data_set_name 2012012181059-D-DIAG-SELECT COUNT(*) FROM hda_fields WHERE hda_fieldname = 'acc_program_id' 2012012181059-D-DIAG-SELECT acc_ccdchip,acc_ltv2,acc_ltv1 FROM acs_chip WHERE acc_program_id = '8Y5' and acc_obset_id = '03' and acc_obsnum = '01' 2012012181059-D-DIAG-No rows found in acs_chip 2012012181059-D-DIAG-SELECT * FROM assoc_member WHERE asm_asn_id = 'J8Y503010' ORDER BY asm_obsnum 2012012181059-D-DIAG-found product asn j8y503011 2012012181059-D-DIAG-found member J8Y503GMQ 2012012181059-D-DIAG-found member J8Y503GNQ 2012012181059-D-DIAG-found member J8Y503GOQ 2012012181059-D-DIAG-found member J8Y503GPQ 2012012181059-D-DIAG-found member J8Y503GQQ 2012012181059-D-DIAG-found member J8Y503GRQ 2012012181059-D-DIAG-found member J8Y503GSQ 2012012181059-D-DIAG-found member J8Y503GTQ 2012012181059-D-DIAG-SELECT acc_ccdchip,acc_ltv2,acc_ltv1 FROM acs_chip WHERE acc_program_id = '8Y5' and acc_obset_id = '03' and acc_obsnum = 'GM' 2012012181059-D-DIAG-saving acc_ccdchip = 0 2012012181059-D-DIAG-saving acc_ltv1 = 0.0 2012012181059-D-DIAG-saving acc_ltv2 = 0.0 2012012181059-D-DIAG-SELECT COUNT(*) FROM hda_fields WHERE hda_fieldname = 'sci_data_set_name' 2012012181059-D-DIAG-SELECT sci_targname FROM science WHERE sci_data_set_name = 'J8Y503011' 2012012181059-D-DIAG-saving sci_targname = M80 2012012181059-D-DIAG-input done,keywords=[] 2012012181059-D-DIAG-reffile will be filled by: filename = cdbs_db.multi_tab( reff) 2012012181059-D-DIAG-SELECT max(synphot_file_1.file_name) FROM synphot_file synphot_file_1 WHERE synphot_file_1.general_availability_date = (SELECT max(synphot_file_2.general_availability_date) from synphot_file synphot_file_2 where synphot_file_2.reference_file_type = 'GRAPHTAB' and synphot_file_2.reject_flag = 'N' and synphot_file_2.opus_flag = 'Y' and synphot_file_2.archive_date is not null and synphot_file_2.opus_load_date is not null ) and synphot_file_1.reference_file_type = 'GRAPHTAB' and synphot_file_1.reject_flag = 'N' and synphot_file_1.opus_flag = 'Y' and synphot_file_1.archive_date is not null and synphot_file_1.opus_load_date is not null 2012012181059-D-DIAG-reffile will be filled by: filename = cdbs_db.multi_tab( reff) 2012012181059-D-DIAG-SELECT max(synphot_file_1.file_name) FROM synphot_file synphot_file_1 WHERE synphot_file_1.general_availability_date = (SELECT max(synphot_file_2.general_availability_date) from synphot_file synphot_file_2 where synphot_file_2.reference_file_type = 'COMPTAB' and synphot_file_2.reject_flag = 'N' and synphot_file_2.opus_flag = 'Y' and synphot_file_2.archive_date is not null and synphot_file_2.opus_load_date is not null ) and synphot_file_1.reference_file_type = 'COMPTAB' and synphot_file_1.reject_flag = 'N' and synphot_file_1.opus_flag = 'Y' and synphot_file_1.archive_date is not null and synphot_file_1.opus_load_date is not null 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC' and aSource._keywords['FLASHCUR'][0] != 'OFF')) Set file to N/A and skip. 2012012181059-I-INFO-FLSHFILE value changed: N/A => N/A 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'IDC' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'IDC' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC')) Set file to N/A and skip. 2012012181059-I-INFO-BIASFILE value changed: N/A => N/A 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'DRK' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'DRK' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-Restriction OK, continue. 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-adding file selection OBSTYPE 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['FW1OFFST'][0] == -1 or aSource._keywords['FW1OFFST'][0] == 1) 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['FW2OFFST'][0] == -1 or aSource._keywords['FW2OFFST'][0] == 1) 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['FWSOFFST'][0] == -1 or aSource._keywords['FWSOFFST'][0] == 1) 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-adding file selection OBSTYPE 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['FW1OFFST'][0] == -1 or aSource._keywords['FW1OFFST'][0] == 1) 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['FW2OFFST'][0] == -1 or aSource._keywords['FW2OFFST'][0] == 1) 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['FWSOFFST'][0] == -1 or aSource._keywords['FWSOFFST'][0] == 1) 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'PFL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' and acs_row_2.filter1 = 'F140LP' and acs_row_2.filter2 = 'N/A' and acs_row_2.obstype = 'IMAGING' ) and acs_file_1.reference_file_type = 'PFL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' and acs_row_1.filter1 = 'F140LP' and acs_row_1.filter2 = 'N/A' and acs_row_1.obstype = 'IMAGING' 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-file selection restriction NOT met: (aSource._keywords['DETECTOR'][0] != 'SBC') 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'LFL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' and acs_row_2.filter1 = 'F140LP' and acs_row_2.filter2 = 'N/A' ) and acs_file_1.reference_file_type = 'LFL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' and acs_row_1.filter1 = 'F140LP' and acs_row_1.filter2 = 'N/A' 2012012181059-D-DIAG-Zero matching rows found. 2012012181059-D-DIAG-required=None 2012012181059-D-DIAG-LFLTFILE NOT required 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'LFL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' and acs_row_2.filter1 = 'F140LP' and acs_row_2.filter2 = 'N/A' ) and acs_file_1.reference_file_type = 'LFL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' and acs_row_1.filter1 = 'F140LP' and acs_row_1.filter2 = 'N/A' 2012012181059-I-INFO-LFLTFILE value changed: N/A => N/A 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'DFL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'DFL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-Zero matching rows found. 2012012181059-D-DIAG-required=None 2012012181059-D-DIAG-DFLTFILE NOT required 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'DFL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'DFL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-I-INFO-DFLTFILE value changed: N/A => N/A 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC')) Set file to N/A and skip. 2012012181059-I-INFO-SHADFILE value changed: N/A => N/A 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC')) Set file to N/A and skip. 2012012181059-I-INFO-ATODTAB value changed: N/A => N/A 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'BPX' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'BPX' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC')) Set file to N/A and skip. 2012012181059-I-INFO-CCDTAB value changed: N/A => N/A 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC')) Set file to N/A and skip. 2012012181059-I-INFO-OSCNTAB value changed: N/A => N/A 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] != 'SBC')) Set file to N/A and skip. 2012012181059-I-INFO-CRREJTAB value changed: N/A => N/A 2012012181059-D-DIAG-Restriction OK, continue. 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'LIN' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'LIN' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'MDZ' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'MDZ' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'DXY' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' and acs_row_2.filter1 = 'F140LP' and acs_row_2.filter2 = 'N/A' ) and acs_file_1.reference_file_type = 'DXY' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' and acs_row_1.filter1 = 'F140LP' and acs_row_1.filter2 = 'N/A' 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] == 'HRC' and aSource._keywords['OBSTYPE'][0] == 'CORONAGRAPHIC')) Set file to N/A and skip. 2012012181059-I-INFO-CFLTFILE value changed: N/A => N/A 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] == 'HRC' and aSource._keywords['OBSTYPE'][0] == 'CORONAGRAPHIC')) Set file to N/A and skip. 2012012181059-I-INFO-SPOTTAB value changed: N/A => N/A 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'IMP' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' ) and acs_file_1.reference_file_type = 'IMP' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' 2012012181059-D-DIAG-Restriction not met ((aSource._keywords['DETECTOR'][0] == 'WFC')) Set file to N/A and skip. 2012012181059-D-DIAG-D2IMFILE value changed: None => N/A 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-adding file selection DETECTOR 2012012181059-D-DIAG-adding file selection FILTER1 2012012181059-D-DIAG-adding file selection FILTER2 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'NPL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' and acs_row_2.filter1 = 'F140LP' and acs_row_2.filter2 = 'N/A' ) and acs_file_1.reference_file_type = 'NPL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' and acs_row_1.filter1 = 'F140LP' and acs_row_1.filter2 = 'N/A' 2012012181059-D-DIAG-Zero matching rows found. 2012012181059-D-DIAG-required=NO 2012012181059-D-DIAG-NPOLFILE NOT required 2012012181059-D-DIAG-SELECT max(acs_file_1.file_name) FROM acs_file acs_file_1, acs_row acs_row_1 WHERE acs_file_1.useafter_date = (SELECT max(acs_file_2.useafter_date) FROM acs_file acs_file_2, acs_row acs_row_2 WHERE acs_file_2.reference_file_type = 'NPL' and acs_file_2.useafter_date <= '09/26/2004 19:52:18' and acs_file_2.reject_flag = 'N' and acs_file_2.opus_flag = 'Y' and acs_file_2.archive_date is not null and acs_file_2.opus_load_date is not null and acs_file_2.file_name =acs_row_2.file_name and acs_file_2.expansion_number = acs_row_2.expansion_number and acs_row_2.detector = 'SBC' and acs_row_2.filter1 = 'F140LP' and acs_row_2.filter2 = 'N/A' ) and acs_file_1.reference_file_type = 'NPL' and acs_file_1.reject_flag = 'N' and acs_file_1.opus_flag = 'Y' and acs_file_1.archive_date is not null and acs_file_1.opus_load_date is not null and acs_file_1.file_name =acs_row_1.file_name and acs_file_1.expansion_number = acs_row_1.expansion_number and acs_row_1.detector = 'SBC' and acs_row_1.filter1 = 'F140LP' and acs_row_1.filter2 = 'N/A' 2012012181059-D-DIAG-NPOLFILE value changed: None => N/A 2012012181059-D-DIAG-before output,keywords={'LFLTFILE': ['N/A', 1], 'FW1OFFST': [0, 0], 'GLINCORR': ['PERFORM ', 0], 'PHOTCORR': ['PERFORM ', 0], 'FLSHCORR': ['PERFORM ', 0], 'MLINTAB': ['K9C13374J_LIN.FITS', 0], 'XCORNER': [0, 0], 'FWSOFFST': [0, 0], 'OSCNTAB': ['N/A', 1], 'OBSTYPE': ['IMAGING', 0], 'PFLTFILE': ['PBG1450LJ_PFL.FITS', 0], 'CCDCHIP': [0, 0], 'EXPSTART': ['2004.09.26 19:52:18 ', 0], 'FLATCORR': ['PERFORM ', 0], 'BIASFILE': ['N/A', 1], 'SPOTTAB': ['N/A', 1], 'CCDAMP': ['? ', 0], 'CFLTFILE': ['N/A', 1], 'FW2OFFST': [0, 0], 'IMPHTTAB': ['VBB18106J_IMP.FITS', 0], 'FLSHFILE': ['N/A', 1], 'DFLTFILE': ['N/A', 1], 'DGEOFILE': ['S5F20000J_DXY.FITS', 0], 'IDCTAB': ['S5D1409DJ_IDC.FITS', 0], 'LTV2': [0.0, 0], 'YCORNER': [0, 0], 'COMPTAB': ['VB71653DM_TMC.FITS', 0], 'DQICORR': ['PERFORM ', 0], 'FLASHCUR': [None, 0], 'NPOLFILE': ['N/A', 1], 'FILTER1': ['F140LP', 0], 'DARKCORR': ['PERFORM ', 0], 'FILTER2': ['N/A', 0], 'DRIZCORR': ['PERFORM ', 0], 'CRREJTAB': ['N/A', 1], 'SHADCORR': ['OMIT ', 0], 'NUMCOLS': [0, 0], 'MDRIZTAB': ['UB215379J_MDZ.FITS', 0], 'TARGNAME': ['M80', 0], 'ATODCORR': ['OMIT ', 0], 'D2IMFILE': ['N/A', 1], 'SHUTRPOS': [None, 0], 'LTV1': [0.0, 0], 'ATODTAB': ['N/A', 1], 'DARKFILE': ['U3O19557J_DRK.FITS', 0], 'NUMROWS': [0, 0], 'BPIXTAB': ['U451251EJ_BPX.FITS', 0], 'CCDGAIN': [None, 0], 'CCDTAB': ['N/A', 1], 'SHADFILE': ['N/A', 1], 'GRAPHTAB': ['V9N1603MM_TMG.FITS', 0], 'DETECTOR': ['SBC', 0], 'CRCORR': ['OMIT ', 0], 'BIASCORR': ['PERFORM ', 0]} UPDATE acs_ref_data SET acr_best_graphtab = 'V9N1603MM_TMG.FITS', acr_best_comptab = 'VB71653DM_TMC.FITS', acr_best_flshfile = 'N/A', acr_best_idctab = 'S5D1409DJ_IDC.FITS', acr_best_biasfile = 'N/A', acr_best_darkfile = 'U3O19557J_DRK.FITS', acr_best_pfltfile = 'PBG1450LJ_PFL.FITS', acr_best_lfltfile = 'N/A', acr_best_dfltfile = 'N/A', acr_best_shadfile = 'N/A', acr_best_atodtab = 'N/A', acr_best_bpixtab = 'U451251EJ_BPX.FITS', acr_best_ccdtab = 'N/A', acr_best_oscntab = 'N/A', acr_best_crrejtab = 'N/A', acr_best_mlintab = 'K9C13374J_LIN.FITS', acr_best_mdriztab = 'UB215379J_MDZ.FITS', acr_best_dgeofile = 'S5F20000J_DXY.FITS', acr_best_cfltfile = 'N/A', acr_best_spottab = 'N/A', acr_best_imphttab = 'VBB18106J_IMP.FITS', acr_best_d2imfile = 'N/A', acr_best_npolfile = 'N/A' WHERE acr_data_set_name = 'J8Y503011'