Report Migration Tool - Explicit conversion of datetime2 float is not allowed.

Hello,

This is a known issue which we are working on improving. Could you open a support case and share the number with me?

Thank you tony.johnson .  00702547 was opened on 1/4 as a medium priority.

I was able to recreate the majority of the data I needed with one exception, there seems to no longer be a Peak Percent Utilization field under the Interface History category, there is an Average utilization which is a piece of the puzzle for me.  

What I attempted to do is take the Peak BPS/Bandwidth*400 to get a utilization percentage from there.  This would be a real useful field since I peak is already defined under alerts.

Hi, I am currently facing the same issues with quite a few reports that failed to migrate over. And rather than rebuilding the reports from scratch, I know that there should be a simpler solution of modifying the line in the SQL formatting. Similar to the thread starter, SQL is foreign to me. The error I am getting is 044 ERROR - Error while migrating report: Explicit conversion from data type datetime2 to float is not allowed. Below is the Date/Time portion of the SQL formatting that I am seeing.

Convert(DateTime,Floor(Cast((DateTime) as Float)*24)/24,0) AS SummaryDateTime

FROM
(Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId)) INNER JOIN APM_CPUAndMemoryUsage ON (APM_AlertsAndReportsData.ComponentId = APM_CPUAndMemoryUsage.ComponentId)

WHERE
( DateTime BETWEEN DateAdd(DD,-1,GETDATE() )and GETDATE() )
AND
(
(Nodes.Database_Type = 1)
)

GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)*24)/24,0),
Nodes.Caption, APM_AlertsAndReportsData.ComponentName

ORDER BY 1 ASC ,SummaryDateTime ASC