Log - Task #2233
| Task | Steps | Files | Log |
taskidstepidphaseidstepnamephasenamestatuststopcomment
223329425291PRELOADFINISHINGERROR7/15/2026 10:55:10 AMError in loading file D:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\sqlBossClamLite.csv
223329425290PRELOADCSV loadOK7/15/2026 10:55:10 AMStarting File load
223329425289PRELOADSTARTINGSTART7/15/2026 10:55:10 AMStarting SQL Preload
223329415288BUILDFINISHINGDONE7/15/2026 10:55:10 AMFinished building DB
223329415287BUILDSchemaOK7/15/2026 10:55:10 AMCreated Spherical assembly in database TEST_DR201
223329415286BUILDSchemaOK7/15/2026 10:55:10 AM [spCosmology.sql]: Cosmology functions and procedures created
223329415285BUILDSchemaOK7/15/2026 10:55:10 AM [spCopyDbSubset]: spCopyDbSubset installed
223329415284BUILDSchemaOK7/15/2026 10:55:09 AM [spFinish.sql]: spFinish procedures created
223329415283BUILDSchemaOK7/15/2026 10:55:08 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
223329415282BUILDSchemaOK7/15/2026 10:55:08 AM [spValidate.sql]: Data validation procedures created
223329415281BUILDSchemaOK7/15/2026 10:55:07 AM [spSetValues.qsl]: Set values procedures created
223329415280BUILDSchemaOK7/15/2026 10:55:07 AM [spNeighbor.sql]: Neighbor and Match creation procedures created
223329415279BUILDSchemaOK7/15/2026 10:55:06 AM [spUrlFitsSupport.sql]: URL and FITS support procs and functions created.
223329415278BUILDSchemaOK7/15/2026 10:55:06 AM [spSQLSupport.sql]: SQL Support procs and functions created.
223329415277BUILDSchemaOK7/15/2026 10:55:06 AM [spDocSupport.sql]: DocSupport procs and functions created.
223329415276BUILDSchemaOK7/15/2026 10:55:05 AM [spTestQueries.sql]: Testing harness installed
223329415275BUILDSchemaOK7/15/2026 10:55:05 AM [spCheckDB.sql]: Database checking procs created
223329415274BUILDSchemaOK7/15/2026 10:55:04 AM [spRegion.sql]: Created functions and procedures for the Region package
223329415273BUILDSchemaOK7/15/2026 10:55:04 AM [spCoordinate.sql]: Coordinate related functions and procedures created
223329415272BUILDSchemaOK7/15/2026 10:55:03 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\spApogee.sql
223329415271BUILDSchemaOK7/15/2026 10:55:02 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
223329415270BUILDSchemaOK7/15/2026 10:55:01 AM [spHtmCsharp.sql]: Version: Spherical.HTM 3.1.5f (Release - Built 5-1-2009) of the HTM library successfully installed.
223329415269BUILDSchemaOK7/15/2026 10:55:00 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]
223329415268BUILDSchemaOK7/15/2026 10:54:59 AMCreated Spherical assembly in database TEST_DR201
223329415267BUILDSchemaOK7/15/2026 10:54:57 AM [LvmTables.sql]: LVM tables created
223329415266BUILDSchemaOK7/15/2026 10:54:56 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\mosTables.sql
223329415265BUILDSchemaOK7/15/2026 10:54:54 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
223329415264BUILDSchemaOK7/15/2026 10:54:53 AM [Views.sql]: Views created
223329415263BUILDSchemaOK7/15/2026 10:54:52 AMosql -dTEST_DR201 -E -n -i\\sdss4c\root\schema\sql\\MarvelsTables.sql
223329415262BUILDSchemaOK7/15/2026 10:54:52 AM [GalaxyZoo2Tables.sql]: Galaxy Zoo 2 tables created
223329415261BUILDSchemaOK7/15/2026 10:54:51 AM [GalaxyZooTables.sql]: Galaxy Zoo tables created
223329415260BUILDSchemaOK7/15/2026 10:54:51 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
223329415259BUILDSchemaOK7/15/2026 10:54:51 AM [QsoVarTables.sql]: EBOSS QSO Variability tables created
223329415258BUILDSchemaOK7/15/2026 10:54:50 AM [MastarTables.sql]: Mastar tables created
223329415257BUILDSchemaOK7/15/2026 10:54:50 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
223329415256BUILDSchemaOK7/15/2026 10:54:49 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
223329415255BUILDSchemaOK7/15/2026 10:54:48 AM [ApogeeTables.sql]: APOGEE tables created
223329415254BUILDSchemaOK7/15/2026 10:54:48 AM [ssppTables.sql]: SEGUE Stellar Parameter Pipeline tables and related views created
223329415253BUILDSchemaOK7/15/2026 10:54:48 AM [WindowTables.sql]: Window tables and related views created
223329415252BUILDSchemaOK7/15/2026 10:54:47 AM [RegionTables.sql]: Created tables for Region package
223329415251BUILDSchemaOK7/15/2026 10:54:47 AM [TilingTables.sql]: Tiling tables and related views created
223329415250BUILDSchemaOK7/15/2026 10:54:47 AM [spSpectro.sql]: Spectro functions/sps created
223329415249BUILDSchemaOK7/15/2026 10:54:46 AM [GalaxyProductTables.sql]: Galprod tables and related functions created
223329415248BUILDSchemaOK7/15/2026 10:54:45 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
223329415247BUILDSchemaOK7/15/2026 10:54:45 AM [NeighborTables.sql]: Neighbor and Match tables created
223329415246BUILDSchemaOK7/15/2026 10:54:44 AM [resolveTables.sql]: Resolve tables created
223329415245BUILDSchemaOK7/15/2026 10:54:44 AM [spPhoto.sql]: Photo procedures and functions created
223329415244BUILDSchemaOK7/15/2026 10:54:44 AM [galSpecTables.sql]: galSpec tables and related functions created
223329415243BUILDSchemaOK7/15/2026 10:54:43 AM [PhotoZTables.sql]: Photometric redshifts tables created
223329415242BUILDSchemaOK7/15/2026 10:54:43 AM [PhotoTables.sql]: Photo tables created
223329415241BUILDSchemaOK7/15/2026 10:54:42 AM [Versions.sql]: Versions table created
223329415240BUILDSchemaOK7/15/2026 10:54:42 AM [IndexMap.sql]: Index management tables and procedures built
223329415239BUILDSchemaOK7/15/2026 10:54:36 AM [MetadataTables.sql]: MetaData tables created
223329415238BUILDSchemaOK7/15/2026 10:54:35 AM [ConstantSupport.sql]: Constant support views and functions created
223329415237BUILDSchemaOK7/15/2026 10:54:33 AM [DataConstants.sql]: Constant tables created
223329415236BUILDSchemaOK7/15/2026 10:54:21 AM [FileGroup.sql]: PartitionMap, FileGroupMap tables and procs created
223329415235BUILDSchemaOK7/15/2026 10:54:20 AMStarting schema creation for TEST_DR201 with partitioning=0
223329415234BUILDDatabaseOK7/15/2026 10:54:20 AMConfigured database TEST_DR201
223329415233BUILDDatabaseOK7/15/2026 10:54:20 AMCreated database TEST_DR201
223329415232BUILDDatabaseOK7/15/2026 10:53:01 AMStarting database creation
223329415231BUILDSTARTINGSTART7/15/2026 10:53:01 AMStarting DB build
223329405230CHECKFINISHINGDONE7/15/2026 10:52:14 AMFinished CSV checking
223329405229CHECKFile countOK7/15/2026 10:52:13 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Number of CSV files is 30
223329405228CHECKDir checkOK7/15/2026 10:52:13 AMD:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1:Checking directory
223329405227CHECKOpen debug file OK7/15/2026 10:52:13 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:File opened
223329405226CHECKCheck backup folOK7/15/2026 10:52:13 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Folder exists
223329405225CHECKCheck rootOK7/15/2026 10:52:13 AMd:\sql_db\staging\sdss5\casload\dr20\vcCSV\dr20vacs\1\:Found root directory
223329405224CHECKSTARTINGSTART7/15/2026 10:52:13 AMStarting CSV check