Log - Task #2246
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
224629926106PRELOADCSV loadOK7/22/2026 2:38:08 PMStarting File load
224629926105PRELOADSTARTINGSTART7/22/2026 2:38:08 PMStarting SQL Preload
224629916104BUILDFINISHINGDONE7/22/2026 2:38:08 PMFinished building DB
224629916103BUILDSchemaOK7/22/2026 2:38:08 PMCreated Spherical assembly in database TEST_DR201
224629916102BUILDSchemaOK7/22/2026 2:38:08 PM [spCosmology.sql]: Cosmology functions and procedures created
224629916101BUILDSchemaOK7/22/2026 2:38:07 PM [spCopyDbSubset]: spCopyDbSubset installed
224629916100BUILDSchemaOK7/22/2026 2:38:07 PM [spFinish.sql]: spFinish procedures created
224629916099BUILDSchemaOK7/22/2026 2:38:06 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
224629916098BUILDSchemaOK7/22/2026 2:38:06 PM [spValidate.sql]: Data validation procedures created
224629916097BUILDSchemaOK7/22/2026 2:38:05 PM [spSetValues.qsl]: Set values procedures created
224629916096BUILDSchemaOK7/22/2026 2:38:05 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
224629916095BUILDSchemaOK7/22/2026 2:38:04 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
224629916094BUILDSchemaOK7/22/2026 2:38:04 PM [spSQLSupport.sql]: SQL Support procs and functions created.
224629916093BUILDSchemaOK7/22/2026 2:38:04 PM [spDocSupport.sql]: DocSupport procs and functions created.
224629916092BUILDSchemaOK7/22/2026 2:38:03 PM [spTestQueries.sql]: Testing harness installed
224629916091BUILDSchemaOK7/22/2026 2:38:03 PM [spCheckDB.sql]: Database checking procs created
224629916090BUILDSchemaOK7/22/2026 2:38:03 PM [spRegion.sql]: Created functions and procedures for the Region package
224629916089BUILDSchemaOK7/22/2026 2:38:02 PM [spCoordinate.sql]: Coordinate related functions and procedures created
224629916088BUILDSchemaOK7/22/2026 2:38:01 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
224629916087BUILDSchemaOK7/22/2026 2:38:01 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
224629916086BUILDSchemaOK7/22/2026 2:37:59 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
224629916085BUILDSchemaOK7/22/2026 2:37:58 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]
224629916084BUILDSchemaOK7/22/2026 2:37:58 PMCreated Spherical assembly in database TEST_DR201
224629916083BUILDSchemaOK7/22/2026 2:37:54 PM [LvmTables.sql]: LVM tables created
224629916082BUILDSchemaOK7/22/2026 2:37:54 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
224629916081BUILDSchemaOK7/22/2026 2:37:52 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 '*'. 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 '*'. [VacTables.sql]: VAC tables created
224629916080BUILDSchemaOK7/22/2026 2:37:50 PM [Views.sql]: Views created
224629916079BUILDSchemaOK7/22/2026 2:37:49 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
224629916078BUILDSchemaOK7/22/2026 2:37:49 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
224629916077BUILDSchemaOK7/22/2026 2:37:48 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
224629916076BUILDSchemaOK7/22/2026 2:37:48 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
224629916075BUILDSchemaOK7/22/2026 2:37:48 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
224629916074BUILDSchemaOK7/22/2026 2:37:48 PM [MastarTables.sql]: Mastar tables created
224629916073BUILDSchemaOK7/22/2026 2:37:47 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
224629916072BUILDSchemaOK7/22/2026 2:37:47 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
224629916071BUILDSchemaOK7/22/2026 2:37:46 PM [ApogeeTables.sql]: APOGEE tables created
224629916070BUILDSchemaOK7/22/2026 2:37:45 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
224629916069BUILDSchemaOK7/22/2026 2:37:45 PM [WindowTables.sql]: Window tables and related views created
224629916068BUILDSchemaOK7/22/2026 2:37:45 PM [RegionTables.sql]: Created tables for Region package
224629916067BUILDSchemaOK7/22/2026 2:37:44 PM [TilingTables.sql]: Tiling tables and related views created
224629916066BUILDSchemaOK7/22/2026 2:37:44 PM [spSpectro.sql]: Spectro functions/sps created
224629916065BUILDSchemaOK7/22/2026 2:37:43 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
224629916064BUILDSchemaOK7/22/2026 2:37:43 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
224629916063BUILDSchemaOK7/22/2026 2:37:42 PM [NeighborTables.sql]: Neighbor and Match tables created
224629916062BUILDSchemaOK7/22/2026 2:37:42 PM [resolveTables.sql]: Resolve tables created
224629916061BUILDSchemaOK7/22/2026 2:37:42 PM [spPhoto.sql]: Photo procedures and functions created
224629916060BUILDSchemaOK7/22/2026 2:37:41 PM [galSpecTables.sql]: galSpec tables and related functions created
224629916059BUILDSchemaOK7/22/2026 2:37:41 PM [PhotoZTables.sql]: Photometric redshifts tables created
224629916058BUILDSchemaOK7/22/2026 2:37:40 PM [PhotoTables.sql]: Photo tables created
224629916057BUILDSchemaOK7/22/2026 2:37:40 PM [Versions.sql]: Versions table created
224629916056BUILDSchemaOK7/22/2026 2:37:39 PM [IndexMap.sql]: Index management tables and procedures built
224629916055BUILDSchemaOK7/22/2026 2:37:33 PM [MetadataTables.sql]: MetaData tables created
224629916054BUILDSchemaOK7/22/2026 2:37:32 PM [ConstantSupport.sql]: Constant support views and functions created
224629916053BUILDSchemaOK7/22/2026 2:37:30 PM [DataConstants.sql]: Constant tables created
224629916052BUILDSchemaOK7/22/2026 2:37:18 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
224629916051BUILDSchemaOK7/22/2026 2:37:17 PMStarting schema creation for TEST_DR201 with partitioning=0
224629916050BUILDDatabaseOK7/22/2026 2:37:17 PMConfigured database TEST_DR201
224629916049BUILDDatabaseOK7/22/2026 2:37:17 PMCreated database TEST_DR201
224629916048BUILDDatabaseOK7/22/2026 2:36:01 PMStarting database creation
224629916047BUILDSTARTINGSTART7/22/2026 2:36:01 PMStarting DB build
224629906046CHECKFINISHINGDONE7/22/2026 2:35:23 PMFinished CSV checking
224629906045CHECKFile countOK7/22/2026 2:35:22 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 29
224629906044CHECKDir checkOK7/22/2026 2:35:22 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
224629906043CHECKOpen debug file OK7/22/2026 2:35:22 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
224629906042CHECKCheck backup folOK7/22/2026 2:35:22 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
224629906041CHECKCheck rootOK7/22/2026 2:35:22 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
224629906040CHECKSTARTINGSTART7/22/2026 2:35:21 PMStarting CSV check