Drill down on the report "How current is my inventory" fails.

Products

• Inventory Solution
• Client Management Suite
• IT Management Suite

Issue/Introduction

When looking at the drill down report in "How current is my inventory" it fails to load:

• An error occurred on the page. Please check the log for more details.
• Failure running this Report. Please check the configuration of the query.
• Conversion failed when converting date and/or time from character string.
• An unexpected SQL error occurred when running the RawSqlDataSource: 'Drill down to How current is my computer Inventory' (480738d1-8d00-4bb8-9942-438a86db0913)
• A failed attempt was made to run the DataSource: 'Drill down to How current is my computer Inventory' (480738d1-8d00-4bb8-9942-438a86db0913)

Environment

ITMS 8.x

Cause

The SQL used for that drill-down is comparing two data types that are not comparable - a character string and a date.

Resolution

This was resolved in a later version and the short term workaround was the following SQL Query that can be run from SQL Management Studio:

update Item
set State = REPLACE (cast (State as nvarchar (max)), 'ELSE rus.[ModifiedDate] END', 'ELSE cast (rus.[ModifiedDate] as nvarchar (110)) END')
where Guid = '480738d1-8d00-4bb8-9942-438a86db0913'