| taskid | stepid | phaseid | stepname | phasename | status | tstop | comment |
| 2234 | 2946 | 5359 | PRELOAD | FINISHING | ERROR | 7/15/2026 10:58:09 AM | Error in loading file D:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\sqlBossClamLite.csv |
| 2234 | 2946 | 5358 | PRELOAD | CSV load | OK | 7/15/2026 10:58:09 AM | Starting File load |
| 2234 | 2946 | 5357 | PRELOAD | STARTING | START | 7/15/2026 10:58:09 AM | Starting SQL Preload |
| 2234 | 2945 | 5356 | BUILD | FINISHING | DONE | 7/15/2026 10:58:09 AM | Finished building DB |
| 2234 | 2945 | 5355 | BUILD | Schema | OK | 7/15/2026 10:58:09 AM | Created Spherical assembly in database TEST_DR201 |
| 2234 | 2945 | 5354 | BUILD | Schema | OK | 7/15/2026 10:58:09 AM | [spCosmology.sql]: Cosmology functions and procedures created |
| 2234 | 2945 | 5353 | BUILD | Schema | OK | 7/15/2026 10:58:08 AM | [spCopyDbSubset]: spCopyDbSubset installed |
| 2234 | 2945 | 5352 | BUILD | Schema | OK | 7/15/2026 10:58:08 AM | [spFinish.sql]: spFinish procedures created |
| 2234 | 2945 | 5351 | BUILD | Schema | OK | 7/15/2026 10:58:07 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 |
| 2234 | 2945 | 5350 | BUILD | Schema | OK | 7/15/2026 10:58:07 AM | [spValidate.sql]: Data validation procedures created |
| 2234 | 2945 | 5349 | BUILD | Schema | OK | 7/15/2026 10:58:06 AM | [spSetValues.qsl]: Set values procedures created |
| 2234 | 2945 | 5348 | BUILD | Schema | OK | 7/15/2026 10:58:05 AM | [spNeighbor.sql]: Neighbor and Match creation procedures created |
| 2234 | 2945 | 5347 | BUILD | Schema | OK | 7/15/2026 10:58:05 AM | [spUrlFitsSupport.sql]: URL and FITS support procs and functions created. |
| 2234 | 2945 | 5346 | BUILD | Schema | OK | 7/15/2026 10:58:05 AM | [spSQLSupport.sql]: SQL Support procs and functions created. |
| 2234 | 2945 | 5345 | BUILD | Schema | OK | 7/15/2026 10:58:04 AM | [spDocSupport.sql]: DocSupport procs and functions created. |
| 2234 | 2945 | 5344 | BUILD | Schema | OK | 7/15/2026 10:58:04 AM | [spTestQueries.sql]: Testing harness installed |
| 2234 | 2945 | 5343 | BUILD | Schema | OK | 7/15/2026 10:58:03 AM | [spCheckDB.sql]: Database checking procs created |
| 2234 | 2945 | 5342 | BUILD | Schema | OK | 7/15/2026 10:58:03 AM | [spRegion.sql]: Created functions and procedures for the Region package |
| 2234 | 2945 | 5341 | BUILD | Schema | OK | 7/15/2026 10:58:02 AM | [spCoordinate.sql]: Coordinate related functions and procedures created |
| 2234 | 2945 | 5340 | BUILD | Schema | OK | 7/15/2026 10:58:02 AM | osql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql |
| 2234 | 2945 | 5339 | BUILD | Schema | OK | 7/15/2026 10:58:01 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 |
| 2234 | 2945 | 5338 | BUILD | Schema | OK | 7/15/2026 10:58:00 AM | [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed. |
| 2234 | 2945 | 5337 | BUILD | Schema | OK | 7/15/2026 10:57:59 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] |
| 2234 | 2945 | 5336 | BUILD | Schema | OK | 7/15/2026 10:57:58 AM | Created Spherical assembly in database TEST_DR201 |
| 2234 | 2945 | 5335 | BUILD | Schema | OK | 7/15/2026 10:57:55 AM | [LvmTables.sql]: LVM tables created |
| 2234 | 2945 | 5334 | BUILD | Schema | OK | 7/15/2026 10:57:55 AM | osql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql |
| 2234 | 2945 | 5333 | BUILD | Schema | OK | 7/15/2026 10:57:52 AM | 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 |
| 2234 | 2945 | 5332 | BUILD | Schema | OK | 7/15/2026 10:57:51 AM | [Views.sql]: Views created |
| 2234 | 2945 | 5331 | BUILD | Schema | OK | 7/15/2026 10:57:51 AM | osql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql |
| 2234 | 2945 | 5330 | BUILD | Schema | OK | 7/15/2026 10:57:50 AM | [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created |
| 2234 | 2945 | 5329 | BUILD | Schema | OK | 7/15/2026 10:57:50 AM | [GalaxyZooTables.sql]: Galaxy Zoo tables created |
| 2234 | 2945 | 5328 | BUILD | Schema | OK | 7/15/2026 10:57:50 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 |
| 2234 | 2945 | 5327 | BUILD | Schema | OK | 7/15/2026 10:57:49 AM | [QsoVarTables.sql]: EBOSS QSO Variability tables created |
| 2234 | 2945 | 5326 | BUILD | Schema | OK | 7/15/2026 10:57:49 AM | [MastarTables.sql]: Mastar tables created |
| 2234 | 2945 | 5325 | BUILD | Schema | OK | 7/15/2026 10:57:49 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 |
| 2234 | 2945 | 5324 | BUILD | Schema | OK | 7/15/2026 10:57:48 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 |
| 2234 | 2945 | 5323 | BUILD | Schema | OK | 7/15/2026 10:57:47 AM | [ApogeeTables.sql]: APOGEE tables created |
| 2234 | 2945 | 5322 | BUILD | Schema | OK | 7/15/2026 10:57:47 AM | [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created |
| 2234 | 2945 | 5321 | BUILD | Schema | OK | 7/15/2026 10:57:46 AM | [WindowTables.sql]: Window tables and related views created |
| 2234 | 2945 | 5320 | BUILD | Schema | OK | 7/15/2026 10:57:46 AM | [RegionTables.sql]: Created tables for Region package |
| 2234 | 2945 | 5319 | BUILD | Schema | OK | 7/15/2026 10:57:46 AM | [TilingTables.sql]: Tiling tables and related views created |
| 2234 | 2945 | 5318 | BUILD | Schema | OK | 7/15/2026 10:57:45 AM | [spSpectro.sql]: Spectro functions/sps created |
| 2234 | 2945 | 5317 | BUILD | Schema | OK | 7/15/2026 10:57:45 AM | [GalaxyProductTables.sql]: Galprod tables and related functions created |
| 2234 | 2945 | 5316 | BUILD | Schema | OK | 7/15/2026 10:57:44 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 |
| 2234 | 2945 | 5315 | BUILD | Schema | OK | 7/15/2026 10:57:44 AM | [NeighborTables.sql]: Neighbor and Match tables created |
| 2234 | 2945 | 5314 | BUILD | Schema | OK | 7/15/2026 10:57:43 AM | [resolveTables.sql]: Resolve tables created |
| 2234 | 2945 | 5313 | BUILD | Schema | OK | 7/15/2026 10:57:43 AM | [spPhoto.sql]: Photo procedures and functions created |
| 2234 | 2945 | 5312 | BUILD | Schema | OK | 7/15/2026 10:57:42 AM | [galSpecTables.sql]: galSpec tables and related functions created |
| 2234 | 2945 | 5311 | BUILD | Schema | OK | 7/15/2026 10:57:42 AM | [PhotoZTables.sql]: Photometric redshifts tables created |
| 2234 | 2945 | 5310 | BUILD | Schema | OK | 7/15/2026 10:57:42 AM | [PhotoTables.sql]: Photo tables created |
| 2234 | 2945 | 5309 | BUILD | Schema | OK | 7/15/2026 10:57:41 AM | [Versions.sql]: Versions table created |
| 2234 | 2945 | 5308 | BUILD | Schema | OK | 7/15/2026 10:57:41 AM | [IndexMap.sql]: Index management tables and procedures built |
| 2234 | 2945 | 5307 | BUILD | Schema | OK | 7/15/2026 10:57:35 AM | [MetadataTables.sql]: MetaData tables created |
| 2234 | 2945 | 5306 | BUILD | Schema | OK | 7/15/2026 10:57:34 AM | [ConstantSupport.sql]: Constant support views and functions created |
| 2234 | 2945 | 5305 | BUILD | Schema | OK | 7/15/2026 10:57:32 AM | [DataConstants.sql]: Constant tables created |
| 2234 | 2945 | 5304 | BUILD | Schema | OK | 7/15/2026 10:57:20 AM | [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created |
| 2234 | 2945 | 5303 | BUILD | Schema | OK | 7/15/2026 10:57:19 AM | Starting schema creation for TEST_DR201 with partitioning=0 |
| 2234 | 2945 | 5302 | BUILD | Database | OK | 7/15/2026 10:57:19 AM | Configured database TEST_DR201 |
| 2234 | 2945 | 5301 | BUILD | Database | OK | 7/15/2026 10:57:18 AM | Created database TEST_DR201 |
| 2234 | 2945 | 5300 | BUILD | Database | OK | 7/15/2026 10:56:01 AM | Starting database creation |
| 2234 | 2945 | 5299 | BUILD | STARTING | START | 7/15/2026 10:56:00 AM | Starting DB build |
| 2234 | 2944 | 5298 | CHECK | FINISHING | DONE | 7/15/2026 10:55:47 AM | Finished CSV checking |
| 2234 | 2944 | 5297 | CHECK | File count | OK | 7/15/2026 10:55:46 AM | D:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 30 |
| 2234 | 2944 | 5296 | CHECK | Dir check | OK | 7/15/2026 10:55:46 AM | D:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory |
| 2234 | 2944 | 5295 | CHECK | Open debug file | OK | 7/15/2026 10:55:46 AM | d:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened |
| 2234 | 2944 | 5294 | CHECK | Check backup fol | OK | 7/15/2026 10:55:46 AM | d:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists |
| 2234 | 2944 | 5293 | CHECK | Check root | OK | 7/15/2026 10:55:46 AM | d:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory |
| 2234 | 2944 | 5292 | CHECK | STARTING | START | 7/15/2026 10:55:46 AM | Starting CSV check |
|
