My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.