EM 13C: Scheduling BIP Report Jobs Giving Error "ORA-00001: Unique Constraint (SYSMAN_BIPLATFORM.SYS_C0050940) violated"
(Doc ID 2877338.1)
Last updated on JULY 13, 2022
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Scheduling BIP Report Job Giving Error as below :
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYSMAN_BIPLATFORM.SYS_C0050940) violated
From bipublisher.log
[2022-02-10T19:15:06.322+00:00] [BIP] [WARNING] [] [oracle.xdo] [tid: 190] [userId: weblogic] [ecid: 7ff3cc4f-ccfb-465a-a06a-71787e5a6cb1-0000000a,0:5132] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] !!!!!!! QuartzJob.execute :: SchedulerJob.execute throws exception:Failed to insert job instance. Insert job failed. [JOB_ID=-1][[
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYSMAN_BIPLATFORM.SYS_C0050940) violated
Error Code: 1
Call: INSERT INTO XMLP_SCHED_JOB (JOB_ID, BURSTING, BURSTING_PARAMETERS, CREATED, DATA_LOCATOR, DELETED, DELIVERY_DESCRIPTION, DELIVERY_PARAMETERS, END_DATE, INSTANCE_ID, ISSUER, JOB_GROUP, JOB_SET_ID, JOB_TYPE, LAST_UPDATED, NOTIFICATION_PARAMETERS, OWNER, PARENT_JOB_ID, REPORT_PARAMETERS, REPORT_URL, RUN_TYPE, SCHEDULE_CONTEXT, SCHEDULE_DESCRIPTION, SCHEDULE_PARAMETERS, SCHEDULE_SOURCE, SHARED_OPTION, START_DATE, STATUS, STATUS_DETAIL, STORAGE_TYPE, USER_DESCRIPTION, USER_JOB_NAME, XML_DATA_AVAILABLE, XML_DATA_COMPRESSED, XML_DATA_CONTENT_TYPE, XSCHURL) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [36 parameters bound]
Query: InsertObjectQuery(oracle.xdo.servlet.scheduler.toplink.XmlpSchedJob@236c7c3b):
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SYSMAN_BIPLATFORM.SYS_C0050940) violated
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |