Log - Task #2215
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221528523672VALIDATEFINISHINGERROR6/18/2026 2:03:54 PMFailed to validate Astra 1
221528523671VALIDATEspValidateAstraOK6/18/2026 2:03:54 PMspValidateAstra called
221528523670VALIDATESTARTINGSTART6/18/2026 2:03:54 PMValidating astra database 1
221528513669PRELOADFINISHINGDONE6/18/2026 2:03:54 PMFinished SQL preload
221528513668PRELOADSet valuesOK6/18/2026 2:03:54 PMloadVersion updated
221528513667PRELOADSet valuesOK6/18/2026 2:03:54 PMSetting loadVersion
221528513666PRELOADCSV loadOK6/18/2026 2:03:54 PMAll rows have been loaded
221528513665PRELOADCSV loadOK6/18/2026 2:03:54 PMAll files are loaded
221528513664PRELOADCSV loadOK6/18/2026 2:03:54 PMFinished File load
221528513663PRELOADCSV loadOK6/18/2026 12:18:43 PMStarting File load
221528513662PRELOADSTARTINGSTART6/18/2026 12:18:43 PMStarting SQL Preload
221528503661BUILDFINISHINGDONE6/18/2026 12:18:43 PMFinished building DB
221528503660BUILDSchemaOK6/18/2026 12:18:43 PMCreated Spherical assembly in database TEST_ASTR1
221528503659BUILDSchemaOK6/18/2026 12:18:43 PM [spCosmology.sql]: Cosmology functions and procedures created
221528503658BUILDSchemaOK6/18/2026 12:18:42 PM [spCopyDbSubset]: spCopyDbSubset installed
221528503657BUILDSchemaOK6/18/2026 12:18:42 PM [spFinish.sql]: spFinish procedures created
221528503656BUILDSchemaOK6/18/2026 12:18:41 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
221528503655BUILDSchemaOK6/18/2026 12:18:41 PM [spValidate.sql]: Data validation procedures created
221528503654BUILDSchemaOK6/18/2026 12:18:40 PM [spSetValues.qsl]: Set values procedures created
221528503653BUILDSchemaOK6/18/2026 12:18:39 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
221528503652BUILDSchemaOK6/18/2026 12:18:39 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221528503651BUILDSchemaOK6/18/2026 12:18:39 PM [spSQLSupport.sql]: SQL Support procs and functions created.
221528503650BUILDSchemaOK6/18/2026 12:18:38 PM [spDocSupport.sql]: DocSupport procs and functions created.
221528503649BUILDSchemaOK6/18/2026 12:18:38 PM [spTestQueries.sql]: Testing harness installed
221528503648BUILDSchemaOK6/18/2026 12:18:37 PM [spCheckDB.sql]: Database checking procs created
221528503647BUILDSchemaOK6/18/2026 12:18:37 PM [spRegion.sql]: Created functions and procedures for the Region package
221528503646BUILDSchemaOK6/18/2026 12:18:36 PM [spCoordinate.sql]: Coordinate related functions and procedures created
221528503645BUILDSchemaOK6/18/2026 12:18:35 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221528503644BUILDSchemaOK6/18/2026 12:18:35 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
221528503643BUILDSchemaOK6/18/2026 12:18:33 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221528503642BUILDSchemaOK6/18/2026 12:18:33 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]
221528503641BUILDSchemaOK6/18/2026 12:18:32 PMCreated Spherical assembly in database TEST_ASTR1
221528503640BUILDSchemaOK6/18/2026 12:18:29 PM [LvmTables.sql]: LVM tables created
221528503639BUILDSchemaOK6/18/2026 12:18:29 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221528503638BUILDSchemaOK6/18/2026 12:18:26 PM [VacTables.sql]: VAC tables created
221528503637BUILDSchemaOK6/18/2026 12:18:25 PM [Views.sql]: Views created
221528503636BUILDSchemaOK6/18/2026 12:18:25 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221528503635BUILDSchemaOK6/18/2026 12:18:24 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221528503634BUILDSchemaOK6/18/2026 12:18:24 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221528503633BUILDSchemaOK6/18/2026 12:18:24 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
221528503632BUILDSchemaOK6/18/2026 12:18:23 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221528503631BUILDSchemaOK6/18/2026 12:18:23 PM [MastarTables.sql]: Mastar tables created
221528503630BUILDSchemaOK6/18/2026 12:18:23 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
221528503629BUILDSchemaOK6/18/2026 12:18:22 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
221528503628BUILDSchemaOK6/18/2026 12:18:21 PM [ApogeeTables.sql]: APOGEE tables created
221528503627BUILDSchemaOK6/18/2026 12:18:21 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221528503626BUILDSchemaOK6/18/2026 12:18:20 PM [WindowTables.sql]: Window tables and related views created
221528503625BUILDSchemaOK6/18/2026 12:18:20 PM [RegionTables.sql]: Created tables for Region package
221528503624BUILDSchemaOK6/18/2026 12:18:20 PM [TilingTables.sql]: Tiling tables and related views created
221528503623BUILDSchemaOK6/18/2026 12:18:19 PM [spSpectro.sql]: Spectro functions/sps created
221528503622BUILDSchemaOK6/18/2026 12:18:19 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
221528503621BUILDSchemaOK6/18/2026 12:18:18 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
221528503620BUILDSchemaOK6/18/2026 12:18:18 PM [NeighborTables.sql]: Neighbor and Match tables created
221528503619BUILDSchemaOK6/18/2026 12:18:17 PM [resolveTables.sql]: Resolve tables created
221528503618BUILDSchemaOK6/18/2026 12:18:17 PM [spPhoto.sql]: Photo procedures and functions created
221528503617BUILDSchemaOK6/18/2026 12:18:16 PM [galSpecTables.sql]: galSpec tables and related functions created
221528503616BUILDSchemaOK6/18/2026 12:18:16 PM [PhotoZTables.sql]: Photometric redshifts tables created
221528503615BUILDSchemaOK6/18/2026 12:18:16 PM [PhotoTables.sql]: Photo tables created
221528503614BUILDSchemaOK6/18/2026 12:18:15 PM [Versions.sql]: Versions table created
221528503613BUILDSchemaOK6/18/2026 12:18:15 PM [IndexMap.sql]: Index management tables and procedures built
221528503612BUILDSchemaOK6/18/2026 12:18:09 PM [MetadataTables.sql]: MetaData tables created
221528503611BUILDSchemaOK6/18/2026 12:18:08 PM [ConstantSupport.sql]: Constant support views and functions created
221528503610BUILDSchemaOK6/18/2026 12:18:06 PM [DataConstants.sql]: Constant tables created
221528503609BUILDSchemaOK6/18/2026 12:17:54 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221528503608BUILDSchemaOK6/18/2026 12:17:53 PMStarting schema creation for TEST_ASTR1 with partitioning=0
221528503607BUILDDatabaseOK6/18/2026 12:17:53 PMConfigured database TEST_ASTR1
221528503606BUILDDatabaseOK6/18/2026 12:17:53 PMCreated database TEST_ASTR1
221528503605BUILDDatabaseOK6/18/2026 12:16:02 PMStarting database creation
221528503604BUILDSTARTINGSTART6/18/2026 12:16:00 PMStarting DB build
221528493603CHECKFINISHINGDONE6/18/2026 12:15:27 PMFinished CSV checking
221528493602CHECKFile countOK6/18/2026 12:15:27 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
221528493601CHECKDir checkOK6/18/2026 12:15:26 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
221528493600CHECKOpen debug file OK6/18/2026 12:15:26 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
221528493599CHECKCheck backup folOK6/18/2026 12:15:26 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
221528493598CHECKCheck rootOK6/18/2026 12:15:26 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
221528493597CHECKSTARTINGSTART6/18/2026 12:15:26 PMStarting CSV check