DataReader.GetFieldType(59) Returned Null Error

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting > Reporting Errors >

DataReader.GetFieldType(59) Returned Null Error

Affected Software/Reports/DLL(s): Google Earth Location Report, VW_LOCATION, DT_GEOGRAPHY, and some graphic interfaces including GMS.

 

Affected Software Version: Professional

 

Symptoms: When running reports in EQuIS Professional, an error may be encountered that includes the following text with the exception message:

 

"DataReader.GetFieldType(59) returned null" or "DataReader.GetFieldType(2) returned null"

 

Cause/Details: The problem can occur because either the appropriate SQL Clr Data Type is not installed or is the wrong version. In older builds of EQuIS, this can occur when EQuIS Professional is installed via a .msi file rather than via the .exe via as instructed here.

 

Note: It is only necessary to apply the hotfix if you see the error noted above.

 

Resolution/Workaround: Download and install the Microsoft SQL Server 2014 Feature Pack item. This fix can be applied to workstations where Microsoft SQL Server and Microsoft SQL Server Management Studio have not been installed.

 

Download and Install 2014 SQLSysClrTypes.msi

 

1.Go to https://www.microsoft.com/en-us/download/details.aspx?id=42295

2.Click the Download button. At the Choose the download you want prompt, check ”ENU\x64\SQLSysClrTypes.msi” (in the middle of list). Click Next to download.

3.Save the install package to a known location on your computer.

4.After the download is complete, make sure to UNBLOCK the file using the instructions in this help article. After unblocking the file, execute it (will install SQL Server System CLR Types).

5.Follow instructions for the Microsoft Install Wizard.

 

When you have completed these steps, reopen EQuIS Professional. The error should be resolved.