Problem / Solution: Change records imported from ITSM 7 cannot be opened.  Error: "Error fetching riskSystem.InvalidOperationException: Nullable object must have a value"

Version 1

     

    Error message:

    Error fetching riskSystem.InvalidOperationException: Nullable object must have a value. at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) at SaaS.WebUI.RiskCalculator.RiskCalcController.GetObjectRiskSumandLevel(String objectRecId, ISessionContext context, RCResponse resp) at SaaS.WebUI.RiskCalculator.RiskCalcController.GetObjectRiskQuestions(String objectRecId, ISessionContext context)

    Problem:

    Change records migrated into ISM from ITSM 7.x generate the error above when opening them in the Change Object workspace.

     

    Cause:

    This was caused by unexpected data in the Change records related to the Risk Assessment.

     

    Solution / Workaround:

    For one customer that was not using Risk assessments, clearing the Risk related fields in the database resolved this error.  If the Risk data needs maintained you must find valid values for ISM in each Risk related field in the Change object.  These fields include (but are not necessarily limited to):

    -CalculatedRiskQuestions

    -RiskCatalogLink

    -RiskSum

    -RiskLevel

    -RiskLevel_valid

    -RiskTotalScore