Log - Task #2211
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
221128373456CLEANUPFINISHINGDONE6/17/2026 11:37:59 AMDeleted db TEST_EBOS1
221128373455CLEANUPSTARTINGSTART6/17/2026 11:37:59 AMStarting cleanup
221128353453PUBLISHFINISHINGDONE6/17/2026 11:37:59 AMPublished eBOSS eboss from: sdss4c.TEST_EBOS1 to: sdss4c.BESTTEST
221128353452PUBLISHspPublishEbossOK6/17/2026 11:37:58 AMPublished Eboss Tables
221128353451PUBLISHTableCopyOK6/17/2026 11:37:58 AM published 4903154 rows of table TEST_EBOS1.dbo.spAll_epoch to table BESTTEST.dbo.spAll_epoch
221128353450PUBLISHTableCopyOK6/17/2026 11:37:09 AM published 506550 rows of table TEST_EBOS1.dbo.spAll_allepoch to table BESTTEST.dbo.spAll_allepoch
221128353449PUBLISHTableCopyOK6/17/2026 11:37:01 AM published 0 rows of table TEST_EBOS1.dbo.spAll to table BESTTEST.dbo.spAll
221128353448PUBLISHspPublishEbossOK6/17/2026 11:37:01 AMStarting spPublishEboss
221128353446PUBLISHAttachOK6/17/2026 11:37:01 AMSuccessfully attached sdss4c.TEST_EBOS1 in file: d:\sql_db\TEST_EBOS1_Data.MDF
221128353444PUBLISHSTARTINGSTART6/17/2026 11:37:00 AMPublishing eboss sdss4c.TEST_EBOS1 to sdss4c.BESTTEST
221128343443DETACHFINISHINGDONE6/17/2026 11:36:57 AMDetached Database TEST_EBOS1
221128343442DETACHSTARTINGSTART6/17/2026 11:36:56 AMStarting DB detach
221128333441BACKUPFINISHINGDONE6/17/2026 11:36:56 AMBacked up Database TEST_EBOS1 done to file \\sdss4c\taskdbbackup\TEST_EBOS1_backup.dat
221128333440BACKUPBackupOK6/17/2026 11:36:56 AMBacked up Database TEST_EBOS1 done to file \\sdss4c\taskdbbackup\TEST_EBOS1_backup.dat
221128333439BACKUPCheckpointOK6/17/2026 11:36:20 AMCheckpoint done
221128333438BACKUPShrinkDBOK6/17/2026 11:36:20 AMShrink DB done
221128333437BACKUPCheckpointOK6/17/2026 11:36:19 AMCheckpoint done
221128333436BACKUPSTARTINGSTART6/17/2026 11:36:19 AMBacking up eboss database 1 to \\sdss4c\taskdbbackup\TEST_EBOS1_backup.dat
221128323435VALIDATEFINISHINGDONE6/17/2026 11:36:19 AMValidated eBOSS 1
221128323434VALIDATEspValidateEbossOK6/17/2026 11:36:19 AMeBOSS tables validated in 3.017 seconds
221128323433VALIDATEUnique key testOK6/17/2026 11:36:19 AMUnique key test passed on spAll(specobjid)
221128323432VALIDATEspValidateEbossOK6/17/2026 11:36:16 AMspValidateEboss called
221128323431VALIDATESTARTINGSTART6/17/2026 11:36:16 AMValidating eboss database 1
221128313430PRELOADFINISHINGDONE6/17/2026 11:36:16 AMFinished SQL preload
221128313429PRELOADSet valuesOK6/17/2026 11:36:16 AMloadVersion updated
221128313428PRELOADSet valuesOK6/17/2026 11:36:16 AMSetting loadVersion
221128313427PRELOADCSV loadOK6/17/2026 11:36:16 AMAll rows have been loaded
221128313426PRELOADCSV loadOK6/17/2026 11:36:16 AMAll files are loaded
221128313425PRELOADCSV loadOK6/17/2026 11:36:16 AMFinished File load
221128313424PRELOADCSV loadOK6/17/2026 11:10:34 AMStarting File load
221128313423PRELOADSTARTINGSTART6/17/2026 11:10:34 AMStarting SQL Preload
221128303422BUILDFINISHINGDONE6/17/2026 11:10:34 AMFinished building DB
221128303421BUILDSchemaOK6/17/2026 11:10:34 AMCreated Spherical assembly in database TEST_EBOS1
221128303420BUILDSchemaOK6/17/2026 11:10:34 AM [spCosmology.sql]: Cosmology functions and procedures created
221128303419BUILDSchemaOK6/17/2026 11:10:33 AM [spCopyDbSubset]: spCopyDbSubset installed
221128303418BUILDSchemaOK6/17/2026 11:10:33 AM [spFinish.sql]: spFinish procedures created
221128303417BUILDSchemaOK6/17/2026 11:10:32 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
221128303416BUILDSchemaOK6/17/2026 11:10:31 AM [spValidate.sql]: Data validation procedures created
221128303415BUILDSchemaOK6/17/2026 11:10:30 AM [spSetValues.qsl]: Set values procedures created
221128303414BUILDSchemaOK6/17/2026 11:10:30 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
221128303413BUILDSchemaOK6/17/2026 11:10:30 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
221128303412BUILDSchemaOK6/17/2026 11:10:29 AM [spSQLSupport.sql]: SQL Support procs and functions created.
221128303411BUILDSchemaOK6/17/2026 11:10:29 AM [spDocSupport.sql]: DocSupport procs and functions created.
221128303410BUILDSchemaOK6/17/2026 11:10:28 AM [spTestQueries.sql]: Testing harness installed
221128303409BUILDSchemaOK6/17/2026 11:10:28 AM [spCheckDB.sql]: Database checking procs created
221128303408BUILDSchemaOK6/17/2026 11:10:27 AM [spRegion.sql]: Created functions and procedures for the Region package
221128303407BUILDSchemaOK6/17/2026 11:10:27 AM [spCoordinate.sql]: Coordinate related functions and procedures created
221128303406BUILDSchemaOK6/17/2026 11:10:26 AMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
221128303405BUILDSchemaOK6/17/2026 11:10:25 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
221128303404BUILDSchemaOK6/17/2026 11:10:24 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
221128303403BUILDSchemaOK6/17/2026 11:10:23 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]
221128303402BUILDSchemaOK6/17/2026 11:10:22 AMCreated Spherical assembly in database TEST_EBOS1
221128303401BUILDSchemaOK6/17/2026 11:10:19 AM [LvmTables.sql]: LVM tables created
221128303400BUILDSchemaOK6/17/2026 11:10:19 AMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
221128303399BUILDSchemaOK6/17/2026 11:10:16 AM [VacTables.sql]: VAC tables created
221128303398BUILDSchemaOK6/17/2026 11:10:15 AM [Views.sql]: Views created
221128303397BUILDSchemaOK6/17/2026 11:10:14 AMosql -dTEST_EBOS1 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
221128303396BUILDSchemaOK6/17/2026 11:10:14 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
221128303395BUILDSchemaOK6/17/2026 11:10:14 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
221128303394BUILDSchemaOK6/17/2026 11:10:13 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
221128303393BUILDSchemaOK6/17/2026 11:10:13 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
221128303392BUILDSchemaOK6/17/2026 11:10:13 AM [MastarTables.sql]: Mastar tables created
221128303391BUILDSchemaOK6/17/2026 11:10:12 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
221128303390BUILDSchemaOK6/17/2026 11:10:12 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
221128303389BUILDSchemaOK6/17/2026 11:10:11 AM [ApogeeTables.sql]: APOGEE tables created
221128303388BUILDSchemaOK6/17/2026 11:10:10 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
221128303387BUILDSchemaOK6/17/2026 11:10:10 AM [WindowTables.sql]: Window tables and related views created
221128303386BUILDSchemaOK6/17/2026 11:10:09 AM [RegionTables.sql]: Created tables for Region package
221128303385BUILDSchemaOK6/17/2026 11:10:09 AM [TilingTables.sql]: Tiling tables and related views created
221128303384BUILDSchemaOK6/17/2026 11:10:09 AM [spSpectro.sql]: Spectro functions/sps created
221128303383BUILDSchemaOK6/17/2026 11:10:08 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
221128303382BUILDSchemaOK6/17/2026 11:10:07 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
221128303381BUILDSchemaOK6/17/2026 11:10:07 AM [NeighborTables.sql]: Neighbor and Match tables created
221128303380BUILDSchemaOK6/17/2026 11:10:06 AM [resolveTables.sql]: Resolve tables created
221128303379BUILDSchemaOK6/17/2026 11:10:06 AM [spPhoto.sql]: Photo procedures and functions created
221128303378BUILDSchemaOK6/17/2026 11:10:05 AM [galSpecTables.sql]: galSpec tables and related functions created
221128303377BUILDSchemaOK6/17/2026 11:10:05 AM [PhotoZTables.sql]: Photometric redshifts tables created
221128303376BUILDSchemaOK6/17/2026 11:10:05 AM [PhotoTables.sql]: Photo tables created
221128303375BUILDSchemaOK6/17/2026 11:10:04 AM [Versions.sql]: Versions table created
221128303374BUILDSchemaOK6/17/2026 11:10:04 AM [IndexMap.sql]: Index management tables and procedures built
221128303373BUILDSchemaOK6/17/2026 11:09:58 AM [MetadataTables.sql]: MetaData tables created
221128303372BUILDSchemaOK6/17/2026 11:09:57 AM [ConstantSupport.sql]: Constant support views and functions created
221128303371BUILDSchemaOK6/17/2026 11:09:55 AM [DataConstants.sql]: Constant tables created
221128303370BUILDSchemaOK6/17/2026 11:09:43 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
221128303369BUILDSchemaOK6/17/2026 11:09:42 AMStarting schema creation for TEST_EBOS1 with partitioning=0
221128303368BUILDDatabaseOK6/17/2026 11:09:42 AMConfigured database TEST_EBOS1
221128303367BUILDDatabaseOK6/17/2026 11:09:41 AMCreated database TEST_EBOS1
221128303366BUILDDatabaseOK6/17/2026 11:08:01 AMStarting database creation
221128303365BUILDSTARTINGSTART6/17/2026 11:08:01 AMStarting DB build
221128293364CHECKFINISHINGDONE6/17/2026 11:07:06 AMFinished CSV checking
221128293363CHECKFile countOK6/17/2026 11:07:06 AMD:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1:Number of CSV files is 3
221128293362CHECKDir checkOK6/17/2026 11:07:06 AMD:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1:Checking directory
221128293361CHECKOpen debug file OK6/17/2026 11:07:06 AMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:File opened
221128293360CHECKCheck backup folOK6/17/2026 11:07:06 AMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:Folder exists
221128293359CHECKCheck rootOK6/17/2026 11:07:06 AMd:\sql_db\staging\sdss5\casload\dr20\ebCSV\eboss\1\:Found root directory
221128293358CHECKSTARTINGSTART6/17/2026 11:07:05 AMStarting CSV check