Log - Task #2217
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221728763945CLEANUPFINISHINGDONE6/19/2026 1:30:04 PMDeleted db TEST_ASTR1
221728763944CLEANUPSTARTINGSTART6/19/2026 1:30:03 PMStarting cleanup
221728743942PUBLISHFINISHINGDONE6/19/2026 1:30:03 PMPublished Astra astra from: sdss4c.TEST_ASTR1 to: sdss4c.BESTTEST
221728743941PUBLISHspPublishAstraOK6/19/2026 1:30:03 PMPublished Astra Tables
221728743940PUBLISHTableCopyOK6/19/2026 1:30:03 PM published 0 rows of table TEST_ASTR1.dbo.the_payne_apogee_visit to table BESTTEST.dbo.the_payne_apogee_visit
221728743939PUBLISHTableCopyOK6/19/2026 1:30:03 PM published 0 rows of table TEST_ASTR1.dbo.the_payne_apogee_star to table BESTTEST.dbo.the_payne_apogee_star
221728743938PUBLISHTableCopyOK6/19/2026 1:30:03 PM published 0 rows of table TEST_ASTR1.dbo.the_cannon_apogee_star to table BESTTEST.dbo.the_cannon_apogee_star
221728743937PUBLISHTableCopyOK6/19/2026 1:30:03 PM published 0 rows of table TEST_ASTR1.dbo.snow_white_boss_visit to table BESTTEST.dbo.snow_white_boss_visit
221728743936PUBLISHTableCopyOK6/19/2026 1:30:02 PM published 1803883 rows of table TEST_ASTR1.dbo.snow_white_boss_star to table BESTTEST.dbo.snow_white_boss_star
221728743935PUBLISHTableCopyOK6/19/2026 1:29:49 PM published 1803883 rows of table TEST_ASTR1.dbo.slam_boss_star to table BESTTEST.dbo.slam_boss_star
221728743934PUBLISHTableCopyOK6/19/2026 1:29:36 PM published 2086349 rows of table TEST_ASTR1.dbo.mwm_targets to table BESTTEST.dbo.mwm_targets
221728743933PUBLISHTableCopyOK6/19/2026 1:29:24 PM published 3364323 rows of table TEST_ASTR1.dbo.mwm_boss_allvisit to table BESTTEST.dbo.mwm_boss_allvisit
221728743932PUBLISHTableCopyOK6/19/2026 1:28:55 PM published 1803883 rows of table TEST_ASTR1.dbo.mwm_boss_allstar to table BESTTEST.dbo.mwm_boss_allstar
221728743931PUBLISHTableCopyOK6/19/2026 1:28:44 PM published 0 rows of table TEST_ASTR1.dbo.mwm_apogee_allvisit to table BESTTEST.dbo.mwm_apogee_allvisit
221728743930PUBLISHTableCopyOK6/19/2026 1:28:43 PM published 0 rows of table TEST_ASTR1.dbo.mwm_apogee_allstar to table BESTTEST.dbo.mwm_apogee_allstar
221728743929PUBLISHTableCopyOK6/19/2026 1:28:43 PM published 5356640 rows of table TEST_ASTR1.dbo.m_dwarf_type_boss_visit to table BESTTEST.dbo.m_dwarf_type_boss_visit
221728743928PUBLISHTableCopyOK6/19/2026 1:27:52 PM published 1802746 rows of table TEST_ASTR1.dbo.m_dwarf_type_boss_star to table BESTTEST.dbo.m_dwarf_type_boss_star
221728743927PUBLISHTableCopyOK6/19/2026 1:27:39 PM published 0 rows of table TEST_ASTR1.dbo.lite_all_star to table BESTTEST.dbo.lite_all_star
221728743926PUBLISHTableCopyOK6/19/2026 1:27:39 PM published 5357038 rows of table TEST_ASTR1.dbo.line_forest_boss_visit to table BESTTEST.dbo.line_forest_boss_visit
221728743925PUBLISHTableCopyOK6/19/2026 1:25:24 PM published 1803883 rows of table TEST_ASTR1.dbo.line_forest_boss_star to table BESTTEST.dbo.line_forest_boss_star
221728743924PUBLISHTableCopyOK6/19/2026 1:24:35 PM published 5328827 rows of table TEST_ASTR1.dbo.corv_boss_visit to table BESTTEST.dbo.corv_boss_visit
221728743923PUBLISHTableCopyOK6/19/2026 1:23:53 PM published 5357038 rows of table TEST_ASTR1.dbo.boss_net_boss_visit to table BESTTEST.dbo.boss_net_boss_visit
221728743922PUBLISHTableCopyOK6/19/2026 1:23:12 PM published 1803883 rows of table TEST_ASTR1.dbo.boss_net_boss_star to table BESTTEST.dbo.boss_net_boss_star
221728743921PUBLISHTableCopyOK6/19/2026 1:23:01 PM published 0 rows of table TEST_ASTR1.dbo.astro_nn_dist_apogee_star to table BESTTEST.dbo.astro_nn_dist_apogee_star
221728743920PUBLISHTableCopyOK6/19/2026 1:23:01 PM published 0 rows of table TEST_ASTR1.dbo.astro_nn_apogee_visit to table BESTTEST.dbo.astro_nn_apogee_visit
221728743919PUBLISHTableCopyOK6/19/2026 1:23:01 PM published 0 rows of table TEST_ASTR1.dbo.astro_nn_apogee_star to table BESTTEST.dbo.astro_nn_apogee_star
221728743918PUBLISHTableCopyOK6/19/2026 1:23:01 PM published 0 rows of table TEST_ASTR1.dbo.aspcap_apogee_star to table BESTTEST.dbo.aspcap_apogee_star
221728743917PUBLISHTableCopyOK6/19/2026 1:23:01 PM published 0 rows of table TEST_ASTR1.dbo.apogee_net_apogee_star to table BESTTEST.dbo.apogee_net_apogee_star
221728743916PUBLISHspPublishAstraOK6/19/2026 1:23:01 PMStarting spPublishAstra ft = 1
221728743914PUBLISHAttachOK6/19/2026 1:23:01 PMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
221728743912PUBLISHSTARTINGSTART6/19/2026 1:23:00 PMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
221728733911DETACHFINISHINGDONE6/19/2026 1:22:28 PMDetached Database TEST_ASTR1
221728733910DETACHSTARTINGSTART6/19/2026 1:22:26 PMStarting DB detach
221728723909BACKUPFINISHINGDONE6/19/2026 1:22:26 PMBacked up Database TEST_ASTR1 done to file \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
221728723908BACKUPBackupOK6/19/2026 1:22:26 PMBacked up Database TEST_ASTR1 done to file \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
221728723907BACKUPCheckpointOK6/19/2026 1:20:48 PMCheckpoint done
221728723906BACKUPShrinkDBOK6/19/2026 1:20:48 PMShrink DB done
221728723905BACKUPCheckpointOK6/19/2026 1:20:46 PMCheckpoint done
221728723904BACKUPSTARTINGSTART6/19/2026 1:20:46 PMBacking up astra database 1 to \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
221728713903VALIDATEFINISHINGDONE6/19/2026 1:20:46 PMValidated Astra 1
221728713902VALIDATEspValidateAstraOK6/19/2026 1:20:46 PMAstra tables validated in 795.153 seconds
221728713901VALIDATEspValidateAstraOK6/19/2026 1:20:46 PMPK_snow_white_boss_star created
221728713900VALIDATEspValidateAstraOK6/19/2026 1:20:24 PMPK_slam_boss_star created
221728713899VALIDATEspValidateAstraOK6/19/2026 1:20:05 PMPK_mwm_targets created
221728713898VALIDATEspValidateAstraOK6/19/2026 1:19:42 PMPK_mwm_boss_allvisit created
221728713897VALIDATEspValidateAstraOK6/19/2026 1:18:56 PMPK_mwm_boss_allstar created
221728713896VALIDATEspValidateAstraOK6/19/2026 1:18:36 PMPK_m_dwarf_type_boss_visit created
221728713895VALIDATEspValidateAstraOK6/19/2026 1:17:25 PMPK_m_dwarf_type_boss_star created
221728713894VALIDATEspValidateAstraOK6/19/2026 1:17:03 PMPK_line_forest_boss_visit created
221728713893VALIDATEspValidateAstraOK6/19/2026 1:10:44 PMPK_line_forest_boss_star created
221728713892VALIDATEspValidateAstraOK6/19/2026 1:10:00 PMPK_corv_boss_visit created
221728713891VALIDATEspValidateAstraOK6/19/2026 1:08:55 PMPK_boss_net_boss_visit created
221728713890VALIDATEspValidateAstraOK6/19/2026 1:07:48 PMPK_boss_net_boss_star created
221728713889VALIDATEspValidateAstraOK6/19/2026 1:07:31 PMspValidateAstra called
221728713888VALIDATESTARTINGSTART6/19/2026 1:07:31 PMValidating astra database 1
221728703887PRELOADFINISHINGDONE6/19/2026 1:07:31 PMFinished SQL preload
221728703886PRELOADSet valuesOK6/19/2026 1:07:31 PMloadVersion updated
221728703885PRELOADSet valuesOK6/19/2026 1:07:31 PMSetting loadVersion
221728703884PRELOADCSV loadOK6/19/2026 1:07:31 PMAll rows have been loaded
221728703883PRELOADCSV loadOK6/19/2026 1:07:30 PMAll files are loaded
221728703882PRELOADCSV loadOK6/19/2026 1:07:30 PMFinished File load
221728703881PRELOADCSV loadOK6/19/2026 11:25:11 AMStarting File load
221728703880PRELOADSTARTINGSTART6/19/2026 11:25:11 AMStarting SQL Preload
221728693879BUILDFINISHINGDONE6/19/2026 11:25:11 AMFinished building DB
221728693878BUILDSchemaOK6/19/2026 11:25:11 AMCreated Spherical assembly in database TEST_ASTR1
221728693877BUILDSchemaOK6/19/2026 11:25:11 AM [spCosmology.sql]: Cosmology functions and procedures created
221728693876BUILDSchemaOK6/19/2026 11:25:10 AM [spCopyDbSubset]: spCopyDbSubset installed
221728693875BUILDSchemaOK6/19/2026 11:25:10 AM [spFinish.sql]: spFinish procedures created
221728693874BUILDSchemaOK6/19/2026 11:25:09 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
221728693873BUILDSchemaOK6/19/2026 11:25:08 AM [spValidate.sql]: Data validation procedures created
221728693872BUILDSchemaOK6/19/2026 11:25:07 AM [spSetValues.qsl]: Set values procedures created
221728693871BUILDSchemaOK6/19/2026 11:25:07 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
221728693870BUILDSchemaOK6/19/2026 11:25:06 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221728693869BUILDSchemaOK6/19/2026 11:25:06 AM [spSQLSupport.sql]: SQL Support procs and functions created.
221728693868BUILDSchemaOK6/19/2026 11:25:05 AM [spDocSupport.sql]: DocSupport procs and functions created.
221728693867BUILDSchemaOK6/19/2026 11:25:05 AM [spTestQueries.sql]: Testing harness installed
221728693866BUILDSchemaOK6/19/2026 11:25:05 AM [spCheckDB.sql]: Database checking procs created
221728693865BUILDSchemaOK6/19/2026 11:25:04 AM [spRegion.sql]: Created functions and procedures for the Region package
221728693864BUILDSchemaOK6/19/2026 11:25:03 AM [spCoordinate.sql]: Coordinate related functions and procedures created
221728693863BUILDSchemaOK6/19/2026 11:25:03 AMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221728693862BUILDSchemaOK6/19/2026 11:25:02 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
221728693861BUILDSchemaOK6/19/2026 11:25:01 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221728693860BUILDSchemaOK6/19/2026 11:25:00 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]
221728693859BUILDSchemaOK6/19/2026 11:24:59 AMCreated Spherical assembly in database TEST_ASTR1
221728693858BUILDSchemaOK6/19/2026 11:24:55 AM [LvmTables.sql]: LVM tables created
221728693857BUILDSchemaOK6/19/2026 11:24:55 AMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221728693856BUILDSchemaOK6/19/2026 11:24:52 AM [VacTables.sql]: VAC tables created
221728693855BUILDSchemaOK6/19/2026 11:24:52 AM [Views.sql]: Views created
221728693854BUILDSchemaOK6/19/2026 11:24:51 AMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221728693853BUILDSchemaOK6/19/2026 11:24:50 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221728693852BUILDSchemaOK6/19/2026 11:24:50 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221728693851BUILDSchemaOK6/19/2026 11:24:50 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
221728693850BUILDSchemaOK6/19/2026 11:24:49 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221728693849BUILDSchemaOK6/19/2026 11:24:49 AM [MastarTables.sql]: Mastar tables created
221728693848BUILDSchemaOK6/19/2026 11:24:49 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
221728693847BUILDSchemaOK6/19/2026 11:24:48 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
221728693846BUILDSchemaOK6/19/2026 11:24:47 AM [ApogeeTables.sql]: APOGEE tables created
221728693845BUILDSchemaOK6/19/2026 11:24:46 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221728693844BUILDSchemaOK6/19/2026 11:24:46 AM [WindowTables.sql]: Window tables and related views created
221728693843BUILDSchemaOK6/19/2026 11:24:46 AM [RegionTables.sql]: Created tables for Region package
221728693842BUILDSchemaOK6/19/2026 11:24:45 AM [TilingTables.sql]: Tiling tables and related views created
221728693841BUILDSchemaOK6/19/2026 11:24:45 AM [spSpectro.sql]: Spectro functions/sps created
221728693840BUILDSchemaOK6/19/2026 11:24:44 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
221728693839BUILDSchemaOK6/19/2026 11:24: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
221728693838BUILDSchemaOK6/19/2026 11:24:43 AM [NeighborTables.sql]: Neighbor and Match tables created
221728693837BUILDSchemaOK6/19/2026 11:24:43 AM [resolveTables.sql]: Resolve tables created
221728693836BUILDSchemaOK6/19/2026 11:24:42 AM [spPhoto.sql]: Photo procedures and functions created
221728693835BUILDSchemaOK6/19/2026 11:24:42 AM [galSpecTables.sql]: galSpec tables and related functions created
221728693834BUILDSchemaOK6/19/2026 11:24:41 AM [PhotoZTables.sql]: Photometric redshifts tables created
221728693833BUILDSchemaOK6/19/2026 11:24:41 AM [PhotoTables.sql]: Photo tables created
221728693832BUILDSchemaOK6/19/2026 11:24:40 AM [Versions.sql]: Versions table created
221728693831BUILDSchemaOK6/19/2026 11:24:40 AM [IndexMap.sql]: Index management tables and procedures built
221728693830BUILDSchemaOK6/19/2026 11:24:34 AM [MetadataTables.sql]: MetaData tables created
221728693829BUILDSchemaOK6/19/2026 11:24:33 AM [ConstantSupport.sql]: Constant support views and functions created
221728693828BUILDSchemaOK6/19/2026 11:24:31 AM [DataConstants.sql]: Constant tables created
221728693827BUILDSchemaOK6/19/2026 11:24:19 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221728693826BUILDSchemaOK6/19/2026 11:24:18 AMStarting schema creation for TEST_ASTR1 with partitioning=0
221728693825BUILDDatabaseOK6/19/2026 11:24:18 AMConfigured database TEST_ASTR1
221728693824BUILDDatabaseOK6/19/2026 11:24:18 AMCreated database TEST_ASTR1
221728693823BUILDDatabaseOK6/19/2026 11:22:01 AMStarting database creation
221728693822BUILDSTARTINGSTART6/19/2026 11:22:01 AMStarting DB build
221728683821CHECKFINISHINGDONE6/19/2026 11:21:17 AMFinished CSV checking
221728683820CHECKFile countOK6/19/2026 11:21:17 AMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
221728683819CHECKDir checkOK6/19/2026 11:21:17 AMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
221728683818CHECKOpen debug file OK6/19/2026 11:21:17 AMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
221728683817CHECKCheck backup folOK6/19/2026 11:21:17 AMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
221728683816CHECKCheck rootOK6/19/2026 11:21:17 AMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
221728683815CHECKSTARTINGSTART6/19/2026 11:21:16 AMStarting CSV check