How do I fix the exception thrown: System.Data.SqlTypes.SqlNullValueException: Data is Null.

This method or property cannot be called on Null values. This error occurs when a Custodian is created in Turbo Import and no imports are performed/assigned to that Custodian.

Creating the Custodian creates an entry in the dbo.tblCustodians table in SQL where it shows a “Null” Value under the Description column.

Data Is Null_Image 1

 

When the Error above occurs:

  1. Suspend the case.

  2. Go to the case in SQL.

  3. Expand Tables.

  4. Right-click on dbo.tblCustodians.

  5. Select top 1000 rows.

  6. Delete the Custodian with the Null description.

  7. Then, go back to the case.

  8. Activate Case and the case should be able to move forward.

 

 

 

 

 

Published by: John Hartman