Skip to main content
Solved

Selecting all rows gives UnhandledException error

  • May 21, 2026
  • 1 reply
  • 21 views

Mark Leunissen
Hero
Forum|alt.badge.img+4

Hi,

 

I am running into an issue with a task when selecting the all rows for a task.

The following error occurs:

System.InvalidCastException: Failed to convert parameter value from a DateTimeOffset to a DateTime.
 ---> System.InvalidCastException: Object must implement IConvertible.
   at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
   at Microsoft.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming)

The error specifically occurs when using the all rows. When I go through all the 200 rows 50 by 50, no error occurs. 

 

 

I do not understand why this error is occuring and how to solve this issue. 

 

Kind regards

Mark Leunissen

Best answer by Erwin Ekkel

There was a fix recently to prevent this problem. Please upgrade the indicum and universal to the latest version and try again. Since you also reported this as a ticket I will close this topic. 

1 reply

There was a fix recently to prevent this problem. Please upgrade the indicum and universal to the latest version and try again. Since you also reported this as a ticket I will close this topic.