Getting an Exception Error When Saving Report Types in Argus Console in Argus Safety 6.0.2 release (Doc ID 1354067.1)

Last updated on SEPTEMBER 02, 2014

Applies to:

Oracle Argus Safety - Version: 6.0.2 and later   [Release: 6.0 and later ]
Information in this document applies to any platform.

Symptoms

Getting the following error when adding a new report type in the Argus Console -> Codelist -> Report Type and saving it:

"Following exception has occurred:
    Database error has occurred. Please contact your system administrator."

Steps to Repeat:
1. Log into Argus Safety
2. Go to Argus Console -> Codelist -> Report Type
3. Click on Add New button
4. Enter data in required fields (Report Type and Abbreviation)
5. Click on Save
6. Observe that system throws an exception error
7. It is writing the following error in the error log:
  "Argus Console - 31-Aug-2011 9:14:16 AM EXC000~/Argus Console/CodeList/ReportType.aspxpid=45&CodeListType=Argus&IsLocalized=1&LanguageSupported=3System.Exception: EXC000 ---> System.Data.OracleClient.OracleException: ORA-01400: cannot insert NULL into ("ARGUS_APP"."LM_REPORT_TYPE"."INCL_RESEARCH")ORA-06512: at "ARGUS_APP.PKG_CNSL_CL_REPORT_TYPE", line 128ORA-06512: at line 1   at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)   at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)   at Relsys.Common.OracleHelper.OraHelper.UpdateDataset(OracleCommand insertCommand, OracleCommand deleteCommand, OracleCommand updateCommand, DataSet dataSet, String tableName, Boolean acceptchanges)   at Relsys.Common.OracleHelper.OraHelper.UpdateDataset(OracleTransaction transaction, OracleCommand insertCommand, OracleCommand deleteCommand, OracleCommand updateCommand, DataSet dataSet, String tableName)   at Relsys.Common.OracleHelper.OraHelper.UpdateDataset(OracleTransaction transaction, OracleCommand[] oraCommand, DataSet dataSet, String tableName)   at Relsys.ArgusConsole.DAL.BizObjects.Entities.CodeList.ReportType.Save()   --- End of inner exception stack trace ---   at Relsys.Common.ExceptionLogger.Logger.HandleAllException(Exception ex)   at Relsys.ArgusConsole.DAL.BizObjects.Entities.CodeList.ReportType.Save()   at Relsys.ArgusConsole.ConsoleWebUI.CodeList.CodeListPage.OnSave()   at Relsys.ArgusConsole.ConsoleWebUI.CodeList.CodeListPage.SaveHandler(Object sender, EventArgs e)"

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