Code: Select all
<Exception Type="System.Exception" Message="
Error occurred while trying to load business object data. Type="TitleInsurancePremium", ID=b6452689-dd5f-e011-8ff0-0050568e002c
System.Exception: 
Error occurred while trying to load business object data. Type="Loan", ID=60462689-dd5f-e011-8ff0-0050568e002c
System.Exception: 
Error occurred while trying to load business object data. Type="HudLine200Section", ID=e5452689-dd5f-e011-8ff0-0050568e002c
System.Data.SqlClient.SqlException (0x80131904): @ID is not a parameter for procedure HudLineLoad.
 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()
 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
 at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
 at System.Data.SqlClient.SqlDataReader.get_MetaData()
 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
 at System.Data.SqlClient.SqlCommand.ExecuteReader()
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)

 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Core.HudLine.Load(Guid primaryID, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext, Boolean allowDisambiguation, SqlDataReader openReader, Boolean allowLoad, Boolean loadingAsCopy, Boolean acquiringRoot, Guid idForNewObject)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.LoadCalculatedChildObject(DataItemDescription itemDesc, Guid primaryKey)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.InternalLoad(Guid primaryID, ContextRoot rootContext, Dictionary`2 values, Byte[]& mergedIDs, Byte[]& userEnteredFlags, Boolean& foundIDs, StringBuilder& errors, Hashtable& nonBaseFieldsFound, Byte[]& sources, String& formulaData, String& customFields)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)

 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext, Boolean allowDisambiguation, SqlDataReader openReader, Boolean allowLoad, Boolean loadingAsCopy, Boolean acquiringRoot, Guid idForNewObject)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.LoadCalculatedChildObject(DataItemDescription itemDesc, Guid primaryKey)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.InternalLoad(Guid primaryID, ContextRoot rootContext, Dictionary`2 values, Byte[]& mergedIDs, Byte[]& userEnteredFlags, Boolean& foundIDs, StringBuilder& errors, Hashtable& nonBaseFieldsFound, Byte[]& sources, String& formulaData, String& customFields)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)
System.Exception: 
Error occurred while trying to load business object data. Type="Loan", ID=60462689-dd5f-e011-8ff0-0050568e002c
System.Exception: 
Error occurred while trying to load business object data. Type="HudLine200Section", ID=e5452689-dd5f-e011-8ff0-0050568e002c
System.Data.SqlClient.SqlException (0x80131904): @ID is not a parameter for procedure HudLineLoad.
 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()
 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
 at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
 at System.Data.SqlClient.SqlDataReader.get_MetaData()
 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
 at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
 at System.Data.SqlClient.SqlCommand.ExecuteReader()
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)

 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Core.HudLine.Load(Guid primaryID, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext, Boolean allowDisambiguation, SqlDataReader openReader, Boolean allowLoad, Boolean loadingAsCopy, Boolean acquiringRoot, Guid idForNewObject)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.LoadCalculatedChildObject(DataItemDescription itemDesc, Guid primaryKey)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.InternalLoad(Guid primaryID, ContextRoot rootContext, Dictionary`2 values, Byte[]& mergedIDs, Byte[]& userEnteredFlags, Boolean& foundIDs, StringBuilder& errors, Hashtable& nonBaseFieldsFound, Byte[]& sources, String& formulaData, String& customFields)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)

 at SoftPro.BusinessObjects.Base.BusinessObjectBase.Load(Guid primaryID, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext, Boolean allowDisambiguation, SqlDataReader openReader, Boolean allowLoad, Boolean loadingAsCopy, Boolean acquiringRoot, Guid idForNewObject)
 at SoftPro.BusinessObjects.Base.BusinessObjectCache.GetBusinessObject(String contextName, Guid primaryKey, ContextRoot rootContext)
 at SoftPro.BusinessObjects.Base.BusinessObjectBase.InternalLoad(Guid primaryID, ContextRoot rootContext, Dictionary`2 values, Byte[]& mergedIDs, Byte[]& userEnteredFlags, Boolean& foundIDs, StringBuilder& errors, Hashtable& nonBaseFieldsFound, Byte[]& sources, String& formulaData, String& customFields)
">
<StackTrace>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectBase" Name="Load">
<Arguments>
<Argument Type="Guid" Name="primaryID" />
<Argument Type="ContextRoot" Name="rootContext" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="GetBusinessObject">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="ContextRoot" Name="rootContext" />
<Argument Type="Boolean" Name="allowDisambiguation" />
<Argument Type="SqlDataReader" Name="openReader" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="GetCollectionBusinessObject">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="ContextRoot" Name="rootContext" />
<Argument Type="Boolean" Name="allowDisambiguation" />
<Argument Type="SqlDataReader" Name="openReader" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCollectionBase" Name="GetNewChildFromGuid">
<Arguments>
<Argument Type="GuidObjectPair" Name="childID" />
<Argument Type="ContextRoot" Name="root" />
<Argument Type="SqlDataReader" Name="openReader" />
<Argument Type="Boolean" Name="allowLoad" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCollectionBase" Name="CreateChildrenFromGuidList">
<Arguments>
<Argument Type="GuidObjectPair[]" Name="childIDs" />
<Argument Type="SqlDataReader" Name="openReader" />
<Argument Type="Boolean" Name="allowLoad" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCollectionBase" Name="LoadIndividual">
<Arguments>
<Argument Type="" Name="" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCollectionBase" Name="Load">
<Arguments>
<Argument Type="" Name="" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectBase" Name="LoadChildCollections">
<Arguments>
<Argument Type="" Name="" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectBase" Name="Load">
<Arguments>
<Argument Type="Guid" Name="primaryID" />
<Argument Type="ContextRoot" Name="rootContext" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="GetBusinessObject">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="ContextRoot" Name="rootContext" />
<Argument Type="Boolean" Name="allowDisambiguation" />
<Argument Type="SqlDataReader" Name="openReader" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="GetBusinessObject">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="ContextRoot" Name="rootContext" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.SingleObjectContainerMatchingIDs" Name="Load">
<Arguments>
<Argument Type="Guid" Name="owningID" />
<Argument Type="ContextRoot" Name="rootContext" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectBase" Name="LoadChildCollections">
<Arguments>
<Argument Type="" Name="" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectBase" Name="Load">
<Arguments>
<Argument Type="Guid" Name="primaryID" />
<Argument Type="ContextRoot" Name="rootContext" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Core.Order" Name="Load">
<Arguments>
<Argument Type="Guid" Name="primaryID" />
<Argument Type="ContextRoot" Name="rootContext" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="GetBusinessObject">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="ContextRoot" Name="rootContext" />
<Argument Type="Boolean" Name="allowDisambiguation" />
<Argument Type="SqlDataReader" Name="openReader" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="GetRootObject">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="ContextRoot" Name="rootContext" />
<Argument Type="Boolean" Name="loadingAsCopy" />
</Arguments>
</Method>
<Method Namespace="SoftPro.BusinessObjects.Base.BusinessObjectCache" Name="AcquireRootReference">
<Arguments>
<Argument Type="String" Name="contextName" />
<Argument Type="Guid" Name="primaryKey" />
<Argument Type="Boolean" Name="loadAsCopy" />
</Arguments>
</Method>
<Method Namespace="SoftPro.OrderTracking.Client.OrderTracking" Name="OpenOrderObject">
<Arguments>
<Argument Type="Guid" Name="id" />
</Arguments>
</Method>
<Method Namespace="SoftPro.OrderTracking.Client.OrderTracking" Name="OpenOrder">
<Arguments>
<Argument Type="Guid" Name="id" />
<Argument Type="Boolean" Name="readOnly" />
</Arguments>
</Method>
<Method Namespace="SoftPro.OrderTracking.Client.OrderTracking" Name="GetOrderOrTemplate">
<Arguments>
<Argument Type="OrderQuerySpec" Name="spec" />
<Argument Type="Boolean" Name="readOnly" />
</Arguments>
</Method>
<Method Namespace="SoftPro.OrderTracking.Client.OrderTracking" Name="GetOrder">
<Arguments>
<Argument Type="OrderQuerySpec" Name="spec" />
<Argument Type="Boolean" Name="readOnly" />
</Arguments>
</Method>
<Method Namespace="TG.SoftPro.OrderLookup.SoftProOrder" Name="LoadOrder">
<Arguments>
<Argument Type="String" Name="orderNumber" />
<Argument Type="Boolean" Name="isReadOnly" />
</Arguments>
</Method>
</StackTrace>
</Exception>
Note: I found a bug in one of your other stored procedures: HudLine1200SectionLoad. This stored procedure also calls: HudLineLoad, but with two parameters: