Log - Task #2220
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
222028944176VALIDATEUnique key testOK7/6/2026 3:50:02 PMUnique key test passed on mwm_boss_allvisit(spectrum_PK)
222028944175VALIDATEUnique key testOK7/6/2026 3:50:00 PMUnique key test passed on mwm_boss_allstar(spectrum_PK)
222028944174VALIDATEUnique key testOK7/6/2026 3:49:58 PMUnique key test passed on mwm_apogee_allvisit(spectrum_PK)
222028944173VALIDATEUnique key testOK7/6/2026 3:49:58 PMUnique key test passed on mwm_apogee_allstar(spectrum_PK)
222028944172VALIDATEUnique key testOK7/6/2026 3:49:58 PMUnique key test passed on m_dwarf_type_boss_visit(spectrum_PK)
222028944171VALIDATEUnique key testOK7/6/2026 3:49:55 PMUnique key test passed on m_dwarf_type_boss_star(spectrum_PK)
222028944170VALIDATEUnique key testOK7/6/2026 3:49:54 PMUnique key test passed on lite_all_star(spectrum_PK)
222028944169VALIDATEUnique key testOK7/6/2026 3:49:54 PMUnique key test passed on line_forest_boss_visit(spectrum_PK)
222028944168VALIDATEUnique key testOK7/6/2026 3:49:49 PMUnique key test passed on line_forest_boss_star(spectrum_PK)
222028944167VALIDATEUnique key testOK7/6/2026 3:49:45 PMUnique key test passed on corv_boss_visit(spectrum_PK)
222028944166VALIDATEUnique key testOK7/6/2026 3:49:41 PMUnique key test passed on boss_net_boss_visit(spectrum_PK)
222028944165VALIDATEUnique key testOK7/6/2026 3:49:37 PMUnique key test passed on boss_net_boss_star(spectrum_PK)
222028944164VALIDATEUnique key testOK7/6/2026 3:49:35 PMUnique key test passed on astro_nn_dist_apogee_star(spectrum_PK)
222028944163VALIDATEUnique key testOK7/6/2026 3:49:35 PMUnique key test passed on astro_nn_apogee_visit(spectrum_PK)
222028944162VALIDATEUnique key testOK7/6/2026 3:49:35 PMUnique key test passed on astro_nn_apogee_star(spectrum_PK)
222028944161VALIDATEUnique key testOK7/6/2026 3:49:35 PMUnique key test passed on aspcap_apogee_star(spectrum_PK)
222028944160VALIDATEUnique key testOK7/6/2026 3:49:35 PMUnique key test passed on apogee_net_apogee_star(spectrum_PK)
222028944159VALIDATEspValidateAstraOK7/6/2026 3:49:34 PMspValidateAstra called
222028944158VALIDATESTARTINGSTART7/6/2026 3:49:34 PMValidating astra database 1
222028934157PRELOADFINISHINGDONE7/6/2026 3:49:34 PMFinished SQL preload
222028934156PRELOADSet valuesOK7/6/2026 3:49:34 PMloadVersion updated
222028934155PRELOADSet valuesOK7/6/2026 3:49:34 PMSetting loadVersion
222028934154PRELOADCSV loadOK7/6/2026 3:49:34 PMAll rows have been loaded
222028934153PRELOADCSV loadOK7/6/2026 3:49:34 PMAll files are loaded
222028934152PRELOADCSV loadOK7/6/2026 3:49:34 PMFinished File load
222028934151PRELOADCSV loadOK7/6/2026 2:09:11 PMStarting File load
222028934150PRELOADSTARTINGSTART7/6/2026 2:09:11 PMStarting SQL Preload
222028924149BUILDFINISHINGDONE7/6/2026 2:09:11 PMFinished building DB
222028924148BUILDSchemaOK7/6/2026 2:09:11 PMCreated Spherical assembly in database TEST_ASTR1
222028924147BUILDSchemaOK7/6/2026 2:09:11 PM [spCosmology.sql]: Cosmology functions and procedures created
222028924146BUILDSchemaOK7/6/2026 2:09:10 PM [spCopyDbSubset]: spCopyDbSubset installed
222028924145BUILDSchemaOK7/6/2026 2:09:10 PM [spFinish.sql]: spFinish procedures created
222028924144BUILDSchemaOK7/6/2026 2:09:09 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
222028924143BUILDSchemaOK7/6/2026 2:09:08 PM [spValidate.sql]: Data validation procedures created
222028924142BUILDSchemaOK7/6/2026 2:09:07 PM [spSetValues.qsl]: Set values procedures created
222028924141BUILDSchemaOK7/6/2026 2:09:07 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
222028924140BUILDSchemaOK7/6/2026 2:09:07 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
222028924139BUILDSchemaOK7/6/2026 2:09:06 PM [spSQLSupport.sql]: SQL Support procs and functions created.
222028924138BUILDSchemaOK7/6/2026 2:09:06 PM [spDocSupport.sql]: DocSupport procs and functions created.
222028924137BUILDSchemaOK7/6/2026 2:09:05 PM [spTestQueries.sql]: Testing harness installed
222028924136BUILDSchemaOK7/6/2026 2:09:05 PM [spCheckDB.sql]: Database checking procs created
222028924135BUILDSchemaOK7/6/2026 2:09:04 PM [spRegion.sql]: Created functions and procedures for the Region package
222028924134BUILDSchemaOK7/6/2026 2:09:04 PM [spCoordinate.sql]: Coordinate related functions and procedures created
222028924133BUILDSchemaOK7/6/2026 2:09:03 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
222028924132BUILDSchemaOK7/6/2026 2:09:02 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
222028924131BUILDSchemaOK7/6/2026 2:09:01 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
222028924130BUILDSchemaOK7/6/2026 2:09:00 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]
222028924129BUILDSchemaOK7/6/2026 2:08:59 PMCreated Spherical assembly in database TEST_ASTR1
222028924128BUILDSchemaOK7/6/2026 2:08:55 PM [LvmTables.sql]: LVM tables created
222028924127BUILDSchemaOK7/6/2026 2:08:55 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
222028924126BUILDSchemaOK7/6/2026 2:08:52 PM [VacTables.sql]: VAC tables created
222028924125BUILDSchemaOK7/6/2026 2:08:51 PM [Views.sql]: Views created
222028924124BUILDSchemaOK7/6/2026 2:08:50 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
222028924123BUILDSchemaOK7/6/2026 2:08:50 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
222028924122BUILDSchemaOK7/6/2026 2:08:50 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
222028924121BUILDSchemaOK7/6/2026 2:08:49 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
222028924120BUILDSchemaOK7/6/2026 2:08:49 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
222028924119BUILDSchemaOK7/6/2026 2:08:49 PM [MastarTables.sql]: Mastar tables created
222028924118BUILDSchemaOK7/6/2026 2:08:48 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
222028924117BUILDSchemaOK7/6/2026 2:08:48 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
222028924116BUILDSchemaOK7/6/2026 2:08:46 PM [ApogeeTables.sql]: APOGEE tables created
222028924115BUILDSchemaOK7/6/2026 2:08:46 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
222028924114BUILDSchemaOK7/6/2026 2:08:45 PM [WindowTables.sql]: Window tables and related views created
222028924113BUILDSchemaOK7/6/2026 2:08:45 PM [RegionTables.sql]: Created tables for Region package
222028924112BUILDSchemaOK7/6/2026 2:08:45 PM [TilingTables.sql]: Tiling tables and related views created
222028924111BUILDSchemaOK7/6/2026 2:08:44 PM [spSpectro.sql]: Spectro functions/sps created
222028924110BUILDSchemaOK7/6/2026 2:08:43 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
222028924109BUILDSchemaOK7/6/2026 2:08:43 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
222028924108BUILDSchemaOK7/6/2026 2:08:42 PM [NeighborTables.sql]: Neighbor and Match tables created
222028924107BUILDSchemaOK7/6/2026 2:08:42 PM [resolveTables.sql]: Resolve tables created
222028924106BUILDSchemaOK7/6/2026 2:08:42 PM [spPhoto.sql]: Photo procedures and functions created
222028924105BUILDSchemaOK7/6/2026 2:08:41 PM [galSpecTables.sql]: galSpec tables and related functions created
222028924104BUILDSchemaOK7/6/2026 2:08:41 PM [PhotoZTables.sql]: Photometric redshifts tables created
222028924103BUILDSchemaOK7/6/2026 2:08:40 PM [PhotoTables.sql]: Photo tables created
222028924102BUILDSchemaOK7/6/2026 2:08:40 PM [Versions.sql]: Versions table created
222028924101BUILDSchemaOK7/6/2026 2:08:39 PM [IndexMap.sql]: Index management tables and procedures built
222028924100BUILDSchemaOK7/6/2026 2:08:33 PM [MetadataTables.sql]: MetaData tables created
222028924099BUILDSchemaOK7/6/2026 2:08:32 PM [ConstantSupport.sql]: Constant support views and functions created
222028924098BUILDSchemaOK7/6/2026 2:08:30 PM [DataConstants.sql]: Constant tables created
222028924097BUILDSchemaOK7/6/2026 2:08:18 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
222028924096BUILDSchemaOK7/6/2026 2:08:17 PMStarting schema creation for TEST_ASTR1 with partitioning=0
222028924095BUILDDatabaseOK7/6/2026 2:08:17 PMConfigured database TEST_ASTR1
222028924094BUILDDatabaseOK7/6/2026 2:08:17 PMCreated database TEST_ASTR1
222028924093BUILDDatabaseOK7/6/2026 2:06:01 PMStarting database creation
222028924092BUILDSTARTINGSTART7/6/2026 2:06:01 PMStarting DB build
222028914091CHECKFINISHINGDONE7/6/2026 2:05:46 PMFinished CSV checking
222028914090CHECKFile countOK7/6/2026 2:05:46 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
222028914089CHECKDir checkOK7/6/2026 2:05:46 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
222028914088CHECKOpen debug file OK7/6/2026 2:05:46 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
222028914087CHECKCheck backup folOK7/6/2026 2:05:46 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
222028914086CHECKCheck rootOK7/6/2026 2:05:46 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
222028914085CHECKSTARTINGSTART7/6/2026 2:05:45 PMStarting CSV check