Database Connection Error: '07009:[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index' when running a Crystal report

Version 3

    Environment:

    Service Desk - All versions

    Crystal Reports - All Versions

     

    Error message:

     

    When running a Crystal report you receive the following error:  Database Connection Error: '07009:[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index'

     

    Cause:

     

    This can be caused when the report uses database views and the columns in the view have had their data types changed e.g the underlying table the view is based on has a description field that was varchar(2000) and is now nvarchar(max).  This is sometimes an issue after upgrading Service Desk as the upgrade process occasionally modifies existing fields to use different data types.

     

    Solution:

     

    Within SQL Server Management Studio, Locate the view, right click and select 'Script View as' --> ALTER To --> New Query Window.  Execute the query.

    Within Crystal Reports, Select the 'Database Menu' and then select Verify Database.  Click OK and then save the report.

     

    The report should now run without errors.