We recently upgraded the Web Reporting tool which included alot of new reports. Only one is not working correctly and we have not been able to get past it. The report is "Count installed applications from Microsoft Corp. (EA True-up)" and we get the following error message when running the report:
There was an error in the SQL Statement.
The following error was returned:
Invalid object name 'v_GS_ADDREMPROGS'. [-2147217865]
If you believe this query is syntactically correct, please refer to the release notes topics After Upgrade to SMS 2.0 SP3 and Schema Views Need To Be Refreshed Periodically for information that may help you resolve this error.
We have refreshed the schema views and this did not resolve the issue.
Thanks,
There was an error in the SQL Statement.
The following error was returned:
Invalid object name 'v_GS_ADDREMPROGS'. [-2147217865]
If you believe this query is syntactically correct, please refer to the release notes topics After Upgrade to SMS 2.0 SP3 and Schema Views Need To Be Refreshed Periodically for information that may help you resolve this error.
We have refreshed the schema views and this did not resolve the issue.
Thanks,