My Oracle Support Banner

Unable to Add Dosage Unit to Codelist DOSE_UNITS in Argus Console - Column 'UNIT_ID' is constrained to be unique. Value 'xxxx' is already present. (Doc ID 3041946.1)

Last updated on AUGUST 18, 2024

Applies to:

Oracle Life Sciences Argus Safety - Version 8.2.3.1 and later
Information in this document applies to any platform.

Symptoms

 While adding a new dosage unit to the DOSE_UNITS Codelist via Argus Console getting the below error message:

"Argus Console - 13-08-2024 16:15:43 Column 'UNIT_ID' is constrained to be unique. Value '100025' is already present.

/Argus Console/CodeList/DosageUnit.aspx
pid=34&CodeListType=Argus&IsLocalized=1&LanguageSupported=3&OCATOK=2054980726
System.Data.ConstraintException: Column 'UNIT_ID' is constrained to be unique. Value '100025' is already present.
at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataRow.EndEdit()
at System.Data.DataRow.set_Item(DataColumn column, Object value)
at Relsys.ArgusConsole.DAL.DataObjects.TypeDataSets.CodeList.DosageUnitDS.LM_DOSE_UNITSRow.set_UNIT_ID(Decimal value)
at Relsys.ArgusConsole.DAL.BizObjects.Operations.CodeList.DosageUnit.ValidateOnSave(Decimal itemId, Int32& errorCode, String& errorMessage)
at Relsys.ArgusConsole.ConsoleWebUI.CodeList.CodeListPage.OnBeforeSave()
at Relsys.ArgusConsole.ConsoleWebUI.CodeList.CodeListPage.SaveHandler(Object sender, EventArgs e)
PEWEB02DC

 

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.