Log - Task #2252
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225230226605VALIDATEUnique key testOK7/23/2026 2:38:31 PMUnique key test passed on fermi_blazar(sdss_id)
225230226604VALIDATEUnique key testOK7/23/2026 2:38:31 PMUnique key test passed on eROSITA_CVs(sdss_id)
225230226603VALIDATEUnique key testOK7/23/2026 2:38:31 PMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
225230226602VALIDATEUnique key testOK7/23/2026 2:38:30 PMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
225230226601VALIDATEUnique key testOK7/23/2026 2:38:30 PMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
225230226600VALIDATEUnique key testOK7/23/2026 2:38:30 PMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
225230226599VALIDATEUnique key testOK7/23/2026 2:38:29 PMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
225230226598VALIDATEUnique key testOK7/23/2026 2:38:29 PMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
225230226597VALIDATEUnique key testOK7/23/2026 2:38:29 PMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
225230226596VALIDATEUnique key testOK7/23/2026 2:38:29 PMUnique key test passed on DR20Q_prop(objid)
225230226595VALIDATEUnique key testOK7/23/2026 2:38:27 PMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
225230226594VALIDATEUnique key testOK7/23/2026 2:38:26 PMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
225230226593VALIDATEUnique key testERROR7/23/2026 2:38:25 PMUnique key test on da_dwd_rvs(exposure_num) failed 93 times.
225230226592VALIDATEUnique key testOK7/23/2026 2:38:25 PMUnique key test passed on da_dwd_candidates(sdss_id)
225230226591VALIDATEUnique key testOK7/23/2026 2:38:25 PMUnique key test passed on boss_vi_results(sdss_id)
225230226590VALIDATEUnique key testOK7/23/2026 2:38:24 PMUnique key test passed on boss_occam_member(sdss_id)
225230226589VALIDATEUnique key testOK7/23/2026 2:38:24 PMUnique key test passed on boss_occam_cluster(name)
225230226588VALIDATEspValidateDR20VAOK7/23/2026 2:38:24 PMPK_boss_ISM_NaI_absorption created
225230226587VALIDATEspValidateDR20VAOK7/23/2026 2:38:03 PMPK_boss_clam_params created
225230226586VALIDATEspValidateDR20VAOK7/23/2026 2:37:45 PMPK_boss_clam_lite created
225230226585VALIDATEspValidateDR20VAOK7/23/2026 2:37:30 PMspValidateDR20VACs called
225230226584VALIDATESTARTINGSTART7/23/2026 2:37:30 PMValidating dr20vacs database 1
225230216583PRELOADFINISHINGDONE7/23/2026 2:37:30 PMFinished SQL preload
225230216582PRELOADSet valuesOK7/23/2026 2:37:30 PMloadVersion updated
225230216581PRELOADSet valuesOK7/23/2026 2:37:30 PMSetting loadVersion
225230216580PRELOADCSV loadOK7/23/2026 2:37:30 PMAll rows have been loaded
225230216579PRELOADCSV loadOK7/23/2026 2:37:30 PMAll files are loaded
225230216578PRELOADCSV loadOK7/23/2026 2:37:30 PMFinished File load
225230216577PRELOADCSV loadOK7/23/2026 2:28:06 PMStarting File load
225230216576PRELOADSTARTINGSTART7/23/2026 2:28:06 PMStarting SQL Preload
225230206575BUILDFINISHINGDONE7/23/2026 2:28:06 PMFinished building DB
225230206574BUILDSchemaOK7/23/2026 2:28:06 PMCreated Spherical assembly in database TEST_DR201
225230206573BUILDSchemaOK7/23/2026 2:28:06 PM [spCosmology.sql]: Cosmology functions and procedures created
225230206572BUILDSchemaOK7/23/2026 2:28:05 PM [spCopyDbSubset]: spCopyDbSubset installed
225230206571BUILDSchemaOK7/23/2026 2:28:05 PM [spFinish.sql]: spFinish procedures created
225230206570BUILDSchemaOK7/23/2026 2:28:04 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
225230206569BUILDSchemaOK7/23/2026 2:28:03 PM [spValidate.sql]: Data validation procedures created
225230206568BUILDSchemaOK7/23/2026 2:28:03 PM [spSetValues.qsl]: Set values procedures created
225230206567BUILDSchemaOK7/23/2026 2:28:02 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
225230206566BUILDSchemaOK7/23/2026 2:28:02 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225230206565BUILDSchemaOK7/23/2026 2:28:01 PM [spSQLSupport.sql]: SQL Support procs and functions created.
225230206564BUILDSchemaOK7/23/2026 2:28:01 PM [spDocSupport.sql]: DocSupport procs and functions created.
225230206563BUILDSchemaOK7/23/2026 2:28:01 PM [spTestQueries.sql]: Testing harness installed
225230206562BUILDSchemaOK7/23/2026 2:28:00 PM [spCheckDB.sql]: Database checking procs created
225230206561BUILDSchemaOK7/23/2026 2:28:00 PM [spRegion.sql]: Created functions and procedures for the Region package
225230206560BUILDSchemaOK7/23/2026 2:27:59 PM [spCoordinate.sql]: Coordinate related functions and procedures created
225230206559BUILDSchemaOK7/23/2026 2:27:58 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225230206558BUILDSchemaOK7/23/2026 2:27:58 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
225230206557BUILDSchemaOK7/23/2026 2:27:57 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225230206556BUILDSchemaOK7/23/2026 2:27:56 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]
225230206555BUILDSchemaOK7/23/2026 2:27:55 PMCreated Spherical assembly in database TEST_DR201
225230206554BUILDSchemaOK7/23/2026 2:27:52 PM [LvmTables.sql]: LVM tables created
225230206553BUILDSchemaOK7/23/2026 2:27:52 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225230206552BUILDSchemaOK7/23/2026 2:27: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 '*'. [VacTables.sql]: VAC tables created
225230206551BUILDSchemaOK7/23/2026 2:27:48 PM [Views.sql]: Views created
225230206550BUILDSchemaOK7/23/2026 2:27:47 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225230206549BUILDSchemaOK7/23/2026 2:27:47 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225230206548BUILDSchemaOK7/23/2026 2:27:47 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225230206547BUILDSchemaOK7/23/2026 2:27:46 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
225230206546BUILDSchemaOK7/23/2026 2:27:46 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225230206545BUILDSchemaOK7/23/2026 2:27:46 PM [MastarTables.sql]: Mastar tables created
225230206544BUILDSchemaOK7/23/2026 2:27:46 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
225230206543BUILDSchemaOK7/23/2026 2:27:45 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
225230206542BUILDSchemaOK7/23/2026 2:27:44 PM [ApogeeTables.sql]: APOGEE tables created
225230206541BUILDSchemaOK7/23/2026 2:27:44 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225230206540BUILDSchemaOK7/23/2026 2:27:43 PM [WindowTables.sql]: Window tables and related views created
225230206539BUILDSchemaOK7/23/2026 2:27:43 PM [RegionTables.sql]: Created tables for Region package
225230206538BUILDSchemaOK7/23/2026 2:27:43 PM [TilingTables.sql]: Tiling tables and related views created
225230206537BUILDSchemaOK7/23/2026 2:27:42 PM [spSpectro.sql]: Spectro functions/sps created
225230206536BUILDSchemaOK7/23/2026 2:27:41 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
225230206535BUILDSchemaOK7/23/2026 2:27:41 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
225230206534BUILDSchemaOK7/23/2026 2:27:40 PM [NeighborTables.sql]: Neighbor and Match tables created
225230206533BUILDSchemaOK7/23/2026 2:27:40 PM [resolveTables.sql]: Resolve tables created
225230206532BUILDSchemaOK7/23/2026 2:27:40 PM [spPhoto.sql]: Photo procedures and functions created
225230206531BUILDSchemaOK7/23/2026 2:27:39 PM [galSpecTables.sql]: galSpec tables and related functions created
225230206530BUILDSchemaOK7/23/2026 2:27:39 PM [PhotoZTables.sql]: Photometric redshifts tables created
225230206529BUILDSchemaOK7/23/2026 2:27:39 PM [PhotoTables.sql]: Photo tables created
225230206528BUILDSchemaOK7/23/2026 2:27:38 PM [Versions.sql]: Versions table created
225230206527BUILDSchemaOK7/23/2026 2:27:38 PM [IndexMap.sql]: Index management tables and procedures built
225230206526BUILDSchemaOK7/23/2026 2:27:31 PM [MetadataTables.sql]: MetaData tables created
225230206525BUILDSchemaOK7/23/2026 2:27:31 PM [ConstantSupport.sql]: Constant support views and functions created
225230206524BUILDSchemaOK7/23/2026 2:27:28 PM [DataConstants.sql]: Constant tables created
225230206523BUILDSchemaOK7/23/2026 2:27:17 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225230206522BUILDSchemaOK7/23/2026 2:27:15 PMStarting schema creation for TEST_DR201 with partitioning=0
225230206521BUILDDatabaseOK7/23/2026 2:27:15 PMConfigured database TEST_DR201
225230206520BUILDDatabaseOK7/23/2026 2:27:15 PMCreated database TEST_DR201
225230206519BUILDDatabaseOK7/23/2026 2:26:01 PMStarting database creation
225230206518BUILDSTARTINGSTART7/23/2026 2:26:00 PMStarting DB build
225230196517CHECKFINISHINGDONE7/23/2026 2:25:34 PMFinished CSV checking
225230196516CHECKFile countOK7/23/2026 2:25:33 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225230196515CHECKDir checkOK7/23/2026 2:25:33 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225230196514CHECKOpen debug file OK7/23/2026 2:25:33 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225230196513CHECKCheck backup folOK7/23/2026 2:25:33 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225230196512CHECKCheck rootOK7/23/2026 2:25:33 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225230196511CHECKSTARTINGSTART7/23/2026 2:25:33 PMStarting CSV check