My Oracle Support Banner

OTAC/TEE: Agent Error: "Oracle Error code: 1, message: ORA-00001: unique constraint violated at OCI call OCIStmtExecute..." (Doc ID 2647999.1)

Last updated on MARCH 11, 2022

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 20A and later
Information in this document applies to any platform.

Symptoms

Error Information:

While attempting to save an agent after creating a new agent or saving changes to an existing agent in Oracle Business Intelligence (OBI), the below error pops up:

The following error occurred: Oracle BI Scheduler Error: [nQSError: 17011] SQL statement execution failed. [nQSError: 17001] Oracle Error code: 1, message: ORA-00001: unique constraint (PR20R12_BIPLATFORM.S_NQ_JOB_P1) violated at OCI call OCIStmtExecute: INSERT INTO S_NQ_JOB (JOB_ID, NAME, DESC_TEXT, SCRIPT_TYPE, SCRIPT, MAX_RUNTIME_MS, USER_ID, NEXT_RUNTIME_TS, LAST_RUNTIME_TS, MAX_CNCURRENT_INST, BEGIN_YEAR, BEGIN_MONTH, BEGIN_DAY, END_YEAR, END_MONTH, END_DAY, START_HOUR, START_MINUTE, END_HOUR, END_MINUTE, INTERVAL_MINUTE, TRIGGER_TYPE, TRIGGER_DAY_INT, TRIGGER_WEEK_INT, TRIGGER_RANGE_DOW, TRIGGER_RANGE_DOM, TRIGGER_RANGE_MTH, TRIG_RANGE_DAY_OCC, DELETE_DONE_FLG, DISABLE_FLG, HAS_END_DT_FLG, EXEC_WHEN_MISS_FLG, DEL_SCPT_DONE_FLG, PATH_IN_SCPT_FLG, ISUSER_SCPT_FLG, DELETE_FLG, TZ_NAME) VALUES ('xxxx'). [nQSError: 68021] Message from Oracle BI Scheduler.

 

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.