Log - Task #2216
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221628663814CLEANUPFINISHINGDONE6/19/2026 11:02:01 AMDeleted db TEST_ASTR1
221628663813CLEANUPSTARTINGSTART6/19/2026 11:02:01 AMStarting cleanup
221628643811PUBLISHFINISHINGDONE6/19/2026 11:01:52 AMPublished Astra astra from: sdss4c.TEST_ASTR1 to: sdss4c.BESTTEST
221628643810PUBLISHspPublishAstraOK6/19/2026 11:01:52 AMPublished Astra Tables
221628643809PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.the_payne_apogee_visit to table BESTTEST.dbo.the_payne_apogee_visit
221628643808PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.the_payne_apogee_star to table BESTTEST.dbo.the_payne_apogee_star
221628643807PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.the_cannon_apogee_star to table BESTTEST.dbo.the_cannon_apogee_star
221628643806PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.snow_white_boss_visit to table BESTTEST.dbo.snow_white_boss_visit
221628643805PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.snow_white_boss_star to table BESTTEST.dbo.snow_white_boss_star
221628643804PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.slam_boss_star to table BESTTEST.dbo.slam_boss_star
221628643803PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.mwm_targets to table BESTTEST.dbo.mwm_targets
221628643802PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.mwm_boss_allvisit to table BESTTEST.dbo.mwm_boss_allvisit
221628643801PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.mwm_boss_allstar to table BESTTEST.dbo.mwm_boss_allstar
221628643800PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.mwm_apogee_allvisit to table BESTTEST.dbo.mwm_apogee_allvisit
221628643799PUBLISHTableCopyOK6/19/2026 11:01:52 AM published 0 rows of table TEST_ASTR1.dbo.mwm_apogee_allstar to table BESTTEST.dbo.mwm_apogee_allstar
221628643798PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.m_dwarf_type_boss_visit to table BESTTEST.dbo.m_dwarf_type_boss_visit
221628643797PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.m_dwarf_type_boss_star to table BESTTEST.dbo.m_dwarf_type_boss_star
221628643796PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.lite_all_star to table BESTTEST.dbo.lite_all_star
221628643795PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.line_forest_boss_visit to table BESTTEST.dbo.line_forest_boss_visit
221628643794PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.line_forest_boss_star to table BESTTEST.dbo.line_forest_boss_star
221628643793PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.corv_boss_visit to table BESTTEST.dbo.corv_boss_visit
221628643792PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.boss_net_boss_visit to table BESTTEST.dbo.boss_net_boss_visit
221628643791PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.boss_net_boss_star to table BESTTEST.dbo.boss_net_boss_star
221628643790PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.astro_nn_dist_apogee_star to table BESTTEST.dbo.astro_nn_dist_apogee_star
221628643789PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.astro_nn_apogee_visit to table BESTTEST.dbo.astro_nn_apogee_visit
221628643788PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.astro_nn_apogee_star to table BESTTEST.dbo.astro_nn_apogee_star
221628643787PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.aspcap_apogee_star to table BESTTEST.dbo.aspcap_apogee_star
221628643786PUBLISHTableCopyOK6/19/2026 11:01:51 AM published 0 rows of table TEST_ASTR1.dbo.apogee_net_apogee_star to table BESTTEST.dbo.apogee_net_apogee_star
221628643785PUBLISHspPublishAstraOK6/19/2026 11:01:51 AMStarting spPublishAstra ft = 0
221628643783PUBLISHAttachOK6/19/2026 11:01:51 AMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
221628643781PUBLISHSTARTINGSTART6/19/2026 11:01:51 AMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
221628623779PUBLISHFINISHINGERROR6/19/2026 10:59:16 AMFailed to attach DB sdss4c.TEST_ASTR1
221628623777PUBLISHAttachABORTING6/19/2026 10:59:16 AMFailed to attach DB sdss4c.TEST_ASTR1
221628623775PUBLISHSTARTINGSTART6/19/2026 10:59:16 AMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
221628603774PUBLISHspPublishAstraOK6/18/2026 4:47:01 PMStarting spPublishAstra ft = 1
221628603772PUBLISHAttachOK6/18/2026 4:47:01 PMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
221628603770PUBLISHSTARTINGSTART6/18/2026 4:47:01 PMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
221628593769DETACHFINISHINGDONE6/18/2026 4:46:22 PMDetached Database TEST_ASTR1
221628593768DETACHSTARTINGSTART6/18/2026 4:46:19 PMStarting DB detach
221628583767BACKUPFINISHINGDONE6/18/2026 4:46:19 PMBacked up Database TEST_ASTR1 done to file \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
221628583766BACKUPBackupOK6/18/2026 4:46:19 PMBacked up Database TEST_ASTR1 done to file \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
221628583765BACKUPCheckpointOK6/18/2026 4:43:14 PMCheckpoint done
221628583764BACKUPShrinkDBOK6/18/2026 4:43:14 PMShrink DB done
221628583763BACKUPCheckpointOK6/18/2026 4:43:12 PMCheckpoint done
221628583762BACKUPSTARTINGSTART6/18/2026 4:43:12 PMBacking up astra database 1 to \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
221628573761VALIDATEFINISHINGDONE6/18/2026 4:43:12 PMValidated Astra 1
221628573760VALIDATEspValidateAstraOK6/18/2026 4:43:12 PMAstra tables validated in 954.03 seconds
221628573759VALIDATEspValidateAstraOK6/18/2026 4:43:12 PMPK_snow_white_boss_star created
221628573758VALIDATEspValidateAstraOK6/18/2026 4:42:48 PMPK_slam_boss_star created
221628573757VALIDATEspValidateAstraOK6/18/2026 4:42:26 PMPK_mwm_targets created
221628573756VALIDATEspValidateAstraOK6/18/2026 4:42:04 PMPK_mwm_boss_allvisit created
221628573755VALIDATEspValidateAstraOK6/18/2026 4:41:16 PMPK_mwm_boss_allstar created
221628573754VALIDATEspValidateAstraOK6/18/2026 4:40:55 PMPK_m_dwarf_type_boss_visit created
221628573753VALIDATEspValidateAstraOK6/18/2026 4:39:42 PMPK_m_dwarf_type_boss_star created
221628573752VALIDATEspValidateAstraOK6/18/2026 4:39:22 PMPK_line_forest_boss_visit created
221628573751VALIDATEspValidateAstraOK6/18/2026 4:30:47 PMPK_line_forest_boss_star created
221628573750VALIDATEspValidateAstraOK6/18/2026 4:29:55 PMPK_corv_boss_visit created
221628573749VALIDATEspValidateAstraOK6/18/2026 4:28:45 PMPK_boss_net_boss_visit created
221628573748VALIDATEspValidateAstraOK6/18/2026 4:27:36 PMPK_boss_net_boss_star created
221628573747VALIDATEspValidateAstraOK6/18/2026 4:27:18 PMspValidateAstra called
221628573746VALIDATESTARTINGSTART6/18/2026 4:27:18 PMValidating astra database 1
221628563745PRELOADFINISHINGDONE6/18/2026 4:27:18 PMFinished SQL preload
221628563744PRELOADSet valuesOK6/18/2026 4:27:18 PMloadVersion updated
221628563743PRELOADSet valuesOK6/18/2026 4:27:18 PMSetting loadVersion
221628563742PRELOADCSV loadOK6/18/2026 4:27:17 PMAll rows have been loaded
221628563741PRELOADCSV loadOK6/18/2026 4:27:17 PMAll files are loaded
221628563740PRELOADCSV loadOK6/18/2026 4:27:17 PMFinished File load
221628563739PRELOADCSV loadOK6/18/2026 2:38:42 PMStarting File load
221628563738PRELOADSTARTINGSTART6/18/2026 2:38:42 PMStarting SQL Preload
221628553737BUILDFINISHINGDONE6/18/2026 2:38:42 PMFinished building DB
221628553736BUILDSchemaOK6/18/2026 2:38:42 PMCreated Spherical assembly in database TEST_ASTR1
221628553735BUILDSchemaOK6/18/2026 2:38:42 PM [spCosmology.sql]: Cosmology functions and procedures created
221628553734BUILDSchemaOK6/18/2026 2:38:41 PM [spCopyDbSubset]: spCopyDbSubset installed
221628553733BUILDSchemaOK6/18/2026 2:38:41 PM [spFinish.sql]: spFinish procedures created
221628553732BUILDSchemaOK6/18/2026 2:38:40 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
221628553731BUILDSchemaOK6/18/2026 2:38:39 PM [spValidate.sql]: Data validation procedures created
221628553730BUILDSchemaOK6/18/2026 2:38:39 PM [spSetValues.qsl]: Set values procedures created
221628553729BUILDSchemaOK6/18/2026 2:38:38 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
221628553728BUILDSchemaOK6/18/2026 2:38:38 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221628553727BUILDSchemaOK6/18/2026 2:38:38 PM [spSQLSupport.sql]: SQL Support procs and functions created.
221628553726BUILDSchemaOK6/18/2026 2:38:37 PM [spDocSupport.sql]: DocSupport procs and functions created.
221628553725BUILDSchemaOK6/18/2026 2:38:37 PM [spTestQueries.sql]: Testing harness installed
221628553724BUILDSchemaOK6/18/2026 2:38:36 PM [spCheckDB.sql]: Database checking procs created
221628553723BUILDSchemaOK6/18/2026 2:38:36 PM [spRegion.sql]: Created functions and procedures for the Region package
221628553722BUILDSchemaOK6/18/2026 2:38:35 PM [spCoordinate.sql]: Coordinate related functions and procedures created
221628553721BUILDSchemaOK6/18/2026 2:38:35 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221628553720BUILDSchemaOK6/18/2026 2:38:34 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
221628553719BUILDSchemaOK6/18/2026 2:38:33 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221628553718BUILDSchemaOK6/18/2026 2:38:32 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]
221628553717BUILDSchemaOK6/18/2026 2:38:31 PMCreated Spherical assembly in database TEST_ASTR1
221628553716BUILDSchemaOK6/18/2026 2:38:28 PM [LvmTables.sql]: LVM tables created
221628553715BUILDSchemaOK6/18/2026 2:38:28 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221628553714BUILDSchemaOK6/18/2026 2:38:25 PM [VacTables.sql]: VAC tables created
221628553713BUILDSchemaOK6/18/2026 2:38:24 PM [Views.sql]: Views created
221628553712BUILDSchemaOK6/18/2026 2:38:24 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221628553711BUILDSchemaOK6/18/2026 2:38:23 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221628553710BUILDSchemaOK6/18/2026 2:38:23 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221628553709BUILDSchemaOK6/18/2026 2:38:23 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
221628553708BUILDSchemaOK6/18/2026 2:38:22 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221628553707BUILDSchemaOK6/18/2026 2:38:22 PM [MastarTables.sql]: Mastar tables created
221628553706BUILDSchemaOK6/18/2026 2:38:22 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
221628553705BUILDSchemaOK6/18/2026 2:38:21 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
221628553704BUILDSchemaOK6/18/2026 2:38:20 PM [ApogeeTables.sql]: APOGEE tables created
221628553703BUILDSchemaOK6/18/2026 2:38:20 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221628553702BUILDSchemaOK6/18/2026 2:38:20 PM [WindowTables.sql]: Window tables and related views created
221628553701BUILDSchemaOK6/18/2026 2:38:19 PM [RegionTables.sql]: Created tables for Region package
221628553700BUILDSchemaOK6/18/2026 2:38:19 PM [TilingTables.sql]: Tiling tables and related views created
221628553699BUILDSchemaOK6/18/2026 2:38:19 PM [spSpectro.sql]: Spectro functions/sps created
221628553698BUILDSchemaOK6/18/2026 2:38:18 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
221628553697BUILDSchemaOK6/18/2026 2:38:17 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
221628553696BUILDSchemaOK6/18/2026 2:38:17 PM [NeighborTables.sql]: Neighbor and Match tables created
221628553695BUILDSchemaOK6/18/2026 2:38:16 PM [resolveTables.sql]: Resolve tables created
221628553694BUILDSchemaOK6/18/2026 2:38:16 PM [spPhoto.sql]: Photo procedures and functions created
221628553693BUILDSchemaOK6/18/2026 2:38:16 PM [galSpecTables.sql]: galSpec tables and related functions created
221628553692BUILDSchemaOK6/18/2026 2:38:15 PM [PhotoZTables.sql]: Photometric redshifts tables created
221628553691BUILDSchemaOK6/18/2026 2:38:15 PM [PhotoTables.sql]: Photo tables created
221628553690BUILDSchemaOK6/18/2026 2:38:14 PM [Versions.sql]: Versions table created
221628553689BUILDSchemaOK6/18/2026 2:38:14 PM [IndexMap.sql]: Index management tables and procedures built
221628553688BUILDSchemaOK6/18/2026 2:38:08 PM [MetadataTables.sql]: MetaData tables created
221628553687BUILDSchemaOK6/18/2026 2:38:08 PM [ConstantSupport.sql]: Constant support views and functions created
221628553686BUILDSchemaOK6/18/2026 2:38:05 PM [DataConstants.sql]: Constant tables created
221628553685BUILDSchemaOK6/18/2026 2:37:54 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221628553684BUILDSchemaOK6/18/2026 2:37:52 PMStarting schema creation for TEST_ASTR1 with partitioning=0
221628553683BUILDDatabaseOK6/18/2026 2:37:52 PMConfigured database TEST_ASTR1
221628553682BUILDDatabaseOK6/18/2026 2:37:52 PMCreated database TEST_ASTR1
221628553681BUILDDatabaseOK6/18/2026 2:36:03 PMStarting database creation
221628553680BUILDSTARTINGSTART6/18/2026 2:36:01 PMStarting DB build
221628543679CHECKFINISHINGDONE6/18/2026 2:35:53 PMFinished CSV checking
221628543678CHECKFile countOK6/18/2026 2:35:53 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
221628543677CHECKDir checkOK6/18/2026 2:35:53 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
221628543676CHECKOpen debug file OK6/18/2026 2:35:53 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
221628543675CHECKCheck backup folOK6/18/2026 2:35:53 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
221628543674CHECKCheck rootOK6/18/2026 2:35:53 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
221628543673CHECKSTARTINGSTART6/18/2026 2:35:52 PMStarting CSV check