defaria.com/blogs/Status/2005/11/several-pqa-fix.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=" Added Exit Sub/Function to several validation and initialization functions in order to allow TransferState to work Fixed some bugs with Fixed_In_SW_Version and OS values of "Novell 6 Pack Beta 3 ". Not sure how this got by before with...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>Several PQA Fixes - 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/11/several-pqa-fix.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/11/final-pqa-fixes.html" title="Final PQA fixes">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2005/11/finalizing-pqam.html" title="Finalizing pqamerge">
  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="Several PQA Fixes">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2005/11/several-pqa-fix.html">
  26     <meta property="og:description" content=" Added Exit Sub/Function to several validation and initialization functions in order to allow TransferState to work Fixed some bugs with Fixed_In_SW_Version and OS values of &quot;Novell 6 Pack Beta 3 &quot;. Not sure how this got by before with...">
  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=" Added Exit Sub/Function to several validation and initialization functions in order to allow TransferState to work Fixed some bugs with Fixed_In_SW_Version and OS values of "Novell 6 Pack Beta 3 ". Not sure how this got by before with...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2005/11/several-pqa-fix.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">Several PQA Fixes</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1740" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">Several PQA Fixes</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2005-11-12T12:17:00-08:00" itemprop="datePublished">November 12, 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>Added Exit Sub/Function to several validation and initialization functions in order to allow TransferState to work</li>
  86
  87   <li>Fixed some bugs with Fixed_In_SW_Version and OS values of "Novell 6 Pack Beta 3 ". Not sure how this got by before with the trailing space but it raised it's ugly head in TransferStates</li>
  88
  89   <li>Change pqamerge to treat the Submit state like the Assigned state</li>
  90
  91   <li>With implementation of ID equality, I have to constantly regenerate the database from scratch. Experienced some problems with this and had to change the schema by allowing admin to submit. This may have been a different problem in that I now need to subscribe all users and groups to Cont database and Upgrade the database each time I create it a new</li>
  92
  93   <li>Transitioning through states have reveal some fields that where not initially tranfered from the TO database. The fields missed were ResolvedBy, ResolveNote and VerifyNote</li>
  94 </ul>
  95                   <h2>Additional Schema Action Hook Changes</h2>
  96
  97 <p>In order to set State properly pqamerge needs to transition through states to get to the desired end state. For eample, many defects in Prod are in the Closed state. But when pqamerge first creates the defect in Cont it will be in the Assigned state. In order to get to the Closed state pqamerge need to apply the Resolve, Verify and Close actions. As such it triggers state change action hook code.</p>
  98
  99 <p>For example, in order to transition to the Verified state the Verify action must be applied. When the Verify action happens the action hooks for Verify are run. Part of what they do is initalize owner to blank. It is expected that the user exectuting the Verify action will fill that in. But that messes us up since we are not a person and we already have the "correct" data. Investigating this further reveals other places where, for example, the current date is put into a field such as Resolve_Date and calculations are made in other fields such TimeFromSubmitToResolve. We don't want any of that happening!</p>
 100
 101 <p>To resolve these issues the following Action Hooks have an Exit Sub or Exit Function placed at the beginning of the subroutine or function call so as to avoid the incorrect updating of data fields and so that email is not send out (the other thing many of these Action Hooks do):</p>
 102
 103 <ul>
 104   <li>Submit: Validation</li>
 105
 106   <li>Assign: Notification</li>
 107
 108   <li>Resolve: Initialization; Validation; Notification</li>
 109
 110   <li>Verify: Initialization; Validation; Notification</li>
 111
 112   <li>Re-Open: Notification</li>
 113
 114   <li>Close: Initialization; Notification</li>
 115
 116   <li>Modify: Notification</li>
 117
 118   <li>Unassign: Notification</li>
 119
 120   <li>DoesNotVerify: Initialization; Validation; Notification</li>
 121
 122   <li>VerifiedPendingCustVerify: Notification</li>
 123
 124   <li>CustomerVerified: Notification</li>
 125
 126   <li>Data_Pending: Notification</li>
 127 </ul>
 128
 129 <p>I should have just done all of them or perhaps tried to change the Actions table from use Basic script to script None but the above set seems to be working.</p>
 130
 131 <h2>Data Issue</h2>
 132
 133 <p>Ran the merge and now it's taking 6 hours 54 minutes 39 seconds. This is due to running through the various states to obtain the appropriate state and "burning" IDs so that the IDs match. One remaining problem that I don't know how to fix: Defect Prod00012546 is in the closed state yet lacks any VerifyNote. When transfered to Cont pqamerge tries to go through the states and gets stuck trying to transition this defect from Resolved -> Verify due to the lack of a VerifyNote. I do not know how this happened in the Prod database. The only thing I can think of is that somebody modified Prod00012546 <strong>after</strong> it passed the Verified state blanking out VerifyNote.</p>
 134
 135 <p>I'm running check_attachments now and I expect that to result is 0 differences in attachments.</p>
 136
 137 <div class="code"><pre>
 138 vobadm@P4TEST /dev/d/PQA
 139 $ cqperl W:/it_scm/adm/cq/check_attachments -v
 140 Grand total (old): 2955822684
 141 Grand total (new): 2955822684
 142 </pre></div>
 143                 </div>
 144                 <nav class="page-navigation entry-navigation pagination content-nav">
 145                   <ul class="page-navigation-list">
 146
 147                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/11/final-pqa-fixes.html" title="Final PQA fixes">Previous entry</a></li>
 148
 149
 150                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/11/finalizing-pqam.html" title="Finalizing pqamerge">Next entry</a></li>
 151
 152                   </ul>
 153                 </nav>
 154                 <!--
 155 <aside id="zenback" class="zenback feedback">
 156   Please paste Zenback script code here.
 157 </aside>
 158 -->
 159
 160
 161               </article>
 162             </div>
 163             <aside class="widgets related" role="complementary">
 164               <nav class="widget-search widget">
 165   <div class="widget-content">
 166     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 167       <div>
 168         <input type="text" name="search" value="" placeholder="Search...">
 169
 170         <input type="hidden" name="IncludeBlogs" value="8">
 171
 172         <input type="hidden" name="limit" value="20">
 173         <button type="submit" name="button">
 174           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 175         </button>
 176       </div>
 177     </form>
 178   </div>
 179 </nav>
 180 <nav class="widget-archive-category widget">
 181   <h3 class="widget-header">Categories</h3>
 182   <div class="widget-content">
 183
 184
 185     <ul class="widget-list">
 186
 187
 188       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 189
 190
 191       </li>
 192
 193
 194
 195
 196       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 197
 198
 199       </li>
 200
 201
 202
 203
 204       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 205
 206
 207       </li>
 208
 209
 210
 211
 212       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 213
 214
 215       </li>
 216
 217
 218
 219
 220       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 221
 222
 223       </li>
 224
 225
 226
 227
 228       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 229
 230
 231       </li>
 232
 233
 234
 235
 236       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 237
 238
 239       </li>
 240
 241
 242
 243
 244       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 245
 246
 247       </li>
 248
 249
 250
 251
 252       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 253
 254
 255       </li>
 256
 257
 258
 259
 260       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 261
 262
 263       </li>
 264
 265
 266
 267
 268       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 269
 270
 271       </li>
 272
 273
 274
 275
 276       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 277
 278
 279       </li>
 280
 281     </ul>
 282
 283
 284   </div>
 285 </nav>
 286
 287
 288 <nav class="widget-archive-dropdown widget">
 289   <h3 class="widget-header">Archives</h3>
 290   <div class="widget-content">
 291     <select>
 292       <option>Select a Month...</option>
 293
 294       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 295
 296
 297
 298       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 299
 300
 301
 302       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 303
 304
 305
 306       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 307
 308
 309
 310       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 311
 312
 313
 314       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 315
 316
 317
 318       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 319
 320
 321
 322       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 323
 324
 325
 326       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 327
 328
 329
 330       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 331
 332
 333
 334       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 335
 336
 337
 338       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 339
 340
 341
 342       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 343
 344
 345
 346       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 347
 348
 349
 350       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 351
 352
 353
 354       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 355
 356
 357
 358       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 359
 360
 361
 362       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 363
 364
 365
 366       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 367
 368
 369
 370       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 371
 372
 373
 374       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 375
 376
 377
 378       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 379
 380
 381
 382       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 383
 384
 385
 386       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 387
 388
 389
 390       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 391
 392
 393
 394       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 395
 396
 397
 398       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 399
 400
 401
 402       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 403
 404
 405
 406       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 407
 408
 409
 410       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 411
 412
 413
 414       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 415
 416
 417
 418       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 419
 420
 421
 422       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 423
 424
 425
 426       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 427
 428
 429
 430       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 431
 432
 433
 434       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 435
 436
 437
 438       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 439
 440
 441
 442       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 443
 444
 445
 446       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 447
 448
 449
 450       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 451
 452
 453
 454       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 455
 456
 457
 458       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 459
 460
 461
 462       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 463
 464
 465
 466       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 467
 468
 469
 470       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 471
 472
 473
 474       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 475
 476
 477
 478       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 479
 480
 481
 482       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 483
 484
 485
 486       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 487
 488
 489
 490       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 491
 492
 493
 494       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 495
 496
 497
 498       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 499
 500
 501
 502       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 503
 504
 505
 506       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 507
 508
 509
 510       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 511
 512
 513
 514       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 515
 516
 517
 518       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 519
 520
 521
 522       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 523
 524
 525
 526       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 527
 528
 529
 530       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 531
 532
 533
 534       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 535
 536
 537
 538       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 539
 540
 541
 542       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 543
 544
 545
 546       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 547
 548
 549
 550       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 551
 552
 553
 554       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 555
 556
 557
 558       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 559
 560
 561
 562       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 563
 564
 565
 566       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 567
 568
 569
 570       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 571
 572
 573
 574       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 575
 576
 577
 578       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 579
 580     </select>
 581   </div>
 582 </nav>
 583
 584
 585
 586 <div class="widget-syndication widget section">
 587   <div class="widget-content">
 588     <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>
 589
 590   </div>
 591 </div>
 592
 593             </aside>
 594           </div>
 595         </div>
 596         <footer id="footer" role="contentinfo">
 597           <div id="footer-inner">
 598             <div id="footer-content">
 599   <nav role="navigation">
 600           <ul>
 601             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 602
 603
 604           </ul>
 605         </nav>
 606
 607   <p class="license">&copy; Copyright 2016.</p>
 608   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 609 </div>
 610           </div>
 611         </footer>
 612       </div>
 613     </div>
 614     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 615     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 616   </body>
 617 </html>