Global Versioning Package Load Error (Doc ID 2147701.1)

Last updated on JUNE 19, 2017

Applies to:

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

Symptoms

On : Insbridge 5.0.1 version, Framework Administrator IBFA

Global Versioning Package Load Error with Insbridge 5.0.1 HF13

When attempting to load global versioning packages (GVP), some packages received an error.
ERROR
-----------------------
General Information
*********************************************
Additional Info:
Insbridge.MachineName: DMI-WIN-RATED1
Insbridge.TimeStamp: 5/2/2016 2:04:10 PM
Insbridge.FullName: Insbridge.Net.Fwk, Version=4.5.0.0, Culture=neutral, PublicKeyToken=c471a996fbcb11ce
Insbridge.AppDomainName: /LM/W3SVC/1/ROOT/IBFA-2-131066728476531772
Insbridge.ThreadIdentity: admin
Insbridge.WindowsIdentity: MARIETTA\svc-insbridge
1) Exception Information
*********************************************
Exception Type: System.Exception
Message: System.Exception: An error has occurred while retrieving a resultset: Cannot Execute SQL DataReader Command: String or binary data would be truncated.
The statement has been terminated. ---> System.Exception: Cannot Execute SQL DataReader Command: String or binary data would be truncated.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)


at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Insbridge.Net.Fwk.DAO.FactoryDataAccess.DrProc(String connectionString, String command, Transaction transType, Object[,] cmdParams, Object[] procParams)
--- End of inner exception stack trace ---
at Insbridge.Net.Fwk.DAO.FactoryDataAccess.DrProc(String connectionString, String command, Transaction transType, Object[,] cmdParams, Object[] procParams)
at Insbridge.Net.Engine.dao.XDB.ExecuteRAWsp(ArrayList aParams, String SQL, Boolean disconnectedRS)
at Insbridge.Net.Engine.dao.XDB.ExecuteSP(ArrayList aParams, String SQL)
--- End of inner exception stack trace ---

at Insbridge.Net.Engine.load.SRP_Lib.LoadFullPackage(Int32 aLob, Int32 aProduct, Int32 aSubscriber, Int32 aProgId, Double aProgVer, Int32 aProgVerMinor, String aProgVerName, PackageTypes aPackageType, String aSummaryInfo, String aLoadSummaryInfo, String aPK, String aRelease, String aTARGETENVIRONMENT)
at Insbridge.Net.Engine.load.SRP.Load(Int32 aSUBSCRIBERID, String aTARGETENVIRONMENT, PackageTypes aPackageType, BuildTypes aBuildType, Int32 aLOBId, Int32 aProductId, Int32 aDataStoreId, Int32 aProgramId, Double aProgramVer, String aProgVerName, String aRelease, String aPK, String aRTO_FN, String aRTD_FN, String aXML_SUMMARY_INFO, String aXML_LOAD_SUMMARY_INFO)
Data: System.Collections.ListDictionaryInternal
TargetSite: NULL
HelpLink: NULL
Source: NULL
HResult: -2146233088


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load SRPs to IBFA.

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