Unable To Import More Than 10K Rows Into A Table With A Field Criterion That Uses A Validation

(Doc ID 2372742.1)

Last updated on MARCH 12, 2018

Applies to:

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

Symptoms

On : 5.4.0.0.0 version, RateManager

When attempting to import more than 10,000 rows and a table varaible includes a field criterion that uses a validation.
the following error occurs.

ERROR
-----------------------
General Information
*********************************************
Additional Info:
Insbridge.MachineName: SLC13NZI
Insbridge.TimeStamp: 3/1/2018 8:50:15 AM
Insbridge.FullName: Insbridge.Net.Fwk, Version=4.5.0.0, Culture=neutral, PublicKeyToken=c471a996fbcb11ce
Insbridge.AppDomainName: /LM/W3SVC/1/ROOT/RM-2-131643926347713245
Insbridge.ThreadIdentity: 1708~5~C00F9C4F-6683-42E1-9B98-2076E8256595~rsa canada~847E6B53-BA7A-4F3F-BF14-4EFDED1E5AE1~Company~Administrator~~10.
Insbridge.WindowsIdentity: SLC13NZI\insbridge
1) Exception Information
*********************************************
Exception Type: System.Exception
Message: System.Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated. ---> System.Exception: Cannot Execute SQL Command: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated. ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
 
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
 
 
 
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Insbridge.Net.Fwk.DAO.DataAccess.NonQuery(String connectionString, String command, Transaction transType, List`1 queryParams, Object[] procParams)
--- End of inner exception stack trace ---
at Insbridge.Net.Fwk.DAO.DataAccess.NonQuery(String connectionString, String command, Transaction transType, List`1 queryParams, Object[] procParams)
at Insbridge.Net.RM.Includes.VariablesImportFile.Execute()
--- End of inner exception stack trace ---
at Insbridge.Net.RM.Includes.VariablesImportFile.Execute()
 
at Insbridge.Net.RM.ControllerRequest.Execute(HttpContext context, Boolean responseOutput)
at Insbridge.Net.RM.ControllerHandler.ProcessRequest(HttpContext context)
Data: System.Collections.ListDictionaryInternal
TargetSite: NULL
HelpLink: NULL
Source: NULL
HResult: -2146233088


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import 10,000 rows
2. Ensure the table variable includes a field criterion that uses a validation

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import 10,000 rows with table variable that includes a field criterion that uses a validation.

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