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">
5 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
6 <meta name="generator" content="Movable Type 5.2.3" />
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"$>" />
12 <title>Status for Andrew DeFaria: November 13, 2005 - November 19, 2005 Archives</title>
14 <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
15 <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2005_11_06.html" title="November 6, 2005 - November 12, 2005" />
16 <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2005_11_20.html" title="November 20, 2005 - November 26, 2005" />
18 <body class="layout-one-column">
20 <div id="container-inner" class="pkg">
23 <div id="banner-inner" class="pkg">
24 <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
25 <h2 id="banner-description">Searchable status reports and work log</h2>
30 <div id="pagebody-inner" class="pkg">
32 <div id="alpha-inner" class="pkg">
34 <p class="content-nav">
35 <a href="http://defaria.com/blogs/Status/archives/week_2005_11_06.html">« November 6, 2005 - November 12, 2005</a> |
36 <a href="http://defaria.com/blogs/Status/">Main</a>
37 | <a href="http://defaria.com/blogs/Status/archives/week_2005_11_20.html">November 20, 2005 - November 26, 2005 »</a>
43 <h2 class="date-header">November 19, 2005</h2>
45 <div class="entry" id="entry-482">
46 <h3 class="entry-header">PQA Merge (Part II)</h3>
47 <div class="entry-content">
48 <div class="entry-body">
50 <li>Worked with Vinh on small problem with Gating_Item_SW.</li>
52 <li>Backed up database to \\p4test\Cont as CQ_Controller_Prod.db.backup</li>
54 <li>Copied backup up to \\pcirvd-dshah\CQ</li>
57 <h2>Gating_Item_SW</h2>
59 <p>Vinh noticed an abnormality whereby some Gating_Item_SW items were not correctly transfered. I'm not sure how pqamerge messed this up as it never changes the value of the data, just the field name. We can look at this later, after the merge is completed. Meantime VInh use his SQL prowness to fix the problem.</p>
63 <p class="entry-footer">
64 <span class="post-footers">Posted by at 2:47 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000482.html">Permalink</a>
74 <h2 class="date-header">November 18, 2005</h2>
76 <div class="entry" id="entry-481">
77 <h3 class="entry-header">PQA Merge</h3>
78 <div class="entry-content">
79 <div class="entry-body">
80 <p>This blog entry is to track the PQA merge process. See extended entry for full details...</p>
83 <li>Received backups from Dave Shah</li>
85 <li>In Clearquest designer I did Database: Delete Database for Cont and ContT</li>
87 <li>In Enterprise Manager:</li>
90 <li>Deleted 5 databases: CQ_Controller_Test, CQ_Controller_Prod, CQSchema03, CQ_TO_Prod and CQ2001AProd</li>
92 <li>Created those 5 databases anew</li>
94 <li>Restored CQSchema03, CQ_TO_Prod and CQ2001AProd</li>
96 <li>Changed server field in CQSchema02: master_dbs from production server to p4test</li>
98 <li>Ran SIDMap on all 5 databases</li>
100 <li>Made sure that the user CQ03_Admin was added to CQSchema03, CQ_Controller_Test and CQ_Controller_Prod as a DB owner</li>
103 <li>Back in Clearquest Designer I found that Cont and ContT were not deleted in the newly restored schema so I deleted ContT</li>
105 <li>Next I created a new database for ContT</li>
107 <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>
109 <li>Created new Cont database</li>
111 <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>
113 <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>
115 <li>Started pqamerge...</li>
117 <li>pqamerge finishes in 7 hours 2 minutes 5 seconds</li>
119 <li>Running check_attachments just to be sure</li>
121 <li>A quick spot check doesn't show any abnormalities. Vinh can check the data more thoroughly</li>
124 <p class="entry-footer">
125 <span class="post-footers">Posted by at 8:21 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000481.html">Permalink</a>
135 <h2 class="date-header">November 17, 2005</h2>
137 <div class="entry" id="entry-480">
138 <h3 class="entry-header">create_dev_snapview.pl</h3>
139 <div class="entry-content">
140 <div class="entry-body">
142 <li>Looked into create_dev_snapview.pl.</li>
144 <li>Tested speeds of FTP vs. SMB</li>
147 <h2>create_dev_snapview.pl</h2>
149 <blockquote type=cite>
150 <b>From:</b> Andrew Feltham <br>
151 <b>Sent:</b> Tuesday, November 15, 2005 3:58 PM<br>
152 <b>To:</b> Shivdutt Jha<br>
153 <b>Subject:</b> creating snapshot views <br>
158 <p>so I've tried to use Naga's tool for creating a snapshot view of a particular stream using a variety of incremental baselines.</p>
160 <p>I've done this using a file generated by Phil's nightly builds (see attached) which lists the specific baseline which was current for each vob.</p>
162 <p>First of all, it does not seem to work (see image below). I'm not sure I'm handling the composite baseline label properly</p>
164 <p>Secondly, I do find the tool a bit awkward as it expects me to input several incremental baselines for vobs which are not included in my load rules.</p>
166 <p>It would be nice if I could specify the vobs on the cmd line, and only provide those labels.</p>
169 <p>Actually the script is working as designed. The arguments for create_dev_snapview.pl are:</p>
171 <div class="code"><pre>
172 create_dev_snapview.pl <project_name> [ baseline_selector ]
175 <p>project_name is mandatory but baseline_selector is optional. If you don't specify the baseline_selector then it appears that the script takes all the recommended baselines for all components in the project. Or you can specify a list of baselines if you want different ones. The script checks the number of baselines you specified and compares them to the number of <i>modifiable</i> components in the project. These two numbers must agree.</p>
177 <p>After painstakingly typing in the command line (wish you would have posted the command line in text! :-( ) and running it through Perl's debugger I came to the realization that you typed in 11 (very long) baselines and there are only 10 modifiable components in the ldx_2.3 project.</p>
179 <p>In thinking of how to do this better I can think of two methods:</p>
182 <li>Assuming the <span>buildconfig</span>.txt file is a standard file and contains all the information needed, add a -f <buildconfig> option to create_dev_snapview.pl. When present the script would open and parse that file, extracting out the required information. This would help cut down on typing and errors.</li>
184 <li>Modify the script to present a series of dialog boxes prompting for the baseline to use for each component in the project. Note that in this instance this would mean a total of 10 dialog box prompts!</li>
187 <p>Either of these options can be added to the existing script via options that cause it to operate in a different way if present or to operate like it used to operate if those options are not present.</p>
189 <p>(Question: When you type "perl" at your command line, what Perl are you running? Because Perl isn't normally present on Windows. Normally people using Clearcase run ccperl...).</p>
193 <p>Well this runs contrary to my previous experience but it turns out that a regular file copy using SMB shares is faster than FTP. I tested copying the old 2.7 Gig CQProd2001A database to my desktop, once with FTP and once with SMB. SMB won! Which is surprising to me because last time I tested something like this FTP was up to 10 times faster:</p>
195 <div class="code"><pre>
196 Local:time ftpget -u vobadm -p4sjadm p4test . "/dev/d/CQBackupsfromIrvine/0916/CQProd2001A_db_200509160213.BAK"
197 CQProd2001A_db_200509160213.BAK 2.66 GB 60.35 kB/s
206 <div class="code"><pre>
207 Local:time cp //p4test/CQBackupsfromIrvine/0916/CQProd2001A_db_200509160213.BAK /tmp
215 <p class="entry-footer">
216 <span class="post-footers">Posted by at 12:39 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000480.html">Permalink</a>
226 <h2 class="date-header">November 16, 2005</h2>
228 <div class="entry" id="entry-478">
229 <h3 class="entry-header">PerlTk</h3>
230 <div class="entry-content">
231 <div class="entry-body">
233 <li>Continued work on clearprompt replacement in PerlTk.</li>
236 <p class="entry-footer">
237 <span class="post-footers">Posted by at 9:13 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000478.html">Permalink</a>
247 <h2 class="date-header">November 15, 2005</h2>
249 <div class="entry" id="entry-477">
250 <h3 class="entry-header">PerlTK/Bug in pqamerge</h3>
251 <div class="entry-content">
252 <div class="entry-body">
254 <li>Experimented with PerlTK in an effort to come up with a better Clearprompt for bin_merge</li>
256 <li>Vinh found a bug in pqamerge where Prod: Open_Close_Status was not getting transferred to Cont: Active_Deferred_Status</li>
259 <p class="entry-footer">
260 <span class="post-footers">Posted by at 5:19 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000477.html">Permalink</a>
270 <h2 class="date-header">November 14, 2005</h2>
272 <div class="entry" id="entry-479">
273 <h3 class="entry-header">Finalizing pqamerge</h3>
274 <div class="entry-content">
275 <div class="entry-body">
277 <li>Identified a few more bugs with pqamerge</li>
280 <li>Changed to handle Open_Close_Status -> Active_Deferred_Status for Prod.</li>
282 <li>Changed to correctly handle Gating_Item_SW. This is set from GatingItem from both TO and Prod. Gating_Item_HW is a new field and is set to "No".</li>
285 <li>Worked with Vinh finalizing steps for pqamerge</li>
288 <p class="entry-footer">
289 <span class="post-footers">Posted by at 9:15 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000479.html">Permalink</a>