Log - Task #2229
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
222929285081PRELOADFINISHINGERROR7/14/2026 3:45:11 PMError in loading file D:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\sqlBossClamLite.csv
222929285080PRELOADCSV loadOK7/14/2026 3:45:11 PMStarting File load
222929285079PRELOADSTARTINGSTART7/14/2026 3:45:11 PMStarting SQL Preload
222929275078BUILDFINISHINGDONE7/14/2026 3:45:11 PMFinished building DB
222929275077BUILDSchemaOK7/14/2026 3:45:11 PMCreated Spherical assembly in database TEST_DR201
222929275076BUILDSchemaOK7/14/2026 3:45:11 PM [spCosmology.sql]: Cosmology functions and procedures created
222929275075BUILDSchemaOK7/14/2026 3:45:10 PM [spCopyDbSubset]: spCopyDbSubset installed
222929275074BUILDSchemaOK7/14/2026 3:45:10 PM [spFinish.sql]: spFinish procedures created
222929275073BUILDSchemaOK7/14/2026 3:45:09 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
222929275072BUILDSchemaOK7/14/2026 3:45:08 PM [spValidate.sql]: Data validation procedures created
222929275071BUILDSchemaOK7/14/2026 3:45:08 PM [spSetValues.qsl]: Set values procedures created
222929275070BUILDSchemaOK7/14/2026 3:45:07 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
222929275069BUILDSchemaOK7/14/2026 3:45:07 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
222929275068BUILDSchemaOK7/14/2026 3:45:06 PM [spSQLSupport.sql]: SQL Support procs and functions created.
222929275067BUILDSchemaOK7/14/2026 3:45:06 PM [spDocSupport.sql]: DocSupport procs and functions created.
222929275066BUILDSchemaOK7/14/2026 3:45:06 PM [spTestQueries.sql]: Testing harness installed
222929275065BUILDSchemaOK7/14/2026 3:45:05 PM [spCheckDB.sql]: Database checking procs created
222929275064BUILDSchemaOK7/14/2026 3:45:05 PM [spRegion.sql]: Created functions and procedures for the Region package
222929275063BUILDSchemaOK7/14/2026 3:45:04 PM [spCoordinate.sql]: Coordinate related functions and procedures created
222929275062BUILDSchemaOK7/14/2026 3:45:03 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
222929275061BUILDSchemaOK7/14/2026 3:45:03 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
222929275060BUILDSchemaOK7/14/2026 3:45:01 PM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
222929275059BUILDSchemaOK7/14/2026 3:45:01 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]
222929275058BUILDSchemaOK7/14/2026 3:45:00 PMCreated Spherical assembly in database TEST_DR201
222929275057BUILDSchemaOK7/14/2026 3:44:57 PM [LvmTables.sql]: LVM tables created
222929275056BUILDSchemaOK7/14/2026 3:44:57 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
222929275055BUILDSchemaOK7/14/2026 3:44:54 PM Msg 102, Level 15, State 1, Server sdss4c, Line 14 Incorrect syntax near 'sdss_id'. Msg 102, Level 15, State 1, Server sdss4c, Line 14 Incorrect syntax near 'apogee_max_mjd'. Msg 102, Level 15, State 1, Server sdss4c, Line 14 Incorrect syntax near 'sdssid'. Msg 102, Level 15, State 1, Server sdss4c, Line 15 Incorrect syntax near 'name'. Msg 102, Level 15, State 1, Server sdss4c, Line 12 Incorrect syntax near 'cluster'. Msg 102, Level 15, State 1, Server sdss4c, Line 10 Incorrect syntax near 'field'. Msg 102, Level 15, State 1, Server sdss4c, Line 10 Incorrect syntax near 'ero_detuid'. Msg 102, Level 15, State 1, Server sdss4c, Line 10 Incorrect syntax near 'ero_detuid'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'obs'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 12 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 11 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 12 Incorrect syntax near 'objid'. Msg 102, Level 15, State 1, Server sdss4c, Line 10 Incorrect syntax near 'iauname'. Msg 102, Level 15, State 1, Server sdss4c, Line 19 Incorrect syntax near 'sdss_id'. Msg 102, Level 15, State 1, Server sdss4c, Line 19 Incorrect syntax near 'ids'. Msg 102, Level 15, State 1, Server sdss4c, Line 10 Incorrect syntax near 'source_id'. Msg 102, Level 15, State 1, Server sdss4c, Line 15 Incorrect syntax near 'sdssid'. Msg 102, Level 15, State 1, Server sdss4c, Line 14 Incorrect syntax near 'airmass'. Msg 102, Level 15, State 1, Server sdss4c, Line 10 Incorrect syntax near 'source_id'. Msg 102, Level 15, State 1, Server sdss4c, Li
222929275054BUILDSchemaOK7/14/2026 3:44:53 PM [Views.sql]: Views created
222929275053BUILDSchemaOK7/14/2026 3:44:52 PMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
222929275052BUILDSchemaOK7/14/2026 3:44:52 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
222929275051BUILDSchemaOK7/14/2026 3:44:51 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
222929275050BUILDSchemaOK7/14/2026 3:44:51 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
222929275049BUILDSchemaOK7/14/2026 3:44:51 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
222929275048BUILDSchemaOK7/14/2026 3:44:51 PM [MastarTables.sql]: Mastar tables created
222929275047BUILDSchemaOK7/14/2026 3:44:50 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
222929275046BUILDSchemaOK7/14/2026 3:44:50 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
222929275045BUILDSchemaOK7/14/2026 3:44:49 PM [ApogeeTables.sql]: APOGEE tables created
222929275044BUILDSchemaOK7/14/2026 3:44:48 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
222929275043BUILDSchemaOK7/14/2026 3:44:48 PM [WindowTables.sql]: Window tables and related views created
222929275042BUILDSchemaOK7/14/2026 3:44:48 PM [RegionTables.sql]: Created tables for Region package
222929275041BUILDSchemaOK7/14/2026 3:44:47 PM [TilingTables.sql]: Tiling tables and related views created
222929275040BUILDSchemaOK7/14/2026 3:44:47 PM [spSpectro.sql]: Spectro functions/sps created
222929275039BUILDSchemaOK7/14/2026 3:44:46 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
222929275038BUILDSchemaOK7/14/2026 3:44:46 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
222929275037BUILDSchemaOK7/14/2026 3:44:45 PM [NeighborTables.sql]: Neighbor and Match tables created
222929275036BUILDSchemaOK7/14/2026 3:44:45 PM [resolveTables.sql]: Resolve tables created
222929275035BUILDSchemaOK7/14/2026 3:44:44 PM [spPhoto.sql]: Photo procedures and functions created
222929275034BUILDSchemaOK7/14/2026 3:44:44 PM [galSpecTables.sql]: galSpec tables and related functions created
222929275033BUILDSchemaOK7/14/2026 3:44:43 PM [PhotoZTables.sql]: Photometric redshifts tables created
222929275032BUILDSchemaOK7/14/2026 3:44:43 PM [PhotoTables.sql]: Photo tables created
222929275031BUILDSchemaOK7/14/2026 3:44:42 PM [Versions.sql]: Versions table created
222929275030BUILDSchemaOK7/14/2026 3:44:42 PM [IndexMap.sql]: Index management tables and procedures built
222929275029BUILDSchemaOK7/14/2026 3:44:36 PM [MetadataTables.sql]: MetaData tables created
222929275028BUILDSchemaOK7/14/2026 3:44:35 PM [ConstantSupport.sql]: Constant support views and functions created
222929275027BUILDSchemaOK7/14/2026 3:44:33 PM [DataConstants.sql]: Constant tables created
222929275026BUILDSchemaOK7/14/2026 3:44:21 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
222929275025BUILDSchemaOK7/14/2026 3:44:20 PMStarting schema creation for TEST_DR201 with partitioning=0
222929275024BUILDDatabaseOK7/14/2026 3:44:20 PMConfigured database TEST_DR201
222929275023BUILDDatabaseOK7/14/2026 3:44:20 PMCreated database TEST_DR201
222929275022BUILDDatabaseOK7/14/2026 3:43:01 PMStarting database creation
222929275021BUILDSTARTINGSTART7/14/2026 3:43:01 PMStarting DB build
222929265020CHECKFINISHINGDONE7/14/2026 3:42:59 PMFinished CSV checking
222929265019CHECKFile countOK7/14/2026 3:42:59 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 30
222929265018CHECKDir checkOK7/14/2026 3:42:59 PMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
222929265017CHECKOpen debug file OK7/14/2026 3:42:59 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
222929265016CHECKCheck backup folOK7/14/2026 3:42:59 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
222929265015CHECKCheck rootOK7/14/2026 3:42:59 PMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
222929265014CHECKSTARTINGSTART7/14/2026 3:42:59 PMStarting CSV check