|
|
| (19 intermediate revisions by one other user not shown) |
| Line 1: |
Line 1: |
| − | When installed, [[Web Edition|XLCubed Web Edition]] installs the [[Scheduling]] component. This is a Windows Service that can be used to automatically deliver reports to users on a schedule, or when certain conditions are met.
| + | Scheduling is available for both the file-based repository and the [[SQL Repository]]: |
| − | | + | * [[Scheduling Installation with the File-based Repository]] |
| − | ==Installation==
| + | * [[Scheduling Installation with the SQL Repository]] |
| − | | |
| − | ===Installing the Windows Service===
| |
| − | If the installation hasn't already configured the Windows Service, run the {{Code|InstallService.cmd}} batch file located in the {{Code|Scheduler}} directory of your XLCubed Web Edition installation.
| |
| − | | |
| − | ===Feature Permissions===
| |
| − | As in [[XLCubed Web Edition Installation Guide#Functional User Permissions|the Web Edition installation guide]], permissions for access to the Scheduling feature can be set by granting or revoking access to the {{Code|Xml\Security\scheduling.xml}} file in the XLCubed Web installation folder.
| |
| − | | |
| − | ===Configuration Files===
| |
| − | There are two sets of configuration files for the Scheduling Service.
| |
| − | * {{Code|XLCubed.Scheduling.Service.exe.config}} in the {{Code|Scheduler}} directory of your XLCubed Web Edition installation. This should be automatically populated with the correct values, and will only need modification if the website or repository are subsequently manually moved, or if the XLCubed Web Edition server uses a non-default [[#Authentication Mode|Authentication mode]].
| |
| − | * The schedules and other configuration files for the Scheduling Service in the XLCubed Web Repository folder, in the {{Code|__xlcubed__\__scheduling__}} subfolder. It is normal for there to be no files until schedules or other configuration parameters have been set up. | |
| − | | |
| − | ===Authentication Mode===
| |
| − | The Scheduling service is set up to use Windows Integrated authentication by default. To use Basic authentication instead, edit the {{Code|XLCubed.Scheduling.Service.exe.config}} file, changing the {{Code|AuthenticationType}} line to {{Code|Basic}} and fill in the user name and password below it. (XLCubed Web Edition v6.5.014 and higher)
| |
| − | | |
| − | ===Using the Role Selector===
| |
| − | When configuring schedules and distribution groups, the Scheduling configuration screens can offer a list of relevant roles available on the server. In order for this to work, Microsoft's Analysis Management Objects must be installed. This can be found here, included in {{Code|Microsoft SQL Server 2005 Management Objects Collection}}:
| |
| − | [http://www.microsoft.com/en-us/download/details.aspx?id=11988 Feature Pack for Microsoft SQL Server 2005 SP4] | |
| − | | |
| − | ==Configuring the Windows Service==
| |
| − | | |
| − | ===The Service Identity===
| |
| − | By default, the Scheduling Service runs under the {{Code|Local System}} account. This allows it to have access to the necessary files, webservices and resources it needs to run reports and send emails. However, to use the Roles feature, a new identity must be chosen that is allowed to use all the roles that will be used. For simplicity, this can be an OLAP Administrator.
| |
| − | | |
| − | ===Starting the Windows Service===
| |
| − | The Scheduling Service can be managed just like any other Windows Service. You can start it by running the {{Code|StartService.cmd}} batch file located in the {{Code|Scheduler}} directory of your XLCubed Web Edition installation or by using the Services control panel.
| |
| − | | |
| − | ==Other considerations==
| |
| − | | |
| − | ===Virus and Malware Scanners===
| |
| − | The Scheduling Service will need access to:
| |
| − | * its configuration files, detailed above,
| |
| − | * the XLCubed Web Edition web services, via HTTP or HTTPS,
| |
| − | * the SMTP server where emails are to be sent.
| |
| − | | |
| − | ===PDF Problems===
| |
| − | The scheduled reports may suffer from problems as described on [[XLCubed_Web_Edition_Installation_Guide/Version_6.1#PDF_Printing_-_Configuration|this page]], even when PDF printing works for normal users. Note that the permissions on the {{Code|Temp}} folder must be set for the Scheduling service user.
| |
| − | | |
| − | ===SendTimeout too short===
| |
| − | If the SendTimeout on the relevant XLCubed Web Edition webservice is set too low, then an error similar to this one can be reported in the Scheduling error log:
| |
| − | System.TimeoutException: The request channel timed out while waiting for a reply after 00:00:58.0399638.
| |
| − | | |
| − | By default, this timeout is set to 1 minute. In order to change this setting, edit the {{Code|web.config}} file held in the root of the XLCubedWeb installation directory, adding a {{Code|sendTimeout}} attribute to the appropriate {{Code|binding}} element. For example, to set the sendTimeout to 10 minutes:
| |
| − | <basicHttpBinding>
| |
| − | <binding name="bigBinding" sendTimeout="00:10:00" maxReceivedMessageSize="2147483647">
| |
| − | ........
| |
| − | </binding>
| |
| − | </basicHttpBinding>
| |
| − | | |
| − | | |
| − | You will need to do an IISRESET after making any changes.
| |
| − | | |
| − | ==See Also==
| |
| − | * [[Scheduling]] | |
| − | | |
| − | [[Category:Web Edition]]
| |
| − | [[Category:Installation]]
| |
| − | [[Category:Scheduling]]
| |
