<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks Valerie !<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">I hope you have a great weekend
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Anne
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Valerie Bookwalter <bookwalt@jlab.org>
<br>
<b>Sent:</b> Friday, April 10, 2020 3:11 PM<br>
<b>To:</b> E. Anne McEwen <mcewen@jlab.org><br>
<b>Cc:</b> Tony Reilly <areilly@jlab.org>; Jacob Harris <jharris@jlab.org>; pansophy <pansophy@jlab.org>; Liang Zhao <lzhao@jlab.org>; George DeKerlegand <georged@jlab.org><br>
<b>Subject:</b> PTeam Weekly Status Report (10Apr2020)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I think we are at 80% complete. <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mostly it is the SQL changes for the datamining and primes areas. Mike is working on a solution that is almost ready. At that time we will be able to apply the solution to the remaining datamining pages and complete the PRIMeS area.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The problem is the new ColdFusion server is translating our use of the Oracle notation of (+) for INNER/OUTER JOINS of tables. This is used for many of our complicated database queries. He reached out to the ColdFusion community but no
one has been able to offer advice on how to correct or why ColdFusion is interpretting the notation incorrectly.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I think most everything else is done with minor exceptions:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">email<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">export to PDF and EXCEL<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">FileUpload<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">One Note: The export feature we utilize is outdated and we are looking for a resolution. This would not stop us going to the new server but would render exports to PDF and Excel unusable until we do find a solution.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">DataMine Areas (need SQL fix):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Queries -> Cavity Performance<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">D3 Reports -> D3s (OP/CL)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">NCR Reports -> NCRs (OP/CL)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">NCR Reports -> NCRs BY ENGR<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Traveler Reports -> TRAVELERs (OP/CL)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Traveler Reports -> TRAVELER WEEKLY REPORT<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Traveler Reports -> TRAVELER WEEKLY OWNER<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif">We are making good progress, albeit a little slow. Finding resolutions to very old versions of code can be trying.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif">Thank You for your patience and support.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif"> <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif">Valerie<o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><img width="420" height="559" style="width:4.375in;height:5.825in" id="_x0000_i1025" src="cid:image001.png@01D60F4B.A3669060"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>