Article - CS251104

Unique constraint violation exception on adding Named Calendar in Servigistics Field Service Management

Modified: 28-Nov-2016   


Applies To

  • Servigistics Field Service Management 11.1.5 to 11.1.7

Description

  • Not able to Create Named Calendar
  • Unique constraint violation exception occurred on adding new Named Calendar
  • WebUI shows below exception:
    • ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (SVGADM.SYS_C0014008283) violated
      ERROR com.svg.req - Could not execute JDBC batch update; SQL [ insert into SVC_CALENDARS (UpdateCnt, CreatedBy, CreatedDT, UpdatedBy, UpdatedDT, ID, DESCRIPTION, CalendarName, CALENDAR, CALENDAR2, CALENDAR3, CALENDAR4, EnterpriseID, PK) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [SVGADM.SYS_C0014008283]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
This is a printer-friendly version of Article 251104 and may be out of date. For the latest version click CS251104