Log - Task #2260
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
226030907488CLEANUPFINISHINGDONE7/24/2026 12:25:45 PMDeleted db TEST_DR201
226030907487CLEANUPSTARTINGSTART7/24/2026 12:25:45 PMStarting cleanup
226030887485PUBLISHFINISHINGDONE7/24/2026 12:25:45 PMPublished DR20 VACs dr20vacs from: sdss4c.TEST_DR201 to: sdss4c.BESTTEST
226030887484PUBLISHspPublishDR20VACABORTING7/24/2026 12:25:45 PMPublished DR20 VAC Tables
226030887483PUBLISHTableCopyERROR7/24/2026 12:25:45 PM*********** NULL phaseMsg ***********
226030887482PUBLISHTableCopyERROR7/24/2026 12:25:44 PM*********** NULL phaseMsg ***********
226030887481PUBLISHTableCopyERROR7/24/2026 12:25:44 PM*********** NULL phaseMsg ***********
226030887480PUBLISHTableCopyERROR7/24/2026 12:25:44 PM*********** NULL phaseMsg ***********
226030887479PUBLISHTableCopyERROR7/24/2026 12:25:41 PM*********** NULL phaseMsg ***********
226030887478PUBLISHTableCopyERROR7/24/2026 12:25:39 PM*********** NULL phaseMsg ***********
226030887477PUBLISHTableCopyERROR7/24/2026 12:25:35 PM*********** NULL phaseMsg ***********
226030887476PUBLISHTableCopyERROR7/24/2026 12:25:34 PM*********** NULL phaseMsg ***********
226030887475PUBLISHTableCopyERROR7/24/2026 12:25:34 PM*********** NULL phaseMsg ***********
226030887474PUBLISHTableCopyERROR7/24/2026 12:25:31 PM*********** NULL phaseMsg ***********
226030887473PUBLISHTableCopyERROR7/24/2026 12:25:30 PM*********** NULL phaseMsg ***********
226030887472PUBLISHTableCopyERROR7/24/2026 12:25:30 PM*********** NULL phaseMsg ***********
226030887471PUBLISHTableCopyERROR7/24/2026 12:25:30 PM*********** NULL phaseMsg ***********
226030887470PUBLISHTableCopyERROR7/24/2026 12:25:28 PM*********** NULL phaseMsg ***********
226030887469PUBLISHTableCopyERROR7/24/2026 12:25:27 PM*********** NULL phaseMsg ***********
226030887468PUBLISHTableCopyERROR7/24/2026 12:25:26 PM*********** NULL phaseMsg ***********
226030887467PUBLISHTableCopyERROR7/24/2026 12:25:26 PM*********** NULL phaseMsg ***********
226030887466PUBLISHTableCopyERROR7/24/2026 12:25:24 PM*********** NULL phaseMsg ***********
226030887465PUBLISHTableCopyERROR7/24/2026 12:25:23 PM*********** NULL phaseMsg ***********
226030887464PUBLISHTableCopyERROR7/24/2026 12:25:17 PM*********** NULL phaseMsg ***********
226030887463PUBLISHTableCopyERROR7/24/2026 12:25:15 PM*********** NULL phaseMsg ***********
226030887462PUBLISHTableCopyERROR7/24/2026 12:25:14 PM*********** NULL phaseMsg ***********
226030887461PUBLISHTableCopyERROR7/24/2026 12:25:14 PM*********** NULL phaseMsg ***********
226030887460PUBLISHTableCopyERROR7/24/2026 12:25:14 PM*********** NULL phaseMsg ***********
226030887459PUBLISHTableCopyERROR7/24/2026 12:25:13 PM*********** NULL phaseMsg ***********
226030887458PUBLISHTableCopyERROR7/24/2026 12:25:13 PM*********** NULL phaseMsg ***********
226030887457PUBLISHTableCopyERROR7/24/2026 12:25:13 PM*********** NULL phaseMsg ***********
226030887456PUBLISHTableCopyERROR7/24/2026 12:25:11 PM*********** NULL phaseMsg ***********
226030887455PUBLISHTableCopyERROR7/24/2026 12:25:05 PM*********** NULL phaseMsg ***********
226030887454PUBLISHspPublishDR20VACOK7/24/2026 12:25:01 PMStarting spPublishDR20VACs
226030887452PUBLISHAttachOK7/24/2026 12:25:01 PMSuccessfully attached sdss4c.TEST_DR201 in file: d:\sql_db\TEST_DR201_Data.MDF
226030887450PUBLISHSTARTINGSTART7/24/2026 12:25:01 PMPublishing dr20vacs sdss4c.TEST_DR201 to sdss4c.BESTTEST
226030877449DETACHFINISHINGDONE7/24/2026 12:24:03 PMDetached Database TEST_DR201
226030877448DETACHSTARTINGSTART7/24/2026 12:24:02 PMStarting DB detach
226030867447BACKUPFINISHINGDONE7/24/2026 12:24:02 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
226030867446BACKUPBackupOK7/24/2026 12:24:02 PMBacked up Database TEST_DR201 done to file \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
226030867445BACKUPCheckpointOK7/24/2026 12:23:54 PMCheckpoint done
226030867444BACKUPShrinkDBOK7/24/2026 12:23:54 PMShrink DB done
226030867443BACKUPCheckpointOK7/24/2026 12:23:53 PMCheckpoint done
226030867442BACKUPSTARTINGSTART7/24/2026 12:23:51 PMBacking up dr20vacs database 1 to \\sdss4c\taskdbbackup\TEST_DR201_backup.dat
226030857441VALIDATEFINISHINGDONE7/24/2026 12:23:51 PMValidated DR20 VACs 1
226030857440VALIDATEspValidateDR20VAOK7/24/2026 12:23:51 PMDR20 VAC tables validated in 64.48 seconds
226030857439VALIDATEUnique key testOK7/24/2026 12:23:51 PMUnique key test passed on yso_ob_kin(gaia_dr3_source_id)
226030857438VALIDATEUnique key testOK7/24/2026 12:23:51 PMUnique key test passed on qms_hg_h_hb_indices(catalogid)
226030857437VALIDATEUnique key testOK7/24/2026 12:23:51 PMUnique key test passed on qms_hg_index_diagram(catalogid)
226030857436VALIDATEUnique key testOK7/24/2026 12:23:51 PMUnique key test passed on payne4GAIN_summary(sdssid)
226030857435VALIDATEUnique key testOK7/24/2026 12:23:50 PMUnique key test passed on minesweeper(sdssid)
226030857434VALIDATEUnique key testOK7/24/2026 12:23:49 PMUnique key test passed on mdwarf_contin_summary(spectrum_pk)
226030857433VALIDATEUnique key testOK7/24/2026 12:23:48 PMUnique key test passed on mdwarf_active_params(sdssid)
226030857432VALIDATEUnique key testOK7/24/2026 12:23:47 PMUnique key test passed on gyro_age_dwarf(sdss_id)
226030857431VALIDATEUnique key testOK7/24/2026 12:23:47 PMUnique key test passed on grav_pot_16(ids)
226030857430VALIDATEUnique key testOK7/24/2026 12:23:46 PMUnique key test passed on fermi_blazar(sdss_id)
226030857429VALIDATEUnique key testOK7/24/2026 12:23:45 PMUnique key test passed on eROSITA_CVs(sdss_id)
226030857428VALIDATEUnique key testOK7/24/2026 12:23:45 PMUnique key test passed on efeds_spiders_agn_xray_props(PK_index)
226030857427VALIDATEUnique key testOK7/24/2026 12:23:45 PMUnique key test passed on efeds_spiders_agn_main_xray_cat(PK_Index)
226030857426VALIDATEUnique key testOK7/24/2026 12:23:45 PMUnique key test passed on efeds_spiders_agn_line_props(PK_index)
226030857425VALIDATEUnique key testOK7/24/2026 12:23:44 PMUnique key test passed on efeds_spiders_agn_host_decomp(PK_index)
226030857424VALIDATEUnique key testOK7/24/2026 12:23:44 PMUnique key test passed on efeds_spiders_agn_hard_xray_cat(PK_index)
226030857423VALIDATEUnique key testOK7/24/2026 12:23:44 PMUnique key test passed on efeds_spiders_agn_fit_params(PK_index)
226030857422VALIDATEUnique key testOK7/24/2026 12:23:43 PMUnique key test passed on efeds_spiders_agn_ctp_salvato(PK_index)
226030857421VALIDATEUnique key testOK7/24/2026 12:23:43 PMUnique key test passed on DR20Q_prop(objid)
226030857420VALIDATEUnique key testOK7/24/2026 12:23:42 PMUnique key test passed on DL1_eROSITA_eRASS3_daily(sdss_id,sdss_mjd)
226030857419VALIDATEUnique key testOK7/24/2026 12:23:41 PMUnique key test passed on DL1_eROSITA_eRASS3_allepoch(sdss_id,sdss_mjd)
226030857418VALIDATEUnique key testOK7/24/2026 12:23:40 PMUnique key test passed on da_dwd_rvs(exposure_num,sdss_id)
226030857417VALIDATEUnique key testOK7/24/2026 12:23:40 PMUnique key test passed on da_dwd_candidates(sdss_id)
226030857416VALIDATEUnique key testOK7/24/2026 12:23:40 PMUnique key test passed on boss_vi_results(sdss_id)
226030857415VALIDATEUnique key testOK7/24/2026 12:23:39 PMUnique key test passed on boss_occam_member(sdss_id)
226030857414VALIDATEUnique key testOK7/24/2026 12:23:39 PMUnique key test passed on boss_occam_cluster(name)
226030857413VALIDATEspValidateDR20VAOK7/24/2026 12:23:38 PMPK_boss_ISM_NaI_absorption created
226030857412VALIDATEspValidateDR20VAOK7/24/2026 12:23:20 PMPK_boss_clam_params created
226030857411VALIDATEspValidateDR20VAOK7/24/2026 12:23:01 PMPK_boss_clam_lite created
226030857410VALIDATEspValidateDR20VAOK7/24/2026 12:22:47 PMspValidateDR20VACs called
226030857409VALIDATESTARTINGSTART7/24/2026 12:22:47 PMValidating dr20vacs database 1
226030847408PRELOADFINISHINGDONE7/24/2026 12:22:47 PMFinished SQL preload
226030847407PRELOADSet valuesOK7/24/2026 12:22:47 PMloadVersion updated
226030847406PRELOADSet valuesOK7/24/2026 12:22:47 PMSetting loadVersion
226030847405PRELOADCSV loadOK7/24/2026 12:22:47 PMAll rows have been loaded
226030847404PRELOADCSV loadOK7/24/2026 12:22:47 PMAll files are loaded
226030847403PRELOADCSV loadOK7/24/2026 12:22:47 PMFinished File load
226030847402PRELOADCSV loadOK7/24/2026 12:14:05 PMStarting File load
226030847401PRELOADSTARTINGSTART7/24/2026 12:14:05 PMStarting SQL Preload
226030837400BUILDFINISHINGDONE7/24/2026 12:14:05 PMFinished building DB
226030837399BUILDSchemaOK7/24/2026 12:14:05 PMCreated Spherical assembly in database TEST_DR201
226030837398BUILDSchemaOK7/24/2026 12:14:05 PM [spCosmology.sql]: Cosmology functions and procedures created
226030837397BUILDSchemaOK7/24/2026 12:14:04 PM [spCopyDbSubset]: spCopyDbSubset installed
226030837396BUILDSchemaOK7/24/2026 12:14:04 PM [spFinish.sql]: spFinish procedures created
226030837395BUILDSchemaOK7/24/2026 12:14:03 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
226030837394BUILDSchemaOK7/24/2026 12:14:03 PM [spValidate.sql]: Data validation procedures created
226030837393BUILDSchemaOK7/24/2026 12:14:02 PM [spSetValues.qsl]: Set values procedures created
226030837392BUILDSchemaOK7/24/2026 12:14:02 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
226030837391BUILDSchemaOK7/24/2026 12:14:01 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
226030837390BUILDSchemaOK7/24/2026 12:14:01 PM [spSQLSupport.sql]: SQL Support procs and functions created.
226030837389BUILDSchemaOK7/24/2026 12:14:00 PM [spDocSupport.sql]: DocSupport procs and functions created.
226030837388BUILDSchemaOK7/24/2026 12:14:00 PM [spTestQueries.sql]: Testing harness installed
226030837387BUILDSchemaOK7/24/2026 12:14:00 PM [spCheckDB.sql]: Database checking procs created
226030837386BUILDSchemaOK7/24/2026 12:13:59 PM [spRegion.sql]: Created functions and procedures for the Region package
226030837385BUILDSchemaOK7/24/2026 12:13:59 PM [spCoordinate.sql]: Coordinate related functions and procedures created
226030837384BUILDSchemaOK7/24/2026 12:13:58 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
226030837383BUILDSchemaOK7/24/2026 12:13:57 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
226030837382BUILDSchemaOK7/24/2026 12:13:56 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
226030837381BUILDSchemaOK7/24/2026 12:13:55 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]
226030837380BUILDSchemaOK7/24/2026 12:13:54 PMCreated Spherical assembly in database TEST_DR201
226030837379BUILDSchemaOK7/24/2026 12:13:52 PM [LvmTables.sql]: LVM tables created
226030837378BUILDSchemaOK7/24/2026 12:13:52 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
226030837377BUILDSchemaOK7/24/2026 12:13:49 PM [VacTables.sql]: VAC tables created
226030837376BUILDSchemaOK7/24/2026 12:13:48 PM [Views.sql]: Views created
226030837375BUILDSchemaOK7/24/2026 12:13:47 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
226030837374BUILDSchemaOK7/24/2026 12:13:47 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
226030837373BUILDSchemaOK7/24/2026 12:13:47 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
226030837372BUILDSchemaOK7/24/2026 12:13: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
226030837371BUILDSchemaOK7/24/2026 12:13:46 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
226030837370BUILDSchemaOK7/24/2026 12:13:46 PM [MastarTables.sql]: Mastar tables created
226030837369BUILDSchemaOK7/24/2026 12:13: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
226030837368BUILDSchemaOK7/24/2026 12:13: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
226030837367BUILDSchemaOK7/24/2026 12:13:44 PM [ApogeeTables.sql]: APOGEE tables created
226030837366BUILDSchemaOK7/24/2026 12:13:44 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
226030837365BUILDSchemaOK7/24/2026 12:13:43 PM [WindowTables.sql]: Window tables and related views created
226030837364BUILDSchemaOK7/24/2026 12:13:43 PM [RegionTables.sql]: Created tables for Region package
226030837363BUILDSchemaOK7/24/2026 12:13:43 PM [TilingTables.sql]: Tiling tables and related views created
226030837362BUILDSchemaOK7/24/2026 12:13:42 PM [spSpectro.sql]: Spectro functions/sps created
226030837361BUILDSchemaOK7/24/2026 12:13:41 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
226030837360BUILDSchemaOK7/24/2026 12:13: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
226030837359BUILDSchemaOK7/24/2026 12:13:40 PM [NeighborTables.sql]: Neighbor and Match tables created
226030837358BUILDSchemaOK7/24/2026 12:13:40 PM [resolveTables.sql]: Resolve tables created
226030837357BUILDSchemaOK7/24/2026 12:13:40 PM [spPhoto.sql]: Photo procedures and functions created
226030837356BUILDSchemaOK7/24/2026 12:13:39 PM [galSpecTables.sql]: galSpec tables and related functions created
226030837355BUILDSchemaOK7/24/2026 12:13:39 PM [PhotoZTables.sql]: Photometric redshifts tables created
226030837354BUILDSchemaOK7/24/2026 12:13:39 PM [PhotoTables.sql]: Photo tables created
226030837353BUILDSchemaOK7/24/2026 12:13:38 PM [Versions.sql]: Versions table created
226030837352BUILDSchemaOK7/24/2026 12:13:38 PM [IndexMap.sql]: Index management tables and procedures built
226030837351BUILDSchemaOK7/24/2026 12:13:31 PM [MetadataTables.sql]: MetaData tables created
226030837350BUILDSchemaOK7/24/2026 12:13:31 PM [ConstantSupport.sql]: Constant support views and functions created
226030837349BUILDSchemaOK7/24/2026 12:13:28 PM [DataConstants.sql]: Constant tables created
226030837348BUILDSchemaOK7/24/2026 12:13:17 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
226030837347BUILDSchemaOK7/24/2026 12:13:15 PMStarting schema creation for TEST_DR201 with partitioning=0
226030837346BUILDDatabaseOK7/24/2026 12:13:15 PMConfigured database TEST_DR201
226030837345BUILDDatabaseOK7/24/2026 12:13:15 PMCreated database TEST_DR201
226030837344BUILDDatabaseOK7/24/2026 12:12:01 PMStarting database creation
226030837343BUILDSTARTINGSTART7/24/2026 12:12:00 PMStarting DB build
226030827342CHECKFINISHINGDONE7/24/2026 12:11:31 PMFinished CSV checking
226030827341CHECKFile countOK7/24/2026 12:11:31 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
226030827340CHECKDir checkOK7/24/2026 12:11:31 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
226030827339CHECKOpen debug file OK7/24/2026 12:11:31 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
226030827338CHECKCheck backup folOK7/24/2026 12:11:31 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
226030827337CHECKCheck rootOK7/24/2026 12:11:30 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
226030827336CHECKSTARTINGSTART7/24/2026 12:11:30 PMStarting CSV check