Log - Task #2243
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
224329805905PRELOADCSV loadOK7/22/2026 11:45:11 AMStarting File load
224329805904PRELOADSTARTINGSTART7/22/2026 11:45:11 AMStarting SQL Preload
224329795903BUILDFINISHINGDONE7/22/2026 11:45:11 AMFinished building DB
224329795902BUILDSchemaOK7/22/2026 11:45:11 AMCreated Spherical assembly in database TEST_DR201
224329795901BUILDSchemaOK7/22/2026 11:45:11 AM [spCosmology.sql]: Cosmology functions and procedures created
224329795900BUILDSchemaOK7/22/2026 11:45:10 AM [spCopyDbSubset]: spCopyDbSubset installed
224329795899BUILDSchemaOK7/22/2026 11:45:10 AM [spFinish.sql]: spFinish procedures created
224329795898BUILDSchemaOK7/22/2026 11:45:09 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
224329795897BUILDSchemaOK7/22/2026 11:45:08 AM [spValidate.sql]: Data validation procedures created
224329795896BUILDSchemaOK7/22/2026 11:45:07 AM [spSetValues.qsl]: Set values procedures created
224329795895BUILDSchemaOK7/22/2026 11:45:07 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
224329795894BUILDSchemaOK7/22/2026 11:45:07 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
224329795893BUILDSchemaOK7/22/2026 11:45:06 AM [spSQLSupport.sql]: SQL Support procs and functions created.
224329795892BUILDSchemaOK7/22/2026 11:45:06 AM [spDocSupport.sql]: DocSupport procs and functions created.
224329795891BUILDSchemaOK7/22/2026 11:45:05 AM [spTestQueries.sql]: Testing harness installed
224329795890BUILDSchemaOK7/22/2026 11:45:05 AM [spCheckDB.sql]: Database checking procs created
224329795889BUILDSchemaOK7/22/2026 11:45:04 AM [spRegion.sql]: Created functions and procedures for the Region package
224329795888BUILDSchemaOK7/22/2026 11:45:04 AM [spCoordinate.sql]: Coordinate related functions and procedures created
224329795887BUILDSchemaOK7/22/2026 11:45:03 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
224329795886BUILDSchemaOK7/22/2026 11:45:02 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
224329795885BUILDSchemaOK7/22/2026 11:45:01 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
224329795884BUILDSchemaOK7/22/2026 11:45:00 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]
224329795883BUILDSchemaOK7/22/2026 11:44:59 AMCreated Spherical assembly in database TEST_DR201
224329795882BUILDSchemaOK7/22/2026 11:44:56 AM [LvmTables.sql]: LVM tables created
224329795881BUILDSchemaOK7/22/2026 11:44:56 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
224329795880BUILDSchemaOK7/22/2026 11:44:53 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
224329795879BUILDSchemaOK7/22/2026 11:44:51 AM [Views.sql]: Views created
224329795878BUILDSchemaOK7/22/2026 11:44:51 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
224329795877BUILDSchemaOK7/22/2026 11:44:50 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
224329795876BUILDSchemaOK7/22/2026 11:44:50 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
224329795875BUILDSchemaOK7/22/2026 11:44:50 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
224329795874BUILDSchemaOK7/22/2026 11:44:49 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
224329795873BUILDSchemaOK7/22/2026 11:44:49 AM [MastarTables.sql]: Mastar tables created
224329795872BUILDSchemaOK7/22/2026 11:44:49 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
224329795871BUILDSchemaOK7/22/2026 11:44:48 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
224329795870BUILDSchemaOK7/22/2026 11:44:47 AM [ApogeeTables.sql]: APOGEE tables created
224329795869BUILDSchemaOK7/22/2026 11:44:46 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
224329795868BUILDSchemaOK7/22/2026 11:44:46 AM [WindowTables.sql]: Window tables and related views created
224329795867BUILDSchemaOK7/22/2026 11:44:46 AM [RegionTables.sql]: Created tables for Region package
224329795866BUILDSchemaOK7/22/2026 11:44:45 AM [TilingTables.sql]: Tiling tables and related views created
224329795865BUILDSchemaOK7/22/2026 11:44:45 AM [spSpectro.sql]: Spectro functions/sps created
224329795864BUILDSchemaOK7/22/2026 11:44:44 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
224329795863BUILDSchemaOK7/22/2026 11:44:44 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
224329795862BUILDSchemaOK7/22/2026 11:44:43 AM [NeighborTables.sql]: Neighbor and Match tables created
224329795861BUILDSchemaOK7/22/2026 11:44:43 AM [resolveTables.sql]: Resolve tables created
224329795860BUILDSchemaOK7/22/2026 11:44:42 AM [spPhoto.sql]: Photo procedures and functions created
224329795859BUILDSchemaOK7/22/2026 11:44:42 AM [galSpecTables.sql]: galSpec tables and related functions created
224329795858BUILDSchemaOK7/22/2026 11:44:41 AM [PhotoZTables.sql]: Photometric redshifts tables created
224329795857BUILDSchemaOK7/22/2026 11:44:41 AM [PhotoTables.sql]: Photo tables created
224329795856BUILDSchemaOK7/22/2026 11:44:40 AM [Versions.sql]: Versions table created
224329795855BUILDSchemaOK7/22/2026 11:44:40 AM [IndexMap.sql]: Index management tables and procedures built
224329795854BUILDSchemaOK7/22/2026 11:44:33 AM [MetadataTables.sql]: MetaData tables created
224329795853BUILDSchemaOK7/22/2026 11:44:33 AM [ConstantSupport.sql]: Constant support views and functions created
224329795852BUILDSchemaOK7/22/2026 11:44:30 AM [DataConstants.sql]: Constant tables created
224329795851BUILDSchemaOK7/22/2026 11:44:18 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
224329795850BUILDSchemaOK7/22/2026 11:44:17 AMStarting schema creation for TEST_DR201 with partitioning=0
224329795849BUILDDatabaseOK7/22/2026 11:44:17 AMConfigured database TEST_DR201
224329795848BUILDDatabaseOK7/22/2026 11:44:17 AMCreated database TEST_DR201
224329795847BUILDDatabaseOK7/22/2026 11:43:01 AMStarting database creation
224329795846BUILDSTARTINGSTART7/22/2026 11:43:00 AMStarting DB build
224329785845CHECKFINISHINGDONE7/22/2026 11:42:42 AMFinished CSV checking
224329785844CHECKFile countOK7/22/2026 11:42:41 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 30
224329785843CHECKDir checkOK7/22/2026 11:42:41 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
224329785842CHECKOpen debug file OK7/22/2026 11:42:41 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
224329785841CHECKCheck backup folOK7/22/2026 11:42:41 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
224329785840CHECKCheck rootOK7/22/2026 11:42:41 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
224329785839CHECKSTARTINGSTART7/22/2026 11:42:40 AMStarting CSV check