Converting data types issues

[gbissio]

Hi Team, I'm getting the following issues:

Report: Daily Performance Trend Issue: An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset 'PerfCtr'. (rsErrorReadingNextDataRow) Error converting data type varchar to float.

Report: Daily_Performance_Workload_Trend Issue: An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset 'PerfCtr'. (rsErrorReadingNextDataRow) Error converting data type varchar to float.

Report: SQL Memory Utilization Report

Issue: An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset 'MemoryUtil'. (rsErrorReadingNextDataRow) Error converting data type varchar to float.

All queries are using the same table PerformanceCounter and the column countervalue was built with varchar(250). Can you please help me to review this? I tried changing the column data type but I got an issue within collection job execution.

Thanks!