Log - Task #2251
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225130176510VALIDATEUnique key testOK7/23/2026 2:07:48 PMUnique key test passed on DR20Q_prop(objid)
225130176509VALIDATEUnique key testOK7/23/2026 2:07:47 PMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
225130176508VALIDATEUnique key testOK7/23/2026 2:07:46 PMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
225130176507VALIDATEUnique key testERROR7/23/2026 2:07:45 PMUnique key test on da_dwd_rvs(sdss_id) failed 5185 times.
225130176506VALIDATEUnique key testOK7/23/2026 2:07:45 PMUnique key test passed on da_dwd_candidates(sdss_id)
225130176505VALIDATEUnique key testOK7/23/2026 2:07:45 PMUnique key test passed on boss_vi_results(sdss_id)
225130176504VALIDATEUnique key testOK7/23/2026 2:07:43 PMUnique key test passed on boss_occam_member(sdss_id)
225130176503VALIDATEUnique key testOK7/23/2026 2:07:43 PMUnique key test passed on boss_occam_cluster(name)
225130176502VALIDATEspValidateDR20VAOK7/23/2026 2:07:43 PMPK_boss_ISM_NaI_absorption created
225130176501VALIDATEspValidateDR20VAOK7/23/2026 2:07:24 PMPK_boss_clam_params created
225130176500VALIDATEspValidateDR20VAOK7/23/2026 2:07:05 PMPK_boss_clam_lite created
225130176499VALIDATEspValidateDR20VAOK7/23/2026 2:06:51 PMspValidateDR20VACs called
225130176498VALIDATESTARTINGSTART7/23/2026 2:06:51 PMValidating dr20vacs database 1
225130166497PRELOADFINISHINGDONE7/23/2026 2:06:51 PMFinished SQL preload
225130166496PRELOADSet valuesOK7/23/2026 2:06:51 PMloadVersion updated
225130166495PRELOADSet valuesOK7/23/2026 2:06:51 PMSetting loadVersion
225130166494PRELOADCSV loadOK7/23/2026 2:06:50 PMAll rows have been loaded
225130166493PRELOADCSV loadOK7/23/2026 2:06:50 PMAll files are loaded
225130166492PRELOADCSV loadOK7/23/2026 2:06:50 PMFinished File load
225130166491PRELOADCSV loadOK7/23/2026 1:58:05 PMStarting File load
225130166490PRELOADSTARTINGSTART7/23/2026 1:58:05 PMStarting SQL Preload
225130156489BUILDFINISHINGDONE7/23/2026 1:58:05 PMFinished building DB
225130156488BUILDSchemaOK7/23/2026 1:58:05 PMCreated Spherical assembly in database TEST_DR201
225130156487BUILDSchemaOK7/23/2026 1:58:05 PM [spCosmology.sql]: Cosmology functions and procedures created
225130156486BUILDSchemaOK7/23/2026 1:58:04 PM [spCopyDbSubset]: spCopyDbSubset installed
225130156485BUILDSchemaOK7/23/2026 1:58:04 PM [spFinish.sql]: spFinish procedures created
225130156484BUILDSchemaOK7/23/2026 1:58:03 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
225130156483BUILDSchemaOK7/23/2026 1:58:02 PM [spValidate.sql]: Data validation procedures created
225130156482BUILDSchemaOK7/23/2026 1:58:01 PM [spSetValues.qsl]: Set values procedures created
225130156481BUILDSchemaOK7/23/2026 1:58:01 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
225130156480BUILDSchemaOK7/23/2026 1:58:01 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225130156479BUILDSchemaOK7/23/2026 1:58:00 PM [spSQLSupport.sql]: SQL Support procs and functions created.
225130156478BUILDSchemaOK7/23/2026 1:58:00 PM [spDocSupport.sql]: DocSupport procs and functions created.
225130156477BUILDSchemaOK7/23/2026 1:58:00 PM [spTestQueries.sql]: Testing harness installed
225130156476BUILDSchemaOK7/23/2026 1:57:59 PM [spCheckDB.sql]: Database checking procs created
225130156475BUILDSchemaOK7/23/2026 1:57:59 PM [spRegion.sql]: Created functions and procedures for the Region package
225130156474BUILDSchemaOK7/23/2026 1:57:58 PM [spCoordinate.sql]: Coordinate related functions and procedures created
225130156473BUILDSchemaOK7/23/2026 1:57:57 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225130156472BUILDSchemaOK7/23/2026 1:57:57 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
225130156471BUILDSchemaOK7/23/2026 1:57:55 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225130156470BUILDSchemaOK7/23/2026 1:57:55 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]
225130156469BUILDSchemaOK7/23/2026 1:57:54 PMCreated Spherical assembly in database TEST_DR201
225130156468BUILDSchemaOK7/23/2026 1:57:51 PM [LvmTables.sql]: LVM tables created
225130156467BUILDSchemaOK7/23/2026 1:57:51 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225130156466BUILDSchemaOK7/23/2026 1:57:48 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 '*'. [VacTables.sql]: VAC tables created
225130156465BUILDSchemaOK7/23/2026 1:57:47 PM [Views.sql]: Views created
225130156464BUILDSchemaOK7/23/2026 1:57:46 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225130156463BUILDSchemaOK7/23/2026 1:57:46 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225130156462BUILDSchemaOK7/23/2026 1:57:46 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225130156461BUILDSchemaOK7/23/2026 1:57:45 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
225130156460BUILDSchemaOK7/23/2026 1:57:45 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225130156459BUILDSchemaOK7/23/2026 1:57:45 PM [MastarTables.sql]: Mastar tables created
225130156458BUILDSchemaOK7/23/2026 1:57:45 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
225130156457BUILDSchemaOK7/23/2026 1:57:44 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
225130156456BUILDSchemaOK7/23/2026 1:57:43 PM [ApogeeTables.sql]: APOGEE tables created
225130156455BUILDSchemaOK7/23/2026 1:57:43 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225130156454BUILDSchemaOK7/23/2026 1:57:42 PM [WindowTables.sql]: Window tables and related views created
225130156453BUILDSchemaOK7/23/2026 1:57:42 PM [RegionTables.sql]: Created tables for Region package
225130156452BUILDSchemaOK7/23/2026 1:57:42 PM [TilingTables.sql]: Tiling tables and related views created
225130156451BUILDSchemaOK7/23/2026 1:57:41 PM [spSpectro.sql]: Spectro functions/sps created
225130156450BUILDSchemaOK7/23/2026 1:57:40 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
225130156449BUILDSchemaOK7/23/2026 1:57:40 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
225130156448BUILDSchemaOK7/23/2026 1:57:39 PM [NeighborTables.sql]: Neighbor and Match tables created
225130156447BUILDSchemaOK7/23/2026 1:57:39 PM [resolveTables.sql]: Resolve tables created
225130156446BUILDSchemaOK7/23/2026 1:57:39 PM [spPhoto.sql]: Photo procedures and functions created
225130156445BUILDSchemaOK7/23/2026 1:57:38 PM [galSpecTables.sql]: galSpec tables and related functions created
225130156444BUILDSchemaOK7/23/2026 1:57:38 PM [PhotoZTables.sql]: Photometric redshifts tables created
225130156443BUILDSchemaOK7/23/2026 1:57:38 PM [PhotoTables.sql]: Photo tables created
225130156442BUILDSchemaOK7/23/2026 1:57:37 PM [Versions.sql]: Versions table created
225130156441BUILDSchemaOK7/23/2026 1:57:37 PM [IndexMap.sql]: Index management tables and procedures built
225130156440BUILDSchemaOK7/23/2026 1:57:30 PM [MetadataTables.sql]: MetaData tables created
225130156439BUILDSchemaOK7/23/2026 1:57:30 PM [ConstantSupport.sql]: Constant support views and functions created
225130156438BUILDSchemaOK7/23/2026 1:57:28 PM [DataConstants.sql]: Constant tables created
225130156437BUILDSchemaOK7/23/2026 1:57:16 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225130156436BUILDSchemaOK7/23/2026 1:57:15 PMStarting schema creation for TEST_DR201 with partitioning=0
225130156435BUILDDatabaseOK7/23/2026 1:57:15 PMConfigured database TEST_DR201
225130156434BUILDDatabaseOK7/23/2026 1:57:14 PMCreated database TEST_DR201
225130156433BUILDDatabaseOK7/23/2026 1:56:01 PMStarting database creation
225130156432BUILDSTARTINGSTART7/23/2026 1:56:00 PMStarting DB build
225130146431CHECKFINISHINGDONE7/23/2026 1:55:14 PMFinished CSV checking
225130146430CHECKFile countOK7/23/2026 1:55:13 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225130146429CHECKDir checkOK7/23/2026 1:55:13 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225130146428CHECKOpen debug file OK7/23/2026 1:55:13 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225130146427CHECKCheck backup folOK7/23/2026 1:55:13 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225130146426CHECKCheck rootOK7/23/2026 1:55:13 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225130146425CHECKSTARTINGSTART7/23/2026 1:55:13 PMStarting CSV check