Remedy - Server - Saving a form in DevStudio the error: "ORA-00001: unique constraint (xxxxx) violated" is displayed

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System


    APPLIES TO:

    Remedy AR System Server v9.1.x



    PROBLEM:

     

    When trying to save a form in DevStudio the following error is observed

      

    ...................
    com.bmc.arsys.domain.etc.
    ARException: ERROR (552): Failure during SQL operation to the database ; org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: java.sql.SQLIntegrityConstraintViolationException:
    ORA-00001: unique constraint (ARADMIN.SYS_C0010370) violated
    Error Code: 1
    Call:
    INSERT INTO field (fieldId, schemaId, overlayGroup, changeDiary, createMode, defaultValue, fbOption, fieldType, fOption, helpText, lastChanged, fieldName, objProp, overlayProp, owner, recordId, resolvedfieldId, resolvedName, smObjProp, timestamp, datatype) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        bind => [21 parameters bound]
    Query: InsertObjectQuery(name=Date/Time Field__c, overlayGroup=1, overlayProp=4); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: java.sql.SQLIntegrityConstraintViolationException:
    ORA-00001: unique constraint (ARADMIN.SYS_C0010370) violated

      

    Error Code: 1
    Call:
    INSERT INTO field (fieldId, schemaId, overlayGroup, changeDiary, createMode, defaultValue, fbOption, fieldType, fOption, helpText, lastChanged, fieldName, objProp, overlayProp, owner, recordId, resolvedfieldId, resolvedName, smObjProp, timestamp, datatype) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        bind => [21 parameters bound]
    Query: InsertObjectQuery(name=Date/Time Field__c, overlayGroup=1, overlayProp=4)
    ...................

      

     

     


    CAUSE:

    Unique constraint violation on column when saving form.


    SOLUTION:

    The error(s) is(are) indicating the records saved based on "ARADMIN.SYS_C0010370" is having duplicate value, which is conflicting with the unique constraint of this column.
    The field added in question in this scenario is "name=Date/Time Field__c".

    - Remove this field "name=Date/Time Field__c" from the form and then save the form again.
    - After removing the field, the form can be saved successfully.


    Article Number:

    000122935


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles