You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Access It! Universal.NET > Error - Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.
Error - Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.
print icon

Symptoms

Within Access It! Universal.NET, an error message is raised stating "Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'."

Cause

This is caused in older versions by editing a cardholder and cutting the image out, resulting in a Null value in the Images table. When the "View Cardholder" option is selected in the Events Feed, and a cardholder with a Null value in the Images table is displayed, this error will occur.

Resolution

Using the Database Configuration Utility or SQL Server Management Studio, take a backup of the AIUniversal database.

Once the backup is complete, run the following script:

USE AIUNIVERSAL DELETE FROM IMAGES WHERE IMAGEDATA IS NULL


scroll to top icon