Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Primo

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Primo
    3. Knowledge Articles
    4. Can't update/create Code Table due to sql error of duplication

    Can't update/create Code Table due to sql error of duplication

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution
    • Product: Primo
    • Product Version: All
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local

     

    Description

    When adding new, or updating, a Code Table Row, an SQL error occur:

     

    Unknown operation was requested - Could not execute JDBC batch update; SQL [insert into C_C_CODE_TABLES (AUTOMATIC_UPDATE, TABLE_OF_TABLE_ID, CODE_TABLE_NAME, LANG, CODE, description, color, DISPLAY_ORDER, DEFAULT_VALUE, icon, ENABLED, customerid, institutionId, libraryId, CREATION_DATE, UPDATED_DATE, UPDATED_BY, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [P41_PRM00.C_C_CODE_TABLES_UK_01]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update  

     

    Resolution

    1. Go to relevant code table page
    2. Filter the results by the Code and Language columns (not by the Description column), 
    3. See there is already a row with this combination of Code and Language.
    4. You can either edit it or delete it, and enter a new one.

    • Article last edited: 16-Jan-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Can't find some records by call number browse search
      • Can’t find/retrieve local records
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Primo
    2. Tags
      1. Oracle
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved