2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content="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...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>PQA Clearquest: Resolving remaining issues with bad data - 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-3.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/10/pqa-merge-actio.html" title="PQA Merge - Action Hooks & Attachments">
20 <link rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-4.html" title="PQA Clearquest:: Spacing out">
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: Resolving remaining issues with bad data">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-3.html">
26 <meta property="og:description" content="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...">
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 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...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-3.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 Clearquest: Resolving remaining issues with bad data</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1717" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">PQA Clearquest: Resolving remaining issues with bad data</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-15T18:41:29-08:00" itemprop="datePublished">October 15, 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 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>
85 <h2>Resolving Data Conversion Problems in PQA Database Merge</h2>
87 <h3>New fields that are mandatory</h3>
89 <p>The following fieilds are new in the destination database (Cont) and are also mandatory thus must be filled in with something:</p>
92 <li><b>Cont:Found_On_Gold:</b> This field is defaulted to <i>No</i>.</li>
95 <h3>Fields with blank or invalid data</h3>
97 <p>The following fields have blank or invalid data in the source database thus fail validation when added to the new database:</p>
100 <li><b>TO:SQATestCase:</b> This field, when blank, is set to the string "N/A". This field is also renamed to <b>Cont:PQATestCase</b>.</li>
102 <li><b>TO:Title_2:</b> This field, when blank, is set to the string "N/A". This field is also renamed to <b>Cont:TItle</b>.</li>
104 <li><b>Prod:Software_Version:</b> This field, when blank, is set to the string "N/A".</li>
106 <li><b>Prod:HUT_Version:</b> This field, when blank, is set to the string "N/A". This field is also renamed to <b>Cont:Board_Revision</b>.</li>
108 <li><b>Prod:Software_Version:</b> This field, when blank, is set to the string "N/A".</li>
110 <li><b>Prod:SQATestCase:</b> This field, when blank, is set to the string "N/A". This field is also renamed to <b>Cont:PQATestCase</b>.</li>
113 <h3>Fields with data that are no longer valid in new database</h3>
115 <p>The following fields have data in the source database but fail validation when added to the new database due to reasons like not being on the list of acceptable values for the field in question:</p>
118 <li><b>Prod:Category</b> This field sometimes has the value of <i>Hardware</i> or <i>System Bios</i> which are not valid choices in the new database. For now I am changing <i>Hardware</i> -> <i>Hardware - Chip</i> and <i>System Bios</i> -> <i>Software</i>. I suggest we add <i>Hardware</i> and <i>System Bios</i> to the constant list as <i>HARDWARE</i> and <i>SYSTEM BIOS</i> (Capitalized) so we can easily find and correct these later.</li>
120 <li><b>Prod:Issue_Classification:</b> This field sometimes has the value of <i>Hardware</i> which is not a valid choice in the new database. For now I'm changing <i>Hardware</i> -> <i>Requirement</i>. I suggest we add <i>Hardware</i> to the constant list as <i>HARDWARE</i> (Capitalized) so we can easily find and correct these later.</li>
122 <li><b>Prod:Resolution:</b> This field sometimes has the value of <i>HW Fix</i> or <i>MAC Core</i> which are not valid choices in the new database. For now I am changing <i>HW Fix</i> -> <i>HW - Fix</i> and <i>MAC Core</i> -> <i>SW Fix</i>. I suggest we add <i>HW - Fix</i> and <i>MAC Core</i> to the constant list as <i>HW - FIX</i> and <i>MAC CORE</i> (Capitalized) so we can easily find and correct these later.</li>
124 <li><b>Prod:HUT_Revision:</b> This field is sometimes set to "n/a". This is translated to "N/A" (note capitalization).</li>
127 <h3>Fields that need truncating</h3>
129 <p>The following fields have data that is too large to fit in the size of the corresponding field in the destination database:</p>
132 <li><b>Prod:ActionNotes:</b> This field is defined with a maximum length of 50 characters in the TO database, 250 characters in the Prod database and 50 characters in the Cont database. Some entries in the Prod database are greater than 50 characters thus require truncation. I suggest that we increase the maximum length of <b>Cont:ActionNotes</b> to 250 characters to avoid this problem.</li>
135 <nav class="page-navigation entry-navigation pagination content-nav">
136 <ul class="page-navigation-list">
138 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2005/10/pqa-merge-actio.html" title="PQA Merge - Action Hooks & Attachments">Previous entry</a></li>
141 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2005/10/pqa-clearquest-4.html" title="PQA Clearquest:: Spacing out">Next entry</a></li>
146 <aside id="zenback" class="zenback feedback">
147 Please paste Zenback script code here.
154 <aside class="widgets related" role="complementary">
155 <nav class="widget-search widget">
156 <div class="widget-content">
157 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
159 <input type="text" name="search" value="" placeholder="Search...">
161 <input type="hidden" name="IncludeBlogs" value="8">
163 <input type="hidden" name="limit" value="20">
164 <button type="submit" name="button">
165 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
171 <nav class="widget-archive-category widget">
172 <h3 class="widget-header">Categories</h3>
173 <div class="widget-content">
176 <ul class="widget-list">
179 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
187 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
195 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
203 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
211 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
219 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
227 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
235 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
243 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
251 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
259 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
267 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
279 <nav class="widget-archive-dropdown widget">
280 <h3 class="widget-header">Archives</h3>
281 <div class="widget-content">
283 <option>Select a Month...</option>
285 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
289 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
293 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
297 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
301 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
305 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
309 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
313 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
317 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
321 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
325 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
329 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
333 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
337 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
341 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
345 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
349 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
353 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
357 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
361 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
365 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
369 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
373 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
377 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
381 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
385 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
389 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
393 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
401 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
405 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
409 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
413 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
417 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
421 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
425 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
429 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
433 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
437 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
445 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
449 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
453 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
457 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
461 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
465 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
469 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
473 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
477 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
481 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
493 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
497 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
501 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
505 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
509 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
513 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
517 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
521 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
525 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
529 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
533 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
537 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
541 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
545 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
549 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
553 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
557 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
561 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
565 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
569 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
577 <div class="widget-syndication widget section">
578 <div class="widget-content">
579 <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>
587 <footer id="footer" role="contentinfo">
588 <div id="footer-inner">
589 <div id="footer-content">
590 <nav role="navigation">
592 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
598 <p class="license">© Copyright 2016.</p>
599 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
605 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
606 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>