Log - Task #2255
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
225530526978PUBLISHspPublishDR20VACOK7/24/2026 10:56:01 AMStarting spPublishDR20VACs
225530526976PUBLISHAttachOK7/24/2026 10:56:01 AMSuccessfully attached sdss4c.TEST_DR201 in file: d:\sql_db\TEST_DR201_Data.MDF
225530526972PUBLISHSTARTINGSTART7/24/2026 10:56:00 AMPublishing dr20vacs sdss4c.TEST_DR201 to sdss4c.BESTTEST
225530506970DETACHFINISHINGDONE7/24/2026 10:55:22 AMDetached Database TEST_DR201
225530506969DETACHSTARTINGSTART7/24/2026 10:55:21 AMStarting DB detach
225530496968BACKUPFINISHINGDONE7/24/2026 10:55:21 AMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225530496967BACKUPBackupOK7/24/2026 10:55:21 AMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225530496966BACKUPCheckpointOK7/24/2026 10:55:13 AMCheckpoint done
225530496965BACKUPShrinkDBOK7/24/2026 10:55:13 AMShrink DB done
225530496964BACKUPCheckpointOK7/24/2026 10:55:13 AMCheckpoint done
225530496963BACKUPSTARTINGSTART7/24/2026 10:55:11 AMBacking up dr20vacs database 1 to \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
225530486962VALIDATEFINISHINGDONE7/24/2026 10:55:11 AMValidated DR20 VACs 1
225530486961VALIDATEspValidateDR20VAOK7/24/2026 10:55:11 AMDR20 VAC tables validated in 63.656 seconds
225530486960VALIDATEUnique key testOK7/24/2026 10:55:11 AMUnique key test passed on yso_ob_kin(gaia_dr3_source_id)
225530486959VALIDATEUnique key testOK7/24/2026 10:55:10 AMUnique key test passed on qms_hg_h_hb_indices(catalogid)
225530486958VALIDATEUnique key testOK7/24/2026 10:55:10 AMUnique key test passed on qms_hg_index_diagram(catalogid)
225530486957VALIDATEUnique key testOK7/24/2026 10:55:10 AMUnique key test passed on payne4GAIN_summary(sdssid)
225530486956VALIDATEUnique key testOK7/24/2026 10:55:09 AMUnique key test passed on minesweeper(sdssid)
225530486955VALIDATEUnique key testOK7/24/2026 10:55:09 AMUnique key test passed on mdwarf_contin_summary(spectrum_pk)
225530486954VALIDATEUnique key testOK7/24/2026 10:55:07 AMUnique key test passed on mdwarf_active_params(sdssid)
225530486953VALIDATEUnique key testOK7/24/2026 10:55:06 AMUnique key test passed on gyro_age_dwarf(sdss_id)
225530486952VALIDATEUnique key testOK7/24/2026 10:55:06 AMUnique key test passed on grav_pot_16(ids)
225530486951VALIDATEUnique key testOK7/24/2026 10:55:05 AMUnique key test passed on fermi_blazar(sdss_id)
225530486950VALIDATEUnique key testOK7/24/2026 10:55:05 AMUnique key test passed on eROSITA_CVs(sdss_id)
225530486949VALIDATEUnique key testOK7/24/2026 10:55:05 AMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
225530486948VALIDATEUnique key testOK7/24/2026 10:55:05 AMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
225530486947VALIDATEUnique key testOK7/24/2026 10:55:04 AMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
225530486946VALIDATEUnique key testOK7/24/2026 10:55:04 AMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
225530486945VALIDATEUnique key testOK7/24/2026 10:55:04 AMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
225530486944VALIDATEUnique key testOK7/24/2026 10:55:03 AMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
225530486943VALIDATEUnique key testOK7/24/2026 10:55:03 AMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
225530486942VALIDATEUnique key testOK7/24/2026 10:55:03 AMUnique key test passed on DR20Q_prop(objid)
225530486941VALIDATEUnique key testOK7/24/2026 10:55:02 AMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
225530486940VALIDATEUnique key testOK7/24/2026 10:55:00 AMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
225530486939VALIDATEUnique key testOK7/24/2026 10:55:00 AMUnique key test passed on da_dwd_rvs(exposure_num,sdss_id)
225530486938VALIDATEUnique key testOK7/24/2026 10:54:59 AMUnique key test passed on da_dwd_candidates(sdss_id)
225530486937VALIDATEUnique key testOK7/24/2026 10:54:59 AMUnique key test passed on boss_vi_results(sdss_id)
225530486936VALIDATEUnique key testOK7/24/2026 10:54:58 AMUnique key test passed on boss_occam_member(sdss_id)
225530486935VALIDATEUnique key testOK7/24/2026 10:54:58 AMUnique key test passed on boss_occam_cluster(name)
225530486934VALIDATEspValidateDR20VAOK7/24/2026 10:54:58 AMPK_boss_ISM_NaI_absorption created
225530486933VALIDATEspValidateDR20VAOK7/24/2026 10:54:39 AMPK_boss_clam_params created
225530486932VALIDATEspValidateDR20VAOK7/24/2026 10:54:21 AMPK_boss_clam_lite created
225530486931VALIDATEspValidateDR20VAOK7/24/2026 10:54:07 AMspValidateDR20VACs called
225530486930VALIDATESTARTINGSTART7/24/2026 10:54:07 AMValidating dr20vacs database 1
225530476929PRELOADFINISHINGDONE7/24/2026 10:54:07 AMFinished SQL preload
225530476928PRELOADSet valuesOK7/24/2026 10:54:07 AMloadVersion updated
225530476927PRELOADSet valuesOK7/24/2026 10:54:07 AMSetting loadVersion
225530476926PRELOADCSV loadOK7/24/2026 10:54:07 AMAll rows have been loaded
225530476925PRELOADCSV loadOK7/24/2026 10:54:07 AMAll files are loaded
225530476924PRELOADCSV loadOK7/24/2026 10:54:07 AMFinished File load
225530476923PRELOADCSV loadOK7/24/2026 10:45:10 AMStarting File load
225530476922PRELOADSTARTINGSTART7/24/2026 10:45:10 AMStarting SQL Preload
225530446921BUILDFINISHINGDONE7/24/2026 10:45:10 AMFinished building DB
225530446920BUILDSchemaOK7/24/2026 10:45:10 AMCreated Spherical assembly in database TEST_DR201
225530446919BUILDSchemaOK7/24/2026 10:45:10 AM [spCosmology.sql]: Cosmology functions and procedures created
225530446918BUILDSchemaOK7/24/2026 10:45:09 AM [spCopyDbSubset]: spCopyDbSubset installed
225530446917BUILDSchemaOK7/24/2026 10:45:09 AM [spFinish.sql]: spFinish procedures created
225530446916BUILDSchemaOK7/24/2026 10:45:08 AM 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
225530446915BUILDSchemaOK7/24/2026 10:45:07 AM [spValidate.sql]: Data validation procedures created
225530446914BUILDSchemaOK7/24/2026 10:45:06 AM [spSetValues.qsl]: Set values procedures created
225530446913BUILDSchemaOK7/24/2026 10:45:06 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
225530446912BUILDSchemaOK7/24/2026 10:45:05 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
225530446911BUILDSchemaOK7/24/2026 10:45:05 AM [spSQLSupport.sql]: SQL Support procs and functions created.
225530446910BUILDSchemaOK7/24/2026 10:45:05 AM [spDocSupport.sql]: DocSupport procs and functions created.
225530446909BUILDSchemaOK7/24/2026 10:45:04 AM [spTestQueries.sql]: Testing harness installed
225530446908BUILDSchemaOK7/24/2026 10:45:04 AM [spCheckDB.sql]: Database checking procs created
225530446907BUILDSchemaOK7/24/2026 10:45:03 AM [spRegion.sql]: Created functions and procedures for the Region package
225530446906BUILDSchemaOK7/24/2026 10:45:03 AM [spCoordinate.sql]: Coordinate related functions and procedures created
225530446905BUILDSchemaOK7/24/2026 10:45:02 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
225530446904BUILDSchemaOK7/24/2026 10:45:01 AM 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
225530446903BUILDSchemaOK7/24/2026 10:45:00 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
225530446902BUILDSchemaOK7/24/2026 10:44:59 AM 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]
225530446901BUILDSchemaOK7/24/2026 10:44:58 AMCreated Spherical assembly in database TEST_DR201
225530446900BUILDSchemaOK7/24/2026 10:44:55 AM [LvmTables.sql]: LVM tables created
225530446899BUILDSchemaOK7/24/2026 10:44:54 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
225530446898BUILDSchemaOK7/24/2026 10:44:52 AM [VacTables.sql]: VAC tables created
225530446897BUILDSchemaOK7/24/2026 10:44:51 AM [Views.sql]: Views created
225530446896BUILDSchemaOK7/24/2026 10:44:50 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
225530446895BUILDSchemaOK7/24/2026 10:44:50 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
225530446894BUILDSchemaOK7/24/2026 10:44:49 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
225530446893BUILDSchemaOK7/24/2026 10:44:49 AM Msg 102, Level 15, State 1, Server sdss4c, Procedure spMakeFrame, Line 56 Incorrect syntax near 'nul'. [FrameTables.sql]: Frame table and related procedures created
225530446892BUILDSchemaOK7/24/2026 10:44:49 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
225530446891BUILDSchemaOK7/24/2026 10:44:48 AM [MastarTables.sql]: Mastar tables created
225530446890BUILDSchemaOK7/24/2026 10:44:48 AM 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
225530446889BUILDSchemaOK7/24/2026 10:44:47 AM 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
225530446888BUILDSchemaOK7/24/2026 10:44:46 AM [ApogeeTables.sql]: APOGEE tables created
225530446887BUILDSchemaOK7/24/2026 10:44:46 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
225530446886BUILDSchemaOK7/24/2026 10:44:45 AM [WindowTables.sql]: Window tables and related views created
225530446885BUILDSchemaOK7/24/2026 10:44:45 AM [RegionTables.sql]: Created tables for Region package
225530446884BUILDSchemaOK7/24/2026 10:44:45 AM [TilingTables.sql]: Tiling tables and related views created
225530446883BUILDSchemaOK7/24/2026 10:44:44 AM [spSpectro.sql]: Spectro functions/sps created
225530446882BUILDSchemaOK7/24/2026 10:44:43 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
225530446881BUILDSchemaOK7/24/2026 10:44:43 AM 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
225530446880BUILDSchemaOK7/24/2026 10:44:42 AM [NeighborTables.sql]: Neighbor and Match tables created
225530446879BUILDSchemaOK7/24/2026 10:44:42 AM [resolveTables.sql]: Resolve tables created
225530446878BUILDSchemaOK7/24/2026 10:44:42 AM [spPhoto.sql]: Photo procedures and functions created
225530446877BUILDSchemaOK7/24/2026 10:44:41 AM [galSpecTables.sql]: galSpec tables and related functions created
225530446876BUILDSchemaOK7/24/2026 10:44:41 AM [PhotoZTables.sql]: Photometric redshifts tables created
225530446875BUILDSchemaOK7/24/2026 10:44:41 AM [PhotoTables.sql]: Photo tables created
225530446874BUILDSchemaOK7/24/2026 10:44:40 AM [Versions.sql]: Versions table created
225530446873BUILDSchemaOK7/24/2026 10:44:40 AM [IndexMap.sql]: Index management tables and procedures built
225530446872BUILDSchemaOK7/24/2026 10:44:33 AM [MetadataTables.sql]: MetaData tables created
225530446871BUILDSchemaOK7/24/2026 10:44:32 AM [ConstantSupport.sql]: Constant support views and functions created
225530446870BUILDSchemaOK7/24/2026 10:44:30 AM [DataConstants.sql]: Constant tables created
225530446869BUILDSchemaOK7/24/2026 10:44:18 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
225530446868BUILDSchemaOK7/24/2026 10:44:17 AMStarting schema creation for TEST_DR201 with partitioning=0
225530446867BUILDDatabaseOK7/24/2026 10:44:17 AMConfigured database TEST_DR201
225530446866BUILDDatabaseOK7/24/2026 10:44:16 AMCreated database TEST_DR201
225530446858BUILDDatabaseOK7/24/2026 10:43:01 AMStarting database creation
225530446857BUILDSTARTINGSTART7/24/2026 10:43:01 AMStarting DB build
225530436856CHECKFINISHINGDONE7/24/2026 10:42:54 AMFinished CSV checking
225530436855CHECKFile countOK7/24/2026 10:42:53 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
225530436854CHECKDir checkOK7/24/2026 10:42:53 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
225530436853CHECKOpen debug file OK7/24/2026 10:42:53 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
225530436852CHECKCheck backup folOK7/24/2026 10:42:53 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
225530436851CHECKCheck rootOK7/24/2026 10:42:53 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
225530436850CHECKSTARTINGSTART7/24/2026 10:42:52 AMStarting CSV check