Log - Task #2244
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
224429845972PRELOADCSV loadOK7/22/2026 12:33:12 PMStarting File load
224429845971PRELOADSTARTINGSTART7/22/2026 12:33:12 PMStarting SQL Preload
224429835970BUILDFINISHINGDONE7/22/2026 12:33:12 PMFinished building DB
224429835969BUILDSchemaOK7/22/2026 12:33:12 PMCreated Spherical assembly in database TEST_DR201
224429835968BUILDSchemaOK7/22/2026 12:33:12 PM [spCosmology.sql]: Cosmology functions and procedures created
224429835967BUILDSchemaOK7/22/2026 12:33:11 PM [spCopyDbSubset]: spCopyDbSubset installed
224429835966BUILDSchemaOK7/22/2026 12:33:11 PM [spFinish.sql]: spFinish procedures created
224429835965BUILDSchemaOK7/22/2026 12:33:10 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
224429835964BUILDSchemaOK7/22/2026 12:33:09 PM [spValidate.sql]: Data validation procedures created
224429835963BUILDSchemaOK7/22/2026 12:33:08 PM [spSetValues.qsl]: Set values procedures created
224429835962BUILDSchemaOK7/22/2026 12:33:08 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
224429835961BUILDSchemaOK7/22/2026 12:33:08 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
224429835960BUILDSchemaOK7/22/2026 12:33:07 PM [spSQLSupport.sql]: SQL Support procs and functions created.
224429835959BUILDSchemaOK7/22/2026 12:33:07 PM [spDocSupport.sql]: DocSupport procs and functions created.
224429835958BUILDSchemaOK7/22/2026 12:33:06 PM [spTestQueries.sql]: Testing harness installed
224429835957BUILDSchemaOK7/22/2026 12:33:06 PM [spCheckDB.sql]: Database checking procs created
224429835956BUILDSchemaOK7/22/2026 12:33:05 PM [spRegion.sql]: Created functions and procedures for the Region package
224429835955BUILDSchemaOK7/22/2026 12:33:05 PM [spCoordinate.sql]: Coordinate related functions and procedures created
224429835954BUILDSchemaOK7/22/2026 12:33:04 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
224429835953BUILDSchemaOK7/22/2026 12:33:03 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
224429835952BUILDSchemaOK7/22/2026 12:33:02 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
224429835951BUILDSchemaOK7/22/2026 12:33:01 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]
224429835950BUILDSchemaOK7/22/2026 12:33:00 PMCreated Spherical assembly in database TEST_DR201
224429835949BUILDSchemaOK7/22/2026 12:32:57 PM [LvmTables.sql]: LVM tables created
224429835948BUILDSchemaOK7/22/2026 12:32:57 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
224429835947BUILDSchemaOK7/22/2026 12:32:54 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 '*'. 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 '*'. [VacTables.sql]: VAC tables created
224429835946BUILDSchemaOK7/22/2026 12:32:53 PM [Views.sql]: Views created
224429835945BUILDSchemaOK7/22/2026 12:32:52 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
224429835944BUILDSchemaOK7/22/2026 12:32:52 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
224429835943BUILDSchemaOK7/22/2026 12:32:51 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
224429835942BUILDSchemaOK7/22/2026 12:32:51 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
224429835941BUILDSchemaOK7/22/2026 12:32:51 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
224429835940BUILDSchemaOK7/22/2026 12:32:50 PM [MastarTables.sql]: Mastar tables created
224429835939BUILDSchemaOK7/22/2026 12:32:50 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
224429835938BUILDSchemaOK7/22/2026 12:32:49 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
224429835937BUILDSchemaOK7/22/2026 12:32:48 PM [ApogeeTables.sql]: APOGEE tables created
224429835936BUILDSchemaOK7/22/2026 12:32:48 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
224429835935BUILDSchemaOK7/22/2026 12:32:47 PM [WindowTables.sql]: Window tables and related views created
224429835934BUILDSchemaOK7/22/2026 12:32:47 PM [RegionTables.sql]: Created tables for Region package
224429835933BUILDSchemaOK7/22/2026 12:32:47 PM [TilingTables.sql]: Tiling tables and related views created
224429835932BUILDSchemaOK7/22/2026 12:32:46 PM [spSpectro.sql]: Spectro functions/sps created
224429835931BUILDSchemaOK7/22/2026 12:32:45 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
224429835930BUILDSchemaOK7/22/2026 12:32:45 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
224429835929BUILDSchemaOK7/22/2026 12:32:44 PM [NeighborTables.sql]: Neighbor and Match tables created
224429835928BUILDSchemaOK7/22/2026 12:32:44 PM [resolveTables.sql]: Resolve tables created
224429835927BUILDSchemaOK7/22/2026 12:32:44 PM [spPhoto.sql]: Photo procedures and functions created
224429835926BUILDSchemaOK7/22/2026 12:32:43 PM [galSpecTables.sql]: galSpec tables and related functions created
224429835925BUILDSchemaOK7/22/2026 12:32:43 PM [PhotoZTables.sql]: Photometric redshifts tables created
224429835924BUILDSchemaOK7/22/2026 12:32:43 PM [PhotoTables.sql]: Photo tables created
224429835923BUILDSchemaOK7/22/2026 12:32:42 PM [Versions.sql]: Versions table created
224429835922BUILDSchemaOK7/22/2026 12:32:42 PM [IndexMap.sql]: Index management tables and procedures built
224429835921BUILDSchemaOK7/22/2026 12:32:35 PM [MetadataTables.sql]: MetaData tables created
224429835920BUILDSchemaOK7/22/2026 12:32:34 PM [ConstantSupport.sql]: Constant support views and functions created
224429835919BUILDSchemaOK7/22/2026 12:32:32 PM [DataConstants.sql]: Constant tables created
224429835918BUILDSchemaOK7/22/2026 12:32:20 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
224429835917BUILDSchemaOK7/22/2026 12:32:19 PMStarting schema creation for TEST_DR201 with partitioning=0
224429835916BUILDDatabaseOK7/22/2026 12:32:19 PMConfigured database TEST_DR201
224429835915BUILDDatabaseOK7/22/2026 12:32:19 PMCreated database TEST_DR201
224429835914BUILDDatabaseOK7/22/2026 12:31:01 PMStarting database creation
224429835913BUILDSTARTINGSTART7/22/2026 12:31:00 PMStarting DB build
224429825912CHECKFINISHINGDONE7/22/2026 12:30:22 PMFinished CSV checking
224429825911CHECKFile countOK7/22/2026 12:30:22 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
224429825910CHECKDir checkOK7/22/2026 12:30:22 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
224429825909CHECKOpen debug file OK7/22/2026 12:30:22 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
224429825908CHECKCheck backup folOK7/22/2026 12:30:22 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
224429825907CHECKCheck rootOK7/22/2026 12:30:22 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
224429825906CHECKSTARTINGSTART7/22/2026 12:30:21 PMStarting CSV check