2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content="This blog entry is to track the PQA merge process. See extended entry for full details......">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>PQA Merge - 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/pqa-merge-1.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
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>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2005/11/create-dev-snap.html" title="create_dev_snapview.pl">
20 <link rel="next" href="http://defaria.com/blogs/Status/2005/11/pqa-merge-part.html" title="PQA Merge (Part II)">
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 Merge">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2005/11/pqa-merge-1.html">
26 <meta property="og:description" content="This blog entry is to track the PQA merge process. See extended entry for full details......">
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">
30 <meta itemprop="description" content="This blog entry is to track the PQA merge process. See extended entry for full details......">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2005/11/pqa-merge-1.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
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 Merge</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1745" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">PQA Merge</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-18T08:21:28-08:00" itemprop="datePublished">November 18, 2005</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/pqa/">PQA</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
84 <p>This blog entry is to track the PQA merge process. See extended entry for full details...</p>
86 <li>Received backups from Dave Shah</li>
88 <li>In Clearquest designer I did Database: Delete Database for Cont and ContT</li>
90 <li>In Enterprise Manager:</li>
93 <li>Deleted 5 databases: CQ_Controller_Test, CQ_Controller_Prod, CQSchema03, CQ_TO_Prod and CQ2001AProd</li>
95 <li>Created those 5 databases anew</li>
97 <li>Restored CQSchema03, CQ_TO_Prod and CQ2001AProd</li>
99 <li>Changed server field in CQSchema02: master_dbs from production server to p4test</li>
101 <li>Ran SIDMap on all 5 databases</li>
103 <li>Made sure that the user CQ03_Admin was added to CQSchema03, CQ_Controller_Test and CQ_Controller_Prod as a DB owner</li>
106 <li>Back in Clearquest Designer I found that Cont and ContT were not deleted in the newly restored schema so I deleted ContT</li>
108 <li>Next I created a new database for ContT</li>
110 <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>
112 <li>Created new Cont database</li>
114 <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>
116 <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>
118 <li>Started pqamerge...</li>
120 <li>pqamerge finishes in 7 hours 2 minutes 5 seconds</li>
122 <li>Running check_attachments just to be sure</li>
124 <li>A quick spot check doesn't show any abnormalities. Vinh can check the data more thoroughly</li>
127 <nav class="page-navigation entry-navigation pagination content-nav">
128 <ul class="page-navigation-list">
130 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/11/create-dev-snap.html" title="create_dev_snapview.pl">Previous entry</a></li>
133 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/11/pqa-merge-part.html" title="PQA Merge (Part II)">Next entry</a></li>
138 <aside id="zenback" class="zenback feedback">
139 Please paste Zenback script code here.
146 <aside class="widgets related" role="complementary">
147 <nav class="widget-search widget">
148 <div class="widget-content">
149 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
151 <input type="text" name="search" value="" placeholder="Search...">
153 <input type="hidden" name="IncludeBlogs" value="8">
155 <input type="hidden" name="limit" value="20">
156 <button type="submit" name="button">
157 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
163 <nav class="widget-archive-category widget">
164 <h3 class="widget-header">Categories</h3>
165 <div class="widget-content">
168 <ul class="widget-list">
171 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
179 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
187 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
195 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
203 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
211 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
219 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
227 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
235 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
243 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
251 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
259 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
271 <nav class="widget-archive-dropdown widget">
272 <h3 class="widget-header">Archives</h3>
273 <div class="widget-content">
275 <option>Select a Month...</option>
277 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
281 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
285 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
289 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
293 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
297 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
301 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
305 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
309 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
313 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
317 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
321 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
325 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
329 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
333 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
337 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
341 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
345 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
349 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
353 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
357 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
361 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
365 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
369 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
373 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
377 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
381 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
385 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
389 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
393 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
401 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
405 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
409 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
413 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
417 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
421 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
425 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
429 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
433 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
437 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
445 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
449 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
453 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
457 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
461 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
465 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
469 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
473 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
477 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
481 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
493 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
497 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
501 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
505 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
509 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
513 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
517 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
521 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
525 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
529 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
533 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
537 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
541 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
545 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
549 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
553 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
557 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
561 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
569 <div class="widget-syndication widget section">
570 <div class="widget-content">
571 <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>
579 <footer id="footer" role="contentinfo">
580 <div id="footer-inner">
581 <div id="footer-content">
582 <nav role="navigation">
584 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
590 <p class="license">© Copyright 2016.</p>
591 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
597 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
598 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>