defaria.com/blogs/Status/archives/000481.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 Merge</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/000480.html" title="create_dev_snapview.pl" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000482.html" title="PQA Merge (Part II)" />
  17
  18
  19
  20
  21
  22    <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
  23 </head>
  24 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
  25    <div id="container">
  26       <div id="container-inner" class="pkg">
  27
  28          <div id="banner">
  29             <div id="banner-inner" class="pkg">
  30                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  31                <h2 id="banner-description">Searchable status reports and work log</h2>
  32             </div>
  33          </div>
  34
  35          <div id="pagebody">
  36             <div id="pagebody-inner" class="pkg">
  37                <div id="alpha">
  38                   <div id="alpha-inner" class="pkg">
  39
  40                      <p class="content-nav">
  41                         <a href="http://defaria.com/blogs/Status/archives/000480.html">&laquo; create_dev_snapview.pl</a> |
  42                         <a href="http://defaria.com/blogs/Status/">Main</a>
  43                         | <a href="http://defaria.com/blogs/Status/archives/000482.html">PQA Merge (Part II) &raquo;</a>
  44                      </p>
  45
  46                      <a id="a000481"></a>
  47                      <div class="entry" id="entry-481">
  48                         <h3 class="entry-header">PQA Merge</h3>
  49                         <div class="entry-content">
  50                            <div class="entry-body">
  51                               <p>This blog entry is to track the PQA merge process. See extended entry for full details...</p>
  52                            </div>
  53                            <div id="more" class="entry-more">
  54                               <ul>
  55   <li>Received backups from Dave Shah</li>
  56
  57   <li>In Clearquest designer I did Database: Delete Database for Cont and ContT</li>
  58
  59   <li>In Enterprise Manager:</li>
  60
  61   <ul>
  62     <li>Deleted 5 databases: CQ_Controller_Test, CQ_Controller_Prod, CQSchema03, CQ_TO_Prod and CQ2001AProd</li>
  63
  64     <li>Created those 5 databases anew</li>
  65
  66     <li>Restored CQSchema03, CQ_TO_Prod and CQ2001AProd</li>
  67
  68     <li>Changed server field in CQSchema02: master_dbs from production server to p4test</li>
  69
  70     <li>Ran SIDMap on all 5 databases</li>
  71
  72     <li>Made sure that the user CQ03_Admin was added to CQSchema03, CQ_Controller_Test and CQ_Controller_Prod as a DB owner</li>
  73   </ul>
  74
  75   <li>Back in Clearquest Designer I found that Cont and ContT were not deleted in the newly restored schema so I deleted ContT</li>
  76
  77   <li>Next I created a new database for ContT</li>
  78
  79   <li>Tried to delete Cont but received an error: Invalid object name "dbglobal". Worked around this problem but setting is_deleted to 1 using Enterprise Manager</li>
  80
  81   <li>Created new Cont database</li>
  82
  83   <li>Imported userinfo.txt (user/group info given to me by Vinh) using Clearquest Designer: User Administration. In looking at the subscriptions I see that groups appear are properly subscribed to databases but the users, particularly admin was not subscribed to any database! I will attempt to apply these user/groups and see if I can get into the db using Clearquest. Nope, as I suspected admin cannot login. Subscribing admin to all databases...</li>
  84
  85   <li>Upgraded Cont and ContT with imported user/group info. By accident I closed Clearquest Designer and now I can no longer login as admin! Ended up hacking the encrypted password from userinfo.txt back into CQSchema03:master_users:admin:encrypted password! I can now run Clearquest Designer. Subscribed admin to all databases. Also changed my user, adefaria, to no longer attempt to authenticate via LDAP (that never worked anyway) and to be on par with admin (be a superuser, subscribe to all databases and groups, etc.). I can now access Cont via Clearquest client.</li>
  86
  87   <li>Started pqamerge...</li>
  88
  89   <li>pqamerge finishes in 7 hours 2 minutes 5 seconds</li>
  90
  91   <li>Running check_attachments just to be sure</li>
  92
  93   <li>A quick spot check doesn't show any abnormalities. Vinh can check the data more thoroughly</li>
  94 </ul>
  95                            </div>
  96                         </div>
  97                         <p class="entry-footer">
  98                            <span class="post-footers">Posted by  on November 18, 2005  8:21 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000481.html">Permalink</a>
  99                         </p>
 100                      </div>
 101
 102
 103
 104
 105                   </div>
 106                </div>
 107             </div>
 108          </div>
 109       </div>
 110    </div>
 111 </body>
 112 </html>