Log - Task #2213
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221328433529PRELOADCSV loadOK6/17/2026 3:24:59 PMStarting File load
221328433528PRELOADSTARTINGSTART6/17/2026 3:24:59 PMStarting SQL Preload
221328423527BUILDFINISHINGDONE6/17/2026 3:24:59 PMFinished building DB
221328423526BUILDSchemaOK6/17/2026 3:24:59 PMCreated Spherical assembly in database TEST_ASTR1
221328423525BUILDSchemaOK6/17/2026 3:24:59 PM [spCosmology.sql]: Cosmology functions and procedures created
221328423524BUILDSchemaOK6/17/2026 3:24:58 PM [spCopyDbSubset]: spCopyDbSubset installed
221328423523BUILDSchemaOK6/17/2026 3:24:58 PM [spFinish.sql]: spFinish procedures created
221328423522BUILDSchemaOK6/17/2026 3:24:57 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
221328423521BUILDSchemaOK6/17/2026 3:24:56 PM [spValidate.sql]: Data validation procedures created
221328423520BUILDSchemaOK6/17/2026 3:24:55 PM [spSetValues.qsl]: Set values procedures created
221328423519BUILDSchemaOK6/17/2026 3:24:55 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
221328423518BUILDSchemaOK6/17/2026 3:24:54 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221328423517BUILDSchemaOK6/17/2026 3:24:54 PM [spSQLSupport.sql]: SQL Support procs and functions created.
221328423516BUILDSchemaOK6/17/2026 3:24:54 PM [spDocSupport.sql]: DocSupport procs and functions created.
221328423515BUILDSchemaOK6/17/2026 3:24:53 PM [spTestQueries.sql]: Testing harness installed
221328423514BUILDSchemaOK6/17/2026 3:24:53 PM [spCheckDB.sql]: Database checking procs created
221328423513BUILDSchemaOK6/17/2026 3:24:52 PM [spRegion.sql]: Created functions and procedures for the Region package
221328423512BUILDSchemaOK6/17/2026 3:24:52 PM [spCoordinate.sql]: Coordinate related functions and procedures created
221328423511BUILDSchemaOK6/17/2026 3:24:51 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221328423510BUILDSchemaOK6/17/2026 3:24:50 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
221328423509BUILDSchemaOK6/17/2026 3:24:49 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221328423508BUILDSchemaOK6/17/2026 3:24:48 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]
221328423507BUILDSchemaOK6/17/2026 3:24:47 PMCreated Spherical assembly in database TEST_ASTR1
221328423506BUILDSchemaOK6/17/2026 3:24:45 PM [LvmTables.sql]: LVM tables created
221328423505BUILDSchemaOK6/17/2026 3:24:44 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221328423504BUILDSchemaOK6/17/2026 3:24:42 PM [VacTables.sql]: VAC tables created
221328423503BUILDSchemaOK6/17/2026 3:24:41 PM [Views.sql]: Views created
221328423502BUILDSchemaOK6/17/2026 3:24:40 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221328423501BUILDSchemaOK6/17/2026 3:24:40 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221328423500BUILDSchemaOK6/17/2026 3:24:39 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221328423499BUILDSchemaOK6/17/2026 3:24:39 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
221328423498BUILDSchemaOK6/17/2026 3:24:39 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221328423497BUILDSchemaOK6/17/2026 3:24:38 PM [MastarTables.sql]: Mastar tables created
221328423496BUILDSchemaOK6/17/2026 3:24:38 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
221328423495BUILDSchemaOK6/17/2026 3:24:37 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
221328423494BUILDSchemaOK6/17/2026 3:24:36 PM [ApogeeTables.sql]: APOGEE tables created
221328423493BUILDSchemaOK6/17/2026 3:24:36 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221328423492BUILDSchemaOK6/17/2026 3:24:35 PM [WindowTables.sql]: Window tables and related views created
221328423491BUILDSchemaOK6/17/2026 3:24:35 PM [RegionTables.sql]: Created tables for Region package
221328423490BUILDSchemaOK6/17/2026 3:24:35 PM [TilingTables.sql]: Tiling tables and related views created
221328423489BUILDSchemaOK6/17/2026 3:24:34 PM [spSpectro.sql]: Spectro functions/sps created
221328423488BUILDSchemaOK6/17/2026 3:24:33 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
221328423487BUILDSchemaOK6/17/2026 3:24:33 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
221328423486BUILDSchemaOK6/17/2026 3:24:32 PM [NeighborTables.sql]: Neighbor and Match tables created
221328423485BUILDSchemaOK6/17/2026 3:24:32 PM [resolveTables.sql]: Resolve tables created
221328423484BUILDSchemaOK6/17/2026 3:24:32 PM [spPhoto.sql]: Photo procedures and functions created
221328423483BUILDSchemaOK6/17/2026 3:24:31 PM [galSpecTables.sql]: galSpec tables and related functions created
221328423482BUILDSchemaOK6/17/2026 3:24:31 PM [PhotoZTables.sql]: Photometric redshifts tables created
221328423481BUILDSchemaOK6/17/2026 3:24:30 PM [PhotoTables.sql]: Photo tables created
221328423480BUILDSchemaOK6/17/2026 3:24:29 PM [Versions.sql]: Versions table created
221328423479BUILDSchemaOK6/17/2026 3:24:29 PM [IndexMap.sql]: Index management tables and procedures built
221328423478BUILDSchemaOK6/17/2026 3:24:23 PM [MetadataTables.sql]: MetaData tables created
221328423477BUILDSchemaOK6/17/2026 3:24:23 PM [ConstantSupport.sql]: Constant support views and functions created
221328423476BUILDSchemaOK6/17/2026 3:24:20 PM [DataConstants.sql]: Constant tables created
221328423475BUILDSchemaOK6/17/2026 3:24:09 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221328423474BUILDSchemaOK6/17/2026 3:24:07 PMStarting schema creation for TEST_ASTR1 with partitioning=0
221328423473BUILDDatabaseOK6/17/2026 3:24:07 PMConfigured database TEST_ASTR1
221328423472BUILDDatabaseOK6/17/2026 3:24:07 PMCreated database TEST_ASTR1
221328423471BUILDDatabaseOK6/17/2026 3:22:01 PMStarting database creation
221328423470BUILDSTARTINGSTART6/17/2026 3:22:01 PMStarting DB build
221328413469CHECKFINISHINGDONE6/17/2026 3:21:18 PMFinished CSV checking
221328413468CHECKFile countOK6/17/2026 3:21:18 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
221328413467CHECKDir checkOK6/17/2026 3:21:18 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
221328413466CHECKOpen debug file OK6/17/2026 3:21:18 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
221328413465CHECKCheck backup folOK6/17/2026 3:21:18 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
221328413464CHECKCheck rootOK6/17/2026 3:21:18 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
221328413463CHECKSTARTINGSTART6/17/2026 3:21:17 PMStarting CSV check