<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)">
<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:Aptos;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Consolas;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">Hello again,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">Okay, I figured out why. The data was entered by ADAPPS on 23-JUN-25. Would this mean that someone actually used a “DISA” traveler? So anyway, I’ll just close the PR and be done with
it.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-family:Consolas;color:black;mso-ligatures:none">Mike Dickey<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:black;mso-ligatures:none">SRF Inventory Technician<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:black;mso-ligatures:none">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-family:Consolas;mso-ligatures:none"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><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;mso-ligatures:none">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;mso-ligatures:none"> Pansophy <pansophy-bounces@jlab.org>
<b>On Behalf Of </b>Mike Dickey via Pansophy<br>
<b>Sent:</b> Thursday, July 10, 2025 7:47 AM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Cc:</b> pansophy <pansophy@jlab.org><br>
<b>Subject:</b> [Pansophy] P.R. 1004 Serial Numbers<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">Hi Val,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">I’m getting an error while trying to update serial numbers for John Fischer.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">INSERT INTO "ADAPPS"."TRAVELER_CM_CAV" (ID_TYPE, MOD_USER, MOD_DATE, PART_NUMBER, PART_NAME, PARTREV, PROJECT, ACRONYM, SERIALNUMBER, ID_NAME) VALUES ('L2RBFPCWSN', 'MDICKEY', TO_DATE('2025-07-10
07:12:39', 'YYYY-MM-DD HH24:MI:SS'), '341081', 'FPC WARM PART', '-', 'L2RB', 'FPCWSN', 'CPI-LWP-087', 'CPI-LWP-087')<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">ORA-00001: unique constraint (ADAPPS.UC_IDNAME) violated<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">ORA-06512: at line 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><a href="https://docs.oracle.com/error-help/db/ora-00001/">https://docs.oracle.com/error-help/db/ora-00001/</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">One error saving changes to table "ADAPPS"."TRAVELER_CM_CAV":<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">Row 90: ORA-00001: unique constraint (ADAPPS.UC_IDNAME) violated<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">ORA-06512: at line 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><a href="https://docs.oracle.com/error-help/db/ora-00001/">https://docs.oracle.com/error-help/db/ora-00001/</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">From Constraints:<o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="107" valign="top" style="width:80.1pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">UC_IDNAME<o:p></o:p></span></p>
</td>
<td width="76" valign="top" style="width:57.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">Unique<o:p></o:p></span></p>
</td>
<td width="35" valign="top" style="width:25.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="35" valign="top" style="width:25.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="35" valign="top" style="width:25.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="35" valign="top" style="width:25.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="35" valign="top" style="width:25.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="86" valign="top" style="width:64.7pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">ENABLED<o:p></o:p></span></p>
</td>
<td width="223" valign="top" style="width:167.55pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">NOT DEFERRABLE<o:p></o:p></span></p>
</td>
<td width="108" valign="top" style="width:81.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">VALIDATED<o:p></o:p></span></p>
</td>
<td width="108" valign="top" style="width:81.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">USER NAME<o:p></o:p></span></p>
</td>
<td width="18" valign="top" style="width:13.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="18" valign="top" style="width:13.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="108" valign="top" style="width:81.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">06-OCT-22<o:p></o:p></span></p>
</td>
<td width="78" valign="top" style="width:58.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">ADAPPS<o:p></o:p></span></p>
</td>
<td width="108" valign="top" style="width:81.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">UC_IDNAME<o:p></o:p></span></p>
</td>
<td width="60" valign="top" style="width:45.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
<td width="66" valign="top" style="width:49.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">Data to be Inserted:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-087 CPI-LWP-087
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-088 CPI-LWP-088
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-089 CPI-LWP-089
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-090 CPI-LWP-090
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-095 CPI-LWP-095
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-096 CPI-LWP-096
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-097 CPI-LWP-097
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">L2RBFPCWSN MDICKEY 10-JUL-25 341081 FPC WARM PART - L2RB FPCWSN CPI-LWP-098 CPI-LWP-098
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas">This has not happened before.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:black;mso-ligatures:none">Mike Dickey<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:black;mso-ligatures:none">SRF Inventory Technician<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas;color:black;mso-ligatures:none">Jefferson Lab<br>
12000 Jefferson Ave<br>
Newport News, VA 23606<br>
(757) 269-7755</span><span style="font-family:Consolas;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>