Log - Task #2247
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
224729976188VALIDATEUnique key testERROR7/22/2026 3:35:51 PMUnique key test on da_dwd_candidates(sdss_id) failed 1 times.
224729976187VALIDATEUnique key testOK7/22/2026 3:35:50 PMUnique key test passed on boss_vi_results(sdss_id)
224729976186VALIDATEUnique key testOK7/22/2026 3:35:49 PMUnique key test passed on boss_occam_member(sdss_id)
224729976185VALIDATEUnique key testOK7/22/2026 3:35:49 PMUnique key test passed on boss_occam_cluster(name)
224729976184VALIDATEspValidateDR20VAOK7/22/2026 3:35:49 PMPK_boss_ISM_NaI_absorption created
224729976183VALIDATEspValidateDR20VAOK7/22/2026 3:35:30 PMPK_boss_clam_params created
224729976182VALIDATEspValidateDR20VAOK7/22/2026 3:35:11 PMPK_boss_clam_lite created
224729976181VALIDATEspValidateDR20VAOK7/22/2026 3:34:56 PMspValidateDR20VACs called
224729976180VALIDATESTARTINGSTART7/22/2026 3:34:56 PMValidating dr20vacs database 1
224729966179PRELOADFINISHINGDONE7/22/2026 3:34:56 PMFinished SQL preload
224729966178PRELOADSet valuesOK7/22/2026 3:34:56 PMloadVersion updated
224729966177PRELOADSet valuesOK7/22/2026 3:34:56 PMSetting loadVersion
224729966176PRELOADCSV loadOK7/22/2026 3:34:56 PMAll rows have been loaded
224729966175PRELOADCSV loadOK7/22/2026 3:34:56 PMAll files are loaded
224729966174PRELOADCSV loadOK7/22/2026 3:34:56 PMFinished File load
224729966173PRELOADCSV loadOK7/22/2026 3:26:07 PMStarting File load
224729966172PRELOADSTARTINGSTART7/22/2026 3:26:07 PMStarting SQL Preload
224729956171BUILDFINISHINGDONE7/22/2026 3:26:07 PMFinished building DB
224729956170BUILDSchemaOK7/22/2026 3:26:07 PMCreated Spherical assembly in database TEST_DR201
224729956169BUILDSchemaOK7/22/2026 3:26:07 PM [spCosmology.sql]: Cosmology functions and procedures created
224729956168BUILDSchemaOK7/22/2026 3:26:06 PM [spCopyDbSubset]: spCopyDbSubset installed
224729956167BUILDSchemaOK7/22/2026 3:26:06 PM [spFinish.sql]: spFinish procedures created
224729956166BUILDSchemaOK7/22/2026 3:26:05 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
224729956165BUILDSchemaOK7/22/2026 3:26:05 PM [spValidate.sql]: Data validation procedures created
224729956164BUILDSchemaOK7/22/2026 3:26:04 PM [spSetValues.qsl]: Set values procedures created
224729956163BUILDSchemaOK7/22/2026 3:26:03 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
224729956162BUILDSchemaOK7/22/2026 3:26:03 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
224729956161BUILDSchemaOK7/22/2026 3:26:03 PM [spSQLSupport.sql]: SQL Support procs and functions created.
224729956160BUILDSchemaOK7/22/2026 3:26:02 PM [spDocSupport.sql]: DocSupport procs and functions created.
224729956159BUILDSchemaOK7/22/2026 3:26:02 PM [spTestQueries.sql]: Testing harness installed
224729956158BUILDSchemaOK7/22/2026 3:26:02 PM [spCheckDB.sql]: Database checking procs created
224729956157BUILDSchemaOK7/22/2026 3:26:01 PM [spRegion.sql]: Created functions and procedures for the Region package
224729956156BUILDSchemaOK7/22/2026 3:26:00 PM [spCoordinate.sql]: Coordinate related functions and procedures created
224729956155BUILDSchemaOK7/22/2026 3:26:00 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
224729956154BUILDSchemaOK7/22/2026 3:25: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
224729956153BUILDSchemaOK7/22/2026 3:25:58 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
224729956152BUILDSchemaOK7/22/2026 3:25: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]
224729956151BUILDSchemaOK7/22/2026 3:25:56 PMCreated Spherical assembly in database TEST_DR201
224729956150BUILDSchemaOK7/22/2026 3:25:53 PM [LvmTables.sql]: LVM tables created
224729956149BUILDSchemaOK7/22/2026 3:25:53 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
224729956148BUILDSchemaOK7/22/2026 3:25:51 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
224729956147BUILDSchemaOK7/22/2026 3:25:50 PM [Views.sql]: Views created
224729956146BUILDSchemaOK7/22/2026 3:25:49 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
224729956145BUILDSchemaOK7/22/2026 3:25:49 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
224729956144BUILDSchemaOK7/22/2026 3:25:48 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
224729956143BUILDSchemaOK7/22/2026 3:25: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
224729956142BUILDSchemaOK7/22/2026 3:25:48 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
224729956141BUILDSchemaOK7/22/2026 3:25:47 PM [MastarTables.sql]: Mastar tables created
224729956140BUILDSchemaOK7/22/2026 3:25: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
224729956139BUILDSchemaOK7/22/2026 3:25: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
224729956138BUILDSchemaOK7/22/2026 3:25:45 PM [ApogeeTables.sql]: APOGEE tables created
224729956137BUILDSchemaOK7/22/2026 3:25:45 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
224729956136BUILDSchemaOK7/22/2026 3:25:45 PM [WindowTables.sql]: Window tables and related views created
224729956135BUILDSchemaOK7/22/2026 3:25:44 PM [RegionTables.sql]: Created tables for Region package
224729956134BUILDSchemaOK7/22/2026 3:25:44 PM [TilingTables.sql]: Tiling tables and related views created
224729956133BUILDSchemaOK7/22/2026 3:25:44 PM [spSpectro.sql]: Spectro functions/sps created
224729956132BUILDSchemaOK7/22/2026 3:25:43 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
224729956131BUILDSchemaOK7/22/2026 3:25: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
224729956130BUILDSchemaOK7/22/2026 3:25:42 PM [NeighborTables.sql]: Neighbor and Match tables created
224729956129BUILDSchemaOK7/22/2026 3:25:42 PM [resolveTables.sql]: Resolve tables created
224729956128BUILDSchemaOK7/22/2026 3:25:41 PM [spPhoto.sql]: Photo procedures and functions created
224729956127BUILDSchemaOK7/22/2026 3:25:41 PM [galSpecTables.sql]: galSpec tables and related functions created
224729956126BUILDSchemaOK7/22/2026 3:25:40 PM [PhotoZTables.sql]: Photometric redshifts tables created
224729956125BUILDSchemaOK7/22/2026 3:25:40 PM [PhotoTables.sql]: Photo tables created
224729956124BUILDSchemaOK7/22/2026 3:25:40 PM [Versions.sql]: Versions table created
224729956123BUILDSchemaOK7/22/2026 3:25:39 PM [IndexMap.sql]: Index management tables and procedures built
224729956122BUILDSchemaOK7/22/2026 3:25:33 PM [MetadataTables.sql]: MetaData tables created
224729956121BUILDSchemaOK7/22/2026 3:25:32 PM [ConstantSupport.sql]: Constant support views and functions created
224729956120BUILDSchemaOK7/22/2026 3:25:30 PM [DataConstants.sql]: Constant tables created
224729956119BUILDSchemaOK7/22/2026 3:25:18 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
224729956118BUILDSchemaOK7/22/2026 3:25:17 PMStarting schema creation for TEST_DR201 with partitioning=0
224729956117BUILDDatabaseOK7/22/2026 3:25:17 PMConfigured database TEST_DR201
224729956116BUILDDatabaseOK7/22/2026 3:25:17 PMCreated database TEST_DR201
224729956115BUILDDatabaseOK7/22/2026 3:24:01 PMStarting database creation
224729956114BUILDSTARTINGSTART7/22/2026 3:24:01 PMStarting DB build
224729946113CHECKFINISHINGDONE7/22/2026 3:23:22 PMFinished CSV checking
224729946112CHECKFile countOK7/22/2026 3:23:21 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
224729946111CHECKDir checkOK7/22/2026 3:23:21 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
224729946110CHECKOpen debug file OK7/22/2026 3:23:21 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
224729946109CHECKCheck backup folOK7/22/2026 3:23:21 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
224729946108CHECKCheck rootOK7/22/2026 3:23:21 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
224729946107CHECKSTARTINGSTART7/22/2026 3:23:20 PMStarting CSV check