Log - Task #2208
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
220828193223CLEANUPFINISHINGDONE6/15/2026 12:31:41 PMDeleted db TEST_ALLS1
220828193222CLEANUPSTARTINGSTART6/15/2026 12:31:41 PMStarting cleanup
220828173220PUBLISHFINISHINGDONE6/15/2026 12:31:41 PMPublished Allspec allspec from: sdss4c.TEST_ALLS1 to: sdss4c.BESTTEST
220828173219PUBLISHspPublishAllspecOK6/15/2026 12:31:41 PMPublished Allspec Tables
220828173218PUBLISHTableCopyOK6/15/2026 12:31:41 PM published 27671504 rows of table TEST_ALLS1.dbo.allspec to table BESTTEST.dbo.allspec
220828173217PUBLISHTableCopyOK6/15/2026 12:30:03 PM published 54297 rows of table TEST_ALLS1.dbo.multiplex to table BESTTEST.dbo.multiplex
220828173216PUBLISHspPublishAllspecOK6/15/2026 12:30:01 PMStarting spPublishAllspec
220828173214PUBLISHAttachOK6/15/2026 12:30:01 PMSuccessfully attached sdss4c.TEST_ALLS1 in file: d:\sql_db\TEST_ALLS1_Data.MDF
220828173212PUBLISHSTARTINGSTART6/15/2026 12:30:01 PMPublishing allspec sdss4c.TEST_ALLS1 to sdss4c.BESTTEST
220828163211DETACHFINISHINGDONE6/15/2026 12:29:25 PMDetached Database TEST_ALLS1
220828163210DETACHSTARTINGSTART6/15/2026 12:29:23 PMStarting DB detach
220828153209BACKUPFINISHINGDONE6/15/2026 12:29:23 PMBacked up Database TEST_ALLS1 done to file \\sdss4c\taskdbbackup\TEST_ALLS1_backup.dat
220828153208BACKUPBackupOK6/15/2026 12:29:23 PMBacked up Database TEST_ALLS1 done to file \\sdss4c\taskdbbackup\TEST_ALLS1_backup.dat
220828153207BACKUPCheckpointOK6/15/2026 12:28:44 PMCheckpoint done
220828153206BACKUPShrinkDBOK6/15/2026 12:28:44 PMShrink DB done
220828153205BACKUPCheckpointOK6/15/2026 12:28:42 PMCheckpoint done
220828153204BACKUPSTARTINGSTART6/15/2026 12:28:42 PMBacking up allspec database 1 to \\sdss4c\taskdbbackup\TEST_ALLS1_backup.dat
220828143203VALIDATEFINISHINGDONE6/15/2026 12:28:42 PMValidated Allspec 1
220828143202VALIDATEspValidateAllspeOK6/15/2026 12:28:42 PMAllspec tables validated in 28.983 seconds
220828143201VALIDATEUnique key testOK6/15/2026 12:28:42 PMUnique key test passed on allspec(allspec_id)
220828143200VALIDATEUnique key testOK6/15/2026 12:28:14 PMUnique key test passed on multiplex(multiplex_id)
220828143199VALIDATEspValidateAllspeOK6/15/2026 12:28:13 PMspValidateEboss called
220828143198VALIDATESTARTINGSTART6/15/2026 12:28:13 PMValidating allspec database 1
220828133197PRELOADFINISHINGDONE6/15/2026 12:28:13 PMFinished SQL preload
220828133196PRELOADSet valuesOK6/15/2026 12:28:13 PMloadVersion updated
220828133195PRELOADSet valuesOK6/15/2026 12:28:13 PMSetting loadVersion
220828133194PRELOADCSV loadOK6/15/2026 12:28:13 PMAll rows have been loaded
220828133193PRELOADCSV loadOK6/15/2026 12:28:13 PMAll files are loaded
220828133192PRELOADCSV loadOK6/15/2026 12:28:13 PMFinished File load
220828133191PRELOADCSV loadOK6/15/2026 12:21:36 PMStarting File load
220828133190PRELOADSTARTINGSTART6/15/2026 12:21:36 PMStarting SQL Preload
220828123189BUILDFINISHINGDONE6/15/2026 12:21:36 PMFinished building DB
220828123188BUILDSchemaOK6/15/2026 12:21:36 PMCreated Spherical assembly in database TEST_ALLS1
220828123187BUILDSchemaOK6/15/2026 12:21:36 PM [spCosmology.sql]: Cosmology functions and procedures created
220828123186BUILDSchemaOK6/15/2026 12:21:35 PM [spCopyDbSubset]: spCopyDbSubset installed
220828123185BUILDSchemaOK6/15/2026 12:21:35 PM [spFinish.sql]: spFinish procedures created
220828123184BUILDSchemaOK6/15/2026 12:21:34 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
220828123183BUILDSchemaOK6/15/2026 12:21:33 PM [spValidate.sql]: Data validation procedures created
220828123182BUILDSchemaOK6/15/2026 12:21:32 PM [spSetValues.qsl]: Set values procedures created
220828123181BUILDSchemaOK6/15/2026 12:21:32 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
220828123180BUILDSchemaOK6/15/2026 12:21:32 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
220828123179BUILDSchemaOK6/15/2026 12:21:31 PM [spSQLSupport.sql]: SQL Support procs and functions created.
220828123178BUILDSchemaOK6/15/2026 12:21:31 PM [spDocSupport.sql]: DocSupport procs and functions created.
220828123177BUILDSchemaOK6/15/2026 12:21:30 PM [spTestQueries.sql]: Testing harness installed
220828123176BUILDSchemaOK6/15/2026 12:21:30 PM [spCheckDB.sql]: Database checking procs created
220828123175BUILDSchemaOK6/15/2026 12:21:29 PM [spRegion.sql]: Created functions and procedures for the Region package
220828123174BUILDSchemaOK6/15/2026 12:21:29 PM [spCoordinate.sql]: Coordinate related functions and procedures created
220828123173BUILDSchemaOK6/15/2026 12:21:28 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
220828123172BUILDSchemaOK6/15/2026 12:21:27 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
220828123171BUILDSchemaOK6/15/2026 12:21:26 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
220828123170BUILDSchemaOK6/15/2026 12:21:25 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]
220828123169BUILDSchemaOK6/15/2026 12:21:24 PMCreated Spherical assembly in database TEST_ALLS1
220828123168BUILDSchemaOK6/15/2026 12:21:20 PM [LvmTables.sql]: LVM tables created
220828123167BUILDSchemaOK6/15/2026 12:21:20 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
220828123166BUILDSchemaOK6/15/2026 12:21:17 PM [VacTables.sql]: VAC tables created
220828123165BUILDSchemaOK6/15/2026 12:21:16 PM [Views.sql]: Views created
220828123164BUILDSchemaOK6/15/2026 12:21:15 PMosql -dTEST_ALLS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
220828123163BUILDSchemaOK6/15/2026 12:21:15 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
220828123162BUILDSchemaOK6/15/2026 12:21:15 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
220828123161BUILDSchemaOK6/15/2026 12:21:14 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
220828123160BUILDSchemaOK6/15/2026 12:21:14 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
220828123159BUILDSchemaOK6/15/2026 12:21:14 PM [MastarTables.sql]: Mastar tables created
220828123158BUILDSchemaOK6/15/2026 12:21:13 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
220828123157BUILDSchemaOK6/15/2026 12:21:13 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
220828123156BUILDSchemaOK6/15/2026 12:21:11 PM [ApogeeTables.sql]: APOGEE tables created
220828123155BUILDSchemaOK6/15/2026 12:21:11 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
220828123154BUILDSchemaOK6/15/2026 12:21:10 PM [WindowTables.sql]: Window tables and related views created
220828123153BUILDSchemaOK6/15/2026 12:21:10 PM [RegionTables.sql]: Created tables for Region package
220828123152BUILDSchemaOK6/15/2026 12:21:10 PM [TilingTables.sql]: Tiling tables and related views created
220828123151BUILDSchemaOK6/15/2026 12:21:09 PM [spSpectro.sql]: Spectro functions/sps created
220828123150BUILDSchemaOK6/15/2026 12:21:08 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
220828123149BUILDSchemaOK6/15/2026 12:21:07 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
220828123148BUILDSchemaOK6/15/2026 12:21:07 PM [NeighborTables.sql]: Neighbor and Match tables created
220828123147BUILDSchemaOK6/15/2026 12:21:06 PM [resolveTables.sql]: Resolve tables created
220828123146BUILDSchemaOK6/15/2026 12:21:06 PM [spPhoto.sql]: Photo procedures and functions created
220828123145BUILDSchemaOK6/15/2026 12:21:05 PM [galSpecTables.sql]: galSpec tables and related functions created
220828123144BUILDSchemaOK6/15/2026 12:21:05 PM [PhotoZTables.sql]: Photometric redshifts tables created
220828123143BUILDSchemaOK6/15/2026 12:21:05 PM [PhotoTables.sql]: Photo tables created
220828123142BUILDSchemaOK6/15/2026 12:21:04 PM [Versions.sql]: Versions table created
220828123141BUILDSchemaOK6/15/2026 12:21:03 PM [IndexMap.sql]: Index management tables and procedures built
220828123140BUILDSchemaOK6/15/2026 12:20:57 PM [MetadataTables.sql]: MetaData tables created
220828123139BUILDSchemaOK6/15/2026 12:20:57 PM [ConstantSupport.sql]: Constant support views and functions created
220828123138BUILDSchemaOK6/15/2026 12:20:54 PM [DataConstants.sql]: Constant tables created
220828123137BUILDSchemaOK6/15/2026 12:20:42 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
220828123136BUILDSchemaOK6/15/2026 12:20:40 PMStarting schema creation for TEST_ALLS1 with partitioning=0
220828123135BUILDDatabaseOK6/15/2026 12:20:40 PMConfigured database TEST_ALLS1
220828123134BUILDDatabaseOK6/15/2026 12:20:40 PMCreated database TEST_ALLS1
220828123133BUILDDatabaseOK6/15/2026 12:19:01 PMStarting database creation
220828123132BUILDSTARTINGSTART6/15/2026 12:19:00 PMStarting DB build
220828113131CHECKFINISHINGDONE6/15/2026 12:18:56 PMFinished CSV checking
220828113130CHECKFile countOK6/15/2026 12:18:56 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Number of CSV files is 2
220828113129CHECKDir checkOK6/15/2026 12:18:56 PMD:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1:Checking directory
220828113128CHECKOpen debug file OK6/15/2026 12:18:56 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:File opened
220828113127CHECKCheck backup folOK6/15/2026 12:18:56 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Folder exists
220828113126CHECKCheck rootOK6/15/2026 12:18:56 PMd:\sql_db\staging\sdss5\casload\dr20\acCSV\allspec\1\:Found root directory
220828113125CHECKSTARTINGSTART6/15/2026 12:18:55 PMStarting CSV check