defaria.com/blogs/Status/2005/10/pqa-clearquest.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=" Hooked up new PQA schema database and data database Starting to code merge routines Created PQA Schedule (See below)...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>PQA Clearquest - 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-clearquest.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/sj-vob-move.html" title="SJ VOB Move">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-1.html" title="PQA Clearquest">
  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 Clearquest">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2005/10/pqa-clearquest.html">
  26     <meta property="og:description" content=" Hooked up new PQA schema database and data database Starting to code merge routines Created PQA Schedule (See below)...">
  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=" Hooked up new PQA schema database and data database Starting to code merge routines Created PQA Schedule (See below)...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest.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 Clearquest</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1712" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">PQA Clearquest</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-10T12:11:29-08:00" itemprop="datePublished">October 10, 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>Hooked up new PQA schema database and data database</li>
  86
  87   <li>Starting to code merge routines</li>
  88
  89   <li>Created PQA Schedule (See below)</li>
  90 </ul>
  91                   <h3>Moving MS/SQL Databases</h3>
  92
  93 <p>Moving a MS/SQL Database from one host to another involves a bit of tweaking to get the new system to recognize that it has a new database. I will attempt to detail here what needs to be done. </p>
  94
  95 <p>In order to import Clearquest databases to a new MS SQL Database Server:</p>
  96
  97 <ol>
  98   <li>Place imported datafile onto new machine.</li>
  99
 100   <li>Start the MS SQL Server Enterprise Manager (C:\Windows\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.msc")</li>
 101
 102   <li>Expand tree until you see "(local)" then "Databases". Right click on Database and select New Database to create an empty new database. Name the database appropriately. On the Data Files tab we changed the default path of C:\Program Files\Microsoft SQL Server\MSSQL\data\&lt;database name&gt;.mdf to a more approriate place. Also check the Transaction Log tab to adust path.</li>
 103
 104   <li>Restore database by right clicked on the new database you created and selecting All Tasks: Restore Database. Under Restore select From Device then click Add then find the restored db file. Under Options change the paths for Move to physical file name.</li>
 105
 106   <li>For Clearquest Schema databases only (You may need to restart the SQL Server Enterprise Manager after the above restore of the database): Since Clearquest uses a database to hold the schema and that schema points to known user databases, importing a Clearquest schema will have entries that point over to <b>projection</b> databases! These need to change:
 107
 108     <ul>
 109       <li>In SQL Sever Enterprise Manager locate your imported schema database and double click on Tables.</li>
 110
 111       <li>Find master_dbs, right click on master_dbs and select Open Table: Return All Rows.</li>
 112
 113       <li>Change the server column to the name of the new server</li>
 114
 115       <li>Select Run (the ! symbol in the toolbar)</li>
 116     </ul>
 117
 118   <li>Folllow instructions at <a href="http://support.microsoft.com/default.aspx?scid=kb;%5bLN%5d;Q240872">How to resolve permission issues when you move a database between servers that are running SQL Server</a> for fixing permissions problems.</li>
 119
 120   <li>Import user databases. Note the fix above regarding master_dbs:server is <b>not</b> required for user databases</li>
 121 </ol>
 122
 123 <h3>Merge Routines and Connecting to Multiple Schemas</h3>
 124
 125 <p>With two schema databases I was having problems with my Perl script connecting to the databases. In the past I had:
 126
 127 <div class="code"><pre>
 128       ## Internal variables ##
 129       my $session;
 130       my $login           = "admin";
 131       my $password    = "*****";
 132       my $masterdb    = ""; # Don't need a masterdb (Using default?)
 133       my $db_name;
 134     ...
 135       sub StartSession {
 136         $db_name = shift;
 137
 138         $session = CQPerlExt::CQSession_Build ();
 139
 140         $session->UserLogon ($login, $password, $db_name, $masterdb);
 141       } # StartSession
 142 </pre></div>
 143
 144 <p>Now when I run this in the presence of two schema databases I get:</p>
 145
 146 <div class=box>
 147     The database "MASTR" belonging to master database "2002.05.00" is an invalid name. Enter the correct name of a ClearQuest user database. at c:/Program Files/Rational/ClearQuest/lib/CQPerlExt.pm line 3713.
 148 </div>
 149
 150 <p>I think I need to specify the proper $ masterdb name but I don't know what that might be... Hmmm... Seems that $masterdb is really just the Connection name that you'd see when you start Clearquest Designer or Clearquest Client and there are multiple schemas to choose from. That's odd because that could be potentially anything as the user could rename it. However if I use PQA_Old on p4test (which is what I named the old schema connection) then it works.</p>
 151
 152 <p>OK, more work on this tomorrow. I have already defined the new defect record in my Perl module. I just have to start coding the merge routines now...</p>
 153
 154 <h3>PQA Schedule</h3>
 155
 156 <p>The following is a rough estimate of the work needed to be completed to get to the point where we are ready to convert the live production databases</p>
 157
 158 <ul>
 159   <li> Restore new Schema DB and Data DB (<font color="#999">1 Day</font>)</li>
 160
 161   <li> Investigate record/field mappings (<font color="#999">2 Days</font>)</li>
 162
 163   <li>Determine order fo record additions (<font color="#999">1 Day</font>)</li>
 164
 165   <li>Investigate requirements for adding of records to Clearquest (<font color="#999">2 Days</font>)</li>
 166
 167   <li>Code/Test merge procedures (<font color="#999">3 Day</font>)</li>
 168
 169   <li>Test conversion on <b>p4test</b> (<font color="#999">4 Days</font>)</li>
 170 </ul>
 171
 172 <p><b>Total:</b> 13 Days</p>
 173                 </div>
 174                 <nav class="page-navigation entry-navigation pagination content-nav">
 175                   <ul class="page-navigation-list">
 176
 177                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/10/sj-vob-move.html" title="SJ VOB Move">Previous entry</a></li>
 178
 179
 180                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-1.html" title="PQA Clearquest">Next entry</a></li>
 181
 182                   </ul>
 183                 </nav>
 184                 <!--
 185 <aside id="zenback" class="zenback feedback">
 186   Please paste Zenback script code here.
 187 </aside>
 188 -->
 189
 190
 191               </article>
 192             </div>
 193             <aside class="widgets related" role="complementary">
 194               <nav class="widget-search widget">
 195   <div class="widget-content">
 196     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 197       <div>
 198         <input type="text" name="search" value="" placeholder="Search...">
 199
 200         <input type="hidden" name="IncludeBlogs" value="8">
 201
 202         <input type="hidden" name="limit" value="20">
 203         <button type="submit" name="button">
 204           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 205         </button>
 206       </div>
 207     </form>
 208   </div>
 209 </nav>
 210 <nav class="widget-archive-category widget">
 211   <h3 class="widget-header">Categories</h3>
 212   <div class="widget-content">
 213
 214
 215     <ul class="widget-list">
 216
 217
 218       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 219
 220
 221       </li>
 222
 223
 224
 225
 226       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 227
 228
 229       </li>
 230
 231
 232
 233
 234       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 235
 236
 237       </li>
 238
 239
 240
 241
 242       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 243
 244
 245       </li>
 246
 247
 248
 249
 250       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 251
 252
 253       </li>
 254
 255
 256
 257
 258       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 259
 260
 261       </li>
 262
 263
 264
 265
 266       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 267
 268
 269       </li>
 270
 271
 272
 273
 274       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 275
 276
 277       </li>
 278
 279
 280
 281
 282       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 283
 284
 285       </li>
 286
 287
 288
 289
 290       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 291
 292
 293       </li>
 294
 295
 296
 297
 298       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 299
 300
 301       </li>
 302
 303
 304
 305
 306       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 307
 308
 309       </li>
 310
 311     </ul>
 312
 313
 314   </div>
 315 </nav>
 316
 317
 318 <nav class="widget-archive-dropdown widget">
 319   <h3 class="widget-header">Archives</h3>
 320   <div class="widget-content">
 321     <select>
 322       <option>Select a Month...</option>
 323
 324       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 325
 326
 327
 328       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 329
 330
 331
 332       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 333
 334
 335
 336       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 337
 338
 339
 340       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 341
 342
 343
 344       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 345
 346
 347
 348       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 349
 350
 351
 352       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 353
 354
 355
 356       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 357
 358
 359
 360       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 361
 362
 363
 364       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 365
 366
 367
 368       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 369
 370
 371
 372       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 373
 374
 375
 376       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 557
 558
 559
 560       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 561
 562
 563
 564       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 565
 566
 567
 568       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 569
 570
 571
 572       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 573
 574
 575
 576       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 577
 578
 579
 580       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 581
 582
 583
 584       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 585
 586
 587
 588       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 589
 590
 591
 592       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 593
 594
 595
 596       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 597
 598
 599
 600       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 601
 602
 603
 604       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 605
 606
 607
 608       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 609
 610     </select>
 611   </div>
 612 </nav>
 613
 614
 615
 616 <div class="widget-syndication widget section">
 617   <div class="widget-content">
 618     <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>
 619
 620   </div>
 621 </div>
 622
 623             </aside>
 624           </div>
 625         </div>
 626         <footer id="footer" role="contentinfo">
 627           <div id="footer-inner">
 628             <div id="footer-content">
 629   <nav role="navigation">
 630           <ul>
 631             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 632
 633
 634           </ul>
 635         </nav>
 636
 637   <p class="license">&copy; Copyright 2016.</p>
 638   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 639 </div>
 640           </div>
 641         </footer>
 642       </div>
 643     </div>
 644     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 645     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 646   </body>
 647 </html>