Log - Task #2250
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225030126424VALIDATEspValidateDR20VAOK7/23/2026 1:17:19 PMPK_boss_clam_params created
225030126423VALIDATEspValidateDR20VAOK7/23/2026 1:17:01 PMPK_boss_clam_lite created
225030126422VALIDATEspValidateDR20VAOK7/23/2026 1:16:47 PMspValidateDR20VACs called
225030126421VALIDATESTARTINGSTART7/23/2026 1:16:47 PMValidating dr20vacs database 1
225030116420PRELOADFINISHINGDONE7/23/2026 1:16:47 PMFinished SQL preload
225030116419PRELOADSet valuesOK7/23/2026 1:16:47 PMloadVersion updated
225030116418PRELOADSet valuesOK7/23/2026 1:16:47 PMSetting loadVersion
225030116417PRELOADCSV loadOK7/23/2026 1:16:47 PMAll rows have been loaded
225030116416PRELOADCSV loadOK7/23/2026 1:16:47 PMAll files are loaded
225030116415PRELOADCSV loadOK7/23/2026 1:16:47 PMFinished File load
225030116414PRELOADCSV loadOK7/23/2026 1:08:07 PMStarting File load
225030116413PRELOADSTARTINGSTART7/23/2026 1:08:07 PMStarting SQL Preload
225030106412BUILDFINISHINGDONE7/23/2026 1:08:07 PMFinished building DB
225030106411BUILDSchemaOK7/23/2026 1:08:07 PMCreated Spherical assembly in database TEST_DR201
225030106410BUILDSchemaOK7/23/2026 1:08:07 PM [spCosmology.sql]: Cosmology functions and procedures created
225030106409BUILDSchemaOK7/23/2026 1:08:06 PM [spCopyDbSubset]: spCopyDbSubset installed
225030106408BUILDSchemaOK7/23/2026 1:08:06 PM [spFinish.sql]: spFinish procedures created
225030106407BUILDSchemaOK7/23/2026 1:08: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
225030106406BUILDSchemaOK7/23/2026 1:08:04 PM [spValidate.sql]: Data validation procedures created
225030106405BUILDSchemaOK7/23/2026 1:08:03 PM [spSetValues.qsl]: Set values procedures created
225030106404BUILDSchemaOK7/23/2026 1:08:03 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
225030106403BUILDSchemaOK7/23/2026 1:08:03 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225030106402BUILDSchemaOK7/23/2026 1:08:02 PM [spSQLSupport.sql]: SQL Support procs and functions created.
225030106401BUILDSchemaOK7/23/2026 1:08:02 PM [spDocSupport.sql]: DocSupport procs and functions created.
225030106400BUILDSchemaOK7/23/2026 1:08:01 PM [spTestQueries.sql]: Testing harness installed
225030106399BUILDSchemaOK7/23/2026 1:08:01 PM [spCheckDB.sql]: Database checking procs created
225030106398BUILDSchemaOK7/23/2026 1:08:01 PM [spRegion.sql]: Created functions and procedures for the Region package
225030106397BUILDSchemaOK7/23/2026 1:08:00 PM [spCoordinate.sql]: Coordinate related functions and procedures created
225030106396BUILDSchemaOK7/23/2026 1:07:59 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225030106395BUILDSchemaOK7/23/2026 1:07: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
225030106394BUILDSchemaOK7/23/2026 1:07:57 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225030106393BUILDSchemaOK7/23/2026 1:07: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]
225030106392BUILDSchemaOK7/23/2026 1:07:56 PMCreated Spherical assembly in database TEST_DR201
225030106391BUILDSchemaOK7/23/2026 1:07:53 PM [LvmTables.sql]: LVM tables created
225030106390BUILDSchemaOK7/23/2026 1:07:53 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225030106389BUILDSchemaOK7/23/2026 1:07:50 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
225030106388BUILDSchemaOK7/23/2026 1:07:49 PM [Views.sql]: Views created
225030106387BUILDSchemaOK7/23/2026 1:07:48 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225030106386BUILDSchemaOK7/23/2026 1:07:48 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225030106385BUILDSchemaOK7/23/2026 1:07:48 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225030106384BUILDSchemaOK7/23/2026 1:07: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
225030106383BUILDSchemaOK7/23/2026 1:07:47 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225030106382BUILDSchemaOK7/23/2026 1:07:47 PM [MastarTables.sql]: Mastar tables created
225030106381BUILDSchemaOK7/23/2026 1:07: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
225030106380BUILDSchemaOK7/23/2026 1:07: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
225030106379BUILDSchemaOK7/23/2026 1:07:45 PM [ApogeeTables.sql]: APOGEE tables created
225030106378BUILDSchemaOK7/23/2026 1:07:45 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225030106377BUILDSchemaOK7/23/2026 1:07:44 PM [WindowTables.sql]: Window tables and related views created
225030106376BUILDSchemaOK7/23/2026 1:07:44 PM [RegionTables.sql]: Created tables for Region package
225030106375BUILDSchemaOK7/23/2026 1:07:44 PM [TilingTables.sql]: Tiling tables and related views created
225030106374BUILDSchemaOK7/23/2026 1:07:43 PM [spSpectro.sql]: Spectro functions/sps created
225030106373BUILDSchemaOK7/23/2026 1:07:43 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
225030106372BUILDSchemaOK7/23/2026 1:07: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
225030106371BUILDSchemaOK7/23/2026 1:07:42 PM [NeighborTables.sql]: Neighbor and Match tables created
225030106370BUILDSchemaOK7/23/2026 1:07:41 PM [resolveTables.sql]: Resolve tables created
225030106369BUILDSchemaOK7/23/2026 1:07:41 PM [spPhoto.sql]: Photo procedures and functions created
225030106368BUILDSchemaOK7/23/2026 1:07:41 PM [galSpecTables.sql]: galSpec tables and related functions created
225030106367BUILDSchemaOK7/23/2026 1:07:40 PM [PhotoZTables.sql]: Photometric redshifts tables created
225030106366BUILDSchemaOK7/23/2026 1:07:40 PM [PhotoTables.sql]: Photo tables created
225030106365BUILDSchemaOK7/23/2026 1:07:39 PM [Versions.sql]: Versions table created
225030106364BUILDSchemaOK7/23/2026 1:07:39 PM [IndexMap.sql]: Index management tables and procedures built
225030106363BUILDSchemaOK7/23/2026 1:07:32 PM [MetadataTables.sql]: MetaData tables created
225030106362BUILDSchemaOK7/23/2026 1:07:32 PM [ConstantSupport.sql]: Constant support views and functions created
225030106361BUILDSchemaOK7/23/2026 1:07:30 PM [DataConstants.sql]: Constant tables created
225030106360BUILDSchemaOK7/23/2026 1:07:18 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225030106359BUILDSchemaOK7/23/2026 1:07:17 PMStarting schema creation for TEST_DR201 with partitioning=0
225030106358BUILDDatabaseOK7/23/2026 1:07:17 PMConfigured database TEST_DR201
225030106357BUILDDatabaseOK7/23/2026 1:07:16 PMCreated database TEST_DR201
225030106356BUILDDatabaseOK7/23/2026 1:06:02 PMStarting database creation
225030106355BUILDSTARTINGSTART7/23/2026 1:06:01 PMStarting DB build
225030096354CHECKFINISHINGDONE7/23/2026 1:05:02 PMFinished CSV checking
225030096353CHECKFile countOK7/23/2026 1:05:02 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225030096352CHECKDir checkOK7/23/2026 1:05:02 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225030096351CHECKOpen debug file OK7/23/2026 1:05:02 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225030096350CHECKCheck backup folOK7/23/2026 1:05:01 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225030096349CHECKCheck rootOK7/23/2026 1:05:01 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225030096348CHECKSTARTINGSTART7/23/2026 1:05:01 PMStarting CSV check