Log - Task #2253
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225330306724PUBLISHFINISHINGERROR7/23/2026 3:12:01 PMFailed to publish dr20vacs db id: 1 name: sdss4c.TEST_DR201 because type: dr20vacs is unknown
225330306722PUBLISHAttachOK7/23/2026 3:12:01 PMSuccessfully attached sdss4c.TEST_DR201 in file: d:\sql_db\TEST_DR201_Data.MDF
225330306720PUBLISHSTARTINGSTART7/23/2026 3:12:00 PMPublishing dr20vacs sdss4c.TEST_DR201 to sdss4c.BESTTEST
225330296719DETACHFINISHINGDONE7/23/2026 3:11:55 PMDetached Database TEST_DR201
225330296718DETACHSTARTINGSTART7/23/2026 3:11:54 PMStarting DB detach
225330286717BACKUPFINISHINGDONE7/23/2026 3:11:54 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225330286716BACKUPBackupOK7/23/2026 3:11:54 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225330286715BACKUPCheckpointOK7/23/2026 3:11:43 PMCheckpoint done
225330286714BACKUPShrinkDBOK7/23/2026 3:11:43 PMShrink DB done
225330286713BACKUPCheckpointOK7/23/2026 3:11:43 PMCheckpoint done
225330286712BACKUPSTARTINGSTART7/23/2026 3:11:41 PMBacking up dr20vacs database 1 to \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225330276711VALIDATEFINISHINGDONE7/23/2026 3:11:41 PMValidated DR20 VACs 1
225330276710VALIDATEspValidateDR20VAOK7/23/2026 3:11:41 PMDR20 VAC tables validated in 63.43 seconds
225330276709VALIDATEUnique key testOK7/23/2026 3:11:41 PMUnique key test passed on yso_ob_kin(gaia_dr3_source_id)
225330276708VALIDATEUnique key testOK7/23/2026 3:11:41 PMUnique key test passed on qms_hg_h_hb_indices(catalogid)
225330276707VALIDATEUnique key testOK7/23/2026 3:11:40 PMUnique key test passed on qms_hg_index_diagram(catalogid)
225330276706VALIDATEUnique key testOK7/23/2026 3:11:40 PMUnique key test passed on payne4GAIN_summary(sdssid)
225330276705VALIDATEUnique key testOK7/23/2026 3:11:39 PMUnique key test passed on minesweeper(sdssid)
225330276704VALIDATEUnique key testOK7/23/2026 3:11:39 PMUnique key test passed on mdwarf_contin_summary(spectrum_pk)
225330276703VALIDATEUnique key testOK7/23/2026 3:11:37 PMUnique key test passed on mdwarf_active_params(sdssid)
225330276702VALIDATEUnique key testOK7/23/2026 3:11:36 PMUnique key test passed on gyro_age_dwarf(sdss_id)
225330276701VALIDATEUnique key testOK7/23/2026 3:11:36 PMUnique key test passed on grav_pot_16(ids)
225330276700VALIDATEUnique key testOK7/23/2026 3:11:35 PMUnique key test passed on fermi_blazar(sdss_id)
225330276699VALIDATEUnique key testOK7/23/2026 3:11:35 PMUnique key test passed on eROSITA_CVs(sdss_id)
225330276698VALIDATEUnique key testOK7/23/2026 3:11:35 PMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
225330276697VALIDATEUnique key testOK7/23/2026 3:11:35 PMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
225330276696VALIDATEUnique key testOK7/23/2026 3:11:34 PMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
225330276695VALIDATEUnique key testOK7/23/2026 3:11:34 PMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
225330276694VALIDATEUnique key testOK7/23/2026 3:11:34 PMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
225330276693VALIDATEUnique key testOK7/23/2026 3:11:34 PMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
225330276692VALIDATEUnique key testOK7/23/2026 3:11:33 PMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
225330276691VALIDATEUnique key testOK7/23/2026 3:11:33 PMUnique key test passed on DR20Q_prop(objid)
225330276690VALIDATEUnique key testOK7/23/2026 3:11:32 PMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
225330276689VALIDATEUnique key testOK7/23/2026 3:11:31 PMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
225330276688VALIDATEUnique key testOK7/23/2026 3:11:30 PMUnique key test passed on da_dwd_rvs(exposure_num,sdss_id)
225330276687VALIDATEUnique key testOK7/23/2026 3:11:29 PMUnique key test passed on da_dwd_candidates(sdss_id)
225330276686VALIDATEUnique key testOK7/23/2026 3:11:29 PMUnique key test passed on boss_vi_results(sdss_id)
225330276685VALIDATEUnique key testOK7/23/2026 3:11:28 PMUnique key test passed on boss_occam_member(sdss_id)
225330276684VALIDATEUnique key testOK7/23/2026 3:11:28 PMUnique key test passed on boss_occam_cluster(name)
225330276683VALIDATEspValidateDR20VAOK7/23/2026 3:11:28 PMPK_boss_ISM_NaI_absorption created
225330276682VALIDATEspValidateDR20VAOK7/23/2026 3:11:10 PMPK_boss_clam_params created
225330276681VALIDATEspValidateDR20VAOK7/23/2026 3:10:52 PMPK_boss_clam_lite created
225330276680VALIDATEspValidateDR20VAOK7/23/2026 3:10:38 PMspValidateDR20VACs called
225330276679VALIDATESTARTINGSTART7/23/2026 3:10:38 PMValidating dr20vacs database 1
225330266678PRELOADFINISHINGDONE7/23/2026 3:10:38 PMFinished SQL preload
225330266677PRELOADSet valuesOK7/23/2026 3:10:38 PMloadVersion updated
225330266676PRELOADSet valuesOK7/23/2026 3:10:38 PMSetting loadVersion
225330266675PRELOADCSV loadOK7/23/2026 3:10:38 PMAll rows have been loaded
225330266674PRELOADCSV loadOK7/23/2026 3:10:37 PMAll files are loaded
225330266673PRELOADCSV loadOK7/23/2026 3:10:37 PMFinished File load
225330266672PRELOADCSV loadOK7/23/2026 3:02:08 PMStarting File load
225330266671PRELOADSTARTINGSTART7/23/2026 3:02:08 PMStarting SQL Preload
225330256670BUILDFINISHINGDONE7/23/2026 3:02:08 PMFinished building DB
225330256669BUILDSchemaOK7/23/2026 3:02:08 PMCreated Spherical assembly in database TEST_DR201
225330256668BUILDSchemaOK7/23/2026 3:02:08 PM [spCosmology.sql]: Cosmology functions and procedures created
225330256667BUILDSchemaOK7/23/2026 3:02:07 PM [spCopyDbSubset]: spCopyDbSubset installed
225330256666BUILDSchemaOK7/23/2026 3:02:06 PM [spFinish.sql]: spFinish procedures created
225330256665BUILDSchemaOK7/23/2026 3:02: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
225330256664BUILDSchemaOK7/23/2026 3:02:05 PM [spValidate.sql]: Data validation procedures created
225330256663BUILDSchemaOK7/23/2026 3:02:04 PM [spSetValues.qsl]: Set values procedures created
225330256662BUILDSchemaOK7/23/2026 3:02:04 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
225330256661BUILDSchemaOK7/23/2026 3:02:03 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225330256660BUILDSchemaOK7/23/2026 3:02:03 PM [spSQLSupport.sql]: SQL Support procs and functions created.
225330256659BUILDSchemaOK7/23/2026 3:02:03 PM [spDocSupport.sql]: DocSupport procs and functions created.
225330256658BUILDSchemaOK7/23/2026 3:02:02 PM [spTestQueries.sql]: Testing harness installed
225330256657BUILDSchemaOK7/23/2026 3:02:02 PM [spCheckDB.sql]: Database checking procs created
225330256656BUILDSchemaOK7/23/2026 3:02:01 PM [spRegion.sql]: Created functions and procedures for the Region package
225330256655BUILDSchemaOK7/23/2026 3:02:01 PM [spCoordinate.sql]: Coordinate related functions and procedures created
225330256654BUILDSchemaOK7/23/2026 3:02:00 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225330256653BUILDSchemaOK7/23/2026 3:01:59 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
225330256652BUILDSchemaOK7/23/2026 3:01:58 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225330256651BUILDSchemaOK7/23/2026 3:01:57 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]
225330256650BUILDSchemaOK7/23/2026 3:01:56 PMCreated Spherical assembly in database TEST_DR201
225330256649BUILDSchemaOK7/23/2026 3:01:53 PM [LvmTables.sql]: LVM tables created
225330256648BUILDSchemaOK7/23/2026 3:01:53 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225330256647BUILDSchemaOK7/23/2026 3:01:50 PM [VacTables.sql]: VAC tables created
225330256646BUILDSchemaOK7/23/2026 3:01:49 PM [Views.sql]: Views created
225330256645BUILDSchemaOK7/23/2026 3:01:49 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225330256644BUILDSchemaOK7/23/2026 3:01:48 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225330256643BUILDSchemaOK7/23/2026 3:01:48 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225330256642BUILDSchemaOK7/23/2026 3:01: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
225330256641BUILDSchemaOK7/23/2026 3:01:47 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225330256640BUILDSchemaOK7/23/2026 3:01:47 PM [MastarTables.sql]: Mastar tables created
225330256639BUILDSchemaOK7/23/2026 3:01: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
225330256638BUILDSchemaOK7/23/2026 3:01:46 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
225330256637BUILDSchemaOK7/23/2026 3:01:45 PM [ApogeeTables.sql]: APOGEE tables created
225330256636BUILDSchemaOK7/23/2026 3:01:45 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225330256635BUILDSchemaOK7/23/2026 3:01:44 PM [WindowTables.sql]: Window tables and related views created
225330256634BUILDSchemaOK7/23/2026 3:01:44 PM [RegionTables.sql]: Created tables for Region package
225330256633BUILDSchemaOK7/23/2026 3:01:44 PM [TilingTables.sql]: Tiling tables and related views created
225330256632BUILDSchemaOK7/23/2026 3:01:43 PM [spSpectro.sql]: Spectro functions/sps created
225330256631BUILDSchemaOK7/23/2026 3:01:42 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
225330256630BUILDSchemaOK7/23/2026 3:01:42 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
225330256629BUILDSchemaOK7/23/2026 3:01:41 PM [NeighborTables.sql]: Neighbor and Match tables created
225330256628BUILDSchemaOK7/23/2026 3:01:41 PM [resolveTables.sql]: Resolve tables created
225330256627BUILDSchemaOK7/23/2026 3:01:41 PM [spPhoto.sql]: Photo procedures and functions created
225330256626BUILDSchemaOK7/23/2026 3:01:40 PM [galSpecTables.sql]: galSpec tables and related functions created
225330256625BUILDSchemaOK7/23/2026 3:01:40 PM [PhotoZTables.sql]: Photometric redshifts tables created
225330256624BUILDSchemaOK7/23/2026 3:01:40 PM [PhotoTables.sql]: Photo tables created
225330256623BUILDSchemaOK7/23/2026 3:01:39 PM [Versions.sql]: Versions table created
225330256622BUILDSchemaOK7/23/2026 3:01:38 PM [IndexMap.sql]: Index management tables and procedures built
225330256621BUILDSchemaOK7/23/2026 3:01:32 PM [MetadataTables.sql]: MetaData tables created
225330256620BUILDSchemaOK7/23/2026 3:01:31 PM [ConstantSupport.sql]: Constant support views and functions created
225330256619BUILDSchemaOK7/23/2026 3:01:29 PM [DataConstants.sql]: Constant tables created
225330256618BUILDSchemaOK7/23/2026 3:01:17 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225330256617BUILDSchemaOK7/23/2026 3:01:16 PMStarting schema creation for TEST_DR201 with partitioning=0
225330256616BUILDDatabaseOK7/23/2026 3:01:16 PMConfigured database TEST_DR201
225330256615BUILDDatabaseOK7/23/2026 3:01:16 PMCreated database TEST_DR201
225330256614BUILDDatabaseOK7/23/2026 3:00:01 PMStarting database creation
225330256613BUILDSTARTINGSTART7/23/2026 3:00:01 PMStarting DB build
225330246612CHECKFINISHINGDONE7/23/2026 2:59:18 PMFinished CSV checking
225330246611CHECKFile countOK7/23/2026 2:59:18 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225330246610CHECKDir checkOK7/23/2026 2:59:18 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225330246609CHECKOpen debug file OK7/23/2026 2:59:18 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225330246608CHECKCheck backup folOK7/23/2026 2:59:18 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225330246607CHECKCheck rootOK7/23/2026 2:59:17 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225330246606CHECKSTARTINGSTART7/23/2026 2:59:17 PMStarting CSV check