defaria.com/blogs/Status/archives/cat_pqa.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml" />
  11
  12    <title>Status for Andrew DeFaria: PQA Archives</title>
  13 </head>
  14 <body class="layout-one-column">
  15    <div id="container">
  16       <div id="container-inner" class="pkg">
  17
  18          <div id="banner">
  19             <div id="banner-inner" class="pkg">
  20                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  21                <h2 id="banner-description">Searchable status reports and work log</h2>
  22             </div>
  23          </div>
  24
  25          <div id="pagebody">
  26             <div id="pagebody-inner" class="pkg">
  27                <div id="alpha">
  28                   <div id="alpha-inner" class="pkg">
  29
  30                      <p class="content-nav">
  31                         <a href="http://defaria.com/blogs/Status/">Main</a>
  32                      </p>
  33
  34
  35
  36
  37                      <h2 class="date-header">January 23, 2006</h2>
  38                      <a id="a000521"></a>
  39                      <div class="entry" id="entry-521">
  40                         <h3 class="entry-header">More CQ Web Email Problems (GetSMTPHost)</h3>
  41                         <div class="entry-content">
  42                            <div class="entry-body">
  43                               <ul>
  44   <li>Implemented and tested GetSMTPHost</li>
  45 </ul>
  46
  47                               <p class="entry-more-link">
  48                                  <a href="http://defaria.com/blogs/Status/archives/000521.html#more">Continue reading "More CQ Web Email Problems (GetSMTPHost)" &raquo;</a>
  49                               </p>
  50
  51                               <p class="entry-footer">
  52                                  <span class="post-footers">Posted by  at 11:00 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000521.html">Permalink</a>
  53
  54
  55                               </p>
  56                            </div>
  57                         </div>
  58                      </div>
  59
  60
  61
  62                      <h2 class="date-header">November 19, 2005</h2>
  63                      <a id="a000482"></a>
  64                      <div class="entry" id="entry-482">
  65                         <h3 class="entry-header">PQA Merge (Part II)</h3>
  66                         <div class="entry-content">
  67                            <div class="entry-body">
  68                               <ul>
  69   <li>Worked with Vinh on small problem with Gating_Item_SW.</li>
  70
  71   <li>Backed up database to \\p4test\Cont as CQ_Controller_Prod.db.backup</li>
  72
  73   <li>Copied backup up to \\pcirvd-dshah\CQ</li>
  74 </ul>
  75
  76                               <p class="entry-more-link">
  77                                  <a href="http://defaria.com/blogs/Status/archives/000482.html#more">Continue reading "PQA Merge (Part II)" &raquo;</a>
  78                               </p>
  79
  80                               <p class="entry-footer">
  81                                  <span class="post-footers">Posted by  at  2:47 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000482.html">Permalink</a>
  82
  83
  84                               </p>
  85                            </div>
  86                         </div>
  87                      </div>
  88
  89
  90
  91                      <h2 class="date-header">November 18, 2005</h2>
  92                      <a id="a000481"></a>
  93                      <div class="entry" id="entry-481">
  94                         <h3 class="entry-header">PQA Merge</h3>
  95                         <div class="entry-content">
  96                            <div class="entry-body">
  97                               <p>This blog entry is to track the PQA merge process. See extended entry for full details...</p>
  98
  99                               <p class="entry-more-link">
 100                                  <a href="http://defaria.com/blogs/Status/archives/000481.html#more">Continue reading "PQA Merge" &raquo;</a>
 101                               </p>
 102
 103                               <p class="entry-footer">
 104                                  <span class="post-footers">Posted by  at  8:21 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000481.html">Permalink</a>
 105
 106
 107                               </p>
 108                            </div>
 109                         </div>
 110                      </div>
 111
 112
 113
 114                      <h2 class="date-header">November 14, 2005</h2>
 115                      <a id="a000479"></a>
 116                      <div class="entry" id="entry-479">
 117                         <h3 class="entry-header">Finalizing pqamerge</h3>
 118                         <div class="entry-content">
 119                            <div class="entry-body">
 120                               <ul>
 121   <li>Identified a few more bugs with pqamerge</li>
 122
 123   <ul>
 124     <li>Changed to handle Open_Close_Status -> Active_Deferred_Status for Prod.</li>
 125
 126     <li>Changed to correctly handle Gating_Item_SW. This is set from GatingItem from both TO and Prod. Gating_Item_HW is a new field and is set to "No".</li>
 127   </ul>
 128
 129   <li>Worked with Vinh finalizing steps for pqamerge</li>
 130 </ul>
 131
 132                               <p class="entry-footer">
 133                                  <span class="post-footers">Posted by  at  9:15 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000479.html">Permalink</a>
 134
 135
 136                               </p>
 137                            </div>
 138                         </div>
 139                      </div>
 140
 141
 142
 143                      <h2 class="date-header">November 12, 2005</h2>
 144                      <a id="a000476"></a>
 145                      <div class="entry" id="entry-476">
 146                         <h3 class="entry-header">Several PQA Fixes</h3>
 147                         <div class="entry-content">
 148                            <div class="entry-body">
 149                               <ul>
 150   <li>Added Exit Sub/Function to several validation and initialization functions in order to allow TransferState to work</li>
 151
 152   <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>
 153
 154   <li>Change pqamerge to treat the Submit state like the Assigned state</li>
 155
 156   <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>
 157
 158   <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>
 159 </ul>
 160
 161                               <p class="entry-more-link">
 162                                  <a href="http://defaria.com/blogs/Status/archives/000476.html#more">Continue reading "Several PQA Fixes" &raquo;</a>
 163                               </p>
 164
 165                               <p class="entry-footer">
 166                                  <span class="post-footers">Posted by  at 12:17 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000476.html">Permalink</a>
 167
 168
 169                               </p>
 170                            </div>
 171                         </div>
 172                      </div>
 173
 174
 175
 176                      <h2 class="date-header">November 11, 2005</h2>
 177                      <a id="a000475"></a>
 178                      <div class="entry" id="entry-475">
 179                         <h3 class="entry-header">Final PQA fixes</h3>
 180                         <div class="entry-content">
 181                            <div class="entry-body">
 182                               <ul>
 183   <li>Implemented TransferStates</li>
 184
 185   <li>Found final problem with attachments and fixed it</li>
 186
 187   <li>Implemented ID number equality</li>
 188 </ul>
 189
 190                               <p class="entry-footer">
 191                                  <span class="post-footers">Posted by  at  1:54 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000475.html">Permalink</a>
 192
 193
 194                               </p>
 195                            </div>
 196                         </div>
 197                      </div>
 198
 199
 200
 201                      <h2 class="date-header">November 10, 2005</h2>
 202                      <a id="a000474"></a>
 203                      <div class="entry" id="entry-474">
 204                         <h3 class="entry-header">Finding the missing 261,285,366 bytes</h3>
 205                         <div class="entry-content">
 206                            <div class="entry-body">
 207                               <ul>
 208   <li>Fixed bug in pqamerge that caused some attachments to not transfer</li>
 209 </ul>
 210
 211                               <p class="entry-more-link">
 212                                  <a href="http://defaria.com/blogs/Status/archives/000474.html#more">Continue reading "Finding the missing 261,285,366 bytes" &raquo;</a>
 213                               </p>
 214
 215                               <p class="entry-footer">
 216                                  <span class="post-footers">Posted by  at 11:55 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000474.html">Permalink</a>
 217
 218
 219                               </p>
 220                            </div>
 221                         </div>
 222                      </div>
 223
 224
 225
 226                      <h2 class="date-header">November  9, 2005</h2>
 227                      <a id="a000473"></a>
 228                      <div class="entry" id="entry-473">
 229                         <h3 class="entry-header">Removing DBs from a Schema/Email link concerns</h3>
 230                         <div class="entry-content">
 231                            <div class="entry-body">
 232                               <ul>
 233   <li>Investigated how to remove databases from a CQ Schema</li>
 234
 235   <li>Created template files for Clearquest Web Login page to swap in for Phase I and Phase II onto the production web server (under C:\Temp\PQA)</li>
 236
 237   <li>Discussed the email link problem with Rational. While they can't say definitively what is supported they have stated that the old email link URL will not work in the new schema</li>
 238 <ul>
 239
 240                               <p class="entry-more-link">
 241                                  <a href="http://defaria.com/blogs/Status/archives/000473.html#more">Continue reading "Removing DBs from a Schema/Email link concerns" &raquo;</a>
 242                               </p>
 243
 244                               <p class="entry-footer">
 245                                  <span class="post-footers">Posted by  at  3:52 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000473.html">Permalink</a>
 246
 247
 248                               </p>
 249                            </div>
 250                         </div>
 251                      </div>
 252
 253
 254
 255                      <h2 class="date-header">November  8, 2005</h2>
 256                      <a id="a000472"></a>
 257                      <div class="entry" id="entry-472">
 258                         <h3 class="entry-header">Web Server Configuration and documentation</h3>
 259                         <div class="entry-content">
 260                            <div class="entry-body">
 261                               <ul>
 262   <li>Installed Clearquest 2001A.04.00 and verified that it can access Cont</li>
 263
 264   <li>Figured out how to modify the login page (Clearquest/Web/logon/default_content.asp) and created default_content1.asp and default_content2.asp</li>
 265
 266   <li>Wrote <a href="http://intranet.broadcom.com/%7Eadefaria/Clearquest/NewCQProfile.php">How to update my Clearquest Profile to access the new Cont database</a>
 267 <ul>
 268
 269                               <p class="entry-footer">
 270                                  <span class="post-footers">Posted by  at  7:54 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000472.html">Permalink</a>
 271
 272
 273                               </p>
 274                            </div>
 275                         </div>
 276                      </div>
 277
 278
 279
 280
 281                      <a id="a000471"></a>
 282                      <div class="entry" id="entry-471">
 283                         <h3 class="entry-header">More on attachments</h3>
 284                         <div class="entry-content">
 285                            <div class="entry-body">
 286                               <ul>
 287   <li>Enhanced check_attachments to log better</li>
 288 </ul>
 289
 290                               <p class="entry-more-link">
 291                                  <a href="http://defaria.com/blogs/Status/archives/000471.html#more">Continue reading "More on attachments" &raquo;</a>
 292                               </p>
 293
 294                               <p class="entry-footer">
 295                                  <span class="post-footers">Posted by  at 10:33 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000471.html">Permalink</a>
 296
 297
 298                               </p>
 299                            </div>
 300                         </div>
 301                      </div>
 302
 303
 304
 305                      <h2 class="date-header">November  7, 2005</h2>
 306                      <a id="a000470"></a>
 307                      <div class="entry" id="entry-470">
 308                         <h3 class="entry-header">check_attachments</h3>
 309                         <div class="entry-content">
 310                            <div class="entry-body">
 311                               <ul>
 312   <li>Worked out a plan for how to perform the PQA Merge this weekend</li>
 313
 314   <li>Concerned about the size discrepancy in the database I wrote a little utility, check_attachments, to total up the size of all attachments in all the databases. This turned up a bug in pqamerge which I fixed. Reperforming pqamerge</li>
 315
 316   <li>There is a problem with using clearprompt to prompt for list input for bin_merge - You can only have one line of prompting text and only 50 characters in that line. It's gonna be hard to describe a binary merge situation in 50 characters or less. Investigated making a PerlTk list dialog. In theory it can be done as ccperl does support PerlTk.</li>
 317
 318   <li>Discussed with Naga the <i>email link</i> issue with PQA</li>
 319 </ul>
 320
 321                               <p class="entry-more-link">
 322                                  <a href="http://defaria.com/blogs/Status/archives/000470.html#more">Continue reading "check_attachments" &raquo;</a>
 323                               </p>
 324
 325                               <p class="entry-footer">
 326                                  <span class="post-footers">Posted by  at  6:54 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000470.html">Permalink</a>
 327
 328
 329                               </p>
 330                            </div>
 331                         </div>
 332                      </div>
 333
 334
 335
 336                      <h2 class="date-header">November  2, 2005</h2>
 337                      <a id="a000465"></a>
 338                      <div class="entry" id="entry-465">
 339                         <h3 class="entry-header">Enable ldap</h3>
 340                         <div class="entry-content">
 341                            <div class="entry-body">
 342                               <ul>
 343   <li>Changed enable_ldap to read from and save to an ldap_settings.cfg file</li>
 344
 345   <li>Helped Ray with some Perl Regex's</li>
 346 </ul>
 347
 348                               <p class="entry-footer">
 349                                  <span class="post-footers">Posted by  at  4:44 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000465.html">Permalink</a>
 350
 351
 352                               </p>
 353                            </div>
 354                         </div>
 355                      </div>
 356
 357
 358
 359                      <h2 class="date-header">November  1, 2005</h2>
 360                      <a id="a000464"></a>
 361                      <div class="entry" id="entry-464">
 362                         <h3 class="entry-header">CQ Users/CQ Web Server Setup</h3>
 363                         <div class="entry-content">
 364                            <div class="entry-body">
 365                               <ul>
 366   <li>Added a few users to Clearquest</li>
 367
 368   <li>Set up IIS on pcsjca-ccrmt03</li>
 369
 370   <li>Set up Clearquest Web on pcsjca-ccrmt03</li>
 371 </ul>
 372
 373                               <p class="entry-more-link">
 374                                  <a href="http://defaria.com/blogs/Status/archives/000464.html#more">Continue reading "CQ Users/CQ Web Server Setup" &raquo;</a>
 375                               </p>
 376
 377                               <p class="entry-footer">
 378                                  <span class="post-footers">Posted by  at  9:43 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000464.html">Permalink</a>
 379
 380
 381                               </p>
 382                            </div>
 383                         </div>
 384                      </div>
 385
 386
 387
 388                      <h2 class="date-header">October 31, 2005</h2>
 389                      <a id="a000463"></a>
 390                      <div class="entry" id="entry-463">
 391                         <h3 class="entry-header">PQA Issues/CQ 2002.05 setup</h3>
 392                         <div class="entry-content">
 393                            <div class="entry-body">
 394                               <ul>
 395   <li>Documented <a href="http://intranet.broadcom.com/~adefaria/Clearquest/PQAIssues.php">PQA issues</a>
 396
 397   <li>Installed old Clearquest on pcsjca-ccrmt03</li>
 398
 399   <li>Investigated more about the DST Clearcase issue</li>
 400 </ul>
 401
 402                               <p class="entry-footer">
 403                                  <span class="post-footers">Posted by  at  5:15 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000463.html">Permalink</a>
 404
 405
 406                               </p>
 407                            </div>
 408                         </div>
 409                      </div>
 410
 411
 412
 413                      <h2 class="date-header">October 28, 2005</h2>
 414                      <a id="a000461"></a>
 415                      <div class="entry" id="entry-461">
 416                         <h3 class="entry-header">PQA: URL Link Issue</h3>
 417                         <div class="entry-content">
 418                            <div class="entry-body">
 419                               <ul>
 420   <li>Documented new URL format</li>
 421
 422   <li>Investigated the feasibility of accommodating a mapping of old URL link with old ID -> new URL</li>
 423 </ul>
 424
 425                               <p class="entry-more-link">
 426                                  <a href="http://defaria.com/blogs/Status/archives/000461.html#more">Continue reading "PQA: URL Link Issue" &raquo;</a>
 427                               </p>
 428
 429                               <p class="entry-footer">
 430                                  <span class="post-footers">Posted by  at  2:00 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000461.html">Permalink</a>
 431
 432
 433                               </p>
 434                            </div>
 435                         </div>
 436                      </div>
 437
 438
 439
 440                      <h2 class="date-header">October 27, 2005</h2>
 441                      <a id="a000462"></a>
 442                      <div class="entry" id="entry-462">
 443                         <h3 class="entry-header">PQA: LDAP</h3>
 444                         <div class="entry-content">
 445                            <div class="entry-body">
 446                               <ul>
 447   <li>Worked on trying to test out LDAP Authentication</li>
 448 </ul>
 449
 450                               <p class="entry-footer">
 451                                  <span class="post-footers">Posted by  at  2:16 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000462.html">Permalink</a>
 452
 453
 454                               </p>
 455                            </div>
 456                         </div>
 457                      </div>
 458
 459
 460
 461                      <h2 class="date-header">October 26, 2005</h2>
 462                      <a id="a000460"></a>
 463                      <div class="entry" id="entry-460">
 464                         <h3 class="entry-header">PQA: More issues</h3>
 465                         <div class="entry-content">
 466                            <div class="entry-body">
 467                               <ul>
 468   <li>Investigating PQA issue regarding email links</li>
 469
 470   <li>Implementing cleanup of Dynamic Lists</li>
 471
 472   <li>Handed off test DB backup to Vinh</li>
 473
 474   <li>Investigated data conversion problems</li>
 475 </ul>
 476
 477                               <p class="entry-more-link">
 478                                  <a href="http://defaria.com/blogs/Status/archives/000460.html#more">Continue reading "PQA: More issues" &raquo;</a>
 479                               </p>
 480
 481                               <p class="entry-footer">
 482                                  <span class="post-footers">Posted by  at  4:14 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000460.html">Permalink</a>
 483
 484
 485                               </p>
 486                            </div>
 487                         </div>
 488                      </div>
 489
 490
 491
 492                      <h2 class="date-header">October 22, 2005</h2>
 493                      <a id="a000458"></a>
 494                      <div class="entry" id="entry-458">
 495                         <h3 class="entry-header">PQA Dynamic Lists</h3>
 496                         <div class="entry-content">
 497                            <div class="entry-body">
 498                               <ul>
 499   <li>Changed Dynamic Lists to properly handle bad data</li>
 500 </ul>
 501
 502                               <p class="entry-more-link">
 503                                  <a href="http://defaria.com/blogs/Status/archives/000458.html#more">Continue reading "PQA Dynamic Lists" &raquo;</a>
 504                               </p>
 505
 506                               <p class="entry-footer">
 507                                  <span class="post-footers">Posted by  at  1:50 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000458.html">Permalink</a>
 508
 509
 510                               </p>
 511                            </div>
 512                         </div>
 513                      </div>
 514
 515
 516
 517                      <h2 class="date-header">October 21, 2005</h2>
 518                      <a id="a000457"></a>
 519                      <div class="entry" id="entry-457">
 520                         <h3 class="entry-header">AddListMember</h3>
 521                         <div class="entry-content">
 522                            <div class="entry-body">
 523                               <ul>
 524   <li>Fixed bug in pqamerge so that it now properly adds new entries to dynamic lists</li>
 525 </ul>
 526
 527                               <p class="entry-more-link">
 528                                  <a href="http://defaria.com/blogs/Status/archives/000457.html#more">Continue reading "AddListMember" &raquo;</a>
 529                               </p>
 530
 531                               <p class="entry-footer">
 532                                  <span class="post-footers">Posted by  at  1:51 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000457.html">Permalink</a>
 533
 534
 535                               </p>
 536                            </div>
 537                         </div>
 538                      </div>
 539
 540
 541
 542                      <h2 class="date-header">October 20, 2005</h2>
 543                      <a id="a000456"></a>
 544                      <div class="entry" id="entry-456">
 545                         <h3 class="entry-header">enable_ldap/Another PQA Merge</h3>
 546                         <div class="entry-content">
 547                            <div class="entry-body">
 548                               <ul>
 549   <li>Wrote and enable_ldap Perl script</li>
 550
 551   <li>Vinh Ton has provided me with yet another schema and corresponding databases</li>
 552 </ul>
 553
 554                               <p class="entry-more-link">
 555                                  <a href="http://defaria.com/blogs/Status/archives/000456.html#more">Continue reading "enable_ldap/Another PQA Merge" &raquo;</a>
 556                               </p>
 557
 558                               <p class="entry-footer">
 559                                  <span class="post-footers">Posted by  at  6:19 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000456.html">Permalink</a>
 560
 561
 562                               </p>
 563                            </div>
 564                         </div>
 565                      </div>
 566
 567
 568
 569                      <h2 class="date-header">October 19, 2005</h2>
 570                      <a id="a000455"></a>
 571                      <div class="entry" id="entry-455">
 572                         <h3 class="entry-header">Most PQA Issues resolved...</h3>
 573                         <div class="entry-content">
 574                            <div class="entry-body">
 575                               <ul>
 576   <li>Resolved most of the remaining issues with PQA Merge Vinh Ton</li>
 577 </ul>
 578
 579                               <p class="entry-more-link">
 580                                  <a href="http://defaria.com/blogs/Status/archives/000455.html#more">Continue reading "Most PQA Issues resolved..." &raquo;</a>
 581                               </p>
 582
 583                               <p class="entry-footer">
 584                                  <span class="post-footers">Posted by  at  5:23 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000455.html">Permalink</a>
 585
 586
 587                               </p>
 588                            </div>
 589                         </div>
 590                      </div>
 591
 592
 593
 594                      <h2 class="date-header">October 18, 2005</h2>
 595                      <a id="a000454"></a>
 596                      <div class="entry" id="entry-454">
 597                         <h3 class="entry-header">PQA Merge: User Issues</h3>
 598                         <div class="entry-content">
 599                            <div class="entry-body">
 600                               <ul>
 601   <li>Starting to look into user accounts issues</li>
 602
 603   <li>Send out form for LDAP Authentication Information</li>
 604
 605   <li>Coded up pong.sh and pong.tcl to check and see if ccase-rmna-3 is up or down</li>
 606
 607   <li>Created initial set of PQA User/Group Account files</li>
 608 </ul>
 609
 610                               <p class="entry-more-link">
 611                                  <a href="http://defaria.com/blogs/Status/archives/000454.html#more">Continue reading "PQA Merge: User Issues" &raquo;</a>
 612                               </p>
 613
 614                               <p class="entry-footer">
 615                                  <span class="post-footers">Posted by  at  3:22 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000454.html">Permalink</a>
 616
 617
 618                               </p>
 619                            </div>
 620                         </div>
 621                      </div>
 622
 623
 624
 625                      <h2 class="date-header">October 17, 2005</h2>
 626                      <a id="a000453"></a>
 627                      <div class="entry" id="entry-453">
 628                         <h3 class="entry-header">PQA Merge Issues/Pong</h3>
 629                         <div class="entry-content">
 630                            <div class="entry-body">
 631                               <ul>
 632   <li>Documented remaining <a href="http://intranet.broadcom.com/~adefaria/Clearquest/">PQA Conversion Issues</a></li>
 633
 634   <li>Audit_Log is not handled properly currently. Querying Vinh</li>
 635
 636   <li>Resolved problem with Submitter and Submit_Date. Need to change schema to make those fields OPTIONAL as well as add return statements to the Perl action hooks</li>
 637
 638   <li>Investigated using LDAP authentication with Clearquest</li>
 639
 640   <li>Wrote a simple expect script (pong) and bash script to verify that a machine is up and send email if it isn't. Problem is ccase-rmna-1 lacks expect!</li>
 641 </ul>
 642
 643                               <p class="entry-more-link">
 644                                  <a href="http://defaria.com/blogs/Status/archives/000453.html#more">Continue reading "PQA Merge Issues/Pong" &raquo;</a>
 645                               </p>
 646
 647                               <p class="entry-footer">
 648                                  <span class="post-footers">Posted by  at  8:00 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000453.html">Permalink</a>
 649
 650
 651                               </p>
 652                            </div>
 653                         </div>
 654                      </div>
 655
 656
 657
 658                      <h2 class="date-header">October 16, 2005</h2>
 659                      <a id="a000452"></a>
 660                      <div class="entry" id="entry-452">
 661                         <h3 class="entry-header">PQA Clearquest:: Spacing out</h3>
 662                         <div class="entry-content">
 663                            <div class="entry-body">
 664                               <ul>
 665   <li>Fixed minor problems with trailing spaces on fields</li>
 666
 667   <li>Fixed minor problem with space filled <b>Software_Revision</b></li>
 668
 669   <li>Fixed problem where field names were reversed.</li>
 670
 671   <li><b>Submitter</b> and <b>Submit_Date</b> are set by action hooks to the current username and current date/time. We'll need to turn
 672  this off if we want the old <b>Submitter</b> and <b>Submit_Date</b>.</li>
 673
 674   <li>Implemented <i>Attachment Handling</i></li>
 675 </ul>
 676
 677
 678
 679                               <p class="entry-more-link">
 680                                  <a href="http://defaria.com/blogs/Status/archives/000452.html#more">Continue reading "PQA Clearquest:: Spacing out" &raquo;</a>
 681                               </p>
 682
 683                               <p class="entry-footer">
 684                                  <span class="post-footers">Posted by  at 12:57 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000452.html">Permalink</a>
 685
 686
 687                               </p>
 688                            </div>
 689                         </div>
 690                      </div>
 691
 692
 693
 694                      <h2 class="date-header">October 15, 2005</h2>
 695                      <a id="a000451"></a>
 696                      <div class="entry" id="entry-451">
 697                         <h3 class="entry-header">PQA Clearquest: Resolving remaining issues with bad data</h3>
 698                         <div class="entry-content">
 699                            <div class="entry-body">
 700                               <p>This is to document all of the issues related with bad data in the source databases that is impeeding the PQA Merge process. Along with the issues I will present what I did to work around the problems and what I suggest we should do to provide a smooth transition of these databases</p>
 701
 702                               <p class="entry-more-link">
 703                                  <a href="http://defaria.com/blogs/Status/archives/000451.html#more">Continue reading "PQA Clearquest: Resolving remaining issues with bad data" &raquo;</a>
 704                               </p>
 705
 706                               <p class="entry-footer">
 707                                  <span class="post-footers">Posted by  at  6:41 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000451.html">Permalink</a>
 708
 709
 710                               </p>
 711                            </div>
 712                         </div>
 713                      </div>
 714
 715
 716
 717                      <h2 class="date-header">October 14, 2005</h2>
 718                      <a id="a000450"></a>
 719                      <div class="entry" id="entry-450">
 720                         <h3 class="entry-header">PQA Merge - Action Hooks & Attachments</h3>
 721                         <div class="entry-content">
 722                            <div class="entry-body">
 723                               <ul>
 724   <li>There are action hooks in Cont that send out email. I fear my testing may be generating lots of unnecessary email. Would like to have the Action Hook's email procedures coded to be conditional based on say an env  var so we can turn off email during the production merge.</lI>
 725
 726   <li>Attachments are currently not handled because they are different and require special code to iterate through them to copy them to the destination database</li>
 727
 728   <li>Need to have the delete action available on the defect record so pqaclean can work. I've modified my schema for that</li>
 729
 730   <li>Changed pqamerge to only get the dbid's then to obtain the entity records when needed. Previously I would build a query with all fields. That query took from 6-40 minutes to run before I could even obtain the first record! Also the memory size of Perl grew very big. This algorithm is much faster with the query taking under 1 second!</li>
 731
 732   <li>Working on problems with the source data.</li>
 733 </ul>
 734
 735                               <p class="entry-more-link">
 736                                  <a href="http://defaria.com/blogs/Status/archives/000450.html#more">Continue reading "PQA Merge - Action Hooks & Attachments" &raquo;</a>
 737                               </p>
 738
 739                               <p class="entry-footer">
 740                                  <span class="post-footers">Posted by  at 11:14 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000450.html">Permalink</a>
 741
 742
 743                               </p>
 744                            </div>
 745                         </div>
 746                      </div>
 747
 748
 749
 750                      <h2 class="date-header">October 13, 2005</h2>
 751                      <a id="a000449"></a>
 752                      <div class="entry" id="entry-449">
 753                         <h3 class="entry-header">PQA Merge</h3>
 754                         <div class="entry-content">
 755                            <div class="entry-body">
 756                               <ul>
 757   <li>Added Display, Logger and new TimeUtils to pqaclean and pqamerge</li>
 758
 759   <li>Finally got ProjectExists() to work. Turns out I was using the wrong CQPerlExt constant causing pqamerge to blow up</li>
 760
 761   <li>Received guidance from Vinh regarding certain field transformations. Incorporated them into pqamerge</li>
 762
 763   <li>Pqamerge now merging all of TO:defect records with a few exceptions that I'm fixing</li>
 764 </ul>
 765
 766
 767                               <p class="entry-footer">
 768                                  <span class="post-footers">Posted by  at  4:09 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000449.html">Permalink</a>
 769
 770
 771                               </p>
 772                            </div>
 773                         </div>
 774                      </div>
 775
 776
 777
 778                      <h2 class="date-header">October 12, 2005</h2>
 779                      <a id="a000448"></a>
 780                      <div class="entry" id="entry-448">
 781                         <h3 class="entry-header">PQA Clearquest: Project fields</h3>
 782                         <div class="entry-content">
 783                            <div class="entry-body">
 784                               <ul>
 785   <li>Started coding TransferDefects(). This is where the rubber hits the road</li>
 786 </ul>
 787
 788                               <p class="entry-more-link">
 789                                  <a href="http://defaria.com/blogs/Status/archives/000448.html#more">Continue reading "PQA Clearquest: Project fields" &raquo;</a>
 790                               </p>
 791
 792                               <p class="entry-footer">
 793                                  <span class="post-footers">Posted by  at 11:40 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000448.html">Permalink</a>
 794
 795
 796                               </p>
 797                            </div>
 798                         </div>
 799                      </div>
 800
 801
 802
 803                      <h2 class="date-header">October 11, 2005</h2>
 804                      <a id="a000447"></a>
 805                      <div class="entry" id="entry-447">
 806                         <h3 class="entry-header">PQA Clearquest</h3>
 807                         <div class="entry-content">
 808                            <div class="entry-body">
 809                               <ul>
 810   <li>Resolved problems being able to log into the new Cont database by redoing the importation of CQSchema, CQ_Controller_Prod and CQ_Controller_Test</li>
 811
 812   <li>Imported user accounts database from old schema to new schema. This was done by simply setting all users to all databases. While this is not what we will do for the production move it allows me to continue coding and testing</li>
 813
 814   <li>Started coding pqamerge. Got to the point of being able to transfer Customer and Project records</li>
 815
 816   <li>Coded pqaclean. This is a little script to effectively erase the destination database. This allows me to run pqamerge over and over from a clean slate. Had to add a delete action to the defect record</li>
 817 </ul>
 818
 819                               <p class="entry-footer">
 820                                  <span class="post-footers">Posted by  at  9:15 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000447.html">Permalink</a>
 821
 822
 823                               </p>
 824                            </div>
 825                         </div>
 826                      </div>
 827
 828
 829
 830                      <h2 class="date-header">October 10, 2005</h2>
 831                      <a id="a000446"></a>
 832                      <div class="entry" id="entry-446">
 833                         <h3 class="entry-header">PQA Clearquest</h3>
 834                         <div class="entry-content">
 835                            <div class="entry-body">
 836                               <ul>
 837   <li>Hooked up new PQA schema database and data database</li>
 838
 839   <li>Starting to code merge routines</li>
 840
 841   <li>Created PQA Schedule (See below)</li>
 842 </ul>
 843
 844                               <p class="entry-more-link">
 845                                  <a href="http://defaria.com/blogs/Status/archives/000446.html#more">Continue reading "PQA Clearquest" &raquo;</a>
 846                               </p>
 847
 848                               <p class="entry-footer">
 849                                  <span class="post-footers">Posted by  at 12:11 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000446.html">Permalink</a>
 850
 851
 852                               </p>
 853                            </div>
 854                         </div>
 855                      </div>
 856
 857
 858
 859                      <h2 class="date-header">October  6, 2005</h2>
 860                      <a id="a000443"></a>
 861                      <div class="entry" id="entry-443">
 862                         <h3 class="entry-header">PQA.pm/adm VOB</h3>
 863                         <div class="entry-content">
 864                            <div class="entry-body">
 865                               <ul>
 866   <li>Converted Code Page routines into a PQA.pm Perl Module</li>
 867
 868   <li>Changed routines to check all fields. Clearquest returns character data for fields such as DATE_TIME fields. These record definitions are now complete and will be useful when it comes time to perform the conversion</li>
 869
 870   <li>Waiting for new schema to start coding/testing conversion process. Contacted David Shaw who had helped us last time to get the databases onto our test server</li>
 871
 872   <li>Finally get adm VOB working and am starting to add my stuff into this VOB in a controlled fashion. This is not just a place to dump all of our scripts rather it's a place to start centralizing our code in a manner consistent with proper software engineering principals (Structured coding, code reuse, generalization, object oriented design principals, etc.)</li>
 873 </ul>
 874
 875                               <p class="entry-footer">
 876                                  <span class="post-footers">Posted by  at 11:28 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000443.html">Permalink</a>
 877
 878
 879                               </p>
 880                            </div>
 881                         </div>
 882                      </div>
 883
 884
 885
 886                      <h2 class="date-header">October  5, 2005</h2>
 887                      <a id="a000441"></a>
 888                      <div class="entry" id="entry-441">
 889                         <h3 class="entry-header">HTML Characters/VOB Distribution</h3>
 890                         <div class="entry-content">
 891                            <div class="entry-body">
 892                               <ul>
 893   <li>Changed CheckCodePage to use HTML character equivalents</li>
 894
 895   <li>Derived a plan of redistributing VOBs between VOB servers based on VOB database size</li>
 896 </ul>
 897
 898                               <p class="entry-more-link">
 899                                  <a href="http://defaria.com/blogs/Status/archives/000441.html#more">Continue reading "HTML Characters/VOB Distribution" &raquo;</a>
 900                               </p>
 901
 902                               <p class="entry-footer">
 903                                  <span class="post-footers">Posted by  at  4:29 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000441.html">Permalink</a>
 904
 905
 906                               </p>
 907                            </div>
 908                         </div>
 909                      </div>
 910
 911
 912
 913                      <h2 class="date-header">September 26, 2005</h2>
 914                      <a id="a000431"></a>
 915                      <div class="entry" id="entry-431">
 916                         <h3 class="entry-header">Clearquest Code Pages</h3>
 917                         <div class="entry-content">
 918                            <div class="entry-body">
 919                               <p>Clearquest 2003.06.15 now uses Code Pages to insure that data entered into Clearquest databases are correct. When incorrect data is encountered there is a problem. The question is, which code page should we use?</p>
 920
 921
 922                               <p class="entry-more-link">
 923                                  <a href="http://defaria.com/blogs/Status/archives/000431.html#more">Continue reading "Clearquest Code Pages" &raquo;</a>
 924                               </p>
 925
 926                               <p class="entry-footer">
 927                                  <span class="post-footers">Posted by  at  6:32 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000431.html">Permalink</a>
 928
 929
 930                               </p>
 931                            </div>
 932                         </div>
 933                      </div>
 934
 935
 936
 937                      <h2 class="date-header">September 23, 2005</h2>
 938                      <a id="a000426"></a>
 939                      <div class="entry" id="entry-426">
 940                         <h3 class="entry-header">PQA Code Page/SJ Vob move</h3>
 941                         <div class="entry-content">
 942                            <div class="entry-body">
 943                               <ul>
 944   <li>Attended meeting regarding SJ/Irvine Vob move. Shivdutt is investigating doing vob moves instead of replication. Briefly discussed Disaster Recover options.</li>
 945
 946   <li>Got Chris' scripts that check for invalid characters in string data for the ASCII character set to work on our test PQA database. Found invalid characters.</li>
 947 </ul>
 948
 949                               <p class="entry-more-link">
 950                                  <a href="http://defaria.com/blogs/Status/archives/000426.html#more">Continue reading "PQA Code Page/SJ Vob move" &raquo;</a>
 951                               </p>
 952
 953                               <p class="entry-footer">
 954                                  <span class="post-footers">Posted by  at  5:16 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000426.html">Permalink</a>
 955
 956
 957                               </p>
 958                            </div>
 959                         </div>
 960                      </div>
 961
 962
 963
 964                      <h2 class="date-header">September 22, 2005</h2>
 965                      <a id="a000424"></a>
 966                      <div class="entry" id="entry-424">
 967                         <h3 class="entry-header">PQA CQ Setup</h3>
 968                         <div class="entry-content">
 969                            <div class="entry-body">
 970                               <ul>
 971   <li>Set up CQ Web Server on p4test. Web client has been updated. Seems a little sluggish</li>
 972
 973   <li>Investigated CQ Web Performance tweaking</li>
 974
 975   <li>Looked into Chris's scripts for handling CQ code page problems</li>
 976 </ul>
 977
 978                               <p class="entry-footer">
 979                                  <span class="post-footers">Posted by  at  2:26 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000424.html">Permalink</a>
 980
 981
 982                               </p>
 983                            </div>
 984                         </div>
 985                      </div>
 986
 987                   </div>
 988                </div>
 989             </div>
 990          </div>
 991       </div>
 992    </div>
 993 </body>
 994 </html>