Log - Task #2221
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
222129044295CLEANUPFINISHINGDONE7/7/2026 10:53:55 PMDeleted db TEST_ASTR1
222129044294CLEANUPSTARTINGSTART7/7/2026 10:53:53 PMStarting cleanup
222129024292PUBLISHFINISHINGDONE7/7/2026 10:53:53 PMPublished Astra astra from: sdss4c.TEST_ASTR1 to: sdss4c.BESTTEST
222129024291PUBLISHspPublishAstraOK7/7/2026 10:53:53 PMPublished Astra Tables
222129024290PUBLISHspPublishAstraOK7/7/2026 10:49:01 PMStarting spPublishAstra ft = 1
222129024288PUBLISHAttachOK7/7/2026 10:49:01 PMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
222129024286PUBLISHSTARTINGSTART7/7/2026 10:49:00 PMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
222129014285DETACHFINISHINGDONE7/7/2026 10:48:04 PMDetached Database TEST_ASTR1
222129014284DETACHSTARTINGSTART7/7/2026 10:48:02 PMStarting DB detach
222129004283BACKUPFINISHINGDONE7/7/2026 10:48:02 PMBacked up Database TEST_ASTR1 done to file \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
222129004282BACKUPBackupOK7/7/2026 10:48:02 PMBacked up Database TEST_ASTR1 done to file \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
222129004281BACKUPCheckpointOK7/7/2026 10:46:32 PMCheckpoint done
222129004280BACKUPShrinkDBOK7/7/2026 10:46:32 PMShrink DB done
222129004279BACKUPCheckpointOK7/7/2026 10:46:29 PMCheckpoint done
222129004278BACKUPSTARTINGSTART7/7/2026 10:46:29 PMBacking up astra database 1 to \\sdss4c\taskdbbackup\TEST_ASTR1_backup.dat
222128994277VALIDATEFINISHINGDONE7/7/2026 10:46:29 PMValidated Astra 1
222128994276VALIDATEspValidateAstraOK7/7/2026 10:46:29 PMAstra tables validated in 23.453 seconds
222128994275VALIDATEUnique key testOK7/7/2026 10:46:28 PMUnique key test passed on the_payne_apogee_visit(spectrum_PK)
222128994274VALIDATEUnique key testOK7/7/2026 10:46:28 PMUnique key test passed on the_payne_apogee_star(spectrum_PK)
222128994273VALIDATEUnique key testOK7/7/2026 10:46:28 PMUnique key test passed on the_cannon_apogee_star(spectrum_PK)
222128994272VALIDATEUnique key testOK7/7/2026 10:46:28 PMUnique key test passed on snow_white_boss_visit(spectrum_PK)
222128994271VALIDATEUnique key testOK7/7/2026 10:46:28 PMUnique key test passed on snow_white_boss_star(spectrum_PK)
222128994270VALIDATEUnique key testOK7/7/2026 10:46:27 PMUnique key test passed on slam_boss_star(spectrum_PK)
222128994269VALIDATEUnique key testOK7/7/2026 10:46:26 PMUnique key test passed on mwm_targets(sdss_id)
222128994268VALIDATEUnique key testOK7/7/2026 10:46:24 PMUnique key test passed on mwm_boss_allvisit(spectrum_PK)
222128994267VALIDATEUnique key testOK7/7/2026 10:46:22 PMUnique key test passed on mwm_boss_allstar(spectrum_PK)
222128994266VALIDATEUnique key testOK7/7/2026 10:46:21 PMUnique key test passed on mwm_apogee_allvisit(spectrum_PK)
222128994265VALIDATEUnique key testOK7/7/2026 10:46:21 PMUnique key test passed on mwm_apogee_allstar(spectrum_PK)
222128994264VALIDATEUnique key testOK7/7/2026 10:46:20 PMUnique key test passed on m_dwarf_type_boss_visit(spectrum_PK)
222128994263VALIDATEUnique key testOK7/7/2026 10:46:18 PMUnique key test passed on m_dwarf_type_boss_star(spectrum_PK)
222128994262VALIDATEUnique key testOK7/7/2026 10:46:17 PMUnique key test passed on lite_all_star(spectrum_PK)
222128994261VALIDATEUnique key testOK7/7/2026 10:46:17 PMUnique key test passed on line_forest_boss_visit(spectrum_PK)
222128994260VALIDATEUnique key testOK7/7/2026 10:46:14 PMUnique key test passed on line_forest_boss_star(spectrum_PK)
222128994259VALIDATEUnique key testOK7/7/2026 10:46:12 PMUnique key test passed on corv_boss_visit(spectrum_PK)
222128994258VALIDATEUnique key testOK7/7/2026 10:46:10 PMUnique key test passed on boss_net_boss_visit(spectrum_PK)
222128994257VALIDATEUnique key testOK7/7/2026 10:46:07 PMUnique key test passed on boss_net_boss_star(spectrum_PK)
222128994256VALIDATEUnique key testOK7/7/2026 10:46:05 PMUnique key test passed on astro_nn_dist_apogee_star(spectrum_PK)
222128994255VALIDATEUnique key testOK7/7/2026 10:46:05 PMUnique key test passed on astro_nn_apogee_visit(spectrum_PK)
222128994254VALIDATEUnique key testOK7/7/2026 10:46:05 PMUnique key test passed on astro_nn_apogee_star(spectrum_PK)
222128994253VALIDATEUnique key testOK7/7/2026 10:46:05 PMUnique key test passed on aspcap_apogee_star(spectrum_PK)
222128994252VALIDATEUnique key testOK7/7/2026 10:46:05 PMUnique key test passed on apogee_net_apogee_star(spectrum_PK)
222128994251VALIDATEspValidateAstraOK7/7/2026 10:46:05 PMspValidateAstra called
222128994250VALIDATESTARTINGSTART7/7/2026 10:46:05 PMValidating astra database 1
222128984249PRELOADFINISHINGDONE7/7/2026 10:46:05 PMFinished SQL preload
222128984248PRELOADSet valuesOK7/7/2026 10:46:05 PMloadVersion updated
222128984247PRELOADSet valuesOK7/7/2026 10:46:05 PMSetting loadVersion
222128984246PRELOADCSV loadOK7/7/2026 10:46:05 PMAll rows have been loaded
222128984245PRELOADCSV loadOK7/7/2026 10:46:05 PMAll files are loaded
222128984244PRELOADCSV loadOK7/7/2026 10:46:05 PMFinished File load
222128984243PRELOADCSV loadOK7/7/2026 9:05:48 PMStarting File load
222128984242PRELOADSTARTINGSTART7/7/2026 9:05:48 PMStarting SQL Preload
222128974241BUILDFINISHINGDONE7/7/2026 9:05:48 PMFinished building DB
222128974240BUILDSchemaOK7/7/2026 9:05:48 PMCreated Spherical assembly in database TEST_ASTR1
222128974239BUILDSchemaOK7/7/2026 9:05:48 PM [spCosmology.sql]: Cosmology functions and procedures created
222128974238BUILDSchemaOK7/7/2026 9:05:47 PM [spCopyDbSubset]: spCopyDbSubset installed
222128974237BUILDSchemaOK7/7/2026 9:05:46 PM [spFinish.sql]: spFinish procedures created
222128974236BUILDSchemaOK7/7/2026 9:05:45 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
222128974235BUILDSchemaOK7/7/2026 9:05:45 PM [spValidate.sql]: Data validation procedures created
222128974234BUILDSchemaOK7/7/2026 9:05:44 PM [spSetValues.qsl]: Set values procedures created
222128974233BUILDSchemaOK7/7/2026 9:05:44 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
222128974232BUILDSchemaOK7/7/2026 9:05:43 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
222128974231BUILDSchemaOK7/7/2026 9:05:43 PM [spSQLSupport.sql]: SQL Support procs and functions created.
222128974230BUILDSchemaOK7/7/2026 9:05:42 PM [spDocSupport.sql]: DocSupport procs and functions created.
222128974229BUILDSchemaOK7/7/2026 9:05:42 PM [spTestQueries.sql]: Testing harness installed
222128974228BUILDSchemaOK7/7/2026 9:05:42 PM [spCheckDB.sql]: Database checking procs created
222128974227BUILDSchemaOK7/7/2026 9:05:41 PM [spRegion.sql]: Created functions and procedures for the Region package
222128974226BUILDSchemaOK7/7/2026 9:05:40 PM [spCoordinate.sql]: Coordinate related functions and procedures created
222128974225BUILDSchemaOK7/7/2026 9:05:40 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
222128974224BUILDSchemaOK7/7/2026 9:05:39 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
222128974223BUILDSchemaOK7/7/2026 9:05:37 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
222128974222BUILDSchemaOK7/7/2026 9:05:37 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]
222128974221BUILDSchemaOK7/7/2026 9:05:36 PMCreated Spherical assembly in database TEST_ASTR1
222128974220BUILDSchemaOK7/7/2026 9:05:32 PM [LvmTables.sql]: LVM tables created
222128974219BUILDSchemaOK7/7/2026 9:05:32 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
222128974218BUILDSchemaOK7/7/2026 9:05:30 PM [VacTables.sql]: VAC tables created
222128974217BUILDSchemaOK7/7/2026 9:05:29 PM [Views.sql]: Views created
222128974216BUILDSchemaOK7/7/2026 9:05:28 PMosql -dTEST_ASTR1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
222128974215BUILDSchemaOK7/7/2026 9:05:28 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
222128974214BUILDSchemaOK7/7/2026 9:05:27 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
222128974213BUILDSchemaOK7/7/2026 9:05:27 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
222128974212BUILDSchemaOK7/7/2026 9:05:27 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
222128974211BUILDSchemaOK7/7/2026 9:05:26 PM [MastarTables.sql]: Mastar tables created
222128974210BUILDSchemaOK7/7/2026 9:05:26 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
222128974209BUILDSchemaOK7/7/2026 9:05:25 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
222128974208BUILDSchemaOK7/7/2026 9:05:24 PM [ApogeeTables.sql]: APOGEE tables created
222128974207BUILDSchemaOK7/7/2026 9:05:24 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
222128974206BUILDSchemaOK7/7/2026 9:05:23 PM [WindowTables.sql]: Window tables and related views created
222128974205BUILDSchemaOK7/7/2026 9:05:23 PM [RegionTables.sql]: Created tables for Region package
222128974204BUILDSchemaOK7/7/2026 9:05:23 PM [TilingTables.sql]: Tiling tables and related views created
222128974203BUILDSchemaOK7/7/2026 9:05:22 PM [spSpectro.sql]: Spectro functions/sps created
222128974202BUILDSchemaOK7/7/2026 9:05:21 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
222128974201BUILDSchemaOK7/7/2026 9:05:21 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
222128974200BUILDSchemaOK7/7/2026 9:05:20 PM [NeighborTables.sql]: Neighbor and Match tables created
222128974199BUILDSchemaOK7/7/2026 9:05:20 PM [resolveTables.sql]: Resolve tables created
222128974198BUILDSchemaOK7/7/2026 9:05:20 PM [spPhoto.sql]: Photo procedures and functions created
222128974197BUILDSchemaOK7/7/2026 9:05:19 PM [galSpecTables.sql]: galSpec tables and related functions created
222128974196BUILDSchemaOK7/7/2026 9:05:19 PM [PhotoZTables.sql]: Photometric redshifts tables created
222128974195BUILDSchemaOK7/7/2026 9:05:18 PM [PhotoTables.sql]: Photo tables created
222128974194BUILDSchemaOK7/7/2026 9:05:17 PM [Versions.sql]: Versions table created
222128974193BUILDSchemaOK7/7/2026 9:05:17 PM [IndexMap.sql]: Index management tables and procedures built
222128974192BUILDSchemaOK7/7/2026 9:05:11 PM [MetadataTables.sql]: MetaData tables created
222128974191BUILDSchemaOK7/7/2026 9:05:10 PM [ConstantSupport.sql]: Constant support views and functions created
222128974190BUILDSchemaOK7/7/2026 9:05:08 PM [DataConstants.sql]: Constant tables created
222128974189BUILDSchemaOK7/7/2026 9:04:56 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
222128974188BUILDSchemaOK7/7/2026 9:04:55 PMStarting schema creation for TEST_ASTR1 with partitioning=0
222128974187BUILDDatabaseOK7/7/2026 9:04:55 PMConfigured database TEST_ASTR1
222128974186BUILDDatabaseOK7/7/2026 9:04:54 PMCreated database TEST_ASTR1
222128974185BUILDDatabaseOK7/7/2026 9:03:02 PMStarting database creation
222128974184BUILDSTARTINGSTART7/7/2026 9:03:00 PMStarting DB build
222128964183CHECKFINISHINGDONE7/7/2026 9:02:59 PMFinished CSV checking
222128964182CHECKFile countOK7/7/2026 9:02:58 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Number of CSV files is 12
222128964181CHECKDir checkOK7/7/2026 9:02:58 PMD:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1:Checking directory
222128964180CHECKOpen debug file OK7/7/2026 9:02:58 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:File opened
222128964179CHECKCheck backup folOK7/7/2026 9:02:58 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Folder exists
222128964178CHECKCheck rootOK7/7/2026 9:02:58 PMd:\sql_db\staging\sdss5\casload\dr20\asCSV\astra\1\:Found root directory
222128964177CHECKSTARTINGSTART7/7/2026 9:02:57 PMStarting CSV check