Hi,
I have a small number of tasks that are being completed and this completes the Request. Upon the Task being completed they are being met with the following exception.
The value for column 'contract_version' in table 'request' is DBNull.
The full message from the server logs are;
Message: Exception Message : The value for column 'contract_version' in table 'request' is DBNull.
Source : Not Available
Target Site : Not Available
Help Link : Not Available
Inner exception message : The value for column 'contract_version' in table 'request' is DBNull.
Inner exception source : Metrix.BusinessEntities
Inner exception target site : get_contract_version
Stack Trace :
Inner exception stack trace: at Metrix.BusinessEntities.requestRow.get_contract_version()
at Metrix.BusinessServer.BusinessPolicies.FieldServiceComponent.RequestManager.ChangeOrRemoveRequestChildrenContractCoverage(requestRow requestIn)
at Metrix.BusinessServer.BusinessPolicies.FieldServiceComponent.RequestPolicy.BeforeRowUpdate(MetrixDataRow rowIn)
at AW.BusinessServer.BusinessPolicies.FieldServiceComponent.AWRequestPolicy.BeforeRowUpdate(MetrixDataRow rowIn)
at Metrix.BusinessServer.BusinessPolicies.BusObjectPolicy.RouteBeforeRowUpdate(MetrixDataRow rowIn)
at Metrix.BusinessServer.BusinessPolicies.BusObjectPolicy.BeforeRowSave(MetrixDataRow rowIn)
at Metrix.BusinessServer.BusinessPolicies.FieldServiceComponent.RequestPolicy.BeforeRowSave(MetrixDataRow rowIn)
at Metrix.BusinessServer.BusinessPolicies.BusObjectPolicy.Update(MetrixDataTable tableIn)
We as a business don’t use Contracts, and no row in the request table has either contract_version or contract_sequence set.
Just wondering on the completion of the request what could be calling Metrix.BusinessEntities.requestRow.get_contract_version?
All other requests are completing just fine, just got a small number that are throwing this exception.
Also check there are no validation business rules in play here.
