Overview

The latest Auto Test Fails reports from the Telecare Dynamics CRM365 have been empty, but this report has always returned data in the past.  

Solution

This can be caused when the Scheme Characteristic Value with the Name Yes is changed to have a value of No.  To verify this, please check the Scheme Characteristic Values on the Auto Test Fail report by doing the following:

1. Log into the Oasis Management Portal on Microsoft Dynamics CRM365
2. Click on the Advanced Find Icon in the top toolbar to open the Advanced Find window.
3. In the Look For: dropdown, select Scheme Characteristic Values.
4. Move your mouse cursor over the Select link and select Scheme Characteristic in the dropdown displayed.
5. Move your mouse cursor over the Enter Text link and enter Auto Test in the text box displayed.
6. Click on the Results button.

There should be both a Yes and No Scheme Characteristic Value, if there isn't a Yes Scheme Characteristic Value then you will need to do one of the following:

• If there is only a single No value, you will need to create a new Yes Scheme Characteristic Value.
• If there are two No values, you will need to check the Audit History of both Scheme Characteristic Values to determine which one was changed from Yes to No and change it back to Yes.

<supportagent>

select distinct vdi_vdi_scheme_to_resolutionid,*
from vdi_schemecharacteristicresolution
where vdi_vdi_schemecharacteristic_to_residname = 'Auto Test'
  and vdi_vdi_schemecharacvalue_to_resoluidname = 'Yes'

</supportagent>

Testing

Once there is a proper Yes and No Scheme Characteristic Value for the Auto Test Scheme Characteristic, the Auto Test Fails report should run correctly.