Central Coding Get Job Error: ORA-00001: Unique Constraint (DBAV503002.CONTEXTID_PK) Violated (Doc ID 2240300.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Health Sciences Central Coding - Version 1.0.0 and later
Information in this document applies to any platform.

Symptoms

Central Coding Get Job failing continuously with the below error

Error From CC UI:

To prevent out-of-sync verbatim and query data, the ExchangeQueryUpdates job will not be run. Please resolve the following error first: Source:Central Coding. Job failed with the following error: An exception has been thrown calling the web method: GetCodingData at url: http://<servername>/informadapter/coding/coding.asmx Exception Message: Server was unable to process request. ---> ExecuteNonQuery() Failed. Internal Exception : Oracle.DataAccess.Client.OracleException ORA-00001: unique constraint (<Trial_Schema_User>.CONTEXTID_PK) violated at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at PhaseForward.Platform.Storage.Providers.CommandProxy.ExecuteNonQuery() in E:\ICEPlatform\AppServer\Storage\Providers\CommandProxy.cs:line 59 at PhaseForward.Platform.Storage.DBProvider.ExecuteNonQuery(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 921. DB Command Text : insert into PFEX_VERBATIMCACHE (tdetargetsetid, tdetargetid, keyid, entereddate, formsetindex, pageindex, setitemorder, strvalue, isstate, contextid, formrevisionnumber, auditorder, controlid, controlvalueid, parentcontrolvalueid, datatype, formsetid, formid, sectionid, itemid, itemsetid, xmlid) select 13075, 13089, cd.keyid, cd.ENTEREDDATE, cd.FORMSETINDEX, cd.PAGEINDEX, cd.SETITEMORDER, cd.STRVALUE, nvl(ic.STATE,0) ISSTATE, cd.CONTEXTID, cd.FORMREVISIONNUMBER, cd.AUDITORDER, cd.controlid, cd.controlvalueid, cd. parentcontrolvalueid, cd.datatype, cd.formsetid, cd.formid, cd.sectionid, cd.itemid, cd.itemsetid, cd.auditorder from PFEX_CDTEMP1610685937 cd, pf_itemcontext ic where cd.AUDITORDER = (select /*+ use_nl(id) ordered */ max(id.AUDITORDER) from PFEX_CDTEMP1610685937 x, pf_itemdata id where id.CONTEXTID = cd.CONTEXTID and id.AUDITORDER <= :maxAuditOrder AND id.CONTEXTID = x.CONTEXTID) and cd.KEYID = ic.SUBJECTKEYID (+) and cd.FORMSETID = ic.CHAPTERID (+) and cd.FORMSETINDEX = ic.CHAPTERINDEX (+) and cd.FORMID = ic.PAGEID (+) and cd.PAGEINDEX = ic.PAGEINDEX (+) and cd.SECTIONID = ic.SECTIONID (+) and cd.ITEMSETID = ic.ITEMID (+) and cd.SETITEMORDER = ic.SETITEMORDER (+) and cd.AUDITORDER <= :maxAuditOrder order by cd.auditorder.

 

Changes

 The study was moved from InForm Adapter 1.3 SP5 to 1.3.7.3 and back to 1.3 SP5 after some issues with the migration.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms