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. Error message in import log "Constraint P41_PRM00.R_STAFF_UK_01 violated"

    Error message in import log "Constraint P41_PRM00.R_STAFF_UK_01 violated"

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Primo
    • Product Version: 4

    Problem Symptoms:
    The following error can be found in the import log file:
    (/exlibris/primo/p4_1/ng/primo/home/profile/publish/processes/ImportConfig/IMPORT_PROD_TO_SANDBOX/log)

    ==================
    Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (P41_PRM00.R_STAFF_UK_01) violated

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
    ... 40 more
    2014-02-28 12:24:26,714 ERROR [t-ImportConfig] [c-StopPrimoToolsExceptionHandler] - Error executing ImportConfig
    org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into R_STAFF (USERNAME, PASSWORD, ADDRESS, EMAIL, END_USER_ID, HOME_PHONE, MOBILE_PHONE, ORGANIZATIONAL_UNIT_ID, USER_ID, WORK_PHONE, customerid, institutionId, libraryId, CREATION_DATE, UPDATED_DATE, UPDATED_BY, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [P41_PRM00.R_STAFF_UK_01]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    =====================

    Cause:
    Unique constraint "R_STAFF_UK_01" is generated from username column in r_staff table.
    Identical staff usernames exists in the source and target environment.

    Resolution:
    1) Go to Primo Back office / On Going configurations / Staff Configurations screen
    2) Compare the source environment and the target environment to find the identical username
    3) Change the username in the target environment to something different

    Category: Primo

    Subject: Export & Import


    • Article last edited: 6/27/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Error in template alma bx, bX Recommender displays error page
      • Error message in pipe log "Content is not allowed in prolog"
    • 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. 4
      2. contype:kba
      3. Export & Import
      4. Primo
      5. Prod:Primo
      6. Type:General
    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