I assigned reviews to my reviewers in Blackbaud Grantmaking (GIFTS Online), but when the reviewer opens the review, several of the fields appear to show error messages in the text fields. The error message only appears in text fields and looks like this:
System.InvalidCastException: Specified cast is not valid.
at MicroEdge.Gifts.Search.Engine.Calculators.TextFileCalculator.CalculateResult(SearchResultBuilder resultBuilder, IViewColumn viewColumn)
at MicroEdge.Gifts.Search.Engine.Calculators.CalculatorBase.CalculateResultSafely(SearchResultBuilder resultBuilder, IViewColumn viewColumn)
How can I resolve this?
This error Is most commonly seen in new Blackbaud Grantmaking (GIFTS Online) clients who have converted from an ORACLE installation to Blackbaud Grantmaking. The error seen is caused by an issue with data types on the database.