| taskid | stepid | phaseid | stepname | phasename | status | tstop | comment |
| 1 | 1 | 64 | CREATE | FINISHING | DONE | 1/28/2026 12:18:19 PM | Created BESTTEST |
| 1 | 1 | 63 | CREATE | Metadata | OK | 1/28/2026 12:18:19 PM | Ran SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loadhistory.sql 1370 lines inserted into History |
| 1 | 1 | 62 | CREATE | Metadata | OK | 1/28/2026 12:18:00 PM | Ran SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddependency.sql 462 lines inserted into Dependency |
| 1 | 1 | 61 | CREATE | Metadata | OK | 1/28/2026 12:17:54 PM | Ran SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loadinventory.sql 830 lines inserted into Inventory |
| 1 | 1 | 60 | CREATE | Metadata | OK | 1/28/2026 12:17:43 PM | Ran SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddbcolumns.sql 25984 lines inserted into DBColumns |
| 1 | 1 | 59 | CREATE | Metadata | OK | 1/28/2026 12:12:01 PM | Ran SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddbviewcols.sql 234 lines inserted into DBViewcols |
| 1 | 1 | 58 | CREATE | Metadata | OK | 1/28/2026 12:11:58 PM | Ran SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddbobjects.sql 830 lines inserted into DBObjects |
| 1 | 1 | 57 | CREATE | Metadata | OK | 1/28/2026 12:11:46 PM | Starting to load metadata |
| 1 | 1 | 56 | CREATE | Schema | OK | 1/28/2026 12:11:46 PM | Created Spherical assembly in database BESTTEST |
| 1 | 1 | 55 | CREATE | Schema | OK | 1/28/2026 12:11:46 PM | [spCosmology.sql]: Cosmology functions and procedures created |
| 1 | 1 | 54 | CREATE | Schema | OK | 1/28/2026 12:11:45 PM | [spCopyDbSubset]: spCopyDbSubset installed |
| 1 | 1 | 53 | CREATE | Schema | OK | 1/28/2026 12:11:45 PM | [spFinish.sql]: spFinish procedures created |
| 1 | 1 | 52 | CREATE | Schema | OK | 1/28/2026 12:11:44 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 |
| 1 | 1 | 51 | CREATE | Schema | OK | 1/28/2026 12:11:44 PM | [spValidate.sql]: Data validation procedures created |
| 1 | 1 | 50 | CREATE | Schema | OK | 1/28/2026 12:11:43 PM | [spSetValues.qsl]: Set values procedures created |
| 1 | 1 | 49 | CREATE | Schema | OK | 1/28/2026 12:11:43 PM | [spNeighbor.sql]: Neighbor and Match creation procedures created |
| 1 | 1 | 48 | CREATE | Schema | OK | 1/28/2026 12:11:42 PM | [spUrlFitsSupport.sql]: URL and FITS support procs and functions created. |
| 1 | 1 | 47 | CREATE | Schema | OK | 1/28/2026 12:11:42 PM | [spSQLSupport.sql]: SQL Support procs and functions created. |
| 1 | 1 | 46 | CREATE | Schema | OK | 1/28/2026 12:11:41 PM | [spDocSupport.sql]: DocSupport procs and functions created. |
| 1 | 1 | 45 | CREATE | Schema | OK | 1/28/2026 12:11:41 PM | [spTestQueries.sql]: Testing harness installed |
| 1 | 1 | 44 | CREATE | Schema | OK | 1/28/2026 12:11:41 PM | [spCheckDB.sql]: Database checking procs created |
| 1 | 1 | 43 | CREATE | Schema | OK | 1/28/2026 12:11:40 PM | [spRegion.sql]: Created functions and procedures for the Region package |
| 1 | 1 | 42 | CREATE | Schema | OK | 1/28/2026 12:11:39 PM | [spCoordinate.sql]: Coordinate related functions and procedures created |
| 1 | 1 | 41 | CREATE | Schema | OK | 1/28/2026 12:11:39 PM | osql -dBESTTEST -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql |
| 1 | 1 | 40 | CREATE | Schema | OK | 1/28/2026 12:11:38 PM | Msg 911, Level 16, State 1, Server sdss4c, Line 2 Database 'BestDR19' does not exist. Make sure that the name is entered correctly. Msg 911, Level 16, State 1, Server sdss4c, Line 2 Database 'BestDR19' does not exist. Make sure that the name is entered correctly. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 55 Invalid column name 'HtmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 55 Invalid column name 'HtmID'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 56 Invalid column name 'cx'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 56 Invalid column name 'cy'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 56 Invalid column name 'cz'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 51 Invalid column name 'htmid'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 57 Invalid column name 'cx'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 57 Invalid column name 'cy'. Msg 207, Level 16, State 1, Server sdss4c, Procedure fGetNearbyApogeeDrpAllstarXYZ, Line 57 Invalid column name 'cz'. Msg 911, Level 16, State 1, Server sdss4c, Line 2 Database 'BestDR19' does not exist. Make sure that the name is entered correctly. [spNearby.sql]: Proximity functions created |
| 1 | 1 | 39 | CREATE | Schema | OK | 1/28/2026 12:11:37 PM | [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed. |
| 1 | 1 | 38 | CREATE | Schema | OK | 1/28/2026 12:11:36 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] |
| 1 | 1 | 37 | CREATE | Schema | OK | 1/28/2026 12:11:35 PM | Created Spherical assembly in database BESTTEST |
| 1 | 1 | 36 | CREATE | Schema | OK | 1/28/2026 12:11:31 PM | osql -dBESTTEST -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql |
| 1 | 1 | 35 | CREATE | Schema | OK | 1/28/2026 12:11:29 PM | [VacTables.sql]: VAC tables created |
| 1 | 1 | 34 | CREATE | Schema | OK | 1/28/2026 12:11:28 PM | [Views.sql]: Views created |
| 1 | 1 | 33 | CREATE | Schema | OK | 1/28/2026 12:11:27 PM | osql -dBESTTEST -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql |
| 1 | 1 | 32 | CREATE | Schema | OK | 1/28/2026 12:11:27 PM | [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created |
| 1 | 1 | 31 | CREATE | Schema | OK | 1/28/2026 12:11:27 PM | [GalaxyZooTables.sql]: Galaxy Zoo tables created |
| 1 | 1 | 30 | CREATE | Schema | OK | 1/28/2026 12:11:26 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 |
| 1 | 1 | 29 | CREATE | Schema | OK | 1/28/2026 12:11:26 PM | [QsoVarTables.sql]: EBOSS QSO Variability tables created |
| 1 | 1 | 28 | CREATE | Schema | OK | 1/28/2026 12:11:26 PM | [MastarTables.sql]: Mastar tables created |
| 1 | 1 | 27 | CREATE | Schema | OK | 1/28/2026 12:11:26 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 |
| 1 | 1 | 26 | CREATE | Schema | OK | 1/28/2026 12:11:25 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 |
| 1 | 1 | 25 | CREATE | Schema | OK | 1/28/2026 12:11:24 PM | [ApogeeTables.sql]: APOGEE tables created |
| 1 | 1 | 24 | CREATE | Schema | OK | 1/28/2026 12:11:23 PM | [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created |
| 1 | 1 | 23 | CREATE | Schema | OK | 1/28/2026 12:11:23 PM | [WindowTables.sql]: Window tables and related views created |
| 1 | 1 | 22 | CREATE | Schema | OK | 1/28/2026 12:11:23 PM | [RegionTables.sql]: Created tables for Region package |
| 1 | 1 | 21 | CREATE | Schema | OK | 1/28/2026 12:11:22 PM | [TilingTables.sql]: Tiling tables and related views created |
| 1 | 1 | 20 | CREATE | Schema | OK | 1/28/2026 12:11:22 PM | [spSpectro.sql]: Spectro functions/sps created |
| 1 | 1 | 19 | CREATE | Schema | OK | 1/28/2026 12:11:21 PM | [GalaxyProductTables.sql]: Galprod tables and related functions created |
| 1 | 1 | 18 | CREATE | Schema | OK | 1/28/2026 12:11:20 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 |
| 1 | 1 | 17 | CREATE | Schema | OK | 1/28/2026 12:11:20 PM | [NeighborTables.sql]: Neighbor and Match tables created |
| 1 | 1 | 16 | CREATE | Schema | OK | 1/28/2026 12:11:20 PM | [resolveTables.sql]: Resolve tables created |
| 1 | 1 | 15 | CREATE | Schema | OK | 1/28/2026 12:11:19 PM | [spPhoto.sql]: Photo procedures and functions created |
| 1 | 1 | 14 | CREATE | Schema | OK | 1/28/2026 12:11:19 PM | [galSpecTables.sql]: galSpec tables and related functions created |
| 1 | 1 | 13 | CREATE | Schema | OK | 1/28/2026 12:11:19 PM | [PhotoZTables.sql]: Photometric redshifts tables created |
| 1 | 1 | 12 | CREATE | Schema | OK | 1/28/2026 12:11:18 PM | [PhotoTables.sql]: Photo tables created |
| 1 | 1 | 11 | CREATE | Schema | OK | 1/28/2026 12:11:18 PM | [Versions.sql]: Versions table created |
| 1 | 1 | 10 | CREATE | Schema | OK | 1/28/2026 12:11:17 PM | [IndexMap.sql]: Index management tables and procedures built |
| 1 | 1 | 9 | CREATE | Schema | OK | 1/28/2026 12:11:13 PM | [MetadataTables.sql]: MetaData tables created |
| 1 | 1 | 8 | CREATE | Schema | OK | 1/28/2026 12:11:13 PM | [ConstantSupport.sql]: Constant support views and functions created |
| 1 | 1 | 7 | CREATE | Schema | OK | 1/28/2026 12:11:10 PM | [DataConstants.sql]: Constant tables created |
| 1 | 1 | 6 | CREATE | Schema | OK | 1/28/2026 12:10:58 PM | [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created |
| 1 | 1 | 5 | CREATE | Schema | OK | 1/28/2026 12:10:57 PM | Starting schema creation for BESTTEST with partitioning=0 |
| 1 | 1 | 4 | CREATE | Database | OK | 1/28/2026 12:10:57 PM | Configured database BESTTEST |
| 1 | 1 | 3 | CREATE | Database | OK | 1/28/2026 12:10:57 PM | Created database BESTTEST |
| 1 | 1 | 2 | CREATE | Database | OK | 1/28/2026 12:10:42 PM | Starting database creation |
| 1 | 1 | 1 | CREATE | STARTING | START | 1/28/2026 12:10:41 PM | Starting to create pubDB |
