When looking at the drill down report in "How current is my inventory" it fails to load.
8.0 and 8.1
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)
The SQL used for that drill down is comparing two data types that are not comparable. A character string and a Date.
This will be resolved in a future version, however, for the short term the following SQL Query can be run to resolve the issue.
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'
Subscribing will provide email updates when this Article is updated. Login is required.