Log - Task #2254
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225430416849CLEANUPFINISHINGDONE7/23/2026 4:06:46 PMDeleted db TEST_DR201
225430416848CLEANUPSTARTINGSTART7/23/2026 4:06:45 PMStarting cleanup
225430396846PUBLISHFINISHINGDONE7/23/2026 4:06:45 PMPublished DR20 VACs dr20vacs from: sdss4c.TEST_DR201 to: sdss4c.BESTTEST
225430396845PUBLISHspPublishDR19VACABORTING7/23/2026 4:06:45 PMPublished DR19 VAC Tables
225430396844PUBLISHspPublishDR20VACOK7/23/2026 4:06:01 PMStarting spPublishDR20VACs
225430396842PUBLISHAttachOK7/23/2026 4:06:01 PMSuccessfully attached sdss4c.TEST_DR201 in file: d:\sql_db\TEST_DR201_Data.MDF
225430396840PUBLISHSTARTINGSTART7/23/2026 4:06:01 PMPublishing dr20vacs sdss4c.TEST_DR201 to sdss4c.BESTTEST
225430386839DETACHFINISHINGDONE7/23/2026 4:05:06 PMDetached Database TEST_DR201
225430386838DETACHSTARTINGSTART7/23/2026 4:05:05 PMStarting DB detach
225430376837BACKUPFINISHINGDONE7/23/2026 4:05:05 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225430376836BACKUPBackupOK7/23/2026 4:05:05 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225430376835BACKUPCheckpointOK7/23/2026 4:04:57 PMCheckpoint done
225430376834BACKUPShrinkDBOK7/23/2026 4:04:57 PMShrink DB done
225430376833BACKUPCheckpointOK7/23/2026 4:04:56 PMCheckpoint done
225430376832BACKUPSTARTINGSTART7/23/2026 4:04:55 PMBacking up dr20vacs database 1 to \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225430366831VALIDATEFINISHINGDONE7/23/2026 4:04:55 PMValidated DR20 VACs 1
225430366830VALIDATEspValidateDR20VAOK7/23/2026 4:04:55 PMDR20 VAC tables validated in 65.007 seconds
225430366829VALIDATEUnique key testOK7/23/2026 4:04:55 PMUnique key test passed on yso_ob_kin(gaia_dr3_source_id)
225430366828VALIDATEUnique key testOK7/23/2026 4:04:54 PMUnique key test passed on qms_hg_h_hb_indices(catalogid)
225430366827VALIDATEUnique key testOK7/23/2026 4:04:54 PMUnique key test passed on qms_hg_index_diagram(catalogid)
225430366826VALIDATEUnique key testOK7/23/2026 4:04:54 PMUnique key test passed on payne4GAIN_summary(sdssid)
225430366825VALIDATEUnique key testOK7/23/2026 4:04:53 PMUnique key test passed on minesweeper(sdssid)
225430366824VALIDATEUnique key testOK7/23/2026 4:04:52 PMUnique key test passed on mdwarf_contin_summary(spectrum_pk)
225430366823VALIDATEUnique key testOK7/23/2026 4:04:51 PMUnique key test passed on mdwarf_active_params(sdssid)
225430366822VALIDATEUnique key testOK7/23/2026 4:04:50 PMUnique key test passed on gyro_age_dwarf(sdss_id)
225430366821VALIDATEUnique key testOK7/23/2026 4:04:50 PMUnique key test passed on grav_pot_16(ids)
225430366820VALIDATEUnique key testOK7/23/2026 4:04:49 PMUnique key test passed on fermi_blazar(sdss_id)
225430366819VALIDATEUnique key testOK7/23/2026 4:04:48 PMUnique key test passed on eROSITA_CVs(sdss_id)
225430366818VALIDATEUnique key testOK7/23/2026 4:04:48 PMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
225430366817VALIDATEUnique key testOK7/23/2026 4:04:48 PMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
225430366816VALIDATEUnique key testOK7/23/2026 4:04:48 PMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
225430366815VALIDATEUnique key testOK7/23/2026 4:04:47 PMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
225430366814VALIDATEUnique key testOK7/23/2026 4:04:47 PMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
225430366813VALIDATEUnique key testOK7/23/2026 4:04:47 PMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
225430366812VALIDATEUnique key testOK7/23/2026 4:04:46 PMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
225430366811VALIDATEUnique key testOK7/23/2026 4:04:46 PMUnique key test passed on DR20Q_prop(objid)
225430366810VALIDATEUnique key testOK7/23/2026 4:04:45 PMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
225430366809VALIDATEUnique key testOK7/23/2026 4:04:44 PMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
225430366808VALIDATEUnique key testOK7/23/2026 4:04:43 PMUnique key test passed on da_dwd_rvs(exposure_num,sdss_id)
225430366807VALIDATEUnique key testOK7/23/2026 4:04:43 PMUnique key test passed on da_dwd_candidates(sdss_id)
225430366806VALIDATEUnique key testOK7/23/2026 4:04:43 PMUnique key test passed on boss_vi_results(sdss_id)
225430366805VALIDATEUnique key testOK7/23/2026 4:04:41 PMUnique key test passed on boss_occam_member(sdss_id)
225430366804VALIDATEUnique key testOK7/23/2026 4:04:41 PMUnique key test passed on boss_occam_cluster(name)
225430366803VALIDATEspValidateDR20VAOK7/23/2026 4:04:41 PMPK_boss_ISM_NaI_absorption created
225430366802VALIDATEspValidateDR20VAOK7/23/2026 4:04:22 PMPK_boss_clam_params created
225430366801VALIDATEspValidateDR20VAOK7/23/2026 4:04:04 PMPK_boss_clam_lite created
225430366800VALIDATEspValidateDR20VAOK7/23/2026 4:03:50 PMspValidateDR20VACs called
225430366799VALIDATESTARTINGSTART7/23/2026 4:03:50 PMValidating dr20vacs database 1
225430356798PRELOADFINISHINGDONE7/23/2026 4:03:50 PMFinished SQL preload
225430356797PRELOADSet valuesOK7/23/2026 4:03:50 PMloadVersion updated
225430356796PRELOADSet valuesOK7/23/2026 4:03:50 PMSetting loadVersion
225430356795PRELOADCSV loadOK7/23/2026 4:03:49 PMAll rows have been loaded
225430356794PRELOADCSV loadOK7/23/2026 4:03:49 PMAll files are loaded
225430356793PRELOADCSV loadOK7/23/2026 4:03:49 PMFinished File load
225430356792PRELOADCSV loadOK7/23/2026 3:55:08 PMStarting File load
225430356791PRELOADSTARTINGSTART7/23/2026 3:55:08 PMStarting SQL Preload
225430346790BUILDFINISHINGDONE7/23/2026 3:55:08 PMFinished building DB
225430346789BUILDSchemaOK7/23/2026 3:55:08 PMCreated Spherical assembly in database TEST_DR201
225430346788BUILDSchemaOK7/23/2026 3:55:08 PM [spCosmology.sql]: Cosmology functions and procedures created
225430346787BUILDSchemaOK7/23/2026 3:55:07 PM [spCopyDbSubset]: spCopyDbSubset installed
225430346786BUILDSchemaOK7/23/2026 3:55:07 PM [spFinish.sql]: spFinish procedures created
225430346785BUILDSchemaOK7/23/2026 3:55:06 PM 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
225430346784BUILDSchemaOK7/23/2026 3:55:05 PM [spValidate.sql]: Data validation procedures created
225430346783BUILDSchemaOK7/23/2026 3:55:04 PM [spSetValues.qsl]: Set values procedures created
225430346782BUILDSchemaOK7/23/2026 3:55:04 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
225430346781BUILDSchemaOK7/23/2026 3:55:04 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225430346780BUILDSchemaOK7/23/2026 3:55:03 PM [spSQLSupport.sql]: SQL Support procs and functions created.
225430346779BUILDSchemaOK7/23/2026 3:55:03 PM [spDocSupport.sql]: DocSupport procs and functions created.
225430346778BUILDSchemaOK7/23/2026 3:55:02 PM [spTestQueries.sql]: Testing harness installed
225430346777BUILDSchemaOK7/23/2026 3:55:02 PM [spCheckDB.sql]: Database checking procs created
225430346776BUILDSchemaOK7/23/2026 3:55:02 PM [spRegion.sql]: Created functions and procedures for the Region package
225430346775BUILDSchemaOK7/23/2026 3:55:01 PM [spCoordinate.sql]: Coordinate related functions and procedures created
225430346774BUILDSchemaOK7/23/2026 3:55:00 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225430346773BUILDSchemaOK7/23/2026 3:55:00 PM 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
225430346772BUILDSchemaOK7/23/2026 3:54:58 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225430346771BUILDSchemaOK7/23/2026 3:54:58 PM 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]
225430346770BUILDSchemaOK7/23/2026 3:54:57 PMCreated Spherical assembly in database TEST_DR201
225430346769BUILDSchemaOK7/23/2026 3:54:54 PM [LvmTables.sql]: LVM tables created
225430346768BUILDSchemaOK7/23/2026 3:54:53 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225430346767BUILDSchemaOK7/23/2026 3:54:51 PM [VacTables.sql]: VAC tables created
225430346766BUILDSchemaOK7/23/2026 3:54:50 PM [Views.sql]: Views created
225430346765BUILDSchemaOK7/23/2026 3:54:49 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225430346764BUILDSchemaOK7/23/2026 3:54:49 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225430346763BUILDSchemaOK7/23/2026 3:54:48 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225430346762BUILDSchemaOK7/23/2026 3:54:48 PM Msg 102, Level 15, State 1, Server sdss4c, Procedure spMakeFrame, Line 56 Incorrect syntax near 'nul'. [FrameTables.sql]: Frame table and related procedures created
225430346761BUILDSchemaOK7/23/2026 3:54:48 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225430346760BUILDSchemaOK7/23/2026 3:54:48 PM [MastarTables.sql]: Mastar tables created
225430346759BUILDSchemaOK7/23/2026 3:54:47 PM 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
225430346758BUILDSchemaOK7/23/2026 3:54:47 PM 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
225430346757BUILDSchemaOK7/23/2026 3:54:46 PM [ApogeeTables.sql]: APOGEE tables created
225430346756BUILDSchemaOK7/23/2026 3:54:45 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225430346755BUILDSchemaOK7/23/2026 3:54:45 PM [WindowTables.sql]: Window tables and related views created
225430346754BUILDSchemaOK7/23/2026 3:54:45 PM [RegionTables.sql]: Created tables for Region package
225430346753BUILDSchemaOK7/23/2026 3:54:44 PM [TilingTables.sql]: Tiling tables and related views created
225430346752BUILDSchemaOK7/23/2026 3:54:44 PM [spSpectro.sql]: Spectro functions/sps created
225430346751BUILDSchemaOK7/23/2026 3:54:43 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
225430346750BUILDSchemaOK7/23/2026 3:54:43 PM 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
225430346749BUILDSchemaOK7/23/2026 3:54:42 PM [NeighborTables.sql]: Neighbor and Match tables created
225430346748BUILDSchemaOK7/23/2026 3:54:42 PM [resolveTables.sql]: Resolve tables created
225430346747BUILDSchemaOK7/23/2026 3:54:42 PM [spPhoto.sql]: Photo procedures and functions created
225430346746BUILDSchemaOK7/23/2026 3:54:41 PM [galSpecTables.sql]: galSpec tables and related functions created
225430346745BUILDSchemaOK7/23/2026 3:54:41 PM [PhotoZTables.sql]: Photometric redshifts tables created
225430346744BUILDSchemaOK7/23/2026 3:54:41 PM [PhotoTables.sql]: Photo tables created
225430346743BUILDSchemaOK7/23/2026 3:54:40 PM [Versions.sql]: Versions table created
225430346742BUILDSchemaOK7/23/2026 3:54:39 PM [IndexMap.sql]: Index management tables and procedures built
225430346741BUILDSchemaOK7/23/2026 3:54:33 PM [MetadataTables.sql]: MetaData tables created
225430346740BUILDSchemaOK7/23/2026 3:54:32 PM [ConstantSupport.sql]: Constant support views and functions created
225430346739BUILDSchemaOK7/23/2026 3:54:30 PM [DataConstants.sql]: Constant tables created
225430346738BUILDSchemaOK7/23/2026 3:54:18 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225430346737BUILDSchemaOK7/23/2026 3:54:17 PMStarting schema creation for TEST_DR201 with partitioning=0
225430346736BUILDDatabaseOK7/23/2026 3:54:17 PMConfigured database TEST_DR201
225430346735BUILDDatabaseOK7/23/2026 3:54:17 PMCreated database TEST_DR201
225430346734BUILDDatabaseOK7/23/2026 3:53:01 PMStarting database creation
225430346733BUILDSTARTINGSTART7/23/2026 3:53:01 PMStarting DB build
225430336732CHECKFINISHINGDONE7/23/2026 3:52:10 PMFinished CSV checking
225430336731CHECKFile countOK7/23/2026 3:52:09 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225430336730CHECKDir checkOK7/23/2026 3:52:09 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225430336729CHECKOpen debug file OK7/23/2026 3:52:09 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225430336728CHECKCheck backup folOK7/23/2026 3:52:09 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225430336727CHECKCheck rootOK7/23/2026 3:52:09 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225430336726CHECKSTARTINGSTART7/23/2026 3:52:08 PMStarting CSV check