Log - Task #1
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
128864077CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated foreign key constraint Inventory(name) references DBObjects(name)
128864076CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated foreign key constraint FileGroupMap(tableFileGroup) references PartitionMap(fileGroupName)
128864075CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated foreign key constraint IndexMap(tableName) references DBObjects(name)
128864074CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated foreign key constraint DBViewCols(viewname) references DBObjects(name)
128864073CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated foreign key constraint DBColumns(tablename) references DBObjects(name)
128864072CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated index DataConstants(value)
128864071CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated primary key constraint LoadHistory(loadVersion,tStart)
128864070CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated primary key constraint ProfileDefs(bin)
128864069CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated primary key constraint SiteDiagnostics(name)
128864068CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated primary key constraint SiteConstants(name)
128864067CLEANUPIndexCreateOK6/19/2026 3:06:59 PMCreated primary key constraint SDSSConstants(name)
128864066CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint Diagnostics(name)
128864065CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint DataConstants(field,name)
128864064CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint Dependency(parent,child)
128864063CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint Inventory(filename,name)
128864062CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint History(id)
128864061CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint DBViewCols(viewName,name)
128864060CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint DBColumns(tableName,name)
128864059CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint DBObjects(name)
128864058CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint Versions(version)
128864057CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint RunShift(run)
128864056CLEANUPIndexCreateOK6/19/2026 3:06:58 PMCreated primary key constraint RecentQueries(ipAddr,lastQueryTime)
128864055CLEANUPIndexCreateOK6/19/2026 3:06:57 PMCreated primary key constraint PubHistory(name,loadversion)
128864054CLEANUPIndexCreateOK6/19/2026 3:06:57 PMCreated primary key constraint IndexMap(indexmapid)
128864053CLEANUPIndexCreateOK6/19/2026 3:06:57 PMCreated primary key constraint FileGroupMap(tableName)
128864052CLEANUPIndexCreateOK6/19/2026 3:06:57 PMCreated primary key constraint PartitionMap(fileGroupName)
128864051CLEANUPMetadataOK6/19/2026 3:06:57 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -iC:\sqlLoader\schema\csv\\loadhistory.sql
128864050CLEANUPMetadataOK6/19/2026 3:06:47 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -iC:\sqlLoader\schema\csv\\loaddependency.sql 462 lines inserted into Dependency
128864049CLEANUPMetadataOK6/19/2026 3:06:41 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -iC:\sqlLoader\schema\csv\\loadinventory.sql
128864048CLEANUPMetadataOK6/19/2026 3:06:34 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -iC:\sqlLoader\schema\csv\\loaddbcolumns.sql 26022 lines inserted into DBColumns
128864047CLEANUPMetadataOK6/19/2026 3:00:52 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -iC:\sqlLoader\schema\csv\\loaddbviewcols.sql 234 lines inserted into DBViewcols
128864046CLEANUPMetadataOK6/19/2026 3:00:49 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -iC:\sqlLoader\schema\csv\\loaddbobjects.sql 830 lines inserted into DBObjects
128864045CLEANUPMetadataOK6/19/2026 3:00:38 PMStarting to load metadata
128854042PUBLISHFINISHINGDONE6/19/2026 2:06:32 PMPublished Allspec allspec from: sdss4c.TEST_ALLS1 to: sdss4c.BESTTEST
128854036PUBLISHAttachOK6/19/2026 2:05:01 PMSuccessfully attached sdss4c.TEST_ALLS1 in file: d:\sql_db\TEST_ALLS1_Data.MDF
128854034PUBLISHSTARTINGSTART6/19/2026 2:05:01 PMPublishing allspec sdss4c.TEST_ALLS1 to sdss4c.BESTTEST
128753943PUBLISHFINISHINGDONE6/19/2026 1:30:03 PMPublished Astra astra from: sdss4c.TEST_ASTR1 to: sdss4c.BESTTEST
128753915PUBLISHAttachOK6/19/2026 1:23:01 PMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
128753913PUBLISHSTARTINGSTART6/19/2026 1:23:00 PMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
128653812PUBLISHFINISHINGDONE6/19/2026 11:01:52 AMPublished Astra astra from: sdss4c.TEST_ASTR1 to: sdss4c.BESTTEST
128653784PUBLISHAttachOK6/19/2026 11:01:51 AMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
128653782PUBLISHSTARTINGSTART6/19/2026 11:01:51 AMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
128633780PUBLISHFINISHINGERROR6/19/2026 10:59:16 AMFailed to attach DB sdss4c.TEST_ASTR1
128633778PUBLISHAttachABORTING6/19/2026 10:59:16 AMFailed to attach DB sdss4c.TEST_ASTR1
128633776PUBLISHSTARTINGSTART6/19/2026 10:59:16 AMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
128613773PUBLISHAttachOK6/18/2026 4:47:01 PMSuccessfully attached sdss4c.TEST_ASTR1 in file: d:\sql_db\TEST_ASTR1_Data.MDF
128613771PUBLISHSTARTINGSTART6/18/2026 4:47:01 PMPublishing astra sdss4c.TEST_ASTR1 to sdss4c.BESTTEST
128363454PUBLISHFINISHINGDONE6/17/2026 11:37:59 AMPublished eBOSS eboss from: sdss4c.TEST_EBOS1 to: sdss4c.BESTTEST
128363447PUBLISHAttachOK6/17/2026 11:37:01 AMSuccessfully attached sdss4c.TEST_EBOS1 in file: d:\sql_db\TEST_EBOS1_Data.MDF
128363445PUBLISHSTARTINGSTART6/17/2026 11:37:00 AMPublishing eboss sdss4c.TEST_EBOS1 to sdss4c.BESTTEST
128183221PUBLISHFINISHINGDONE6/15/2026 12:31:41 PMPublished Allspec allspec from: sdss4c.TEST_ALLS1 to: sdss4c.BESTTEST
128183215PUBLISHAttachOK6/15/2026 12:30:01 PMSuccessfully attached sdss4c.TEST_ALLS1 in file: d:\sql_db\TEST_ALLS1_Data.MDF
128183213PUBLISHSTARTINGSTART6/15/2026 12:30:01 PMPublishing allspec sdss4c.TEST_ALLS1 to sdss4c.BESTTEST
1164CREATEFINISHINGDONE1/28/2026 12:18:19 PMCreated BESTTEST
1163CREATEMetadataOK1/28/2026 12:18:19 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loadhistory.sql 1370 lines inserted into History
1162CREATEMetadataOK1/28/2026 12:18:00 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddependency.sql 462 lines inserted into Dependency
1161CREATEMetadataOK1/28/2026 12:17:54 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loadinventory.sql 830 lines inserted into Inventory
1160CREATEMetadataOK1/28/2026 12:17:43 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddbcolumns.sql 25984 lines inserted into DBColumns
1159CREATEMetadataOK1/28/2026 12:12:01 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddbviewcols.sql 234 lines inserted into DBViewcols
1158CREATEMetadataOK1/28/2026 12:11:58 PMRan SQL script osql -S sdss4c -dBESTTEST -E -n -i\\sdss4c\root\schema\csv\\loaddbobjects.sql 830 lines inserted into DBObjects
1157CREATEMetadataOK1/28/2026 12:11:46 PMStarting to load metadata
1156CREATESchemaOK1/28/2026 12:11:46 PMCreated Spherical assembly in database BESTTEST
1155CREATESchemaOK1/28/2026 12:11:46 PM [spCosmology.sql]: Cosmology functions and procedures created
1154CREATESchemaOK1/28/2026 12:11:45 PM [spCopyDbSubset]: spCopyDbSubset installed
1153CREATESchemaOK1/28/2026 12:11:45 PM [spFinish.sql]: spFinish procedures created
1152CREATESchemaOK1/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
1151CREATESchemaOK1/28/2026 12:11:44 PM [spValidate.sql]: Data validation procedures created
1150CREATESchemaOK1/28/2026 12:11:43 PM [spSetValues.qsl]: Set values procedures created
1149CREATESchemaOK1/28/2026 12:11:43 PM [spNeighbor.sql]: Neighbor and Match creation procedures created
1148CREATESchemaOK1/28/2026 12:11:42 PM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
1147CREATESchemaOK1/28/2026 12:11:42 PM [spSQLSupport.sql]: SQL Support procs and functions created.
1146CREATESchemaOK1/28/2026 12:11:41 PM [spDocSupport.sql]: DocSupport procs and functions created.
1145CREATESchemaOK1/28/2026 12:11:41 PM [spTestQueries.sql]: Testing harness installed
1144CREATESchemaOK1/28/2026 12:11:41 PM [spCheckDB.sql]: Database checking procs created
1143CREATESchemaOK1/28/2026 12:11:40 PM [spRegion.sql]: Created functions and procedures for the Region package
1142CREATESchemaOK1/28/2026 12:11:39 PM [spCoordinate.sql]: Coordinate related functions and procedures created
1141CREATESchemaOK1/28/2026 12:11:39 PMosql -dBESTTEST -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
1140CREATESchemaOK1/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
1139CREATESchemaOK1/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.
1138CREATESchemaOK1/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]
1137CREATESchemaOK1/28/2026 12:11:35 PMCreated Spherical assembly in database BESTTEST
1136CREATESchemaOK1/28/2026 12:11:31 PMosql -dBESTTEST -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
1135CREATESchemaOK1/28/2026 12:11:29 PM [VacTables.sql]: VAC tables created
1134CREATESchemaOK1/28/2026 12:11:28 PM [Views.sql]: Views created
1133CREATESchemaOK1/28/2026 12:11:27 PMosql -dBESTTEST -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
1132CREATESchemaOK1/28/2026 12:11:27 PM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
1131CREATESchemaOK1/28/2026 12:11:27 PM [GalaxyZooTables.sql]: Galaxy Zoo tables created
1130CREATESchemaOK1/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
1129CREATESchemaOK1/28/2026 12:11:26 PM [QsoVarTables.sql]: EBOSS QSO Variability tables created
1128CREATESchemaOK1/28/2026 12:11:26 PM [MastarTables.sql]: Mastar tables created
1127CREATESchemaOK1/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
1126CREATESchemaOK1/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
1125CREATESchemaOK1/28/2026 12:11:24 PM [ApogeeTables.sql]: APOGEE tables created
1124CREATESchemaOK1/28/2026 12:11:23 PM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
1123CREATESchemaOK1/28/2026 12:11:23 PM [WindowTables.sql]: Window tables and related views created
1122CREATESchemaOK1/28/2026 12:11:23 PM [RegionTables.sql]: Created tables for Region package
1121CREATESchemaOK1/28/2026 12:11:22 PM [TilingTables.sql]: Tiling tables and related views created
1120CREATESchemaOK1/28/2026 12:11:22 PM [spSpectro.sql]: Spectro functions/sps created
1119CREATESchemaOK1/28/2026 12:11:21 PM [GalaxyProductTables.sql]: Galprod tables and related functions created
1118CREATESchemaOK1/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
1117CREATESchemaOK1/28/2026 12:11:20 PM [NeighborTables.sql]: Neighbor and Match tables created
1116CREATESchemaOK1/28/2026 12:11:20 PM [resolveTables.sql]: Resolve tables created
1115CREATESchemaOK1/28/2026 12:11:19 PM [spPhoto.sql]: Photo procedures and functions created
1114CREATESchemaOK1/28/2026 12:11:19 PM [galSpecTables.sql]: galSpec tables and related functions created
1113CREATESchemaOK1/28/2026 12:11:19 PM [PhotoZTables.sql]: Photometric redshifts tables created
1112CREATESchemaOK1/28/2026 12:11:18 PM [PhotoTables.sql]: Photo tables created
1111CREATESchemaOK1/28/2026 12:11:18 PM [Versions.sql]: Versions table created
1110CREATESchemaOK1/28/2026 12:11:17 PM [IndexMap.sql]: Index management tables and procedures built
119CREATESchemaOK1/28/2026 12:11:13 PM [MetadataTables.sql]: MetaData tables created
118CREATESchemaOK1/28/2026 12:11:13 PM [ConstantSupport.sql]: Constant support views and functions created
117CREATESchemaOK1/28/2026 12:11:10 PM [DataConstants.sql]: Constant tables created
116CREATESchemaOK1/28/2026 12:10:58 PM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
115CREATESchemaOK1/28/2026 12:10:57 PMStarting schema creation for BESTTEST with partitioning=0
114CREATEDatabaseOK1/28/2026 12:10:57 PMConfigured database BESTTEST
113CREATEDatabaseOK1/28/2026 12:10:57 PMCreated database BESTTEST
112CREATEDatabaseOK1/28/2026 12:10:42 PMStarting database creation
111CREATESTARTINGSTART1/28/2026 12:10:41 PMStarting to create pubDB