Log - Task #2207
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
220728093124PRELOADCSV loadOK6/12/2026 11:22:32 AMStarting File load
220728093123PRELOADSTARTINGSTART6/12/2026 11:22:32 AMStarting SQL Preload
220728083122BUILDFINISHINGDONE6/12/2026 11:22:32 AMFinished building DB
220728083121BUILDSchemaOK6/12/2026 11:22:32 AMCreated Spherical assembly in database TEST_ALLS1
220728083120BUILDSchemaOK6/12/2026 11:22:32 AM [spCosmology.sql]: Cosmology functions and procedures created
220728083119BUILDSchemaOK6/12/2026 11:22:31 AM [spCopyDbSubset]: spCopyDbSubset installed
220728083118BUILDSchemaOK6/12/2026 11:22:31 AM [spFinish.sql]: spFinish procedures created
220728083117BUILDSchemaOK6/12/2026 11:22:30 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
220728083116BUILDSchemaOK6/12/2026 11:22:29 AM [spValidate.sql]: Data validation procedures created
220728083115BUILDSchemaOK6/12/2026 11:22:28 AM [spSetValues.qsl]: Set values procedures created
220728083114BUILDSchemaOK6/12/2026 11:22:28 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
220728083113BUILDSchemaOK6/12/2026 11:22:27 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
220728083112BUILDSchemaOK6/12/2026 11:22:27 AM [spSQLSupport.sql]: SQL Support procs and functions created.
220728083111BUILDSchemaOK6/12/2026 11:22:26 AM [spDocSupport.sql]: DocSupport procs and functions created.
220728083110BUILDSchemaOK6/12/2026 11:22:26 AM [spTestQueries.sql]: Testing harness installed
220728083109BUILDSchemaOK6/12/2026 11:22:26 AM [spCheckDB.sql]: Database checking procs created
220728083108BUILDSchemaOK6/12/2026 11:22:25 AM [spRegion.sql]: Created functions and procedures for the Region package
220728083107BUILDSchemaOK6/12/2026 11:22:24 AM [spCoordinate.sql]: Coordinate related functions and procedures created
220728083106BUILDSchemaOK6/12/2026 11:22:23 AMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
220728083105BUILDSchemaOK6/12/2026 11:22:23 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
220728083104BUILDSchemaOK6/12/2026 11:22:21 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
220728083103BUILDSchemaOK6/12/2026 11:22:20 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]
220728083102BUILDSchemaOK6/12/2026 11:22:20 AMCreated Spherical assembly in database TEST_ALLS1
220728083101BUILDSchemaOK6/12/2026 11:22:16 AM [LvmTables.sql]: LVM tables created
220728083100BUILDSchemaOK6/12/2026 11:22:16 AMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
220728083099BUILDSchemaOK6/12/2026 11:22:13 AM [VacTables.sql]: VAC tables created
220728083098BUILDSchemaOK6/12/2026 11:22:12 AM [Views.sql]: Views created
220728083097BUILDSchemaOK6/12/2026 11:22:11 AMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
220728083096BUILDSchemaOK6/12/2026 11:22:11 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
220728083095BUILDSchemaOK6/12/2026 11:22:10 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
220728083094BUILDSchemaOK6/12/2026 11:22:10 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
220728083093BUILDSchemaOK6/12/2026 11:22:10 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
220728083092BUILDSchemaOK6/12/2026 11:22:09 AM [MastarTables.sql]: Mastar tables created
220728083091BUILDSchemaOK6/12/2026 11:22:09 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
220728083090BUILDSchemaOK6/12/2026 11:22:08 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
220728083089BUILDSchemaOK6/12/2026 11:22:07 AM [ApogeeTables.sql]: APOGEE tables created
220728083088BUILDSchemaOK6/12/2026 11:22:07 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
220728083087BUILDSchemaOK6/12/2026 11:22:06 AM [WindowTables.sql]: Window tables and related views created
220728083086BUILDSchemaOK6/12/2026 11:22:06 AM [RegionTables.sql]: Created tables for Region package
220728083085BUILDSchemaOK6/12/2026 11:22:06 AM [TilingTables.sql]: Tiling tables and related views created
220728083084BUILDSchemaOK6/12/2026 11:22:05 AM [spSpectro.sql]: Spectro functions/sps created
220728083083BUILDSchemaOK6/12/2026 11:22:04 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
220728083082BUILDSchemaOK6/12/2026 11:22:04 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
220728083081BUILDSchemaOK6/12/2026 11:22:03 AM [NeighborTables.sql]: Neighbor and Match tables created
220728083080BUILDSchemaOK6/12/2026 11:22:03 AM [resolveTables.sql]: Resolve tables created
220728083079BUILDSchemaOK6/12/2026 11:22:02 AM [spPhoto.sql]: Photo procedures and functions created
220728083078BUILDSchemaOK6/12/2026 11:22:02 AM [galSpecTables.sql]: galSpec tables and related functions created
220728083077BUILDSchemaOK6/12/2026 11:22:01 AM [PhotoZTables.sql]: Photometric redshifts tables created
220728083076BUILDSchemaOK6/12/2026 11:22:01 AM [PhotoTables.sql]: Photo tables created
220728083075BUILDSchemaOK6/12/2026 11:22:00 AM [Versions.sql]: Versions table created
220728083074BUILDSchemaOK6/12/2026 11:22:00 AM [IndexMap.sql]: Index management tables and procedures built
220728083073BUILDSchemaOK6/12/2026 11:21:54 AM [MetadataTables.sql]: MetaData tables created
220728083072BUILDSchemaOK6/12/2026 11:21:53 AM [ConstantSupport.sql]: Constant support views and functions created
220728083071BUILDSchemaOK6/12/2026 11:21:50 AM [DataConstants.sql]: Constant tables created
220728083070BUILDSchemaOK6/12/2026 11:21:38 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
220728083069BUILDSchemaOK6/12/2026 11:21:37 AMStarting schema creation for TEST_ALLS1 with partitioning=0
220728083068BUILDDatabaseOK6/12/2026 11:21:37 AMConfigured database TEST_ALLS1
220728083067BUILDDatabaseOK6/12/2026 11:21:36 AMCreated database TEST_ALLS1
220728083066BUILDDatabaseOK6/12/2026 11:20:01 AMStarting database creation
220728083065BUILDSTARTINGSTART6/12/2026 11:20:01 AMStarting DB build
220728073064CHECKFINISHINGDONE6/12/2026 11:19:56 AMFinished CSV checking
220728073063CHECKFile countOK6/12/2026 11:19:56 AMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Number of CSV files is 2
220728073062CHECKDir checkOK6/12/2026 11:19:56 AMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Checking directory
220728073061CHECKOpen debug file OK6/12/2026 11:19:56 AMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:File opened
220728073060CHECKCheck backup folOK6/12/2026 11:19:56 AMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Folder exists
220728073059CHECKCheck rootOK6/12/2026 11:19:56 AMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Found root directory
220728073058CHECKSTARTINGSTART6/12/2026 11:19:55 AMStarting CSV check