Log - Task #2257
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225730617097PUBLISHspPublishDR20VACOK7/24/2026 11:17:01 AMStarting spPublishDR20VACs
225730617095PUBLISHAttachOK7/24/2026 11:17:01 AMSuccessfully attached sdss4c.TEST_DR201 in file: d:\sql_db\TEST_DR201_Data.MDF
225730617093PUBLISHSTARTINGSTART7/24/2026 11:17:00 AMPublishing dr20vacs sdss4c.TEST_DR201 to sdss4c.BESTTEST
225730607092DETACHFINISHINGDONE7/24/2026 11:16:55 AMDetached Database TEST_DR201
225730607091DETACHSTARTINGSTART7/24/2026 11:16:53 AMStarting DB detach
225730597090BACKUPFINISHINGDONE7/24/2026 11:16:53 AMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225730597089BACKUPBackupOK7/24/2026 11:16:53 AMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225730597088BACKUPCheckpointOK7/24/2026 11:16:45 AMCheckpoint done
225730597087BACKUPShrinkDBOK7/24/2026 11:16:45 AMShrink DB done
225730597086BACKUPCheckpointOK7/24/2026 11:16:45 AMCheckpoint done
225730597085BACKUPSTARTINGSTART7/24/2026 11:16:43 AMBacking up dr20vacs database 1 to \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225730587084VALIDATEFINISHINGDONE7/24/2026 11:16:43 AMValidated DR20 VACs 1
225730587083VALIDATEspValidateDR20VAOK7/24/2026 11:16:43 AMDR20 VAC tables validated in 63.093 seconds
225730587082VALIDATEUnique key testOK7/24/2026 11:16:43 AMUnique key test passed on yso_ob_kin(gaia_dr3_source_id)
225730587081VALIDATEUnique key testOK7/24/2026 11:16:42 AMUnique key test passed on qms_hg_h_hb_indices(catalogid)
225730587080VALIDATEUnique key testOK7/24/2026 11:16:42 AMUnique key test passed on qms_hg_index_diagram(catalogid)
225730587079VALIDATEUnique key testOK7/24/2026 11:16:42 AMUnique key test passed on payne4GAIN_summary(sdssid)
225730587078VALIDATEUnique key testOK7/24/2026 11:16:41 AMUnique key test passed on minesweeper(sdssid)
225730587077VALIDATEUnique key testOK7/24/2026 11:16:41 AMUnique key test passed on mdwarf_contin_summary(spectrum_pk)
225730587076VALIDATEUnique key testOK7/24/2026 11:16:39 AMUnique key test passed on mdwarf_active_params(sdssid)
225730587075VALIDATEUnique key testOK7/24/2026 11:16:38 AMUnique key test passed on gyro_age_dwarf(sdss_id)
225730587074VALIDATEUnique key testOK7/24/2026 11:16:38 AMUnique key test passed on grav_pot_16(ids)
225730587073VALIDATEUnique key testOK7/24/2026 11:16:37 AMUnique key test passed on fermi_blazar(sdss_id)
225730587072VALIDATEUnique key testOK7/24/2026 11:16:37 AMUnique key test passed on eROSITA_CVs(sdss_id)
225730587071VALIDATEUnique key testOK7/24/2026 11:16:37 AMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
225730587070VALIDATEUnique key testOK7/24/2026 11:16:37 AMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
225730587069VALIDATEUnique key testOK7/24/2026 11:16:36 AMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
225730587068VALIDATEUnique key testOK7/24/2026 11:16:36 AMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
225730587067VALIDATEUnique key testOK7/24/2026 11:16:36 AMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
225730587066VALIDATEUnique key testOK7/24/2026 11:16:36 AMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
225730587065VALIDATEUnique key testOK7/24/2026 11:16:35 AMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
225730587064VALIDATEUnique key testOK7/24/2026 11:16:35 AMUnique key test passed on DR20Q_prop(objid)
225730587063VALIDATEUnique key testOK7/24/2026 11:16:34 AMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
225730587062VALIDATEUnique key testOK7/24/2026 11:16:32 AMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
225730587061VALIDATEUnique key testOK7/24/2026 11:16:32 AMUnique key test passed on da_dwd_rvs(exposure_num,sdss_id)
225730587060VALIDATEUnique key testOK7/24/2026 11:16:31 AMUnique key test passed on da_dwd_candidates(sdss_id)
225730587059VALIDATEUnique key testOK7/24/2026 11:16:31 AMUnique key test passed on boss_vi_results(sdss_id)
225730587058VALIDATEUnique key testOK7/24/2026 11:16:30 AMUnique key test passed on boss_occam_member(sdss_id)
225730587057VALIDATEUnique key testOK7/24/2026 11:16:30 AMUnique key test passed on boss_occam_cluster(name)
225730587056VALIDATEspValidateDR20VAOK7/24/2026 11:16:30 AMPK_boss_ISM_NaI_absorption created
225730587055VALIDATEspValidateDR20VAOK7/24/2026 11:16:11 AMPK_boss_clam_params created
225730587054VALIDATEspValidateDR20VAOK7/24/2026 11:15:53 AMPK_boss_clam_lite created
225730587053VALIDATEspValidateDR20VAOK7/24/2026 11:15:40 AMspValidateDR20VACs called
225730587052VALIDATESTARTINGSTART7/24/2026 11:15:40 AMValidating dr20vacs database 1
225730577051PRELOADFINISHINGDONE7/24/2026 11:15:40 AMFinished SQL preload
225730577050PRELOADSet valuesOK7/24/2026 11:15:40 AMloadVersion updated
225730577049PRELOADSet valuesOK7/24/2026 11:15:40 AMSetting loadVersion
225730577048PRELOADCSV loadOK7/24/2026 11:15:40 AMAll rows have been loaded
225730577047PRELOADCSV loadOK7/24/2026 11:15:40 AMAll files are loaded
225730577046PRELOADCSV loadOK7/24/2026 11:15:40 AMFinished File load
225730577045PRELOADCSV loadOK7/24/2026 11:07:06 AMStarting File load
225730577044PRELOADSTARTINGSTART7/24/2026 11:07:06 AMStarting SQL Preload
225730567043BUILDFINISHINGDONE7/24/2026 11:07:06 AMFinished building DB
225730567042BUILDSchemaOK7/24/2026 11:07:06 AMCreated Spherical assembly in database TEST_DR201
225730567041BUILDSchemaOK7/24/2026 11:07:06 AM [spCosmology.sql]: Cosmology functions and procedures created
225730567040BUILDSchemaOK7/24/2026 11:07:05 AM [spCopyDbSubset]: spCopyDbSubset installed
225730567039BUILDSchemaOK7/24/2026 11:07:05 AM [spFinish.sql]: spFinish procedures created
225730567038BUILDSchemaOK7/24/2026 11:07:04 AM Msg 3701, Level 11, State 5, Server sdss4c, Line 6 Cannot drop the procedure 'spPublishManga', because it does not exist or you do not have permission. Msg 3701, Level 11, State 5, Server sdss4c, Line 6 Cannot drop the procedure 'spPublishMastar', because it does not exist or you do not have permission. [spPublish]: spPublishStep installed
225730567037BUILDSchemaOK7/24/2026 11:07:03 AM [spValidate.sql]: Data validation procedures created
225730567036BUILDSchemaOK7/24/2026 11:07:02 AM [spSetValues.qsl]: Set values procedures created
225730567035BUILDSchemaOK7/24/2026 11:07:02 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
225730567034BUILDSchemaOK7/24/2026 11:07:02 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225730567033BUILDSchemaOK7/24/2026 11:07:01 AM [spSQLSupport.sql]: SQL Support procs and functions created.
225730567032BUILDSchemaOK7/24/2026 11:07:01 AM [spDocSupport.sql]: DocSupport procs and functions created.
225730567031BUILDSchemaOK7/24/2026 11:07:01 AM [spTestQueries.sql]: Testing harness installed
225730567030BUILDSchemaOK7/24/2026 11:07:00 AM [spCheckDB.sql]: Database checking procs created
225730567029BUILDSchemaOK7/24/2026 11:07:00 AM [spRegion.sql]: Created functions and procedures for the Region package
225730567028BUILDSchemaOK7/24/2026 11:06:59 AM [spCoordinate.sql]: Coordinate related functions and procedures created
225730567027BUILDSchemaOK7/24/2026 11:06:58 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225730567026BUILDSchemaOK7/24/2026 11:06:58 AM Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 65 Invalid column name 'HtmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 65 Invalid column name 'HtmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 66 Invalid column name 'cx'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 66 Invalid column name 'cy'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 66 Invalid column name 'cz'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 62 Invalid column name 'htmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 67 Invalid column name 'cx'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 67 Invalid column name 'cy'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyAllspecXYZ, Line 67 Invalid column name 'cz'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 50 Invalid column name 'HtmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 50 Invalid column name 'HtmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 51 Invalid column name 'cx'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 51 Invalid column name 'cy'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 51 Invalid column name 'cz'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 47 Invalid column name 'htmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 52 Invalid column name 'cx'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 52 Invalid column name 'cy'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbySpAllXYZ, Line 52 Invalid column name 'cz'. [spNearby.sql]: Proximity functions created
225730567025BUILDSchemaOK7/24/2026 11:06:56 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225730567024BUILDSchemaOK7/24/2026 11:06:56 AM Created schema sph [spSphericalLib.sql]: Versions: SphericalLib 1.0.11116.26815 [RELEASE+JITOPT] SphericalHtm 1.0.11115.26816 [RELEASE+JITOPT] SphericalSql 1.0.11116.26816 [RELEASE+JITOPT]
225730567023BUILDSchemaOK7/24/2026 11:06:55 AMCreated Spherical assembly in database TEST_DR201
225730567022BUILDSchemaOK7/24/2026 11:06:52 AM [LvmTables.sql]: LVM tables created
225730567021BUILDSchemaOK7/24/2026 11:06:52 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225730567020BUILDSchemaOK7/24/2026 11:06:49 AM [VacTables.sql]: VAC tables created
225730567019BUILDSchemaOK7/24/2026 11:06:48 AM [Views.sql]: Views created
225730567018BUILDSchemaOK7/24/2026 11:06:48 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225730567017BUILDSchemaOK7/24/2026 11:06:47 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225730567016BUILDSchemaOK7/24/2026 11:06:47 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225730567015BUILDSchemaOK7/24/2026 11:06:47 AM Msg 102, Level 15, State 1, Server sdss4c, Procedure spMakeFrame, Line 56 Incorrect syntax near 'nul'. [FrameTables.sql]: Frame table and related procedures created
225730567014BUILDSchemaOK7/24/2026 11:06:46 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225730567013BUILDSchemaOK7/24/2026 11:06:46 AM [MastarTables.sql]: Mastar tables created
225730567012BUILDSchemaOK7/24/2026 11:06:46 AM Msg 113, Level 15, State 1, Server sdss4c, Line 110 Missing end comment mark '*/'. Msg 102, Level 15, State 1, Server sdss4c, Line 3 Incorrect syntax near '*'. [MangaTables.sql]: MaNGA tables created
225730567011BUILDSchemaOK7/24/2026 11:06:45 AM Msg 113, Level 15, State 1, Server sdss4c, Line 8 Missing end comment mark '*/'. Msg 102, Level 15, State 1, Server sdss4c, Line 1 Incorrect syntax near '*'. [AstraTables.sql]: Astra tables created
225730567010BUILDSchemaOK7/24/2026 11:06:44 AM [ApogeeTables.sql]: APOGEE tables created
225730567009BUILDSchemaOK7/24/2026 11:06:44 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225730567008BUILDSchemaOK7/24/2026 11:06:43 AM [WindowTables.sql]: Window tables and related views created
225730567007BUILDSchemaOK7/24/2026 11:06:43 AM [RegionTables.sql]: Created tables for Region package
225730567006BUILDSchemaOK7/24/2026 11:06:43 AM [TilingTables.sql]: Tiling tables and related views created
225730567005BUILDSchemaOK7/24/2026 11:06:42 AM [spSpectro.sql]: Spectro functions/sps created
225730567004BUILDSchemaOK7/24/2026 11:06:42 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
225730567003BUILDSchemaOK7/24/2026 11:06:41 AM Msg 113, Level 15, State 1, Server sdss4c, Line 11 Missing end comment mark '*/'. Msg 2714, Level 16, State 6, Server sdss4c, Line 2 There is already an object named 'SpecObjAll' in the database. Msg 102, Level 15, State 1, Server sdss4c, Line 3 Incorrect syntax near '*'. [SpectroTables.sql]: Spec tables and related functions created
225730567002BUILDSchemaOK7/24/2026 11:06:41 AM [NeighborTables.sql]: Neighbor and Match tables created
225730567001BUILDSchemaOK7/24/2026 11:06:40 AM [resolveTables.sql]: Resolve tables created
225730567000BUILDSchemaOK7/24/2026 11:06:40 AM [spPhoto.sql]: Photo procedures and functions created
225730566999BUILDSchemaOK7/24/2026 11:06:40 AM [galSpecTables.sql]: galSpec tables and related functions created
225730566998BUILDSchemaOK7/24/2026 11:06:39 AM [PhotoZTables.sql]: Photometric redshifts tables created
225730566997BUILDSchemaOK7/24/2026 11:06:39 AM [PhotoTables.sql]: Photo tables created
225730566996BUILDSchemaOK7/24/2026 11:06:38 AM [Versions.sql]: Versions table created
225730566995BUILDSchemaOK7/24/2026 11:06:38 AM [IndexMap.sql]: Index management tables and procedures built
225730566994BUILDSchemaOK7/24/2026 11:06:31 AM [MetadataTables.sql]: MetaData tables created
225730566993BUILDSchemaOK7/24/2026 11:06:31 AM [ConstantSupport.sql]: Constant support views and functions created
225730566992BUILDSchemaOK7/24/2026 11:06:28 AM [DataConstants.sql]: Constant tables created
225730566991BUILDSchemaOK7/24/2026 11:06:17 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225730566990BUILDSchemaOK7/24/2026 11:06:15 AMStarting schema creation for TEST_DR201 with partitioning=0
225730566989BUILDDatabaseOK7/24/2026 11:06:15 AMConfigured database TEST_DR201
225730566988BUILDDatabaseOK7/24/2026 11:06:15 AMCreated database TEST_DR201
225730566987BUILDDatabaseOK7/24/2026 11:05:01 AMStarting database creation
225730566986BUILDSTARTINGSTART7/24/2026 11:05:01 AMStarting DB build
225730556985CHECKFINISHINGDONE7/24/2026 11:04:52 AMFinished CSV checking
225730556984CHECKFile countOK7/24/2026 11:04:51 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225730556983CHECKDir checkOK7/24/2026 11:04:51 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225730556982CHECKOpen debug file OK7/24/2026 11:04:51 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225730556981CHECKCheck backup folOK7/24/2026 11:04:51 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225730556980CHECKCheck rootOK7/24/2026 11:04:51 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225730556979CHECKSTARTINGSTART7/24/2026 11:04:51 AMStarting CSV check