defaria.com/blogs/Status/2005/10/pqa-more-issues.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content=" Investigating PQA issue regarding email links Implementing cleanup of Dynamic Lists Handed off test DB backup to Vinh Investigated data conversion problems...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>PQA: More issues - Status</title>
   8     <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
   9     <link rel="canonical" href="http://defaria.com/blogs/Status/2005/10/pqa-more-issues.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  13     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
  14     <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2005/10/daylight-saving.html" title="Daylight Savings Time &amp; Clearcase">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-ldap.html" title="PQA: LDAP">
  21     <!-- Open Graph Protocol -->
  22     <meta property="og:type" content="article">
  23     <meta property="og:locale" content="en-us">
  24     <meta property="og:title" content="PQA: More issues">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2005/10/pqa-more-issues.html">
  26     <meta property="og:description" content=" Investigating PQA issue regarding email links Implementing cleanup of Dynamic Lists Handed off test DB backup to Vinh Investigated data conversion problems...">
  27     <meta property="og:site_name" content="Status">
  28     <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content=" Investigating PQA issue regarding email links Implementing cleanup of Dynamic Lists Handed off test DB backup to Vinh Investigated data conversion problems...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2005/10/pqa-more-issues.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  62           <div id="content-inner">
  63             <ul class="breadcrumb breadcrumb-list">
  64               <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
  65               <li class="breadcrumb-list-item">PQA: More issues</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1726" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">PQA: More issues</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2005-10-26T16:14:16-08:00" itemprop="datePublished">October 26, 2005</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/pqa/">PQA</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <li>Investigating PQA issue regarding email links</li>
  86
  87   <li>Implementing cleanup of Dynamic Lists</li>
  88
  89   <li>Handed off test DB backup to Vinh</li>
  90
  91   <li>Investigated data conversion problems</li>
  92 </ul>
  93                   <h2>PQA: Remaining Issues</h2>
  94
  95 <p>The following issues came up at this meeting:</p>
  96
  97 <ol>
  98   <li>Requirement to support old style Email Link's (See below)</li>
  99
 100   <li>Update Production Web Server to latest Clearquest version (See below)</li>
 101
 102   <li>Remaining data conversion issues (Emailed Vinh asking for details)</li>
 103
 104   <li>Dynamic List cleanup (Emailed Vinh asking for updates)</li>
 105
 106   <li>Test DB hand off (Emailed Vinh pointing to backups of my converted database for him to test)</li>
 107 </ol>
 108
 109 <p>Vinh provided an example: http://extranet.broadcom.com/cqweb/url/default.asp?id=Prod00014218. There are several problems with this. First the default.asp indicates an IIS server and an ASP web application. The new version of RWP is not IIS based rather it is Apache based. I cannot find a default.asp in RWP at all. Thus the above style link will not work.</p>
 110
 111 <p>Vinh says that he generates through hooks in CQ. I suspect what is happening is this: When a defect changes state action hooks kick in and determine it's time to send email to notify the appropriate people that a change in state has happened. At this time Vinh's hooks change/generate these links. As such Vinh needs to change his hooks to generate new URLs that conform to the new Clearquest software. One question I have is how did Vinh come up with http://<servername>/url/default.asp?id=<ID> as a syntactical template meaning "Show this specific defect"? I cannot find where this is documented.</p>
 112
 113 <p>I tried http://p4test/url/default.asp?id=<ID> on p4test and that doesn't work. Perhaps this is just an issue of figuring out what the correct URL template is and changing the hook. The hook could also be modified to perhaps add links for http://<server>/<path>/<script>?old_id=<ID> if that is possible. This would then take care of all future emailed URL's. I'm not sure how to account for old emails that may have now invalid links.</p>
 114
 115 <p>I did see that the new Web interface has a Email Defect link which produces URLs of the form: http://p4test/cqweb/main?command=GenerateMainFrame&service=CQ&schema=2005.02.00&contextid=Cont&entityID=33580034&entityDefName=Defect</p>
 116
 117 <p>(Decidedly not user friendly).</p>
 118
 119 <p>The question remains whether or not to go with upgrading the production server to the newest version of Clearquest so we can get the new version of Clearquest Web. It is a different web interface. Ray is looking into getting another machine so we can have both new and old versions of Clearquest Web. One issue is that if we do go to the merged database and new Clearquest Web and run for a while then decide there is some critical flaw, going back to the old Web server will also mean going back to the old databases and losing any work done during the time we were on the new setup.</p>
 120
 121 <h2>Data Conversion Problems</h2>
 122
 123 <p>Vinh wrote:</p>
 124
 125 <blockquote type=cite>
 126   <p>by compare with Prod0009710, not match values for these</p>
 127
 128   <ol>
 129     <li>SW Version</li>
 130
 131     <li>Time From Resolve To Verify</li>
 132
 133     <li>Closed Date</li>
 134   </ol>
 135 </blockquote>
 136
 137 <p># 1 was due to a bug - I fixed this.</p>
 138
 139 <p># 2 and 3 are due to the fact that these fields are set to readonly. The odd thing is that they do not appear to have any good. The question then is how do they obtain values? My guess is that these values are fielded in by some other sort of hook script at some time. My workaround is to add these to the list of fields that must be toggled to optional in order for the conversion to work and toggled back after the conversion. My fear is what other fields are like these?</p>
 140
 141 <p>The list of readonly fields in the schema are:</p>
 142
 143 <ol>
 144   <li>Fixed_In_Project</li>
 145
 146   <li>Close_Date (Mentioned above)</li>
 147
 148   <li>Submit_Date (Already toggled to optional)</li>
 149
 150   <li>Submitter (Already toggled to optional)</li>
 151
 152   <li>Notes_Log</li>
 153
 154   <li>old_id (Already toggled to optional)</li>
 155
 156   <li>TimeFromSubmitToVerify</li>
 157
 158   <li>TimeToVerify (Time From Resolve To Verify mentioned above)</li>
 159
 160   <li>Audit_Log (Already toggled to optional)</li>
 161 </ol>
 162
 163 <p>My guess here is that the other fields (#1, 5 & 7 above) are also empty. The solution therefore it to toggle all readonly fields in the list above to optional before performing the merge.</p>
 164                 </div>
 165                 <nav class="page-navigation entry-navigation pagination content-nav">
 166                   <ul class="page-navigation-list">
 167
 168                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/10/daylight-saving.html" title="Daylight Savings Time &amp; Clearcase">Previous entry</a></li>
 169
 170
 171                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-ldap.html" title="PQA: LDAP">Next entry</a></li>
 172
 173                   </ul>
 174                 </nav>
 175                 <!--
 176 <aside id="zenback" class="zenback feedback">
 177   Please paste Zenback script code here.
 178 </aside>
 179 -->
 180
 181
 182               </article>
 183             </div>
 184             <aside class="widgets related" role="complementary">
 185               <nav class="widget-search widget">
 186   <div class="widget-content">
 187     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 188       <div>
 189         <input type="text" name="search" value="" placeholder="Search...">
 190
 191         <input type="hidden" name="IncludeBlogs" value="8">
 192
 193         <input type="hidden" name="limit" value="20">
 194         <button type="submit" name="button">
 195           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 196         </button>
 197       </div>
 198     </form>
 199   </div>
 200 </nav>
 201 <nav class="widget-archive-category widget">
 202   <h3 class="widget-header">Categories</h3>
 203   <div class="widget-content">
 204
 205
 206     <ul class="widget-list">
 207
 208
 209       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 210
 211
 212       </li>
 213
 214
 215
 216
 217       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 218
 219
 220       </li>
 221
 222
 223
 224
 225       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 226
 227
 228       </li>
 229
 230
 231
 232
 233       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 234
 235
 236       </li>
 237
 238
 239
 240
 241       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 242
 243
 244       </li>
 245
 246
 247
 248
 249       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 250
 251
 252       </li>
 253
 254
 255
 256
 257       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 258
 259
 260       </li>
 261
 262
 263
 264
 265       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 266
 267
 268       </li>
 269
 270
 271
 272
 273       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 274
 275
 276       </li>
 277
 278
 279
 280
 281       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 282
 283
 284       </li>
 285
 286
 287
 288
 289       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 290
 291
 292       </li>
 293
 294
 295
 296
 297       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 298
 299
 300       </li>
 301
 302     </ul>
 303
 304
 305   </div>
 306 </nav>
 307
 308
 309 <nav class="widget-archive-dropdown widget">
 310   <h3 class="widget-header">Archives</h3>
 311   <div class="widget-content">
 312     <select>
 313       <option>Select a Month...</option>
 314
 315       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 316
 317
 318
 319       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 320
 321
 322
 323       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 324
 325
 326
 327       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 328
 329
 330
 331       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 332
 333
 334
 335       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 336
 337
 338
 339       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 340
 341
 342
 343       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 344
 345
 346
 347       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 348
 349
 350
 351       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 352
 353
 354
 355       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 356
 357
 358
 359       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 360
 361
 362
 363       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 364
 365
 366
 367       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 368
 369
 370
 371       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 372
 373
 374
 375       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 376
 377
 378
 379       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 380
 381
 382
 383       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 384
 385
 386
 387       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 388
 389
 390
 391       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 392
 393
 394
 395       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 396
 397
 398
 399       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 400
 401
 402
 403       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 404
 405
 406
 407       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 408
 409
 410
 411       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 412
 413
 414
 415       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 416
 417
 418
 419       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 420
 421
 422
 423       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 424
 425
 426
 427       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 428
 429
 430
 431       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 432
 433
 434
 435       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 436
 437
 438
 439       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 440
 441
 442
 443       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 444
 445
 446
 447       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 448
 449
 450
 451       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 452
 453
 454
 455       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 456
 457
 458
 459       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 460
 461
 462
 463       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 464
 465
 466
 467       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 468
 469
 470
 471       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 472
 473
 474
 475       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 476
 477
 478
 479       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 480
 481
 482
 483       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 484
 485
 486
 487       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 488
 489
 490
 491       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 492
 493
 494
 495       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 496
 497
 498
 499       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 500
 501
 502
 503       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 504
 505
 506
 507       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 508
 509
 510
 511       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 512
 513
 514
 515       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 516
 517
 518
 519       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 520
 521
 522
 523       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 524
 525
 526
 527       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 528
 529
 530
 531       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 532
 533
 534
 535       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 536
 537
 538
 539       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 540
 541
 542
 543       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 544
 545
 546
 547       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 548
 549
 550
 551       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 552
 553
 554
 555       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 556
 557
 558
 559       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 560
 561
 562
 563       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 564
 565
 566
 567       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 568
 569
 570
 571       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 572
 573
 574
 575       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 576
 577
 578
 579       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 580
 581
 582
 583       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 584
 585
 586
 587       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 588
 589
 590
 591       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 592
 593
 594
 595       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 596
 597
 598
 599       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 600
 601     </select>
 602   </div>
 603 </nav>
 604
 605
 606
 607 <div class="widget-syndication widget section">
 608   <div class="widget-content">
 609     <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
 610
 611   </div>
 612 </div>
 613
 614             </aside>
 615           </div>
 616         </div>
 617         <footer id="footer" role="contentinfo">
 618           <div id="footer-inner">
 619             <div id="footer-content">
 620   <nav role="navigation">
 621           <ul>
 622             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 623
 624
 625           </ul>
 626         </nav>
 627
 628   <p class="license">&copy; Copyright 2016.</p>
 629   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 630 </div>
 631           </div>
 632         </footer>
 633       </div>
 634     </div>
 635     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 636     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 637   </body>
 638 </html>