Log - Task #2238
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
223829605569PRELOADFINISHINGERROR7/15/2026 1:58:29 PMError in loading file D:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\sqlEfedsSpidersAgnFitParams.csv
223829605568PRELOADCSV loadOK7/15/2026 1:52:12 PMStarting File load
223829605567PRELOADSTARTINGSTART7/15/2026 1:52:12 PMStarting SQL Preload
223829595566BUILDFINISHINGDONE7/15/2026 1:52:12 PMFinished building DB
223829595565BUILDSchemaOK7/15/2026 1:52:12 PMCreated Spherical assembly in database TEST_DR201
223829595564BUILDSchemaOK7/15/2026 1:52:12 PM [spCosmology.sql]: Cosmology functions and procedures created
223829595563BUILDSchemaOK7/15/2026 1:52:11 PM [spCopyDbSubset]: spCopyDbSubset installed
223829595562BUILDSchemaOK7/15/2026 1:52:11 PM [spFinish.sql]: spFinish procedures created
223829595561BUILDSchemaOK7/15/2026 1:52:10 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
223829595560BUILDSchemaOK7/15/2026 1:52:09 PM [spValidate.sql]: Data validation procedures created
223829595559BUILDSchemaOK7/15/2026 1:52:08 PM [spSetValues.qsl]: Set values procedures created
223829595558BUILDSchemaOK7/15/2026 1:52:08 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
223829595557BUILDSchemaOK7/15/2026 1:52:08 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
223829595556BUILDSchemaOK7/15/2026 1:52:07 PM [spSQLSupport.sql]: SQL Support procs and functions created.
223829595555BUILDSchemaOK7/15/2026 1:52:07 PM [spDocSupport.sql]: DocSupport procs and functions created.
223829595554BUILDSchemaOK7/15/2026 1:52:06 PM [spTestQueries.sql]: Testing harness installed
223829595553BUILDSchemaOK7/15/2026 1:52:06 PM [spCheckDB.sql]: Database checking procs created
223829595552BUILDSchemaOK7/15/2026 1:52:05 PM [spRegion.sql]: Created functions and procedures for the Region package
223829595551BUILDSchemaOK7/15/2026 1:52:05 PM [spCoordinate.sql]: Coordinate related functions and procedures created
223829595550BUILDSchemaOK7/15/2026 1:52:04 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
223829595549BUILDSchemaOK7/15/2026 1:52:03 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
223829595548BUILDSchemaOK7/15/2026 1:52:02 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
223829595547BUILDSchemaOK7/15/2026 1:52:01 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]
223829595546BUILDSchemaOK7/15/2026 1:52:00 PMCreated Spherical assembly in database TEST_DR201
223829595545BUILDSchemaOK7/15/2026 1:51:57 PM [LvmTables.sql]: LVM tables created
223829595544BUILDSchemaOK7/15/2026 1:51:57 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
223829595543BUILDSchemaOK7/15/2026 1:51:55 PM Msg 102, Level 15, State 1, Server sdss4c, Line 62 Incorrect syntax near '1'. Msg 102, Level 15, State 1, Server sdss4c, Line 24 Incorrect syntax near '-'. 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
223829595542BUILDSchemaOK7/15/2026 1:51:53 PM [Views.sql]: Views created
223829595541BUILDSchemaOK7/15/2026 1:51:52 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
223829595540BUILDSchemaOK7/15/2026 1:51:52 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
223829595539BUILDSchemaOK7/15/2026 1:51:51 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
223829595538BUILDSchemaOK7/15/2026 1:51:51 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
223829595537BUILDSchemaOK7/15/2026 1:51:51 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
223829595536BUILDSchemaOK7/15/2026 1:51:51 PM [MastarTables.sql]: Mastar tables created
223829595535BUILDSchemaOK7/15/2026 1:51:50 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
223829595534BUILDSchemaOK7/15/2026 1:51: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 '*'. [AstraTables.sql]: Astra tables created
223829595533BUILDSchemaOK7/15/2026 1:51:49 PM [ApogeeTables.sql]: APOGEE tables created
223829595532BUILDSchemaOK7/15/2026 1:51:48 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
223829595531BUILDSchemaOK7/15/2026 1:51:48 PM [WindowTables.sql]: Window tables and related views created
223829595530BUILDSchemaOK7/15/2026 1:51:47 PM [RegionTables.sql]: Created tables for Region package
223829595529BUILDSchemaOK7/15/2026 1:51:47 PM [TilingTables.sql]: Tiling tables and related views created
223829595528BUILDSchemaOK7/15/2026 1:51:47 PM [spSpectro.sql]: Spectro functions/sps created
223829595527BUILDSchemaOK7/15/2026 1:51:46 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
223829595526BUILDSchemaOK7/15/2026 1:51:45 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
223829595525BUILDSchemaOK7/15/2026 1:51:45 PM [NeighborTables.sql]: Neighbor and Match tables created
223829595524BUILDSchemaOK7/15/2026 1:51:44 PM [resolveTables.sql]: Resolve tables created
223829595523BUILDSchemaOK7/15/2026 1:51:44 PM [spPhoto.sql]: Photo procedures and functions created
223829595522BUILDSchemaOK7/15/2026 1:51:44 PM [galSpecTables.sql]: galSpec tables and related functions created
223829595521BUILDSchemaOK7/15/2026 1:51:43 PM [PhotoZTables.sql]: Photometric redshifts tables created
223829595520BUILDSchemaOK7/15/2026 1:51:43 PM [PhotoTables.sql]: Photo tables created
223829595519BUILDSchemaOK7/15/2026 1:51:42 PM [Versions.sql]: Versions table created
223829595518BUILDSchemaOK7/15/2026 1:51:42 PM [IndexMap.sql]: Index management tables and procedures built
223829595517BUILDSchemaOK7/15/2026 1:51:36 PM [MetadataTables.sql]: MetaData tables created
223829595516BUILDSchemaOK7/15/2026 1:51:35 PM [ConstantSupport.sql]: Constant support views and functions created
223829595515BUILDSchemaOK7/15/2026 1:51:33 PM [DataConstants.sql]: Constant tables created
223829595514BUILDSchemaOK7/15/2026 1:51:21 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
223829595513BUILDSchemaOK7/15/2026 1:51:20 PMStarting schema creation for TEST_DR201 with partitioning=0
223829595512BUILDDatabaseOK7/15/2026 1:51:20 PMConfigured database TEST_DR201
223829595511BUILDDatabaseOK7/15/2026 1:51:19 PMCreated database TEST_DR201
223829595510BUILDDatabaseOK7/15/2026 1:50:01 PMStarting database creation
223829595509BUILDSTARTINGSTART7/15/2026 1:50:00 PMStarting DB build
223829585508CHECKFINISHINGDONE7/15/2026 1:49:47 PMFinished CSV checking
223829585507CHECKFile countOK7/15/2026 1:49:46 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 30
223829585506CHECKDir checkOK7/15/2026 1:49:46 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
223829585505CHECKOpen debug file OK7/15/2026 1:49:46 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
223829585504CHECKCheck backup folOK7/15/2026 1:49:46 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
223829585503CHECKCheck rootOK7/15/2026 1:49:46 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
223829585502CHECKSTARTINGSTART7/15/2026 1:49:46 PMStarting CSV check