Log - Task #2261
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
226131007612CLEANUPFINISHINGDONE7/24/2026 12:53:45 PMDeleted db TEST_DR201
226131007611CLEANUPSTARTINGSTART7/24/2026 12:53:44 PMStarting cleanup
226130987609PUBLISHFINISHINGDONE7/24/2026 12:53:44 PMPublished DR20 VACs dr20vacs from: sdss4c.TEST_DR201 to: sdss4c.BESTTEST
226130987608PUBLISHspPublishDR20VACABORTING7/24/2026 12:53:44 PMPublished DR20 VAC Tables
226130987607PUBLISHspPublishDR20VACOK7/24/2026 12:53:00 PMStarting spPublishDR20VACs
226130987605PUBLISHAttachOK7/24/2026 12:53:00 PMSuccessfully attached sdss4c.TEST_DR201 in file: d:\sql_db\TEST_DR201_Data.MDF
226130987603PUBLISHSTARTINGSTART7/24/2026 12:53:00 PMPublishing dr20vacs sdss4c.TEST_DR201 to sdss4c.BESTTEST
226130977602DETACHFINISHINGDONE7/24/2026 12:52:59 PMDetached Database TEST_DR201
226130977601DETACHSTARTINGSTART7/24/2026 12:52:58 PMStarting DB detach
226130967600BACKUPFINISHINGDONE7/24/2026 12:52:58 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
226130967599BACKUPBackupOK7/24/2026 12:52:58 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
226130967598BACKUPCheckpointOK7/24/2026 12:52:50 PMCheckpoint done
226130967597BACKUPShrinkDBOK7/24/2026 12:52:50 PMShrink DB done
226130967596BACKUPCheckpointOK7/24/2026 12:52:49 PMCheckpoint done
226130967595BACKUPSTARTINGSTART7/24/2026 12:52:47 PMBacking up dr20vacs database 1 to \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
226130957594VALIDATEFINISHINGDONE7/24/2026 12:52:47 PMValidated DR20 VACs 1
226130957593VALIDATEspValidateDR20VAOK7/24/2026 12:52:47 PMDR20 VAC tables validated in 63.794 seconds
226130957592VALIDATEUnique key testOK7/24/2026 12:52:47 PMUnique key test passed on yso_ob_kin(gaia_dr3_source_id)
226130957591VALIDATEUnique key testOK7/24/2026 12:52:47 PMUnique key test passed on qms_hg_h_hb_indices(catalogid)
226130957590VALIDATEUnique key testOK7/24/2026 12:52:47 PMUnique key test passed on qms_hg_index_diagram(catalogid)
226130957589VALIDATEUnique key testOK7/24/2026 12:52:46 PMUnique key test passed on payne4GAIN_summary(sdssid)
226130957588VALIDATEUnique key testOK7/24/2026 12:52:46 PMUnique key test passed on minesweeper(sdssid)
226130957587VALIDATEUnique key testOK7/24/2026 12:52:45 PMUnique key test passed on mdwarf_contin_summary(spectrum_pk)
226130957586VALIDATEUnique key testOK7/24/2026 12:52:43 PMUnique key test passed on mdwarf_active_params(sdssid)
226130957585VALIDATEUnique key testOK7/24/2026 12:52:43 PMUnique key test passed on gyro_age_dwarf(sdss_id)
226130957584VALIDATEUnique key testOK7/24/2026 12:52:42 PMUnique key test passed on grav_pot_16(ids)
226130957583VALIDATEUnique key testOK7/24/2026 12:52:41 PMUnique key test passed on fermi_blazar(sdss_id)
226130957582VALIDATEUnique key testOK7/24/2026 12:52:41 PMUnique key test passed on eROSITA_CVs(sdss_id)
226130957581VALIDATEUnique key testOK7/24/2026 12:52:41 PMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
226130957580VALIDATEUnique key testOK7/24/2026 12:52:41 PMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
226130957579VALIDATEUnique key testOK7/24/2026 12:52:40 PMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
226130957578VALIDATEUnique key testOK7/24/2026 12:52:40 PMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
226130957577VALIDATEUnique key testOK7/24/2026 12:52:40 PMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
226130957576VALIDATEUnique key testOK7/24/2026 12:52:40 PMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
226130957575VALIDATEUnique key testOK7/24/2026 12:52:39 PMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
226130957574VALIDATEUnique key testOK7/24/2026 12:52:39 PMUnique key test passed on DR20Q_prop(objid)
226130957573VALIDATEUnique key testOK7/24/2026 12:52:38 PMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
226130957572VALIDATEUnique key testOK7/24/2026 12:52:37 PMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
226130957571VALIDATEUnique key testOK7/24/2026 12:52:36 PMUnique key test passed on da_dwd_rvs(exposure_num,sdss_id)
226130957570VALIDATEUnique key testOK7/24/2026 12:52:35 PMUnique key test passed on da_dwd_candidates(sdss_id)
226130957569VALIDATEUnique key testOK7/24/2026 12:52:35 PMUnique key test passed on boss_vi_results(sdss_id)
226130957568VALIDATEUnique key testOK7/24/2026 12:52:34 PMUnique key test passed on boss_occam_member(sdss_id)
226130957567VALIDATEUnique key testOK7/24/2026 12:52:34 PMUnique key test passed on boss_occam_cluster(name)
226130957566VALIDATEspValidateDR20VAOK7/24/2026 12:52:34 PMPK_boss_ISM_NaI_absorption created
226130957565VALIDATEspValidateDR20VAOK7/24/2026 12:52:16 PMPK_boss_clam_params created
226130957564VALIDATEspValidateDR20VAOK7/24/2026 12:51:57 PMPK_boss_clam_lite created
226130957563VALIDATEspValidateDR20VAOK7/24/2026 12:51:43 PMspValidateDR20VACs called
226130957562VALIDATESTARTINGSTART7/24/2026 12:51:43 PMValidating dr20vacs database 1
226130947561PRELOADFINISHINGDONE7/24/2026 12:51:43 PMFinished SQL preload
226130947560PRELOADSet valuesOK7/24/2026 12:51:43 PMloadVersion updated
226130947559PRELOADSet valuesOK7/24/2026 12:51:43 PMSetting loadVersion
226130947558PRELOADCSV loadOK7/24/2026 12:51:43 PMAll rows have been loaded
226130947557PRELOADCSV loadOK7/24/2026 12:51:43 PMAll files are loaded
226130947556PRELOADCSV loadOK7/24/2026 12:51:43 PMFinished File load
226130947555PRELOADCSV loadOK7/24/2026 12:43:06 PMStarting File load
226130947554PRELOADSTARTINGSTART7/24/2026 12:43:06 PMStarting SQL Preload
226130937553BUILDFINISHINGDONE7/24/2026 12:43:06 PMFinished building DB
226130937552BUILDSchemaOK7/24/2026 12:43:06 PMCreated Spherical assembly in database TEST_DR201
226130937551BUILDSchemaOK7/24/2026 12:43:06 PM [spCosmology.sql]: Cosmology functions and procedures created
226130937550BUILDSchemaOK7/24/2026 12:43:05 PM [spCopyDbSubset]: spCopyDbSubset installed
226130937549BUILDSchemaOK7/24/2026 12:43:05 PM [spFinish.sql]: spFinish procedures created
226130937548BUILDSchemaOK7/24/2026 12:43: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
226130937547BUILDSchemaOK7/24/2026 12:43:04 PM [spValidate.sql]: Data validation procedures created
226130937546BUILDSchemaOK7/24/2026 12:43:03 PM [spSetValues.qsl]: Set values procedures created
226130937545BUILDSchemaOK7/24/2026 12:43:02 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
226130937544BUILDSchemaOK7/24/2026 12:43:02 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
226130937543BUILDSchemaOK7/24/2026 12:43:02 PM [spSQLSupport.sql]: SQL Support procs and functions created.
226130937542BUILDSchemaOK7/24/2026 12:43:01 PM [spDocSupport.sql]: DocSupport procs and functions created.
226130937541BUILDSchemaOK7/24/2026 12:43:01 PM [spTestQueries.sql]: Testing harness installed
226130937540BUILDSchemaOK7/24/2026 12:43:00 PM [spCheckDB.sql]: Database checking procs created
226130937539BUILDSchemaOK7/24/2026 12:43:00 PM [spRegion.sql]: Created functions and procedures for the Region package
226130937538BUILDSchemaOK7/24/2026 12:42:59 PM [spCoordinate.sql]: Coordinate related functions and procedures created
226130937537BUILDSchemaOK7/24/2026 12:42:59 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
226130937536BUILDSchemaOK7/24/2026 12:42: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
226130937535BUILDSchemaOK7/24/2026 12:42:57 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
226130937534BUILDSchemaOK7/24/2026 12:42: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]
226130937533BUILDSchemaOK7/24/2026 12:42:55 PMCreated Spherical assembly in database TEST_DR201
226130937532BUILDSchemaOK7/24/2026 12:42:52 PM [LvmTables.sql]: LVM tables created
226130937531BUILDSchemaOK7/24/2026 12:42:52 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
226130937530BUILDSchemaOK7/24/2026 12:42:49 PM [VacTables.sql]: VAC tables created
226130937529BUILDSchemaOK7/24/2026 12:42:48 PM [Views.sql]: Views created
226130937528BUILDSchemaOK7/24/2026 12:42:48 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
226130937527BUILDSchemaOK7/24/2026 12:42:47 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
226130937526BUILDSchemaOK7/24/2026 12:42:47 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
226130937525BUILDSchemaOK7/24/2026 12:42:47 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
226130937524BUILDSchemaOK7/24/2026 12:42:46 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
226130937523BUILDSchemaOK7/24/2026 12:42:46 PM [MastarTables.sql]: Mastar tables created
226130937522BUILDSchemaOK7/24/2026 12:42: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
226130937521BUILDSchemaOK7/24/2026 12:42: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
226130937520BUILDSchemaOK7/24/2026 12:42:44 PM [ApogeeTables.sql]: APOGEE tables created
226130937519BUILDSchemaOK7/24/2026 12:42:44 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
226130937518BUILDSchemaOK7/24/2026 12:42:43 PM [WindowTables.sql]: Window tables and related views created
226130937517BUILDSchemaOK7/24/2026 12:42:43 PM [RegionTables.sql]: Created tables for Region package
226130937516BUILDSchemaOK7/24/2026 12:42:43 PM [TilingTables.sql]: Tiling tables and related views created
226130937515BUILDSchemaOK7/24/2026 12:42:42 PM [spSpectro.sql]: Spectro functions/sps created
226130937514BUILDSchemaOK7/24/2026 12:42:42 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
226130937513BUILDSchemaOK7/24/2026 12:42: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
226130937512BUILDSchemaOK7/24/2026 12:42:41 PM [NeighborTables.sql]: Neighbor and Match tables created
226130937511BUILDSchemaOK7/24/2026 12:42:41 PM [resolveTables.sql]: Resolve tables created
226130937510BUILDSchemaOK7/24/2026 12:42:40 PM [spPhoto.sql]: Photo procedures and functions created
226130937509BUILDSchemaOK7/24/2026 12:42:40 PM [galSpecTables.sql]: galSpec tables and related functions created
226130937508BUILDSchemaOK7/24/2026 12:42:39 PM [PhotoZTables.sql]: Photometric redshifts tables created
226130937507BUILDSchemaOK7/24/2026 12:42:39 PM [PhotoTables.sql]: Photo tables created
226130937506BUILDSchemaOK7/24/2026 12:42:38 PM [Versions.sql]: Versions table created
226130937505BUILDSchemaOK7/24/2026 12:42:38 PM [IndexMap.sql]: Index management tables and procedures built
226130937504BUILDSchemaOK7/24/2026 12:42:32 PM [MetadataTables.sql]: MetaData tables created
226130937503BUILDSchemaOK7/24/2026 12:42:31 PM [ConstantSupport.sql]: Constant support views and functions created
226130937502BUILDSchemaOK7/24/2026 12:42:29 PM [DataConstants.sql]: Constant tables created
226130937501BUILDSchemaOK7/24/2026 12:42:17 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
226130937500BUILDSchemaOK7/24/2026 12:42:16 PMStarting schema creation for TEST_DR201 with partitioning=0
226130937499BUILDDatabaseOK7/24/2026 12:42:16 PMConfigured database TEST_DR201
226130937498BUILDDatabaseOK7/24/2026 12:42:15 PMCreated database TEST_DR201
226130937497BUILDDatabaseOK7/24/2026 12:41:01 PMStarting database creation
226130937496BUILDSTARTINGSTART7/24/2026 12:41:01 PMStarting DB build
226130927495CHECKFINISHINGDONE7/24/2026 12:40:43 PMFinished CSV checking
226130927494CHECKFile countOK7/24/2026 12:40:42 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
226130927493CHECKDir checkOK7/24/2026 12:40:42 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
226130927492CHECKOpen debug file OK7/24/2026 12:40:42 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
226130927491CHECKCheck backup folOK7/24/2026 12:40:42 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
226130927490CHECKCheck rootOK7/24/2026 12:40:42 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
226130927489CHECKSTARTINGSTART7/24/2026 12:40:41 PMStarting CSV check