Log - Task #2206
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
220628053057PRELOADCSV loadOK6/11/2026 3:39:35 PMStarting File load
220628053056PRELOADSTARTINGSTART6/11/2026 3:39:35 PMStarting SQL Preload
220628043055BUILDFINISHINGDONE6/11/2026 3:39:35 PMFinished building DB
220628043054BUILDSchemaOK6/11/2026 3:39:35 PMCreated Spherical assembly in database TEST_ALLS1
220628043053BUILDSchemaOK6/11/2026 3:39:35 PM [spCosmology.sql]: Cosmology functions and procedures created
220628043052BUILDSchemaOK6/11/2026 3:39:34 PM [spCopyDbSubset]: spCopyDbSubset installed
220628043051BUILDSchemaOK6/11/2026 3:39:34 PM [spFinish.sql]: spFinish procedures created
220628043050BUILDSchemaOK6/11/2026 3:39:33 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
220628043049BUILDSchemaOK6/11/2026 3:39:32 PM [spValidate.sql]: Data validation procedures created
220628043048BUILDSchemaOK6/11/2026 3:39:31 PM [spSetValues.qsl]: Set values procedures created
220628043047BUILDSchemaOK6/11/2026 3:39:31 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
220628043046BUILDSchemaOK6/11/2026 3:39:31 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
220628043045BUILDSchemaOK6/11/2026 3:39:30 PM [spSQLSupport.sql]: SQL Support procs and functions created.
220628043044BUILDSchemaOK6/11/2026 3:39:30 PM [spDocSupport.sql]: DocSupport procs and functions created.
220628043043BUILDSchemaOK6/11/2026 3:39:29 PM [spTestQueries.sql]: Testing harness installed
220628043042BUILDSchemaOK6/11/2026 3:39:29 PM [spCheckDB.sql]: Database checking procs created
220628043041BUILDSchemaOK6/11/2026 3:39:28 PM [spRegion.sql]: Created functions and procedures for the Region package
220628043040BUILDSchemaOK6/11/2026 3:39:27 PM [spCoordinate.sql]: Coordinate related functions and procedures created
220628043039BUILDSchemaOK6/11/2026 3:39:26 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
220628043038BUILDSchemaOK6/11/2026 3:39:26 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
220628043037BUILDSchemaOK6/11/2026 3:39:24 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
220628043036BUILDSchemaOK6/11/2026 3:39:23 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]
220628043035BUILDSchemaOK6/11/2026 3:39:22 PMCreated Spherical assembly in database TEST_ALLS1
220628043034BUILDSchemaOK6/11/2026 3:39:19 PM [LvmTables.sql]: LVM tables created
220628043033BUILDSchemaOK6/11/2026 3:39:19 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
220628043032BUILDSchemaOK6/11/2026 3:39:16 PM [VacTables.sql]: VAC tables created
220628043031BUILDSchemaOK6/11/2026 3:39:15 PM [Views.sql]: Views created
220628043030BUILDSchemaOK6/11/2026 3:39:14 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
220628043029BUILDSchemaOK6/11/2026 3:39:14 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
220628043028BUILDSchemaOK6/11/2026 3:39:14 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
220628043027BUILDSchemaOK6/11/2026 3:39:13 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
220628043026BUILDSchemaOK6/11/2026 3:39:13 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
220628043025BUILDSchemaOK6/11/2026 3:39:13 PM [MastarTables.sql]: Mastar tables created
220628043024BUILDSchemaOK6/11/2026 3:39:12 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
220628043023BUILDSchemaOK6/11/2026 3:39:11 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
220628043022BUILDSchemaOK6/11/2026 3:39:10 PM [ApogeeTables.sql]: APOGEE tables created
220628043021BUILDSchemaOK6/11/2026 3:39:10 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
220628043020BUILDSchemaOK6/11/2026 3:39:09 PM [WindowTables.sql]: Window tables and related views created
220628043019BUILDSchemaOK6/11/2026 3:39:09 PM [RegionTables.sql]: Created tables for Region package
220628043018BUILDSchemaOK6/11/2026 3:39:08 PM [TilingTables.sql]: Tiling tables and related views created
220628043017BUILDSchemaOK6/11/2026 3:39:08 PM [spSpectro.sql]: Spectro functions/sps created
220628043016BUILDSchemaOK6/11/2026 3:39:07 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
220628043015BUILDSchemaOK6/11/2026 3:39:07 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
220628043014BUILDSchemaOK6/11/2026 3:39:06 PM [NeighborTables.sql]: Neighbor and Match tables created
220628043013BUILDSchemaOK6/11/2026 3:39:06 PM [resolveTables.sql]: Resolve tables created
220628043012BUILDSchemaOK6/11/2026 3:39:05 PM [spPhoto.sql]: Photo procedures and functions created
220628043011BUILDSchemaOK6/11/2026 3:39:05 PM [galSpecTables.sql]: galSpec tables and related functions created
220628043010BUILDSchemaOK6/11/2026 3:39:04 PM [PhotoZTables.sql]: Photometric redshifts tables created
220628043009BUILDSchemaOK6/11/2026 3:39:04 PM [PhotoTables.sql]: Photo tables created
220628043008BUILDSchemaOK6/11/2026 3:39:03 PM [Versions.sql]: Versions table created
220628043007BUILDSchemaOK6/11/2026 3:39:03 PM [IndexMap.sql]: Index management tables and procedures built
220628043006BUILDSchemaOK6/11/2026 3:38:57 PM [MetadataTables.sql]: MetaData tables created
220628043005BUILDSchemaOK6/11/2026 3:38:56 PM [ConstantSupport.sql]: Constant support views and functions created
220628043004BUILDSchemaOK6/11/2026 3:38:53 PM [DataConstants.sql]: Constant tables created
220628043003BUILDSchemaOK6/11/2026 3:38:41 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
220628043002BUILDSchemaOK6/11/2026 3:38:40 PMStarting schema creation for TEST_ALLS1 with partitioning=0
220628043001BUILDDatabaseOK6/11/2026 3:38:40 PMConfigured database TEST_ALLS1
220628043000BUILDDatabaseOK6/11/2026 3:38:40 PMCreated database TEST_ALLS1
220628042999BUILDDatabaseOK6/11/2026 3:37:01 PMStarting database creation
220628042998BUILDSTARTINGSTART6/11/2026 3:37:01 PMStarting DB build
220628032997CHECKFINISHINGDONE6/11/2026 3:36:29 PMFinished CSV checking
220628032996CHECKFile countOK6/11/2026 3:36:29 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Number of CSV files is 2
220628032995CHECKDir checkOK6/11/2026 3:36:28 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Checking directory
220628032994CHECKOpen debug file OK6/11/2026 3:36:28 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:File opened
220628032993CHECKCheck backup folOK6/11/2026 3:36:28 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Folder exists
220628032992CHECKCheck rootOK6/11/2026 3:36:28 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Found root directory
220628032991CHECKSTARTINGSTART6/11/2026 3:36:28 PMStarting CSV check