- Report repository should be shared
- The scheduler should be configured for a cluster
Report Repository
Through Admin>System Maintenance>Report Repository I changed the path from the default,
So pedantaries aside, I moved the contents of
A side effect of config being held in the "Report Repository" path is that when I configured the second BI Publisher server to use this new shared path all of the config I'd done on the first server was applied to the second. I wonder if this is how it's supposed to work, or there's going to be server-specific config written to a shared location which will cause problems?
With hindsight, and if the config can be shared like this, then setting up the shared file system first would have been best, and then I'd have only had to configure the one server and the second would have picked it up (for Scheduler changes etc).
Scheduler
I installed the Scheduler schema successfully, and ticked the Enable Clustering under Scheduler Properties. Doing some poking around (google for "Enable Clustering" "Scheduler Properties") I found this page which documents Quartz (used for scheduling in BI Publisher, some more info here). It states
Enable clustering by setting the "org.quartz.jobStore.isClustered" property to "true". Each instance in the cluster should use the same copy of the quartz.properties file.The last sentence of this is reassuring as it describes what I've now got with the shared Report Repository folder. Checking data/shared/xmlp/Admin/Scheduler/quartz-config.properties shows that it now includes:
org.quartz.jobStore.isClustered=true