Log - Task #2218
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221828864044CLEANUPFINISHINGDONE6/19/2026 2:06:32 PMDeleted db TEST_ALLS1
221828864043CLEANUPSTARTINGSTART6/19/2026 2:06:32 PMStarting cleanup
221828844041PUBLISHFINISHINGDONE6/19/2026 2:06:32 PMPublished Allspec allspec from: sdss4c.TEST_ALLS1 to: sdss4c.BESTTEST
221828844040PUBLISHspPublishAllspecOK6/19/2026 2:06:32 PMPublished Allspec Tables
221828844039PUBLISHTableCopyOK6/19/2026 2:06:32 PM published 27671504 rows of table TEST_ALLS1.dbo.allspec to table BESTTEST.dbo.allspec
221828844038PUBLISHTableCopyOK6/19/2026 2:05:02 PM published 54297 rows of table TEST_ALLS1.dbo.multiplex to table BESTTEST.dbo.multiplex
221828844037PUBLISHspPublishAllspecOK6/19/2026 2:05:01 PMStarting spPublishAllspec
221828844035PUBLISHAttachOK6/19/2026 2:05:01 PMSuccessfully attached sdss4c.TEST_ALLS1 in file: d:\sql_db\TEST_ALLS1_Data.MDF
221828844033PUBLISHSTARTINGSTART6/19/2026 2:05:01 PMPublishing allspec sdss4c.TEST_ALLS1 to sdss4c.BESTTEST
221828834032DETACHFINISHINGDONE6/19/2026 2:04:25 PMDetached Database TEST_ALLS1
221828834031DETACHSTARTINGSTART6/19/2026 2:04:24 PMStarting DB detach
221828824030BACKUPFINISHINGDONE6/19/2026 2:04:24 PMBacked up Database TEST_ALLS1 done to file \\sdss4c\taskdbbackup\TEST_ALLS1_backup.dat
221828824029BACKUPBackupOK6/19/2026 2:04:24 PMBacked up Database TEST_ALLS1 done to file \\sdss4c\taskdbbackup\TEST_ALLS1_backup.dat
221828824028BACKUPCheckpointOK6/19/2026 2:03:56 PMCheckpoint done
221828824027BACKUPShrinkDBOK6/19/2026 2:03:56 PMShrink DB done
221828824026BACKUPCheckpointOK6/19/2026 2:03:49 PMCheckpoint done
221828824025BACKUPSTARTINGSTART6/19/2026 2:03:49 PMBacking up allspec database 1 to \\sdss4c\taskdbbackup\TEST_ALLS1_backup.dat
221828814024VALIDATEFINISHINGDONE6/19/2026 2:03:49 PMValidated Allspec 1
221828814023VALIDATEspValidateAllspeOK6/19/2026 2:03:49 PMAllspec tables validated in 32.503 seconds
221828814022VALIDATEUnique key testOK6/19/2026 2:03:49 PMUnique key test passed on allspec(allspec_id)
221828814021VALIDATEUnique key testOK6/19/2026 2:03:17 PMUnique key test passed on multiplex(multiplex_id)
221828814020VALIDATEspValidateAllspeOK6/19/2026 2:03:16 PMspValidateEboss called
221828814019VALIDATESTARTINGSTART6/19/2026 2:03:16 PMValidating allspec database 1
221828804018PRELOADFINISHINGDONE6/19/2026 2:03:16 PMFinished SQL preload
221828804017PRELOADSet valuesOK6/19/2026 2:03:16 PMloadVersion updated
221828804016PRELOADSet valuesOK6/19/2026 2:03:16 PMSetting loadVersion
221828804015PRELOADCSV loadOK6/19/2026 2:03:16 PMAll rows have been loaded
221828804014PRELOADCSV loadOK6/19/2026 2:03:16 PMAll files are loaded
221828804013PRELOADCSV loadOK6/19/2026 2:03:16 PMFinished File load
221828804012PRELOADCSV loadOK6/19/2026 1:55:42 PMStarting File load
221828804011PRELOADSTARTINGSTART6/19/2026 1:55:42 PMStarting SQL Preload
221828794010BUILDFINISHINGDONE6/19/2026 1:55:42 PMFinished building DB
221828794009BUILDSchemaOK6/19/2026 1:55:42 PMCreated Spherical assembly in database TEST_ALLS1
221828794008BUILDSchemaOK6/19/2026 1:55:42 PM [spCosmology.sql]: Cosmology functions and procedures created
221828794007BUILDSchemaOK6/19/2026 1:55:41 PM [spCopyDbSubset]: spCopyDbSubset installed
221828794006BUILDSchemaOK6/19/2026 1:55:41 PM [spFinish.sql]: spFinish procedures created
221828794005BUILDSchemaOK6/19/2026 1:55: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
221828794004BUILDSchemaOK6/19/2026 1:55:39 PM [spValidate.sql]: Data validation procedures created
221828794003BUILDSchemaOK6/19/2026 1:55:39 PM [spSetValues.qsl]: Set values procedures created
221828794002BUILDSchemaOK6/19/2026 1:55:38 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
221828794001BUILDSchemaOK6/19/2026 1:55:38 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221828794000BUILDSchemaOK6/19/2026 1:55:37 PM [spSQLSupport.sql]: SQL Support procs and functions created.
221828793999BUILDSchemaOK6/19/2026 1:55:37 PM [spDocSupport.sql]: DocSupport procs and functions created.
221828793998BUILDSchemaOK6/19/2026 1:55:37 PM [spTestQueries.sql]: Testing harness installed
221828793997BUILDSchemaOK6/19/2026 1:55:36 PM [spCheckDB.sql]: Database checking procs created
221828793996BUILDSchemaOK6/19/2026 1:55:36 PM [spRegion.sql]: Created functions and procedures for the Region package
221828793995BUILDSchemaOK6/19/2026 1:55:35 PM [spCoordinate.sql]: Coordinate related functions and procedures created
221828793994BUILDSchemaOK6/19/2026 1:55:34 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221828793993BUILDSchemaOK6/19/2026 1:55: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
221828793992BUILDSchemaOK6/19/2026 1:55:32 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221828793991BUILDSchemaOK6/19/2026 1:55:31 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]
221828793990BUILDSchemaOK6/19/2026 1:55:31 PMCreated Spherical assembly in database TEST_ALLS1
221828793989BUILDSchemaOK6/19/2026 1:55:27 PM [LvmTables.sql]: LVM tables created
221828793988BUILDSchemaOK6/19/2026 1:55:27 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221828793987BUILDSchemaOK6/19/2026 1:55:24 PM [VacTables.sql]: VAC tables created
221828793986BUILDSchemaOK6/19/2026 1:55:23 PM [Views.sql]: Views created
221828793985BUILDSchemaOK6/19/2026 1:55:22 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221828793984BUILDSchemaOK6/19/2026 1:55:22 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221828793983BUILDSchemaOK6/19/2026 1:55:22 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221828793982BUILDSchemaOK6/19/2026 1:55:21 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
221828793981BUILDSchemaOK6/19/2026 1:55:21 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221828793980BUILDSchemaOK6/19/2026 1:55:21 PM [MastarTables.sql]: Mastar tables created
221828793979BUILDSchemaOK6/19/2026 1:55:20 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
221828793978BUILDSchemaOK6/19/2026 1:55:20 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
221828793977BUILDSchemaOK6/19/2026 1:55:19 PM [ApogeeTables.sql]: APOGEE tables created
221828793976BUILDSchemaOK6/19/2026 1:55:18 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221828793975BUILDSchemaOK6/19/2026 1:55:18 PM [WindowTables.sql]: Window tables and related views created
221828793974BUILDSchemaOK6/19/2026 1:55:17 PM [RegionTables.sql]: Created tables for Region package
221828793973BUILDSchemaOK6/19/2026 1:55:17 PM [TilingTables.sql]: Tiling tables and related views created
221828793972BUILDSchemaOK6/19/2026 1:55:17 PM [spSpectro.sql]: Spectro functions/sps created
221828793971BUILDSchemaOK6/19/2026 1:55:16 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
221828793970BUILDSchemaOK6/19/2026 1:55:15 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
221828793969BUILDSchemaOK6/19/2026 1:55:15 PM [NeighborTables.sql]: Neighbor and Match tables created
221828793968BUILDSchemaOK6/19/2026 1:55:14 PM [resolveTables.sql]: Resolve tables created
221828793967BUILDSchemaOK6/19/2026 1:55:14 PM [spPhoto.sql]: Photo procedures and functions created
221828793966BUILDSchemaOK6/19/2026 1:55:14 PM [galSpecTables.sql]: galSpec tables and related functions created
221828793965BUILDSchemaOK6/19/2026 1:55:13 PM [PhotoZTables.sql]: Photometric redshifts tables created
221828793964BUILDSchemaOK6/19/2026 1:55:13 PM [PhotoTables.sql]: Photo tables created
221828793963BUILDSchemaOK6/19/2026 1:55:12 PM [Versions.sql]: Versions table created
221828793962BUILDSchemaOK6/19/2026 1:55:12 PM [IndexMap.sql]: Index management tables and procedures built
221828793961BUILDSchemaOK6/19/2026 1:55:06 PM [MetadataTables.sql]: MetaData tables created
221828793960BUILDSchemaOK6/19/2026 1:55:06 PM [ConstantSupport.sql]: Constant support views and functions created
221828793959BUILDSchemaOK6/19/2026 1:55:03 PM [DataConstants.sql]: Constant tables created
221828793958BUILDSchemaOK6/19/2026 1:54:52 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221828793957BUILDSchemaOK6/19/2026 1:54:50 PMStarting schema creation for TEST_ALLS1 with partitioning=0
221828793956BUILDDatabaseOK6/19/2026 1:54:50 PMConfigured database TEST_ALLS1
221828793955BUILDDatabaseOK6/19/2026 1:54:50 PMCreated database TEST_ALLS1
221828793954BUILDDatabaseOK6/19/2026 1:53:01 PMStarting database creation
221828793953BUILDSTARTINGSTART6/19/2026 1:53:00 PMStarting DB build
221828783952CHECKFINISHINGDONE6/19/2026 1:52:14 PMFinished CSV checking
221828783951CHECKFile countOK6/19/2026 1:52:14 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Number of CSV files is 2
221828783950CHECKDir checkOK6/19/2026 1:52:14 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Checking directory
221828783949CHECKOpen debug file OK6/19/2026 1:52:14 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:File opened
221828783948CHECKCheck backup folOK6/19/2026 1:52:14 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Folder exists
221828783947CHECKCheck rootOK6/19/2026 1:52:14 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Found root directory
221828783946CHECKSTARTINGSTART6/19/2026 1:52:14 PMStarting CSV check