[Pansophy] P.R. 1004 Serial Numbers

[Mike Dickey]

Hi Val,

I'm getting an error while trying to update serial numbers for John Fischer.


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')
ORA-00001: unique constraint (ADAPPS.UC_IDNAME) violated
ORA-06512: at line 1

https://docs.oracle.com/error-help/db/ora-00001/

One error saving changes to table "ADAPPS"."TRAVELER_CM_CAV":
Row 90: ORA-00001: unique constraint (ADAPPS.UC_IDNAME) violated
ORA-06512: at line 1

https://docs.oracle.com/error-help/db/ora-00001/

>From Constraints:
UC_IDNAME
Unique





ENABLED
NOT DEFERRABLE
VALIDATED
USER NAME


06-OCT-22
ADAPPS
UC_IDNAME



Data to be Inserted:
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-087   CPI-LWP-087
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-088   CPI-LWP-088
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-089   CPI-LWP-089
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-090   CPI-LWP-090
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-095   CPI-LWP-095
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-096   CPI-LWP-096
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-097   CPI-LWP-097
L2RBFPCWSN    MDICKEY  10-JUL-25               341081   FPC WARM PART -         L2RB FPCWSN   CPI-LWP-098   CPI-LWP-098

This has not happened before.

Mike Dickey
SRF Inventory Technician
Jefferson Lab
12000 Jefferson Ave
Newport News, VA 23606
(757) 269-7755

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20250710/191f674b/attachment-0001.htm>