taskid | stepid | phaseid | stepname | phasename | status | tstop | comment |
3 | 4 | 63 | CHECK | STARTING | START | 5/17/2003 3:10:31 PM | Starting CSV check |
3 | 4 | 64 | CHECK | Check root | OK | 5/17/2003 3:10:33 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\:Found root directory |
3 | 4 | 65 | CHECK | Dir check | OK | 5/17/2003 3:10:33 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191:Checking directory |
3 | 4 | 66 | CHECK | File count | OK | 5/17/2003 3:10:35 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191:Number of CSV files is 1 |
3 | 4 | 67 | CHECK | Dir check | OK | 5/17/2003 3:10:35 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\1339:Checking directory |
3 | 4 | 68 | CHECK | File count | OK | 5/17/2003 3:10:35 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\1339:Number of CSV files is 12 |
3 | 4 | 69 | CHECK | JPG count | OK | 5/17/2003 3:10:36 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\1339\zoom:Number of JPG files is 3570 |
3 | 4 | 70 | CHECK | Dir check | OK | 5/17/2003 3:10:36 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\1336:Checking directory |
3 | 4 | 71 | CHECK | File count | OK | 5/17/2003 3:10:36 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\1336:Number of CSV files is 12 |
3 | 4 | 72 | CHECK | JPG count | OK | 5/17/2003 3:10:37 PM | \\sxatlas\staging2\loadtest2\phCSV\best\1-42-750191\1336\zoom:Number of JPG files is 3570 |
3 | 4 | 73 | CHECK | FINISHING | DONE | 5/17/2003 3:10:37 PM | Finished CSV checking |
3 | 5 | 74 | BUILD | STARTING | START | 5/17/2003 3:11:01 PM | Starting DB build |
3 | 5 | 75 | BUILD | Database | OK | 5/17/2003 3:11:01 PM | Starting database creation |
3 | 5 | 76 | BUILD | Database | OK | 5/17/2003 3:17:19 PM | Created database TEST_BEST1_42_750191 |
3 | 5 | 77 | BUILD | Database | OK | 5/17/2003 3:17:20 PM | Configured database TEST_BEST1_42_750191 |
3 | 5 | 78 | BUILD | Schema | OK | 5/17/2003 3:17:20 PM | Starting schema creation for TEST_BEST1_42_750191 |
3 | 5 | 79 | BUILD | Schema | OK | 5/17/2003 3:17:21 PM | Created FileGroupMap table and procs |
3 | 5 | 80 | BUILD | Schema | OK | 5/17/2003 3:17:27 PM | Constant tables created |
3 | 5 | 81 | BUILD | Schema | OK | 5/17/2003 3:17:42 PM | Constant support functions created |
3 | 5 | 82 | BUILD | Schema | OK | 5/17/2003 3:17:45 PM | MetaData Tables created. |
3 | 5 | 83 | BUILD | Schema | OK | 5/17/2003 3:17:54 PM | Photo tables created |
3 | 5 | 84 | BUILD | Schema | OK | 5/17/2003 3:17:55 PM | Neighbor tables created |
3 | 5 | 85 | BUILD | Schema | OK | 5/17/2003 3:18:02 PM | Spec tables created |
3 | 5 | 86 | BUILD | Schema | OK | 5/17/2003 3:18:05 PM | Views created |
3 | 5 | 87 | BUILD | Schema | OK | 5/17/2003 3:18:07 PM | HTM functions created |
3 | 5 | 88 | BUILD | Schema | OK | 5/17/2003 3:18:11 PM | Proximity functions created |
3 | 5 | 89 | BUILD | Schema | OK | 5/17/2003 3:18:13 PM | Zoom tables created |
3 | 5 | 90 | BUILD | Schema | OK | 5/17/2003 3:18:21 PM | WebSupport tables and functions created. |
3 | 5 | 91 | BUILD | Schema | OK | 5/17/2003 3:18:24 PM | Boundary tables and functions created |
3 | 5 | 92 | BUILD | Schema | OK | 5/17/2003 3:18:25 PM | MyTimeX procedures created |
3 | 5 | 93 | BUILD | Schema | OK | 5/17/2003 3:18:26 PM | spSetValues procedure created |
3 | 5 | 94 | BUILD | Schema | OK | 5/17/2003 3:18:28 PM | spValidate created |
3 | 5 | 95 | BUILD | Schema | OK | 5/17/2003 3:18:30 PM | Index management stored procedures built |
3 | 5 | 96 | BUILD | Schema | OK | 5/17/2003 3:18:31 PM | spBackupStep and spCleanupStep created |
3 | 5 | 97 | BUILD | Schema | OK | 5/17/2003 3:18:33 PM | spPublishStep installed |
3 | 5 | 98 | BUILD | Schema | OK | 5/17/2003 3:18:34 PM | spFinish procedures created |
3 | 5 | 99 | BUILD | Schema | OK | 5/17/2003 3:18:35 PM | Installed spGrantAccess |
3 | 5 | 100 | BUILD | Schema | OK | 5/17/2003 3:18:35 PM | Schema created for TEST_BEST1_42_750191 |
3 | 5 | 101 | BUILD | FINISHING | DONE | 5/17/2003 3:18:35 PM | Finished building DB |
3 | 6 | 102 | PRELOAD | STARTING | START | 5/17/2003 3:18:35 PM | Starting SQL Preload |
3 | 6 | 103 | PRELOAD | CSV load | OK | 5/17/2003 3:18:35 PM | Starting File load |
3 | 6 | 104 | PRELOAD | CSV load | OK | 5/17/2003 4:25:19 PM | Finished File load |
3 | 6 | 105 | PRELOAD | CSV load | OK | 5/17/2003 4:25:19 PM | All files are loaded |
3 | 6 | 106 | PRELOAD | CSV load | OK | 5/17/2003 4:25:19 PM | All rows have been loaded |
3 | 6 | 107 | PRELOAD | Set values | OK | 5/17/2003 4:25:19 PM | loadVersion updated |
3 | 6 | 108 | PRELOAD | Set values | OK | 5/17/2003 4:26:59 PM | Simplified magnitudes set |
3 | 6 | 109 | PRELOAD | Set values | OK | 5/17/2003 4:27:00 PM | Deleted 0 rows from the ObjMask table in HOLE fields |
3 | 6 | 110 | PRELOAD | Set values | OK | 5/17/2003 4:27:00 PM | Starting Frame HTM computation |
3 | 6 | 111 | PRELOAD | Set values | OK | 5/17/2003 4:28:59 PM | Frame HTM computed |
3 | 6 | 112 | PRELOAD | Set values | OK | 5/17/2003 4:31:28 PM | Mask HTM computed |
3 | 6 | 113 | PRELOAD | Set values | WARNING | 5/17/2003 4:31:28 PM | todo: need to add Boundary calculations !!! |
3 | 6 | 114 | PRELOAD | FINISHING | DONE | 5/17/2003 4:31:28 PM | Finished SQL preload |
3 | 7 | 115 | VALIDATE | STARTING | START | 5/17/2003 4:31:29 PM | Validating best database 1-42-750191 |
3 | 7 | 116 | VALIDATE | spValidatePhoto | OK | 5/17/2003 4:31:29 PM | spValidatePhoto called |
3 | 7 | 117 | VALIDATE | Unique key test | OK | 5/17/2003 4:31:29 PM | Unique key test passed on Chunk(chunkId) |
3 | 7 | 118 | VALIDATE | Unique key test | OK | 5/17/2003 4:31:29 PM | Unique key test passed on Segment(segmentID) |
3 | 7 | 119 | VALIDATE | Unique key test | OK | 5/17/2003 4:31:29 PM | Unique key test passed on StripeDefs(stripe) |
3 | 7 | 120 | VALIDATE | Unique key test | OK | 5/17/2003 4:31:29 PM | Unique key test passed on Field(FieldID) |
3 | 7 | 121 | VALIDATE | Unique key test | OK | 5/17/2003 4:31:30 PM | Unique key test passed on FieldProfile(fieldID, bin, band) |
3 | 7 | 122 | VALIDATE | Unique key test | OK | 5/17/2003 4:31:30 PM | Unique key test passed on Frame(FieldID,Zoom) |
3 | 7 | 123 | VALIDATE | Unique key test | OK | 5/17/2003 4:32:00 PM | Unique key test passed on PhotoObjAll(objID) |
3 | 7 | 124 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:23 PM | Unique key test passed on PhotoProfile(objID, bin, band) |
3 | 7 | 125 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:24 PM | Unique key test passed on PhotoZ(objID) |
3 | 7 | 126 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:24 PM | Unique key test passed on First(objID) |
3 | 7 | 127 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:24 PM | Unique key test passed on Rosat(objID) |
3 | 7 | 128 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:27 PM | Unique key test passed on USNO(objID) |
3 | 7 | 129 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:28 PM | Unique key test passed on Mask(maskID) |
3 | 7 | 130 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:35 PM | Unique key test passed on ObjMask(objID) |
3 | 7 | 131 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:36 PM | Unique key test passed on Target(targetID) |
3 | 7 | 132 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:36 PM | Unique key test passed on TargetInfo(targetObjID) |
3 | 7 | 133 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:36 PM | Unique key test passed on TargetInfo(skyVersion,targetID) |
3 | 7 | 134 | VALIDATE | Unique key test | OK | 5/17/2003 4:38:36 PM | Unique key test passed on TargetParam(targetVersion,paramName) |
3 | 7 | 135 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:36 PM | Foreign key test passed on table: Chunk(stripe) ->StripeDefs |
3 | 7 | 136 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:36 PM | Foreign key test passed on table: Segment(stripe) ->StripeDefs |
3 | 7 | 137 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:36 PM | Foreign key test passed on table: Segment(chunkID) ->Chunk |
3 | 7 | 138 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:36 PM | Foreign key test passed on table: Field(segmentID) ->Segment |
3 | 7 | 139 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:36 PM | Foreign key test passed on table: Frame(fieldID) ->Field |
3 | 7 | 140 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:36 PM | Foreign key test passed on table: FieldProfile(fieldID) ->Field |
3 | 7 | 141 | VALIDATE | Foreign key test | OK | 5/17/2003 4:38:50 PM | Foreign key test passed on table: photoObjAll(fieldID) ->Field |
3 | 7 | 142 | VALIDATE | Foreign key test | OK | 5/17/2003 4:39:34 PM | Foreign key test passed on table: PhotoProfile(ObjID) ->photoObjAll |
3 | 7 | 143 | VALIDATE | Foreign key test | OK | 5/17/2003 4:39:34 PM | Foreign key test passed on table: PhotoZ(ObjID) ->photoObjAll |
3 | 7 | 144 | VALIDATE | Foreign key test | OK | 5/17/2003 4:39:37 PM | Foreign key test passed on table: ObjMask(ObjID) ->photoObjAll |
3 | 7 | 145 | VALIDATE | Foreign key test | OK | 5/17/2003 4:39:37 PM | Foreign key test passed on table: First(ObjID) ->photoObjAll |
3 | 7 | 146 | VALIDATE | Foreign key test | OK | 5/17/2003 4:39:39 PM | Foreign key test passed on table: Rosat(ObjID) ->photoObjAll |
3 | 7 | 147 | VALIDATE | Foreign key test | OK | 5/17/2003 4:40:03 PM | Foreign key test passed on table: USNO(ObjID) ->photoObjAll |
3 | 7 | 148 | VALIDATE | Foreign key test | OK | 5/17/2003 4:40:03 PM | Foreign key test passed on table: TargetInfo(targetID) ->Target |
3 | 7 | 149 | VALIDATE | Test Mask is in | OK | 5/17/2003 4:40:04 PM | Passed Test Mask is in Field test |
3 | 7 | 150 | VALIDATE | Test Segment.nFi | OK | 5/17/2003 4:40:04 PM | Passed Test Segment.nFields test |
3 | 7 | 151 | VALIDATE | Test Field.nObje | OK | 5/17/2003 4:40:18 PM | Passed Test Field.nObjects test |
3 | 7 | 152 | VALIDATE | Test Field zoom | OK | 5/17/2003 4:40:18 PM | Passed Test Field zoom levels test |
3 | 7 | 153 | VALIDATE | Test photoObjAll | OK | 5/17/2003 4:42:24 PM | Passed Test photoObjAll.nProf_ugriz test |
3 | 7 | 154 | VALIDATE | HTM test | OK | 5/17/2003 4:42:25 PM | HTM test passed on table: Frame |
3 | 7 | 155 | VALIDATE | HTM test | OK | 5/17/2003 4:42:25 PM | HTM test passed on table: Mask |
3 | 7 | 156 | VALIDATE | HTM test | OK | 5/17/2003 4:42:25 PM | HTM test passed on table: photoObjAll |
3 | 7 | 157 | VALIDATE | Photo Parent tes | OK | 5/17/2003 4:42:49 PM | photoObjAll Parent test succeeded |
3 | 7 | 158 | VALIDATE | spValidatePhoto | OK | 5/17/2003 4:42:49 PM | Photo validated in 680.913 seconds |
3 | 7 | 159 | VALIDATE | FINISHING | DONE | 5/17/2003 4:42:50 PM | Validated photo best id: 1-42-750191 |
3 | 8 | 160 | BACKUP | STARTING | START | 5/17/2003 4:42:50 PM | Backing up best database 1-42-750191 to \\sneakernet0\dr1backup\TEST_BEST1_42_750191_backup.dat |
3 | 8 | 161 | BACKUP | Checkpoint | OK | 5/17/2003 4:42:50 PM | Checkpoint done |
3 | 8 | 162 | BACKUP | ShrinkDB | OK | 5/17/2003 4:42:53 PM | Shrink DB done |
3 | 8 | 163 | BACKUP | Checkpoint | OK | 5/17/2003 4:42:53 PM | Checkpoint done |
3 | 8 | 164 | BACKUP | Backup | OK | 5/17/2003 4:50:29 PM | Backed up Database TEST_BEST1_42_750191 done to file \\sneakernet0\dr1backup\TEST_BEST1_42_750191_backup.dat |
3 | 8 | 165 | BACKUP | FINISHING | DONE | 5/17/2003 4:50:29 PM | Backed up Database TEST_BEST1_42_750191 done to file \\sneakernet0\dr1backup\TEST_BEST1_42_750191_backup.dat |
3 | 9 | 166 | DETACH | STARTING | START | 5/17/2003 4:50:29 PM | Starting DB detach |
3 | 9 | 167 | DETACH | FINISHING | DONE | 5/17/2003 4:50:29 PM | Detached Database TEST_BEST1_42_750191 |
3 | 10 | 168 | PUBLISH | STARTING | START | 5/17/2003 4:51:01 PM | Publishing best SDSSAD2.TEST_BEST1_42_750191 to SDSSAD2.BESTTEST |
3 | 10 | 170 | PUBLISH | Attach | OK | 5/17/2003 4:51:02 PM | Successfully attached SDSSAD2.TEST_BEST1_42_750191 in file: \\SDSSAD2\d$\sql_db\TEST_BEST1_42_750191_Data.MDF |
3 | 10 | 172 | PUBLISH | spPublishPhoto | OK | 5/17/2003 4:51:02 PM | Starting spPublishPhoto |
3 | 10 | 173 | PUBLISH | TableCopy | OK | 5/17/2003 4:51:02 PM | published 1 rows of table TEST_BEST1_42_750191.dbo.Chunk to table BESTTEST.dbo.Chunk |
3 | 10 | 174 | PUBLISH | TableCopy | OK | 5/17/2003 4:51:02 PM | published 12 rows of table TEST_BEST1_42_750191.dbo.Segment to table BESTTEST.dbo.Segment |
3 | 10 | 175 | PUBLISH | TableCopy | OK | 5/17/2003 4:51:03 PM | published 1020 rows of table TEST_BEST1_42_750191.dbo.Field to table BESTTEST.dbo.Field |
3 | 10 | 176 | PUBLISH | TableCopy | OK | 5/17/2003 4:52:30 PM | published 7140 rows of table TEST_BEST1_42_750191.dbo.Frame to table BESTTEST.dbo.Frame |
3 | 10 | 177 | PUBLISH | TableCopy | OK | 5/17/2003 4:52:31 PM | published 46449 rows of table TEST_BEST1_42_750191.dbo.FieldProfile to table BESTTEST.dbo.FieldProfile |
3 | 10 | 178 | PUBLISH | TableCopy | OK | 5/17/2003 5:00:27 PM | published 1240134 rows of table TEST_BEST1_42_750191.dbo.PhotoObjAll to table BESTTEST.dbo.PhotoObjAll |
3 | 10 | 179 | PUBLISH | TableCopy | OK | 5/17/2003 5:12:06 PM | published 43806059 rows of table TEST_BEST1_42_750191.dbo.PhotoProfile to table BESTTEST.dbo.PhotoProfile |
3 | 10 | 180 | PUBLISH | TableCopy | OK | 5/17/2003 5:12:06 PM | published 0 rows of table TEST_BEST1_42_750191.dbo.PhotoZ to table BESTTEST.dbo.PhotoZ |
3 | 10 | 181 | PUBLISH | TableCopy | OK | 5/17/2003 5:12:06 PM | published 413 rows of table TEST_BEST1_42_750191.dbo.First to table BESTTEST.dbo.First |
3 | 10 | 182 | PUBLISH | TableCopy | OK | 5/17/2003 5:12:07 PM | published 7597 rows of table TEST_BEST1_42_750191.dbo.Rosat to table BESTTEST.dbo.Rosat |
3 | 10 | 183 | PUBLISH | TableCopy | OK | 5/17/2003 5:12:14 PM | published 535963 rows of table TEST_BEST1_42_750191.dbo.USNO to table BESTTEST.dbo.USNO |
3 | 10 | 184 | PUBLISH | TableCopy | OK | 5/17/2003 5:12:16 PM | published 67755 rows of table TEST_BEST1_42_750191.dbo.Mask to table BESTTEST.dbo.Mask |
3 | 10 | 185 | PUBLISH | TableCopy | OK | 5/17/2003 5:14:34 PM | published 1181919 rows of table TEST_BEST1_42_750191.dbo.ObjMask to table BESTTEST.dbo.ObjMask |
3 | 10 | 186 | PUBLISH | TableCopy | OK | 5/17/2003 5:14:34 PM | published 0 rows of table TEST_BEST1_42_750191.dbo.Target to table BESTTEST.dbo.Target |
3 | 10 | 187 | PUBLISH | TableCopy | OK | 5/17/2003 5:14:34 PM | published 0 rows of table TEST_BEST1_42_750191.dbo.TargetInfo to table BESTTEST.dbo.TargetInfo |
3 | 10 | 188 | PUBLISH | TableCopy | OK | 5/17/2003 5:14:34 PM | published 0 rows of table TEST_BEST1_42_750191.dbo.TargetParam to table BESTTEST.dbo.TargetParam |
3 | 10 | 189 | PUBLISH | spPublishPhoto | OK | 5/17/2003 5:14:34 PM | Published Photo Tables |
3 | 10 | 190 | PUBLISH | FINISHING | DONE | 5/17/2003 5:14:34 PM | Published Photo best from: SDSSAD2.TEST_BEST1_42_750191 to: SDSSAD2.BESTTEST |
3 | 12 | 192 | CLEANUP | STARTING | START | 5/17/2003 5:14:34 PM | Starting cleanup |
3 | 12 | 193 | CLEANUP | FINISHING | DONE | 5/17/2003 5:14:34 PM | Deleted db TEST_BEST1_42_750191 |