defaria.com/blogs/Status/archives/000474.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: Finding the missing 261,285,366 bytes</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/000473.html" title="Removing DBs from a Schema/Email link concerns" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000475.html" title="Final PQA fixes" />
  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/000473.html">&laquo; Removing DBs from a Schema/Email link concerns</a> |
  42                         <a href="http://defaria.com/blogs/Status/">Main</a>
  43                         | <a href="http://defaria.com/blogs/Status/archives/000475.html">Final PQA fixes &raquo;</a>
  44                      </p>
  45
  46                      <a id="a000474"></a>
  47                      <div class="entry" id="entry-474">
  48                         <h3 class="entry-header">Finding the missing 261,285,366 bytes</h3>
  49                         <div class="entry-content">
  50                            <div class="entry-body">
  51                               <ul>
  52   <li>Fixed bug in pqamerge that caused some attachments to not transfer</li>
  53 </ul>
  54                            </div>
  55                            <div id="more" class="entry-more">
  56                               <p>I think I've figured out where that missing data went to. As you know the total of the attachment sizes of the old databases compared to the new database was still off but a relatively substantial amount (261,285,366 bytes - see https://defaria.com/blogs/Status/archives/000471.html#more).</p>
  57
  58 <p>I changed check_attachments to help me find where the missing data was. The basic idea was to read all Cont records, total up the attachment size, then use Cont: old_id to locate the old record and total it. With those two figures I could find which records didn't convert correctly.</p>
  59
  60 <p>Turns out:</p>
  61
  62 <div class="code"><pre>
  63  # At this point we don't have any info about whether we are
  64  # coming from Prod or TO, however, there are the following fields:
  65  #
  66  #          TO               Prod              Cont
  67  # ----------------------- ----------------------- ----------------
  68  # Attachments        Attachments        Attachments
  69  # AttachmentsBRCM        AttachmentBRCM        AttachmentsBRCM
  70  #
  71  # You may notice that Prod: AttachmentBRCM is missing the "s".
  72  # Therefore:
  73  $field_name = "AttachmentsBRCM" if $field_name eq "AttachmentBRCM";
  74 </pre></div>
  75
  76 <p>Remerging and will run check_attachments again.</p>
  77                            </div>
  78                         </div>
  79                         <p class="entry-footer">
  80                            <span class="post-footers">Posted by  on November 10, 2005 11:55 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000474.html">Permalink</a>
  81                         </p>
  82                      </div>
  83
  84
  85
  86
  87                   </div>
  88                </div>
  89             </div>
  90          </div>
  91       </div>
  92    </div>
  93 </body>
  94 </html>