Log - Task #2210
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221028273357PRELOADCSV loadOK6/16/2026 12:29:43 PMStarting File load
221028273356PRELOADSTARTINGSTART6/16/2026 12:29:43 PMStarting SQL Preload
221028263355BUILDFINISHINGDONE6/16/2026 12:29:43 PMFinished building DB
221028263354BUILDSchemaOK6/16/2026 12:29:43 PMCreated Spherical assembly in database TEST_EBOS1
221028263353BUILDSchemaOK6/16/2026 12:29:43 PM [spCosmology.sql]: Cosmology functions and procedures created
221028263352BUILDSchemaOK6/16/2026 12:29:42 PM [spCopyDbSubset]: spCopyDbSubset installed
221028263351BUILDSchemaOK6/16/2026 12:29:41 PM [spFinish.sql]: spFinish procedures created
221028263350BUILDSchemaOK6/16/2026 12:29: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
221028263349BUILDSchemaOK6/16/2026 12:29:40 PM [spValidate.sql]: Data validation procedures created
221028263348BUILDSchemaOK6/16/2026 12:29:39 PM [spSetValues.qsl]: Set values procedures created
221028263347BUILDSchemaOK6/16/2026 12:29:39 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
221028263346BUILDSchemaOK6/16/2026 12:29:38 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221028263345BUILDSchemaOK6/16/2026 12:29:38 PM [spSQLSupport.sql]: SQL Support procs and functions created.
221028263344BUILDSchemaOK6/16/2026 12:29:37 PM [spDocSupport.sql]: DocSupport procs and functions created.
221028263343BUILDSchemaOK6/16/2026 12:29:37 PM [spTestQueries.sql]: Testing harness installed
221028263342BUILDSchemaOK6/16/2026 12:29:36 PM [spCheckDB.sql]: Database checking procs created
221028263341BUILDSchemaOK6/16/2026 12:29:36 PM [spRegion.sql]: Created functions and procedures for the Region package
221028263340BUILDSchemaOK6/16/2026 12:29:35 PM [spCoordinate.sql]: Coordinate related functions and procedures created
221028263339BUILDSchemaOK6/16/2026 12:29:34 PMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221028263338BUILDSchemaOK6/16/2026 12:29:34 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
221028263337BUILDSchemaOK6/16/2026 12:29:32 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221028263336BUILDSchemaOK6/16/2026 12:29:31 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]
221028263335BUILDSchemaOK6/16/2026 12:29:30 PMCreated Spherical assembly in database TEST_EBOS1
221028263334BUILDSchemaOK6/16/2026 12:29:27 PM [LvmTables.sql]: LVM tables created
221028263333BUILDSchemaOK6/16/2026 12:29:26 PMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221028263332BUILDSchemaOK6/16/2026 12:29:23 PM [VacTables.sql]: VAC tables created
221028263331BUILDSchemaOK6/16/2026 12:29:23 PM [Views.sql]: Views created
221028263330BUILDSchemaOK6/16/2026 12:29:22 PMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221028263329BUILDSchemaOK6/16/2026 12:29:21 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221028263328BUILDSchemaOK6/16/2026 12:29:21 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221028263327BUILDSchemaOK6/16/2026 12:29:21 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
221028263326BUILDSchemaOK6/16/2026 12:29:20 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221028263325BUILDSchemaOK6/16/2026 12:29:20 PM [MastarTables.sql]: Mastar tables created
221028263324BUILDSchemaOK6/16/2026 12:29:20 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
221028263323BUILDSchemaOK6/16/2026 12:29:19 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
221028263322BUILDSchemaOK6/16/2026 12:29:18 PM [ApogeeTables.sql]: APOGEE tables created
221028263321BUILDSchemaOK6/16/2026 12:29:17 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221028263320BUILDSchemaOK6/16/2026 12:29:17 PM [WindowTables.sql]: Window tables and related views created
221028263319BUILDSchemaOK6/16/2026 12:29:16 PM [RegionTables.sql]: Created tables for Region package
221028263318BUILDSchemaOK6/16/2026 12:29:16 PM [TilingTables.sql]: Tiling tables and related views created
221028263317BUILDSchemaOK6/16/2026 12:29:15 PM [spSpectro.sql]: Spectro functions/sps created
221028263316BUILDSchemaOK6/16/2026 12:29:14 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
221028263315BUILDSchemaOK6/16/2026 12:29:14 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
221028263314BUILDSchemaOK6/16/2026 12:29:13 PM [NeighborTables.sql]: Neighbor and Match tables created
221028263313BUILDSchemaOK6/16/2026 12:29:13 PM [resolveTables.sql]: Resolve tables created
221028263312BUILDSchemaOK6/16/2026 12:29:12 PM [spPhoto.sql]: Photo procedures and functions created
221028263311BUILDSchemaOK6/16/2026 12:29:12 PM [galSpecTables.sql]: galSpec tables and related functions created
221028263310BUILDSchemaOK6/16/2026 12:29:11 PM [PhotoZTables.sql]: Photometric redshifts tables created
221028263309BUILDSchemaOK6/16/2026 12:29:11 PM [PhotoTables.sql]: Photo tables created
221028263308BUILDSchemaOK6/16/2026 12:29:10 PM [Versions.sql]: Versions table created
221028263307BUILDSchemaOK6/16/2026 12:29:10 PM [IndexMap.sql]: Index management tables and procedures built
221028263306BUILDSchemaOK6/16/2026 12:29:04 PM [MetadataTables.sql]: MetaData tables created
221028263305BUILDSchemaOK6/16/2026 12:29:03 PM [ConstantSupport.sql]: Constant support views and functions created
221028263304BUILDSchemaOK6/16/2026 12:29:00 PM [DataConstants.sql]: Constant tables created
221028263303BUILDSchemaOK6/16/2026 12:28:48 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221028263302BUILDSchemaOK6/16/2026 12:28:47 PMStarting schema creation for TEST_EBOS1 with partitioning=0
221028263301BUILDDatabaseOK6/16/2026 12:28:47 PMConfigured database TEST_EBOS1
221028263300BUILDDatabaseOK6/16/2026 12:28:46 PMCreated database TEST_EBOS1
221028263299BUILDDatabaseOK6/16/2026 12:27:01 PMStarting database creation
221028263298BUILDSTARTINGSTART6/16/2026 12:27:01 PMStarting DB build
221028253297CHECKFINISHINGDONE6/16/2026 12:26:39 PMFinished CSV checking
221028253296CHECKFile countOK6/16/2026 12:26:39 PMD:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1:Number of CSV files is 3
221028253295CHECKDir checkOK6/16/2026 12:26:39 PMD:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1:Checking directory
221028253294CHECKOpen debug file OK6/16/2026 12:26:39 PMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:File opened
221028253293CHECKCheck backup folOK6/16/2026 12:26:39 PMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:Folder exists
221028253292CHECKCheck rootOK6/16/2026 12:26:39 PMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:Found root directory
221028253291CHECKSTARTINGSTART6/16/2026 12:26:38 PMStarting CSV check