<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The order was originally wrong in the TT when we started PrimEx. David L. was working on the interface
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
to propagate changes from the CCDB to the TT. Don't submit anything, I will take a look.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Justin Stevens <jrsteven@jlab.org><br>
<b>Sent:</b> Friday, December 13, 2019 4:15 PM<br>
<b>To:</b> Alexander Somov <somov@jlab.org><br>
<b>Cc:</b> jonesrt@jlab.org <jonesrt@jlab.org>; primexd@jlab.org <primexd@jlab.org><br>
<b>Subject:</b> Re: [Primexd] [New Comment] Follow-up Re: Follow-up Re: error in translation table for TAGM column 21</font>
<div> </div>
</div>
<div class="" style="word-wrap:break-word; line-break:after-white-space">They are swapped because that is the order of the columns in the sqlite table which generates the XML. In terms of the XML and how it’s used in the offline software (as with all our other
detectors) the order doesn’t matter.
<div class=""><br class="">
</div>
<div class="">I will make the change to the sqlite table, such that it produces the XML TT which matches what your preference. This way we can continue to make changes to the TT which propagate to both the standard EPICs GUIs and the XML file used for offline
processing. </div>
<div class=""><br class="">
</div>
<div class="">-Justin<br class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Dec 13, 2019, at 3:50 PM, Alexander Somov <<a href="mailto:somov@jlab.org" class="">somov@jlab.org</a>> wrote:</div>
<br class="x_Apple-interchange-newline">
<div class="">
<div class="" style="font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
Why did you swap row and columns in the translation table ?</div>
<div class="" style="font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
We have a numbering convention in the detector, which is also used in the local monitoring.</div>
<div class="" style="font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<br class="">
</div>
<div class="" style="font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
Please don't modify the CCAL section without at least letting us know about this.</div>
<div class="" style="font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<br class="">
</div>
<div class="" style="font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<br class="">
</div>
<div class="" style="font-family:Helvetica; font-size:12px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
<div id="x_appendonsend" class=""></div>
<div class="" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<br class="">
</div>
<hr tabindex="-1" class="" style="display:inline-block; width:661.5px">
<div id="x_divRplyFwdMsg" dir="ltr" class=""><font class="" style="font-size:11pt" face="Calibri, sans-serif"><b class="">From:</b><span class="x_Apple-converted-space"> </span>Justin Stevens <<a href="mailto:jrsteven@jlab.org" class="">jrsteven@jlab.org</a>><br class="">
<b class="">Sent:</b><span class="x_Apple-converted-space"> </span>Friday, December 13, 2019 7:11 AM<br class="">
<b class="">To:</b><span class="x_Apple-converted-space"> </span>Alexander Somov <<a href="mailto:somov@jlab.org" class="">somov@jlab.org</a>><br class="">
<b class="">Cc:</b><span class="x_Apple-converted-space"> </span><a href="mailto:jonesrt@jlab.org" class="">jonesrt@jlab.org</a> <<a href="mailto:jonesrt@jlab.org" class="">jonesrt@jlab.org</a>>;
<a href="mailto:primexd@jlab.org" class="">primexd@jlab.org</a> <<a href="mailto:primexd@jlab.org" class="">primexd@jlab.org</a>><br class="">
<b class="">Subject:</b><span class="x_Apple-converted-space"> </span>Re: [Primexd] [New Comment] Follow-up Re: Follow-up Re: error in translation table for TAGM column 21</font>
<div class=""> </div>
</div>
<div class="" style="word-wrap:break-word; line-break:after-white-space">
<div dir="auto" class="" style="word-wrap:break-word; line-break:after-white-space">
Actually Sasha, I was quite careful to be sure that I did not cause an error in the CCAL translation table when I updated CCDB. If you look carefully at the diff you show below, they are functionally equivalent (i.e. channel number, col, row numerical values
are identical in the xml tags, although the order is different).
<div class=""><br class="">
</div>
<div class="">In fact, I did more than a diff before I put this in CCDB. I actually ran the CCAL_online plugin and hd_dump to confirm that the results are identical for the CCAL before and after my upload. If you want to try this for yourself you can run
these commands:</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">setenv JANA_CALIB_URL<span class="x_Apple-converted-space"> </span><a href="" class="">mysql://ccdb_user@hallddb.jlab.org/ccdb</a></div>
</div>
<div class=""><br class="">
</div>
<div class=""># your version of the TT just checked in to CCDB yesterday evening is now the default</div>
<div class="">hd_dump -DDCCALDigiHit -DDCCALHit /cache/halld/RunPeriod-2019-01/rawdata/Run061887/hd_rawdata_061887_000.evio</div>
<div class=""><br class="">
</div>
<div class=""># my version of the TT uploaded to CCDB on 12/3/19 (set using calibration context before your upload)</div>
<div class="">hd_dump -DDCCALDigiHit -DDCCALHit -PJANA_CALIB_CONTEXT="calibtime=2019-12-12-18-00-00" /cache/halld/RunPeriod-2019-01/rawdata/Run061887/hd_rawdata_061887_000.evio</div>
<div class="">
<div class=""><br class="">
<div class="">They result in the same hit objects in our standard halld_recon framework. If there are other issues with the TT, please let me know and I’ll be happy to fix them promptly. Now I’ll get back to fixing the actual problem with the TAGM reported
by Richard.</div>
<div class=""><br class="">
</div>
<div class="">-Justin<br class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On Dec 12, 2019, at 7:50 PM,<span class="x_Apple-converted-space"> </span><a href="mailto:somov@jlab.org" class="">somov@jlab.org</a><span class="x_Apple-converted-space"> </span>wrote:</div>
<br class="x_x_Apple-interchange-newline">
<div class="">
<div id="x_x_center" class="" style="color:rgb(85,85,85); font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
<div id="x_x_main" class="">
<h1 class="x_x_node-title" style="font-size:1.6em"><a href="https://logbooks.jlab.org/entry/3752314" rel="bookmark" class="" target="_BLANK" style="text-decoration:none">Follow-up Re: Follow-up Re: error in translation table for TAGM column 21</a></h1>
<div class="x_x_contextual-links-wrapper">
<ul class="x_x_contextual-links">
<li class=""><a href="https://logbooks.jlab.org/entry/3752314/edit?destination=email/send" class="" target="_BLANK" style="text-decoration:none">Edit</a></li><li class=""><a href="https://logbooks.jlab.org/entry/3752314/delete?destination=email/send" class="" target="_BLANK" style="text-decoration:none">Delete</a></li></ul>
</div>
<div class="x_x_date-vitals">
<div class="" style="font-weight:bold; font-size:9.1875px; margin:0.1em 0px">Lognumber<span class="x_x_Apple-converted-space"> </span><a href="https://logbooks.jlab.org/entry/3752314" class="x_x_lognumber" target="_BLANK" style="text-decoration:none">3752314</a>.
Submitted by<span class="x_x_Apple-converted-space"> </span><a href="https://logbooks.jlab.org/user/jonesrt" class="" target="_BLANK" style="text-decoration:none">jonesrt</a><span class="x_x_Apple-converted-space"> </span>on<span class="x_x_Apple-converted-space"> </span><time datetime="2019-12-12T14:54:50-0500" class=""><a href="https://logbooks.jlab.org/entries?start_date=1576176890&end_date=1576184090&book=HDLOG&book=HDTAGGER" class="" target="_BLANK" style="text-decoration:none">Thu,
12/12/2019 - 14:54</a></time>.<span class="x_x_Apple-converted-space"> </span></div>
<div class="x_x_comments-box">
<div class="x_x_ctools-collapsible-container" style="clear:both">
<div class="x_x_ctools-collapsible-handle"><a href="" class="" style="text-decoration:none">There is 1 comment...</a></div>
<div class="x_x_ctools-collapsible-content"><a id="x_x_comment-24915" class="" style="text-decoration:none"></a>
<h3 class="x_x_comment-title"><a href="https://logbooks.jlab.org/comment/24915#comment-24915" rel="bookmark" class="" target="_BLANK" style="text-decoration:none">Translation Table<span class="x_x_Apple-converted-space"> </span></a></h3>
<em class="x_x_new">new</em>
<div class="" style="font-weight:bold; font-size:9.1875px; margin:0.1em 0px">by<span class="x_x_Apple-converted-space"> </span><a href="https://logbooks.jlab.org/user/somov" title="View user profile." class="x_x_username" target="_BLANK" style="text-decoration:none">somov</a><span class="x_x_Apple-converted-space"> </span>on<span class="x_x_Apple-converted-space"> </span><time datetime="2019-12-12T19:46:45-0500" class="">Thu,
12/12/2019 - 19:46</time></div>
<div class="x_x_comment-content">
<div class="x_x_field-type-text-long x_x_view-mode-elog_email x_x_field-name-comment-body x_x_field x_x_field-label-hidden">
<div class="x_x_field-items">
<div class="x_x_field-item x_x_even">
<div class="" style="font-size:9.1875px; margin:0.1em 0px">The translation table /Translation/DAQ2detector was overwritten in the beginning of December 2019,<br class="">
see below</div>
<div class="" style="font-size:9.1875px; margin:0.1em 0px">create jrsteven 2019-12-03 13-12-36 Created assignment '/Translation/DAQ2detector:60000:default:2019-12-03_13-12-36</div>
<div class="" style="font-size:9.1875px; margin:0.1em 0px">As a result, the CCAL table was corrupted for the PrimEx run period, see some differences between the old and<br class="">
new table below (the data is Ok, the CCAL reconstruction didn't work properly if you run it after 12/03/19, fixed now)<br class="">
(I will also update the run period 70000+ when we understand TAGM cabling)</div>
<div class="" style="font-size:9.1875px; margin:0.1em 0px">I restored the table and going to check it. The TAGM was restored according to the PrimEx run period, for<br class="">
consistency (we need to debug and correct swapped DSC/TDC cables though).</div>
<div class="" style="font-size:9.1875px; margin:0.1em 0px">----------------------------------------------------------------------------------<br class="">
When you update CCDB tables, please check and modify only sections relevant to you<br class="">
(using diff is not a bad idea to compare versions).<br class="">
----------------------------------------------------------------------------------</div>
<div class="" style="font-size:9.1875px; margin:0.1em 0px">.............................</div>
<div class="" style="font-size:9.1875px; margin:0.1em 0px">< <channel number="0" detector="CCAL" col="-6" row="5"/><br class="">
< <channel number="1" detector="CCAL" col="-1" row="-6"/><br class="">
< <channel number="2" detector="CCAL" col="-2" row="-6"/><br class="">
< <channel number="3" detector="CCAL" col="-3" row="-6"/><br class="">
< <channel number="4" detector="CCAL" col="-4" row="-6"/><br class="">
< <channel number="5" detector="CCAL" col="-5" row="-6"/><br class="">
< <channel number="6" detector="CCAL" col="-6" row="-6"/><br class="">
< <channel number="7" detector="CCAL" col="-6" row="-1"/><br class="">
< <channel number="8" detector="CCAL" col="-6" row="-2"/><br class="">
< <channel number="9" detector="CCAL" col="-6" row="-3"/><br class="">
< <channel number="10" detector="CCAL" col="-6" row="-4"/><br class="">
< <channel number="11" detector="CCAL" col="-6" row="-5"/><br class="">
---<br class="">
> <channel number="0" detector="CCAL" row="5" col="-6"/><br class="">
> <channel number="1" detector="CCAL" row="-6" col="-1"/><br class="">
> <channel number="2" detector="CCAL" row="-6" col="-2"/><br class="">
> <channel number="3" detector="CCAL" row="-6" col="-3"/><br class="">
> <channel number="4" detector="CCAL" row="-6" col="-4"/><br class="">
> <channel number="5" detector="CCAL" row="-6" col="-5"/><br class="">
> <channel number="6" detector="CCAL" row="-6" col="-6"/><br class="">
> <channel number="7" detector="CCAL" row="-1" col="-6"/><br class="">
> <channel number="8" detector="CCAL" row="-2" col="-6"/><br class="">
> <channel number="9" detector="CCAL" row="-3" col="-6"/><br class="">
> <channel number="10" detector="CCAL" row="-4" col="-6"/><br class="">
> <channel number="11" detector="CCAL" row="-5" col="-6"/></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<table class="x_x_field-vitals" style="margin-top:1em; margin-bottom:1em; font-size:9.1875px">
<tbody class="">
<tr class="">
<th class="" style="vertical-align:middle; text-align:left; width:50.46875px; padding:0.1em">
Logbooks:</th>
<td class="" style="vertical-align:middle; text-align:left; width:auto; padding:0.1em">
<a href="https://logbooks.jlab.org/book/hdlog" class="" target="_BLANK" style="text-decoration:none">HDLOG</a><span class="x_x_Apple-converted-space"> </span><a href="https://logbooks.jlab.org/book/hdtagger" class="" target="_BLANK" style="text-decoration:none">HDTAGGER</a></td>
</tr>
<tr class="">
<th class="" style="vertical-align:middle; text-align:left; width:50.46875px; padding:0.1em">
References:</th>
<td class="" style="vertical-align:middle; text-align:left; width:auto; padding:0.1em">
<a href="https://logbooks.jlab.org/entry/3751784" class="" target="_BLANK" style="text-decoration:none">3751784 - Follow-up Re: error in translation table for TAGM column 21</a></td>
</tr>
</tbody>
</table>
</div>
<div class="x_x_node-content x_x_logentry">
<div class="" style="margin-top:0px; margin-bottom:0px">Here is a diff between a current (tt_bad) and what it would look like corrected (tt_good). The line numbers might be off, as I am comparing what existed back in February before and after the change that
introduced the mutation. That is, you want to comment out the line where col="21" is assigned for the DISCIM and F1TDC sections, then uncomment the line where is should be assigned in each section. The correct value is there, but it is commented out. Apparently
before the "fix the dup" correction, both entries were uncommented in the tt, which prompted David to try and fix it. Problem was, he commented out the wrong one.</div>
<div class="" style="margin-top:0px; margin-bottom:0px">[<a href="mailto:jonesrt@gluey" class="" style="text-decoration:none">jonesrt@gluey</a><span class="x_x_Apple-converted-space"> </span>TranslationTable]$ diff tt_bad.xml tt_good.xml</div>
<div class="" style="margin-top:0px; margin-bottom:0px">24712c24712</div>
<div class="" style="margin-top:0px; margin-bottom:0px">< <channel number="8" detector="TAGM" col="21" row="0"/></div>
<div class="" style="margin-top:0px; margin-bottom:0px">---</div>
<div class="" style="margin-top:0px; margin-bottom:0px">> <!--channel number="8" detector="TAGM" col="21" row="0"/--></div>
<div class="" style="margin-top:0px; margin-bottom:0px">24823c24823</div>
<div class="" style="margin-top:0px; margin-bottom:0px">< <!--channel number="11" detector="TAGM" col="21" row="0"/--></div>
<div class="" style="margin-top:0px; margin-bottom:0px">---</div>
<div class="" style="margin-top:0px; margin-bottom:0px">> <channel number="11" detector="TAGM" col="21" row="0"/></div>
<div class="" style="margin-top:0px; margin-bottom:0px">25394c25394</div>
<div class="" style="margin-top:0px; margin-bottom:0px">< <channel number="23" detector="TAGM" col="21" row="0"/></div>
<div class="" style="margin-top:0px; margin-bottom:0px">---</div>
<div class="" style="margin-top:0px; margin-bottom:0px">> <!--channel number="23" detector="TAGM" col="21" row="0"/--></div>
<div class="" style="margin-top:0px; margin-bottom:0px">25499c25499</div>
<div class="" style="margin-top:0px; margin-bottom:0px">< <!--channel number="26" detector="TAGM" col="21" row="0"/--></div>
<div class="" style="margin-top:0px; margin-bottom:0px">---</div>
<div class="" style="margin-top:0px; margin-bottom:0px">> <channel number="26" detector="TAGM" col="21" row="0"/></div>
</div>
<div class="x_x_attachment-box"></div>
</div>
</div>
<span class="" style="color:rgb(85,85,85); font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; float:none; display:inline!important">_______________________________________________</span><br class="" style="color:rgb(85,85,85); font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
<span class="" style="color:rgb(85,85,85); font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; float:none; display:inline!important">Primexd
mailing list</span><br class="" style="color:rgb(85,85,85); font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
<a href="mailto:Primexd@jlab.org" class="" style="text-decoration:none; font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px">Primexd@jlab.org</a><br class="" style="color:rgb(85,85,85); font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none">
<a href="https://mailman.jlab.org/mailman/listinfo/primexd" class="" target="_BLANK" style="text-decoration:none; font-family:"Trebuchet MS","Helvetica Neue",Arial,Helvetica,sans-serif; font-size:10.5px; font-style:normal; font-variant-caps:normal; font-weight:normal; letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px">https://mailman.jlab.org/mailman/listinfo/primexd</a></div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</body>
</html>