15 April,20 at 09:05 AM
Applies to: All versions of Centrify Infrastructure Services
Problem:
This warning window prompts at the step of specifying SSRS URLs to deploy the Centrify Reports.
The SQL server has been configured properly, it is online and port is opened.
Cause:
Go to this Web Service URL http://hostname:80/ReportServer_SQLInstanceName on the browser directly, below reporting services error is received.
Invalid object name 'XXXXTempDB.dbo.TempCatalog'. Could not use view or function 'ExtendedCatalog' because of binding errors.
The message means the TempDB 'ReportServer$CENTRIFYSUITETempDB' is missing.
In Reporting Services, each report server database uses a related temporary database to store session and execution data, cached reports, and work tables that are generated by the report server. Background server processes will periodically remove older and unused items from the tables in the temporary database.
If this temporary database was accidentally deleted or missing then the connection will be blocked.
Resolution:
Create another temporary database on Reporting Services Configuration Manager.
Link provided as courtesy:
https://social.msdn.microsoft.com/Forums/en-US/e3a9a951-126c-47ca-bf0c-a436b95a2ec2/invalid-object-name-reportservertempdbdbotempcatalog?forum=sqlreportingservices