Log - Task #2248
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
224830026270VALIDATEUnique key testOK7/23/2026 10:50:21 AMUnique key test passed on da_dwd_candidates(sdss_id)
224830026269VALIDATEUnique key testOK7/23/2026 10:50:21 AMUnique key test passed on boss_vi_results(sdss_id)
224830026268VALIDATEUnique key testOK7/23/2026 10:50:20 AMUnique key test passed on boss_occam_member(sdss_id)
224830026267VALIDATEUnique key testOK7/23/2026 10:50:20 AMUnique key test passed on boss_occam_cluster(name)
224830026266VALIDATEspValidateDR20VAOK7/23/2026 10:50:20 AMPK_boss_ISM_NaI_absorption created
224830026265VALIDATEspValidateDR20VAOK7/23/2026 10:49:59 AMPK_boss_clam_params created
224830026264VALIDATEspValidateDR20VAOK7/23/2026 10:49:41 AMPK_boss_clam_lite created
224830026263VALIDATEspValidateDR20VAOK7/23/2026 10:49:26 AMspValidateDR20VACs called
224830026262VALIDATESTARTINGSTART7/23/2026 10:49:26 AMValidating dr20vacs database 1
224830016261PRELOADFINISHINGDONE7/23/2026 10:49:26 AMFinished SQL preload
224830016260PRELOADSet valuesOK7/23/2026 10:49:26 AMloadVersion updated
224830016259PRELOADSet valuesOK7/23/2026 10:49:26 AMSetting loadVersion
224830016258PRELOADCSV loadOK7/23/2026 10:49:26 AMAll rows have been loaded
224830016257PRELOADCSV loadOK7/23/2026 10:49:26 AMAll files are loaded
224830016256PRELOADCSV loadOK7/23/2026 10:49:26 AMFinished File load
224830016255PRELOADCSV loadOK7/23/2026 10:40:09 AMStarting File load
224830016254PRELOADSTARTINGSTART7/23/2026 10:40:09 AMStarting SQL Preload
224830006253BUILDFINISHINGDONE7/23/2026 10:40:09 AMFinished building DB
224830006252BUILDSchemaOK7/23/2026 10:40:09 AMCreated Spherical assembly in database TEST_DR201
224830006251BUILDSchemaOK7/23/2026 10:40:09 AM [spCosmology.sql]: Cosmology functions and procedures created
224830006250BUILDSchemaOK7/23/2026 10:40:08 AM [spCopyDbSubset]: spCopyDbSubset installed
224830006249BUILDSchemaOK7/23/2026 10:40:07 AM [spFinish.sql]: spFinish procedures created
224830006248BUILDSchemaOK7/23/2026 10:40:07 AM 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
224830006247BUILDSchemaOK7/23/2026 10:40:06 AM [spValidate.sql]: Data validation procedures created
224830006246BUILDSchemaOK7/23/2026 10:40:05 AM [spSetValues.qsl]: Set values procedures created
224830006245BUILDSchemaOK7/23/2026 10:40:05 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
224830006244BUILDSchemaOK7/23/2026 10:40:04 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
224830006243BUILDSchemaOK7/23/2026 10:40:04 AM [spSQLSupport.sql]: SQL Support procs and functions created.
224830006242BUILDSchemaOK7/23/2026 10:40:03 AM [spDocSupport.sql]: DocSupport procs and functions created.
224830006241BUILDSchemaOK7/23/2026 10:40:03 AM [spTestQueries.sql]: Testing harness installed
224830006240BUILDSchemaOK7/23/2026 10:40:03 AM [spCheckDB.sql]: Database checking procs created
224830006239BUILDSchemaOK7/23/2026 10:40:02 AM [spRegion.sql]: Created functions and procedures for the Region package
224830006238BUILDSchemaOK7/23/2026 10:40:02 AM [spCoordinate.sql]: Coordinate related functions and procedures created
224830006237BUILDSchemaOK7/23/2026 10:40:01 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
224830006236BUILDSchemaOK7/23/2026 10:40:00 AM 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
224830006235BUILDSchemaOK7/23/2026 10:39:59 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
224830006234BUILDSchemaOK7/23/2026 10:39:58 AM 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]
224830006233BUILDSchemaOK7/23/2026 10:39:57 AMCreated Spherical assembly in database TEST_DR201
224830006232BUILDSchemaOK7/23/2026 10:39:54 AM [LvmTables.sql]: LVM tables created
224830006231BUILDSchemaOK7/23/2026 10:39:54 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
224830006230BUILDSchemaOK7/23/2026 10:39:51 AM 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
224830006229BUILDSchemaOK7/23/2026 10:39:50 AM [Views.sql]: Views created
224830006228BUILDSchemaOK7/23/2026 10:39:49 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
224830006227BUILDSchemaOK7/23/2026 10:39:49 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
224830006226BUILDSchemaOK7/23/2026 10:39:49 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
224830006225BUILDSchemaOK7/23/2026 10:39:48 AM Msg 102, Level 15, State 1, Server sdss4c, Procedure spMakeFrame, Line 56 Incorrect syntax near 'nul'. [FrameTables.sql]: Frame table and related procedures created
224830006224BUILDSchemaOK7/23/2026 10:39:48 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
224830006223BUILDSchemaOK7/23/2026 10:39:48 AM [MastarTables.sql]: Mastar tables created
224830006222BUILDSchemaOK7/23/2026 10:39:47 AM 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
224830006221BUILDSchemaOK7/23/2026 10:39:47 AM 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
224830006220BUILDSchemaOK7/23/2026 10:39:46 AM [ApogeeTables.sql]: APOGEE tables created
224830006219BUILDSchemaOK7/23/2026 10:39:45 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
224830006218BUILDSchemaOK7/23/2026 10:39:45 AM [WindowTables.sql]: Window tables and related views created
224830006217BUILDSchemaOK7/23/2026 10:39:44 AM [RegionTables.sql]: Created tables for Region package
224830006216BUILDSchemaOK7/23/2026 10:39:44 AM [TilingTables.sql]: Tiling tables and related views created
224830006215BUILDSchemaOK7/23/2026 10:39:44 AM [spSpectro.sql]: Spectro functions/sps created
224830006214BUILDSchemaOK7/23/2026 10:39:43 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
224830006213BUILDSchemaOK7/23/2026 10:39:42 AM 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
224830006212BUILDSchemaOK7/23/2026 10:39:42 AM [NeighborTables.sql]: Neighbor and Match tables created
224830006211BUILDSchemaOK7/23/2026 10:39:42 AM [resolveTables.sql]: Resolve tables created
224830006210BUILDSchemaOK7/23/2026 10:39:41 AM [spPhoto.sql]: Photo procedures and functions created
224830006209BUILDSchemaOK7/23/2026 10:39:41 AM [galSpecTables.sql]: galSpec tables and related functions created
224830006208BUILDSchemaOK7/23/2026 10:39:40 AM [PhotoZTables.sql]: Photometric redshifts tables created
224830006207BUILDSchemaOK7/23/2026 10:39:40 AM [PhotoTables.sql]: Photo tables created
224830006206BUILDSchemaOK7/23/2026 10:39:39 AM [Versions.sql]: Versions table created
224830006205BUILDSchemaOK7/23/2026 10:39:39 AM [IndexMap.sql]: Index management tables and procedures built
224830006204BUILDSchemaOK7/23/2026 10:39:32 AM [MetadataTables.sql]: MetaData tables created
224830006203BUILDSchemaOK7/23/2026 10:39:32 AM [ConstantSupport.sql]: Constant support views and functions created
224830006202BUILDSchemaOK7/23/2026 10:39:29 AM [DataConstants.sql]: Constant tables created
224830006201BUILDSchemaOK7/23/2026 10:39:18 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
224830006200BUILDSchemaOK7/23/2026 10:39:16 AMStarting schema creation for TEST_DR201 with partitioning=0
224830006199BUILDDatabaseOK7/23/2026 10:39:16 AMConfigured database TEST_DR201
224830006198BUILDDatabaseOK7/23/2026 10:39:16 AMCreated database TEST_DR201
224830006197BUILDDatabaseOK7/23/2026 10:38:01 AMStarting database creation
224830006196BUILDSTARTINGSTART7/23/2026 10:38:01 AMStarting DB build
224829996195CHECKFINISHINGDONE7/23/2026 10:37:32 AMFinished CSV checking
224829996194CHECKFile countOK7/23/2026 10:37:31 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
224829996193CHECKDir checkOK7/23/2026 10:37:31 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
224829996192CHECKOpen debug file OK7/23/2026 10:37:31 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
224829996191CHECKCheck backup folOK7/23/2026 10:37:31 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
224829996190CHECKCheck rootOK7/23/2026 10:37:31 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
224829996189CHECKSTARTINGSTART7/23/2026 10:37:30 AMStarting CSV check