When trying to open and run any OCS/Lync Report pack report the following is displayed on screen:
"No fields in datasource 604080 ((SELECT * FROM V_DataSources WHERE Language = 'en-US) tmpReports)"
(0x8004005)"
OCS Report pack tables do not exist in the database.
Check the MessageStats database and make sure the OCS Report Pack Tables exist.
This is found by:
1. Opening SQL Server Management Studio
2. Expand Databases | MessageStats | Tables
3. Look for tables that begin with dbo.T_OCS.
E.g. dbo.T_OCS_DD_Tables.
4. If these tables don't exist run the OCS.sql script against the MessageStats database located on the MessageStats server at "C:\Program Files (x86)\Quest Software\MessageStats\Report Packs\OCS\SQL" or uninstall & reinstall the OCS Report pack.
