Impact Analysis Scenario Report That Uses Large Batch Files Fails (Doc ID 2060800.1)

Last updated on SEPTEMBER 28, 2015

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 4.7.3 and later
Information in this document applies to any platform.

Symptoms

On : Insbridge 4.7.3 version, RateManager

ACTUAL BEHAVIOR
---------------
Impact analysis scenario report that uses large batch files fails

Error message in IBFA logs:

Additional Info:
Insbridge.MachineName: WBWPRAT01
Insbridge.TimeStamp: 7/20/2015 4:09:19 PM
Insbridge.FullName: Microsoft.ApplicationBlocks.ExceptionManagement, Version=2.0.0.0, Culture=neutral, PublicKeyToken=c471a996fbcb11ce
Insbridge.AppDomainName: messageservice.exe
Insbridge.ThreadIdentity:
Insbridge.WindowsIdentity: WBMI\InsBridgeProd
1) Exception Information
*********************************************
Exception Type: System.Exception
Message: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_IA_COMP_FILES'. Cannot insert duplicate key in object 'dbo.IA_COMP_FILES'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Insbridge.Net.Batch.PM.Manager.ProcessResultForDB(Object state)

Data: System.Collections.ListDictionaryInternal
TargetSite: NULL
HelpLink: NULL
Source: NULL


EXPECTED BEHAVIOR
-----------------------
Scenario report should send results.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run a scenario report

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