defaria.com/blogs/Status/2007/01/cclic-report-ye.html

   1 <!DOCTYPE html>
   2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
   3   <head>
   4     <meta charset="utf-8">
   5     <meta name="description" content=" Documented problem with cclic_report and crossing of the new year's boundary...">
   6     <meta name="generator" content="Movable Type 5.2.3">
   7     <title>cclic_report year boundary problem - 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/2007/01/cclic-report-ye.html">
  10     <meta name="viewport" content="width=device-width,initial-scale=1">
  11     <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
  12     <!--[if lt IE 9]>
  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>
  15     <![endif]-->
  16
  17     <link rel="start" href="http://defaria.com/blogs/Status/">
  18
  19     <link rel="prev" href="http://defaria.com/blogs/Status/2007/01/checkpoint.html" title="Checkpoint">
  20     <link rel="next" href="http://defaria.com/blogs/Status/2007/01/clearcase-70.html" title="Clearcase 7.0">
  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="cclic_report year boundary problem">
  25     <meta property="og:url" content="http://defaria.com/blogs/Status/2007/01/cclic-report-ye.html">
  26     <meta property="og:description" content=" Documented problem with cclic_report and crossing of the new year's boundary...">
  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">
  29     <!-- Metadata -->
  30     <meta itemprop="description" content=" Documented problem with cclic_report and crossing of the new year's boundary...">
  31     <link itemprop="url" href="http://defaria.com/blogs/Status/2007/01/cclic-report-ye.html">
  32     <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
  33
  34   </head>
  35   <body>
  36     <div id="container">
  37       <div id="container-inner">
  38         <header id="header" role="banner">
  39           <div id="header-inner">
  40             <div id="header-content">
  41               <h1>
  42                 <a href="http://defaria.com/blogs/Status/">
  43
  44                   Status
  45
  46                 </a>
  47               </h1>
  48
  49             </div>
  50
  51             <nav role="navigation">
  52           <ul>
  53             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
  54
  55
  56           </ul>
  57         </nav>
  58
  59           </div>
  60         </header>
  61         <div id="content">
  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">cclic_report year boundary problem</li>
  66             </ul>
  67             <div id="individual-main" class="main" role="main">
  68               <article id="entry-1865" class="entry entry-asset asset hentry">
  69                 <div class="asset-header">
  70                   <h2 itemprop="name" class="asset-name entry-title">cclic_report year boundary problem</h2>
  71                   <footer class="asset-meta">
  72                     <ul class="asset-meta-list">
  73                       <li class="asset-meta-list-item">Posted on <time datetime="2007-01-08T08:34:17-08:00" itemprop="datePublished">January  8, 2007</time></li>
  74                       <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
  75
  76
  77                       <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments</a></li>
  78
  79
  80                    </ul>
  81                 </footer>
  82                 </div>
  83                 <div class="entry-content asset-content" itemprop="articleBody">
  84                   <ul>
  85   <li>Documented problem with cclic_report and crossing of the new year's boundary</li>
  86 </ul>
  87                   <h3>Year boundary problem</h3>
  88
  89 <p>I have been working resolving problems with the cclic_report for this month. The script to do this has been failing due to a subtle bug in the algorithm used for obtaining the necessary files to translate the various user IDs and map them to Org 9 numbers and the like.</p>
  90
  91 <p>The script looks in a series of files out on the file system in order to obtain information to build mapping tables it needs to do the translation. These files are of the form:</p>
  92
  93 <div class=code><pre>
  94 /data/cmetrics/recv/&lt;<i>site</i>&gt;/&lt;<i>type&gt;.&lt;year</i>&gt;/&lt;<i>date</i>&gt;<br>
  95 </pre></div>
  96
  97 <p>Where:</p>
  98
  99 <dl>
 100   <dt>site</dt>
 101   <dd>A site designator. This is one of: dal-design (Dallas), nice-design (Nice), tii-shared (Bangalore) or vorlagenkontoliste (Vorlagenkontoliste)</dd>
 102   <dt>type</dt>
 103   <dd>The type of map. This is one of: passwd, aids or sbes</dd>
 104   <dt>year</dt>
 105   <dd>The current year</dd>
 106   <dt>date</dt>
 107   <dd>The current date in YYYY-MM-DD format</dd>
 108 </dl>
 109
 110 <p>These files are automatically generated by dsmetrics however they are not guaranteed to be up to the minute. The script attempts to workaround this by first starting with the current day then working backward one day at a time for up to 30 days. Thus if say /data/cmetrics/dal-design/passwd.2006/2006-12-31 has not yet be generated 2006-12-30 will be checked, then 2006-12-29 and so on.</p>
 111
 112 <p>Problem is that that algorithm <i>assumes</i> that the data store (e.g. /data/cmetrics/&lt;<i>site</i>&gt;/&lt;<i>type</i>&gt;.&lt;<i>year</i>&gt;) has at least 30 days of information. This assumption breaks when the year changes since the year is contained in the parent directory. So, for example, given today is 1/8/2007, if .../passwd.2007/2007-01-08 has not be generated we can only check for 07, 06, .., 01. Checking for .../paswd.<font color="#ff0000"><b>2007</b></font>/<font  color="#3333ff"><b>2006</b></font>-12-31 makes no sense and will never work.</p>
 113
 114 <p>Updating of the various files under /data/cmetrics seems sporadic. Currently the script is still not runnable as there is no /data/cmetrics/recv/tii-shared/password.2007 entries at all! The script is failing with:</p>
 115
 116 <div class=code><pre>
 117 $ ./cclic_report.pl -v
 118 cclic_report.pl (v{VERSION}) starting
 119 Getting full path to data files
 120 Unable to find /data/cmetrics/recv/tii-shared/passwd.2007/2006-12-10 at ./cclic_report.pl line 137
 121         main::findFile('/data/cmetrics/recv/tii-shared/passwd.2007') called at ./cclic_report.pl line 249
 122 </pre></div>
 123
 124 <p>I can see no real quick or easy solution for this except to wait for tii-shared's 2007 files to be generated...</p>
 125                 </div>
 126                 <nav class="page-navigation entry-navigation pagination content-nav">
 127                   <ul class="page-navigation-list">
 128
 129                     <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/01/checkpoint.html" title="Checkpoint">Previous entry</a></li>
 130
 131
 132                     <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/01/clearcase-70.html" title="Clearcase 7.0">Next entry</a></li>
 133
 134                   </ul>
 135                 </nav>
 136                 <!--
 137 <aside id="zenback" class="zenback feedback">
 138   Please paste Zenback script code here.
 139 </aside>
 140 -->
 141
 142
 143               </article>
 144             </div>
 145             <aside class="widgets related" role="complementary">
 146               <nav class="widget-search widget">
 147   <div class="widget-content">
 148     <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
 149       <div>
 150         <input type="text" name="search" value="" placeholder="Search...">
 151
 152         <input type="hidden" name="IncludeBlogs" value="8">
 153
 154         <input type="hidden" name="limit" value="20">
 155         <button type="submit" name="button">
 156           <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
 157         </button>
 158       </div>
 159     </form>
 160   </div>
 161 </nav>
 162 <nav class="widget-archive-category widget">
 163   <h3 class="widget-header">Categories</h3>
 164   <div class="widget-content">
 165
 166
 167     <ul class="widget-list">
 168
 169
 170       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
 171
 172
 173       </li>
 174
 175
 176
 177
 178       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
 179
 180
 181       </li>
 182
 183
 184
 185
 186       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
 187
 188
 189       </li>
 190
 191
 192
 193
 194       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
 195
 196
 197       </li>
 198
 199
 200
 201
 202       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
 203
 204
 205       </li>
 206
 207
 208
 209
 210       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
 211
 212
 213       </li>
 214
 215
 216
 217
 218       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
 219
 220
 221       </li>
 222
 223
 224
 225
 226       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
 227
 228
 229       </li>
 230
 231
 232
 233
 234       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
 235
 236
 237       </li>
 238
 239
 240
 241
 242       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
 243
 244
 245       </li>
 246
 247
 248
 249
 250       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
 251
 252
 253       </li>
 254
 255
 256
 257
 258       <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
 259
 260
 261       </li>
 262
 263     </ul>
 264
 265
 266   </div>
 267 </nav>
 268
 269
 270 <nav class="widget-archive-dropdown widget">
 271   <h3 class="widget-header">Archives</h3>
 272   <div class="widget-content">
 273     <select>
 274       <option>Select a Month...</option>
 275
 276       <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
 277
 278
 279
 280       <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
 281
 282
 283
 284       <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
 285
 286
 287
 288       <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
 289
 290
 291
 292       <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
 293
 294
 295
 296       <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
 297
 298
 299
 300       <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
 301
 302
 303
 304       <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
 305
 306
 307
 308       <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
 309
 310
 311
 312       <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
 313
 314
 315
 316       <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
 317
 318
 319
 320       <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
 321
 322
 323
 324       <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
 325
 326
 327
 328       <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
 329
 330
 331
 332       <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
 333
 334
 335
 336       <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
 337
 338
 339
 340       <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
 341
 342
 343
 344       <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
 345
 346
 347
 348       <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
 349
 350
 351
 352       <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
 353
 354
 355
 356       <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
 357
 358
 359
 360       <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
 361
 362
 363
 364       <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
 365
 366
 367
 368       <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
 369
 370
 371
 372       <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
 373
 374
 375
 376       <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
 377
 378
 379
 380       <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
 381
 382
 383
 384       <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
 385
 386
 387
 388       <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
 389
 390
 391
 392       <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
 393
 394
 395
 396       <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
 397
 398
 399
 400       <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
 401
 402
 403
 404       <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
 405
 406
 407
 408       <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
 409
 410
 411
 412       <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
 413
 414
 415
 416       <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
 417
 418
 419
 420       <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
 421
 422
 423
 424       <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
 425
 426
 427
 428       <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
 429
 430
 431
 432       <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
 433
 434
 435
 436       <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
 437
 438
 439
 440       <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
 441
 442
 443
 444       <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
 445
 446
 447
 448       <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
 449
 450
 451
 452       <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
 453
 454
 455
 456       <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
 457
 458
 459
 460       <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
 461
 462
 463
 464       <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
 465
 466
 467
 468       <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
 469
 470
 471
 472       <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
 473
 474
 475
 476       <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
 477
 478
 479
 480       <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
 481
 482
 483
 484       <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
 485
 486
 487
 488       <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
 489
 490
 491
 492       <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
 493
 494
 495
 496       <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
 497
 498
 499
 500       <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
 501
 502
 503
 504       <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
 505
 506
 507
 508       <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
 509
 510
 511
 512       <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
 513
 514
 515
 516       <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
 517
 518
 519
 520       <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
 521
 522
 523
 524       <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
 525
 526
 527
 528       <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
 529
 530
 531
 532       <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
 533
 534
 535
 536       <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
 537
 538
 539
 540       <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
 541
 542
 543
 544       <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
 545
 546
 547
 548       <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
 549
 550
 551
 552       <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
 553
 554
 555
 556       <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
 557
 558
 559
 560       <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
 561
 562     </select>
 563   </div>
 564 </nav>
 565
 566
 567
 568 <div class="widget-syndication widget section">
 569   <div class="widget-content">
 570     <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>
 571
 572   </div>
 573 </div>
 574
 575             </aside>
 576           </div>
 577         </div>
 578         <footer id="footer" role="contentinfo">
 579           <div id="footer-inner">
 580             <div id="footer-content">
 581   <nav role="navigation">
 582           <ul>
 583             <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
 584
 585
 586           </ul>
 587         </nav>
 588
 589   <p class="license">&copy; Copyright 2016.</p>
 590   <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
 591 </div>
 592           </div>
 593         </footer>
 594       </div>
 595     </div>
 596     <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
 597     <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>
 598   </body>
 599 </html>