Log - Task #2205
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
220528012990PRELOADCSV loadOK6/11/2026 1:13:33 PMStarting File load
220528012989PRELOADSTARTINGSTART6/11/2026 1:13:33 PMStarting SQL Preload
220528002988BUILDFINISHINGDONE6/11/2026 1:13:33 PMFinished building DB
220528002987BUILDSchemaOK6/11/2026 1:13:33 PMCreated Spherical assembly in database TEST_ALLS1
220528002986BUILDSchemaOK6/11/2026 1:13:33 PM [spCosmology.sql]: Cosmology functions and procedures created
220528002985BUILDSchemaOK6/11/2026 1:13:32 PM [spCopyDbSubset]: spCopyDbSubset installed
220528002984BUILDSchemaOK6/11/2026 1:13:32 PM [spFinish.sql]: spFinish procedures created
220528002983BUILDSchemaOK6/11/2026 1:13:31 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
220528002982BUILDSchemaOK6/11/2026 1:13:30 PM [spValidate.sql]: Data validation procedures created
220528002981BUILDSchemaOK6/11/2026 1:13:29 PM [spSetValues.qsl]: Set values procedures created
220528002980BUILDSchemaOK6/11/2026 1:13:29 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
220528002979BUILDSchemaOK6/11/2026 1:13:28 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
220528002978BUILDSchemaOK6/11/2026 1:13:28 PM [spSQLSupport.sql]: SQL Support procs and functions created.
220528002977BUILDSchemaOK6/11/2026 1:13:27 PM [spDocSupport.sql]: DocSupport procs and functions created.
220528002976BUILDSchemaOK6/11/2026 1:13:27 PM [spTestQueries.sql]: Testing harness installed
220528002975BUILDSchemaOK6/11/2026 1:13:27 PM [spCheckDB.sql]: Database checking procs created
220528002974BUILDSchemaOK6/11/2026 1:13:26 PM [spRegion.sql]: Created functions and procedures for the Region package
220528002973BUILDSchemaOK6/11/2026 1:13:25 PM [spCoordinate.sql]: Coordinate related functions and procedures created
220528002972BUILDSchemaOK6/11/2026 1:13:24 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
220528002971BUILDSchemaOK6/11/2026 1:13:24 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
220528002970BUILDSchemaOK6/11/2026 1:13:22 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
220528002969BUILDSchemaOK6/11/2026 1:13:22 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]
220528002968BUILDSchemaOK6/11/2026 1:13:21 PMCreated Spherical assembly in database TEST_ALLS1
220528002967BUILDSchemaOK6/11/2026 1:13:17 PM [LvmTables.sql]: LVM tables created
220528002966BUILDSchemaOK6/11/2026 1:13:17 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
220528002965BUILDSchemaOK6/11/2026 1:13:14 PM [VacTables.sql]: VAC tables created
220528002964BUILDSchemaOK6/11/2026 1:13:13 PM [Views.sql]: Views created
220528002963BUILDSchemaOK6/11/2026 1:13:12 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
220528002962BUILDSchemaOK6/11/2026 1:13:12 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
220528002961BUILDSchemaOK6/11/2026 1:13:11 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
220528002960BUILDSchemaOK6/11/2026 1:13:11 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
220528002959BUILDSchemaOK6/11/2026 1:13:11 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
220528002958BUILDSchemaOK6/11/2026 1:13:10 PM [MastarTables.sql]: Mastar tables created
220528002957BUILDSchemaOK6/11/2026 1:13:10 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
220528002956BUILDSchemaOK6/11/2026 1:13:09 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
220528002955BUILDSchemaOK6/11/2026 1:13:08 PM [ApogeeTables.sql]: APOGEE tables created
220528002954BUILDSchemaOK6/11/2026 1:13:07 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
220528002953BUILDSchemaOK6/11/2026 1:13:07 PM [WindowTables.sql]: Window tables and related views created
220528002952BUILDSchemaOK6/11/2026 1:13:07 PM [RegionTables.sql]: Created tables for Region package
220528002951BUILDSchemaOK6/11/2026 1:13:06 PM [TilingTables.sql]: Tiling tables and related views created
220528002950BUILDSchemaOK6/11/2026 1:13:06 PM [spSpectro.sql]: Spectro functions/sps created
220528002949BUILDSchemaOK6/11/2026 1:13:05 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
220528002948BUILDSchemaOK6/11/2026 1:13:04 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
220528002947BUILDSchemaOK6/11/2026 1:13:03 PM [NeighborTables.sql]: Neighbor and Match tables created
220528002946BUILDSchemaOK6/11/2026 1:13:03 PM [resolveTables.sql]: Resolve tables created
220528002945BUILDSchemaOK6/11/2026 1:13:03 PM [spPhoto.sql]: Photo procedures and functions created
220528002944BUILDSchemaOK6/11/2026 1:13:02 PM [galSpecTables.sql]: galSpec tables and related functions created
220528002943BUILDSchemaOK6/11/2026 1:13:02 PM [PhotoZTables.sql]: Photometric redshifts tables created
220528002942BUILDSchemaOK6/11/2026 1:13:01 PM [PhotoTables.sql]: Photo tables created
220528002941BUILDSchemaOK6/11/2026 1:13:00 PM [Versions.sql]: Versions table created
220528002940BUILDSchemaOK6/11/2026 1:13:00 PM [IndexMap.sql]: Index management tables and procedures built
220528002939BUILDSchemaOK6/11/2026 1:12:54 PM [MetadataTables.sql]: MetaData tables created
220528002938BUILDSchemaOK6/11/2026 1:12:53 PM [ConstantSupport.sql]: Constant support views and functions created
220528002937BUILDSchemaOK6/11/2026 1:12:50 PM [DataConstants.sql]: Constant tables created
220528002936BUILDSchemaOK6/11/2026 1:12:39 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
220528002935BUILDSchemaOK6/11/2026 1:12:37 PMStarting schema creation for TEST_ALLS1 with partitioning=0
220528002934BUILDDatabaseOK6/11/2026 1:12:37 PMConfigured database TEST_ALLS1
220528002933BUILDDatabaseOK6/11/2026 1:12:37 PMCreated database TEST_ALLS1
220528002932BUILDDatabaseOK6/11/2026 1:11:01 PMStarting database creation
220528002931BUILDSTARTINGSTART6/11/2026 1:11:01 PMStarting DB build
220527992930CHECKFINISHINGDONE6/11/2026 1:09:38 PMFinished CSV checking
220527992929CHECKFile countOK6/11/2026 1:09:38 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Number of CSV files is 2
220527992928CHECKDir checkOK6/11/2026 1:09:38 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Checking directory
220527992927CHECKOpen debug file OK6/11/2026 1:09:38 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:File opened
220527992926CHECKCheck backup folOK6/11/2026 1:09:38 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Folder exists
220527992925CHECKCheck rootOK6/11/2026 1:09:38 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Found root directory
220527992924CHECKSTARTINGSTART6/11/2026 1:09:38 PMStarting CSV check