Scheduled reports run successfully but can not view

I’ve just completed an install of Server XI with sp3 and migrated all of my users/objects from a machine that i’m about to replace that is also running XI/sp3. On the new machine the reports run fine, but when I click the instance to view it I get this error: All the servers with CMS (servername), cluster @(servername) and kind cacheserver are down or disabled

When I open central configuration manager all services are up and running. This is going to be a standalone server, no cluster. I’ve looked at all the settings on the old server and they all appear to be exactly the same. Anyone have any ideas?


paulio (BOB member since 2010-03-18)

OK, so the servers are running, but have you checked that all the necessary servers are Enabled?

If the report schedules are running OK, but you cannot view instances, it sounds like the JobServer is running OK, but have you checked that the Output FRS is reading/writing to the Filestore correctly?

Cheers,
Sean


Sean Reynolds :uk: (BOB member since 2004-12-16)

As far as I can tell all the servers are enabled. I’ve checked all the settings on the new server against the ones on the old server that works and I can’t find any differences. Where would I go to check to see that the output FRS is reading/writing correctly?


paulio (BOB member since 2010-03-18)

To check whether the Instance file(s) actually got written to the Output filestore:

[1] In the CMC or InfoView, look at the properties for the document you are scheduling. Make a not of the CUID.

[2] Using “Query Builder”, get a list of all instances for that document by executing the following query (note: replace the si_parent_cuid with the CUID you found in [1] above).

select si_name, si_kind, si_files, si_instance, si_creation_time
from ci_infoobjects
where (si_parent_cuid = 'AYYQhgq1BcdLhpPSCZMI2Zg') and (si_instance = 1)
order by si_creation_time desc

[3] For each instance in the query output, note the SI_PATH property in the SI_FILES property bag. Navigate to your Output filestore and check that the file exists.


Sean Reynolds :uk: (BOB member since 2004-12-16)

I’m having a hrad time finding the CUID of the query in the properties. What exactly am I looking for?


paulio (BOB member since 2010-03-18)