To use IBM Cognos product documentation, you must enable JavaScript in your browser.

HRESULT= DB_E_CANTCONVERTVALUE Error When Filtering on a _make_timestamp Column

You cannot filter on a _make_timestamp column, and the following error messages appear:

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive

UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= DB_E_CANTCONVERTVALUE "

RSV-SRV-0025 Unable to execute this request

The solution is to apply the filter after aggregation and not before.