Log - Task #2214
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221428473596PRELOADCSV loadOK6/18/2026 10:37:50 AMStarting File load
221428473595PRELOADSTARTINGSTART6/18/2026 10:37:50 AMStarting SQL Preload
221428463594BUILDFINISHINGDONE6/18/2026 10:37:50 AMFinished building DB
221428463593BUILDSchemaOK6/18/2026 10:37:50 AMCreated Spherical assembly in database TEST_ASTR1
221428463592BUILDSchemaOK6/18/2026 10:37:50 AM [spCosmology.sql]: Cosmology functions and procedures created
221428463591BUILDSchemaOK6/18/2026 10:37:49 AM [spCopyDbSubset]: spCopyDbSubset installed
221428463590BUILDSchemaOK6/18/2026 10:37:48 AM [spFinish.sql]: spFinish procedures created
221428463589BUILDSchemaOK6/18/2026 10:37:47 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
221428463588BUILDSchemaOK6/18/2026 10:37:47 AM [spValidate.sql]: Data validation procedures created
221428463587BUILDSchemaOK6/18/2026 10:37:46 AM [spSetValues.qsl]: Set values procedures created
221428463586BUILDSchemaOK6/18/2026 10:37:46 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
221428463585BUILDSchemaOK6/18/2026 10:37:45 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221428463584BUILDSchemaOK6/18/2026 10:37:45 AM [spSQLSupport.sql]: SQL Support procs and functions created.
221428463583BUILDSchemaOK6/18/2026 10:37:44 AM [spDocSupport.sql]: DocSupport procs and functions created.
221428463582BUILDSchemaOK6/18/2026 10:37:44 AM [spTestQueries.sql]: Testing harness installed
221428463581BUILDSchemaOK6/18/2026 10:37:44 AM [spCheckDB.sql]: Database checking procs created
221428463580BUILDSchemaOK6/18/2026 10:37:43 AM [spRegion.sql]: Created functions and procedures for the Region package
221428463579BUILDSchemaOK6/18/2026 10:37:42 AM [spCoordinate.sql]: Coordinate related functions and procedures created
221428463578BUILDSchemaOK6/18/2026 10:37:42 AMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221428463577BUILDSchemaOK6/18/2026 10:37:41 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
221428463576BUILDSchemaOK6/18/2026 10:37:40 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221428463575BUILDSchemaOK6/18/2026 10:37:39 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]
221428463574BUILDSchemaOK6/18/2026 10:37:38 AMCreated Spherical assembly in database TEST_ASTR1
221428463573BUILDSchemaOK6/18/2026 10:37:34 AM [LvmTables.sql]: LVM tables created
221428463572BUILDSchemaOK6/18/2026 10:37:34 AMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221428463571BUILDSchemaOK6/18/2026 10:37:32 AM [VacTables.sql]: VAC tables created
221428463570BUILDSchemaOK6/18/2026 10:37:31 AM [Views.sql]: Views created
221428463569BUILDSchemaOK6/18/2026 10:37:30 AMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221428463568BUILDSchemaOK6/18/2026 10:37:29 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221428463567BUILDSchemaOK6/18/2026 10:37:29 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221428463566BUILDSchemaOK6/18/2026 10:37:29 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
221428463565BUILDSchemaOK6/18/2026 10:37:29 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221428463564BUILDSchemaOK6/18/2026 10:37:28 AM [MastarTables.sql]: Mastar tables created
221428463563BUILDSchemaOK6/18/2026 10:37:28 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
221428463562BUILDSchemaOK6/18/2026 10:37:27 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
221428463561BUILDSchemaOK6/18/2026 10:37:26 AM [ApogeeTables.sql]: APOGEE tables created
221428463560BUILDSchemaOK6/18/2026 10:37:26 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221428463559BUILDSchemaOK6/18/2026 10:37:25 AM [WindowTables.sql]: Window tables and related views created
221428463558BUILDSchemaOK6/18/2026 10:37:25 AM [RegionTables.sql]: Created tables for Region package
221428463557BUILDSchemaOK6/18/2026 10:37:25 AM [TilingTables.sql]: Tiling tables and related views created
221428463556BUILDSchemaOK6/18/2026 10:37:24 AM [spSpectro.sql]: Spectro functions/sps created
221428463555BUILDSchemaOK6/18/2026 10:37:23 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
221428463554BUILDSchemaOK6/18/2026 10:37:23 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
221428463553BUILDSchemaOK6/18/2026 10:37:22 AM [NeighborTables.sql]: Neighbor and Match tables created
221428463552BUILDSchemaOK6/18/2026 10:37:22 AM [resolveTables.sql]: Resolve tables created
221428463551BUILDSchemaOK6/18/2026 10:37:22 AM [spPhoto.sql]: Photo procedures and functions created
221428463550BUILDSchemaOK6/18/2026 10:37:21 AM [galSpecTables.sql]: galSpec tables and related functions created
221428463549BUILDSchemaOK6/18/2026 10:37:21 AM [PhotoZTables.sql]: Photometric redshifts tables created
221428463548BUILDSchemaOK6/18/2026 10:37:20 AM [PhotoTables.sql]: Photo tables created
221428463547BUILDSchemaOK6/18/2026 10:37:19 AM [Versions.sql]: Versions table created
221428463546BUILDSchemaOK6/18/2026 10:37:19 AM [IndexMap.sql]: Index management tables and procedures built
221428463545BUILDSchemaOK6/18/2026 10:37:13 AM [MetadataTables.sql]: MetaData tables created
221428463544BUILDSchemaOK6/18/2026 10:37:13 AM [ConstantSupport.sql]: Constant support views and functions created
221428463543BUILDSchemaOK6/18/2026 10:37:10 AM [DataConstants.sql]: Constant tables created
221428463542BUILDSchemaOK6/18/2026 10:36:59 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221428463541BUILDSchemaOK6/18/2026 10:36:57 AMStarting schema creation for TEST_ASTR1 with partitioning=0
221428463540BUILDDatabaseOK6/18/2026 10:36:57 AMConfigured database TEST_ASTR1
221428463539BUILDDatabaseOK6/18/2026 10:36:57 AMCreated database TEST_ASTR1
221428463538BUILDDatabaseOK6/18/2026 10:35:02 AMStarting database creation
221428463537BUILDSTARTINGSTART6/18/2026 10:35:00 AMStarting DB build
221428453536CHECKFINISHINGDONE6/18/2026 10:34:57 AMFinished CSV checking
221428453535CHECKFile countOK6/18/2026 10:34:57 AMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
221428453534CHECKDir checkOK6/18/2026 10:34:57 AMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
221428453533CHECKOpen debug file OK6/18/2026 10:34:57 AMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
221428453532CHECKCheck backup folOK6/18/2026 10:34:57 AMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
221428453531CHECKCheck rootOK6/18/2026 10:34:57 AMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
221428453530CHECKSTARTINGSTART6/18/2026 10:34:56 AMStarting CSV check