The OCS/Lync Servers & Users task fails with the below error:
The following error occurred during the processing of a given gathering: An SqlParameter with ParameterName '@Department' is not contained by this SqlParameterCollection..
Time:2013-05-13T16:06:04.2026308Z
Component:Internal Processing
HR:
EventID:{e4ae5340-3285-4bcc-881a-e667070e4773}
Rerun the "QMSOcsLyncDatabase.sql" database script manually against the MessageStats database found in the unzipped package under SQL\ReportPacks\OCS-Lync.
The reason for rerunning the script manaully is to take care of anything else that might be missing. In this particular error it was found in an upgrade of the OCS/Lync Report pack from 3.5 to 7.1. (QMS 6.9 - 7.1)
Note: You will not lose any historical data, but it is a good idea that you have a good backup of the MessageStats database just incase there is any problem.
