Log - Task #2209
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
220928233290PRELOADCSV loadOK6/15/2026 1:24:40 PMStarting File load
220928233289PRELOADSTARTINGSTART6/15/2026 1:24:40 PMStarting SQL Preload
220928223288BUILDFINISHINGDONE6/15/2026 1:24:40 PMFinished building DB
220928223287BUILDSchemaOK6/15/2026 1:24:40 PMCreated Spherical assembly in database TEST_EBOS1
220928223286BUILDSchemaOK6/15/2026 1:24:40 PM [spCosmology.sql]: Cosmology functions and procedures created
220928223285BUILDSchemaOK6/15/2026 1:24:39 PM [spCopyDbSubset]: spCopyDbSubset installed
220928223284BUILDSchemaOK6/15/2026 1:24:39 PM [spFinish.sql]: spFinish procedures created
220928223283BUILDSchemaOK6/15/2026 1:24:38 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
220928223282BUILDSchemaOK6/15/2026 1:24:37 PM [spValidate.sql]: Data validation procedures created
220928223281BUILDSchemaOK6/15/2026 1:24:36 PM [spSetValues.qsl]: Set values procedures created
220928223280BUILDSchemaOK6/15/2026 1:24:36 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
220928223279BUILDSchemaOK6/15/2026 1:24:35 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
220928223278BUILDSchemaOK6/15/2026 1:24:35 PM [spSQLSupport.sql]: SQL Support procs and functions created.
220928223277BUILDSchemaOK6/15/2026 1:24:34 PM [spDocSupport.sql]: DocSupport procs and functions created.
220928223276BUILDSchemaOK6/15/2026 1:24:34 PM [spTestQueries.sql]: Testing harness installed
220928223275BUILDSchemaOK6/15/2026 1:24:33 PM [spCheckDB.sql]: Database checking procs created
220928223274BUILDSchemaOK6/15/2026 1:24:33 PM [spRegion.sql]: Created functions and procedures for the Region package
220928223273BUILDSchemaOK6/15/2026 1:24:32 PM [spCoordinate.sql]: Coordinate related functions and procedures created
220928223272BUILDSchemaOK6/15/2026 1:24:31 PMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
220928223271BUILDSchemaOK6/15/2026 1:24:31 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
220928223270BUILDSchemaOK6/15/2026 1:24:29 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
220928223269BUILDSchemaOK6/15/2026 1:24:28 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]
220928223268BUILDSchemaOK6/15/2026 1:24:27 PMCreated Spherical assembly in database TEST_EBOS1
220928223267BUILDSchemaOK6/15/2026 1:24:24 PM [LvmTables.sql]: LVM tables created
220928223266BUILDSchemaOK6/15/2026 1:24:24 PMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
220928223265BUILDSchemaOK6/15/2026 1:24:21 PM [VacTables.sql]: VAC tables created
220928223264BUILDSchemaOK6/15/2026 1:24:20 PM [Views.sql]: Views created
220928223263BUILDSchemaOK6/15/2026 1:24:19 PMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
220928223262BUILDSchemaOK6/15/2026 1:24:19 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
220928223261BUILDSchemaOK6/15/2026 1:24:18 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
220928223260BUILDSchemaOK6/15/2026 1:24:18 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
220928223259BUILDSchemaOK6/15/2026 1:24:17 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
220928223258BUILDSchemaOK6/15/2026 1:24:17 PM [MastarTables.sql]: Mastar tables created
220928223257BUILDSchemaOK6/15/2026 1:24:17 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
220928223256BUILDSchemaOK6/15/2026 1:24:16 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
220928223255BUILDSchemaOK6/15/2026 1:24:15 PM [ApogeeTables.sql]: APOGEE tables created
220928223254BUILDSchemaOK6/15/2026 1:24:14 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
220928223253BUILDSchemaOK6/15/2026 1:24:14 PM [WindowTables.sql]: Window tables and related views created
220928223252BUILDSchemaOK6/15/2026 1:24:13 PM [RegionTables.sql]: Created tables for Region package
220928223251BUILDSchemaOK6/15/2026 1:24:13 PM [TilingTables.sql]: Tiling tables and related views created
220928223250BUILDSchemaOK6/15/2026 1:24:12 PM [spSpectro.sql]: Spectro functions/sps created
220928223249BUILDSchemaOK6/15/2026 1:24:11 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
220928223248BUILDSchemaOK6/15/2026 1:24:11 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
220928223247BUILDSchemaOK6/15/2026 1:24:10 PM [NeighborTables.sql]: Neighbor and Match tables created
220928223246BUILDSchemaOK6/15/2026 1:24:10 PM [resolveTables.sql]: Resolve tables created
220928223245BUILDSchemaOK6/15/2026 1:24:10 PM [spPhoto.sql]: Photo procedures and functions created
220928223244BUILDSchemaOK6/15/2026 1:24:09 PM [galSpecTables.sql]: galSpec tables and related functions created
220928223243BUILDSchemaOK6/15/2026 1:24:08 PM [PhotoZTables.sql]: Photometric redshifts tables created
220928223242BUILDSchemaOK6/15/2026 1:24:08 PM [PhotoTables.sql]: Photo tables created
220928223241BUILDSchemaOK6/15/2026 1:24:07 PM [Versions.sql]: Versions table created
220928223240BUILDSchemaOK6/15/2026 1:24:07 PM [IndexMap.sql]: Index management tables and procedures built
220928223239BUILDSchemaOK6/15/2026 1:24:01 PM [MetadataTables.sql]: MetaData tables created
220928223238BUILDSchemaOK6/15/2026 1:24:00 PM [ConstantSupport.sql]: Constant support views and functions created
220928223237BUILDSchemaOK6/15/2026 1:23:58 PM [DataConstants.sql]: Constant tables created
220928223236BUILDSchemaOK6/15/2026 1:23:46 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
220928223235BUILDSchemaOK6/15/2026 1:23:44 PMStarting schema creation for TEST_EBOS1 with partitioning=0
220928223234BUILDDatabaseOK6/15/2026 1:23:44 PMConfigured database TEST_EBOS1
220928223233BUILDDatabaseOK6/15/2026 1:23:44 PMCreated database TEST_EBOS1
220928223232BUILDDatabaseOK6/15/2026 1:22:01 PMStarting database creation
220928223231BUILDSTARTINGSTART6/15/2026 1:22:00 PMStarting DB build
220928213230CHECKFINISHINGDONE6/15/2026 1:21:26 PMFinished CSV checking
220928213229CHECKFile countOK6/15/2026 1:21:26 PMD:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1:Number of CSV files is 3
220928213228CHECKDir checkOK6/15/2026 1:21:26 PMD:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1:Checking directory
220928213227CHECKOpen debug file OK6/15/2026 1:21:26 PMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:File opened
220928213226CHECKCheck backup folOK6/15/2026 1:21:26 PMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:Folder exists
220928213225CHECKCheck rootOK6/15/2026 1:21:26 PMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:Found root directory
220928213224CHECKSTARTINGSTART6/15/2026 1:21:25 PMStarting CSV check