Log - Task #2249
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
224930076347VALIDATEUnique key testERROR7/23/2026 12:29:42 PMUnique key test on boss_clam_params(source) failed 1497 times.
224930076346VALIDATEUnique key testERROR7/23/2026 12:29:40 PMUnique key test on boss_clam_lite(sdss_id) failed 1497 times.
224930076345VALIDATEspValidateDR20VAOK7/23/2026 12:29:38 PMspValidateDR20VACs called
224930076344VALIDATESTARTINGSTART7/23/2026 12:29:38 PMValidating dr20vacs database 1
224930066343PRELOADFINISHINGDONE7/23/2026 12:29:38 PMFinished SQL preload
224930066342PRELOADSet valuesOK7/23/2026 12:29:38 PMloadVersion updated
224930066341PRELOADSet valuesOK7/23/2026 12:29:38 PMSetting loadVersion
224930066340PRELOADCSV loadOK7/23/2026 12:29:38 PMAll rows have been loaded
224930066339PRELOADCSV loadOK7/23/2026 12:29:38 PMAll files are loaded
224930066338PRELOADCSV loadOK7/23/2026 12:29:38 PMFinished File load
224930066337PRELOADCSV loadOK7/23/2026 12:21:08 PMStarting File load
224930066336PRELOADSTARTINGSTART7/23/2026 12:21:08 PMStarting SQL Preload
224930056335BUILDFINISHINGDONE7/23/2026 12:21:08 PMFinished building DB
224930056334BUILDSchemaOK7/23/2026 12:21:08 PMCreated Spherical assembly in database TEST_DR201
224930056333BUILDSchemaOK7/23/2026 12:21:08 PM [spCosmology.sql]: Cosmology functions and procedures created
224930056332BUILDSchemaOK7/23/2026 12:21:07 PM [spCopyDbSubset]: spCopyDbSubset installed
224930056331BUILDSchemaOK7/23/2026 12:21:07 PM [spFinish.sql]: spFinish procedures created
224930056330BUILDSchemaOK7/23/2026 12:21: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
224930056329BUILDSchemaOK7/23/2026 12:21:05 PM [spValidate.sql]: Data validation procedures created
224930056328BUILDSchemaOK7/23/2026 12:21:04 PM [spSetValues.qsl]: Set values procedures created
224930056327BUILDSchemaOK7/23/2026 12:21:04 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
224930056326BUILDSchemaOK7/23/2026 12:21:04 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
224930056325BUILDSchemaOK7/23/2026 12:21:03 PM [spSQLSupport.sql]: SQL Support procs and functions created.
224930056324BUILDSchemaOK7/23/2026 12:21:03 PM [spDocSupport.sql]: DocSupport procs and functions created.
224930056323BUILDSchemaOK7/23/2026 12:21:02 PM [spTestQueries.sql]: Testing harness installed
224930056322BUILDSchemaOK7/23/2026 12:21:02 PM [spCheckDB.sql]: Database checking procs created
224930056321BUILDSchemaOK7/23/2026 12:21:02 PM [spRegion.sql]: Created functions and procedures for the Region package
224930056320BUILDSchemaOK7/23/2026 12:21:01 PM [spCoordinate.sql]: Coordinate related functions and procedures created
224930056319BUILDSchemaOK7/23/2026 12:21:00 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
224930056318BUILDSchemaOK7/23/2026 12:21: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
224930056317BUILDSchemaOK7/23/2026 12:20:58 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
224930056316BUILDSchemaOK7/23/2026 12:20: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]
224930056315BUILDSchemaOK7/23/2026 12:20:57 PMCreated Spherical assembly in database TEST_DR201
224930056314BUILDSchemaOK7/23/2026 12:20:54 PM [LvmTables.sql]: LVM tables created
224930056313BUILDSchemaOK7/23/2026 12:20:54 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
224930056312BUILDSchemaOK7/23/2026 12:20: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
224930056311BUILDSchemaOK7/23/2026 12:20:50 PM [Views.sql]: Views created
224930056310BUILDSchemaOK7/23/2026 12:20:49 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
224930056309BUILDSchemaOK7/23/2026 12:20:49 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
224930056308BUILDSchemaOK7/23/2026 12:20:49 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
224930056307BUILDSchemaOK7/23/2026 12:20: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
224930056306BUILDSchemaOK7/23/2026 12:20:48 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
224930056305BUILDSchemaOK7/23/2026 12:20:48 PM [MastarTables.sql]: Mastar tables created
224930056304BUILDSchemaOK7/23/2026 12:20:48 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
224930056303BUILDSchemaOK7/23/2026 12:20: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
224930056302BUILDSchemaOK7/23/2026 12:20:46 PM [ApogeeTables.sql]: APOGEE tables created
224930056301BUILDSchemaOK7/23/2026 12:20:45 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
224930056300BUILDSchemaOK7/23/2026 12:20:45 PM [WindowTables.sql]: Window tables and related views created
224930056299BUILDSchemaOK7/23/2026 12:20:45 PM [RegionTables.sql]: Created tables for Region package
224930056298BUILDSchemaOK7/23/2026 12:20:44 PM [TilingTables.sql]: Tiling tables and related views created
224930056297BUILDSchemaOK7/23/2026 12:20:44 PM [spSpectro.sql]: Spectro functions/sps created
224930056296BUILDSchemaOK7/23/2026 12:20:43 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
224930056295BUILDSchemaOK7/23/2026 12:20: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
224930056294BUILDSchemaOK7/23/2026 12:20:42 PM [NeighborTables.sql]: Neighbor and Match tables created
224930056293BUILDSchemaOK7/23/2026 12:20:42 PM [resolveTables.sql]: Resolve tables created
224930056292BUILDSchemaOK7/23/2026 12:20:42 PM [spPhoto.sql]: Photo procedures and functions created
224930056291BUILDSchemaOK7/23/2026 12:20:41 PM [galSpecTables.sql]: galSpec tables and related functions created
224930056290BUILDSchemaOK7/23/2026 12:20:41 PM [PhotoZTables.sql]: Photometric redshifts tables created
224930056289BUILDSchemaOK7/23/2026 12:20:41 PM [PhotoTables.sql]: Photo tables created
224930056288BUILDSchemaOK7/23/2026 12:20:40 PM [Versions.sql]: Versions table created
224930056287BUILDSchemaOK7/23/2026 12:20:40 PM [IndexMap.sql]: Index management tables and procedures built
224930056286BUILDSchemaOK7/23/2026 12:20:33 PM [MetadataTables.sql]: MetaData tables created
224930056285BUILDSchemaOK7/23/2026 12:20:32 PM [ConstantSupport.sql]: Constant support views and functions created
224930056284BUILDSchemaOK7/23/2026 12:20:30 PM [DataConstants.sql]: Constant tables created
224930056283BUILDSchemaOK7/23/2026 12:20:18 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
224930056282BUILDSchemaOK7/23/2026 12:20:17 PMStarting schema creation for TEST_DR201 with partitioning=0
224930056281BUILDDatabaseOK7/23/2026 12:20:17 PMConfigured database TEST_DR201
224930056280BUILDDatabaseOK7/23/2026 12:20:17 PMCreated database TEST_DR201
224930056279BUILDDatabaseOK7/23/2026 12:19:02 PMStarting database creation
224930056278BUILDSTARTINGSTART7/23/2026 12:19:01 PMStarting DB build
224930046277CHECKFINISHINGDONE7/23/2026 12:18:17 PMFinished CSV checking
224930046276CHECKFile countOK7/23/2026 12:18:16 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
224930046275CHECKDir checkOK7/23/2026 12:18:16 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
224930046274CHECKOpen debug file OK7/23/2026 12:18:16 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
224930046273CHECKCheck backup folOK7/23/2026 12:18:16 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
224930046272CHECKCheck rootOK7/23/2026 12:18:16 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
224930046271CHECKSTARTINGSTART7/23/2026 12:18:15 PMStarting CSV check