-
Title
OCS/Lync Report Pack Reports return: "No fields in datasource 604080 ((SELECT * FROM V_DataSource -
Description
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)"
-
Cause
OCS Report pack tables do not exist in the database.
-
Resolution
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.