New Cache
The New Cache dialog appears when you select the New Cache link on the Logi JReport Administration > Cache > Data Cache page. It helps you to create a schedule task for generating cached report data for the specified data resources.
The dialog is divided into two phases, one for selecting data resources and the other for defining the schedule task.
Selecting Data Resource Phase
At this phase, you need to specify the data resources for which to create cached data. See the dialog at this phase.
Select a Folder
Specifies the folder in the server resource tree that contains the required catalog. You can select the button to open the Select Folder dialog for selecting the folder.
Select a Catalog
Specifies the catalog in the folder.
Select Queries
Lists the selected data resources.
Opens the Select Queries dialog to select the data resources that you are going to create data caches for.
Removes the selected data resources.
OK
Goes to the next phase to define the schedule information.
Cancel
Does not retain any changes and closes the dialog.
Help
Displays the help document about this feature.
Scheduling Phase
At this phase, you need to define the data resource information and the updating policy of the data cache with the following tabs:
Back
Goes back to the previous tab.
Next
Goes to the next tab.
Finish
Applies the settings.
Cancel
Cancels any settings and returns to the selecting data resource phase.
Help
Displays the help document about this feature.
General
Before you can schedule a CRD task, you first need to configure the settings in this tab. See the tab.
Select Query
Lists all the data resources selected in the selecting query phase. Select a data resource from the drop-down list and then specify the general properties of its scheduled CRD task.
Specifies values of the parameters applied in the selected data resource. You may specify parameter values in these ways.
If the data resource does not have parameters, "No Parameter Needed" is displayed here.
Cached Report Data Info
Specifies the data cache information.
- Name
Displays the name of the selected data resource. It is also used as the name of the new data cache. - Data Source
Displays the data source name. - Catalog
Displays the catalog information. The latest version is used by default. - Type
Displays the type of the data resource. - Priority
Specifies a priority level to the scheduling task. The priority levels are from 1 to 10 in ascending order of lowest priority to highest priority. By default this property is ignored unless server.properties is modified to set queue.policy not equal to 0.
Advanced
Configures some advanced settings.
- Connect to [Data Source Name]
Specifies the DB user and password with which you want to connect to the data source.- Use the DB user and password defined in catalog
If checked, the DB user and password defined in the catalog will be used. - Use the DB User
If checked, specify another DB user and password instead of the one defined in the catalog.
- Use the DB user and password defined in catalog
- Add TaskListener to be Invoked
Enables you to call the Java application before/after viewing or when scheduling the task. - Enable Auto Recover Task
Specifies to enable the task to be auto recovered.- Maximum Retry Times
Specifies the maximum number of times in which to retry running the task in order to recover it. - Retry Interval
Specifies the interval between retries. - Recreate All Results
Specifies whether to recreate all or just the failed results.
- Maximum Retry Times
Conditions
The Conditions tab allows you to specify the updating policy of for the task. It contains the following two sub tabs:
Time
The Time tab allows you to set settings for specifying the time for when a task is to be performed. See the tab.
Time Zone
Specifies the time zone.
Time Type
Specifies the time type of the task.
- Run this task immediately
Performs the task as soon as you submit it.- Expires
Specifies when the task expires.- Never
The new task never expires. - At
Specifies a specific time on a selected day when the task expires. - After
Specifies a time period after that the task expires.
- Never
- Expires
- Run this task at
Specifies the time for when the task is to be performed once.- Date
Specifies the date for when the task will be run. You can specify the date by selecting the calendar button . - Time
Specifies the time for when the task will be run. - Run missed task upon Server restart
Specifies to run missed tasks when you restart the server.
- Date
- Run this task periodically
Specifies the time for when the task is to be performed on a repeated basis.- Do not start schedule until the report is requested
This option is used to freeze the way of automatically performing the schedule and change it to the schedule being fired upon certain condition.If the option is not checked, the schedule will be performed automatically according to the time condition.
If the option is checked, the schedule will be fired only upon the first report running request based on the query after each scheduled time.
- Duration
- Run after
Specifies the start date and time of the period during which the task is to be performed on a repeated basis. - Run until
Specifies the end date and time of the period during which the task is to be performed on a repeated basis.
- Run after
- Date
Specifies the date for when a task is to be performed.- Daily
Performs the task every one day, two days, etc., or every weekday (from Monday to Friday). - Weekly
Performs the task every one week, two weeks, etc., and on Sunday, Monday, Tuesday, etc. - Monthly
Performs the task on the first day, second day, etc. of every one month, two months, etc., or on the first Sunday, Monday, etc. of every one month, two months, etc.
- Daily
- Time
Specifies the exact time for when a task is to be performed on a selected day.- At
Specifies a specific time for when to perform a task on a selected day. - Hourly
Performs the task every one hour, two hours, etc., at a certain minute on a selected day. - Minutely
Performs the task every one minute, two minutes, etc.
- At
- Expires
Specifies the expiration time for how long to keep the scheduled data caches.- Never
The data caches will not expire. - At
Specifies a specific time when the data caches will expire. - After
Specifies a period of time after which the data caches will expire.
- Never
- Run missed task upon server restart
Specifies to run missed tasks when you restart the server.
- Do not start schedule until the report is requested
Trigger
The Trigger tab allows you to set settings for specifying a trigger for the task. See the tab.
Select a trigger to bind
Specifies the trigger from the drop-down list for the task.
Create New
Creates a new trigger.
- Trigger Name
Specifies the name of the trigger. - Conflict Check
Checks if the name has been used for another trigger. - Description
Specifies the description of the trigger (if required). - OK
Creates the trigger with the specified information. - Cancel
Cancels the trigger creating process.
Logic with time condition
Specifies the logic between time condition and trigger condition.
- Trigger Only
Performs the task only when the trigger is fired. - Trigger and Time Condition
Performs the task when both time is up and the trigger is fired.Note: When this logic is selected:
- No matter which condition is ready, the task can only be performed when its counterpart is ready.
- If you specify the task to be performed at a specific time, you must check the option Run missed task upon server restart, otherwise the task will be regarded as expired and will be deleted when the time condition is ready before the trigger condition.
- Time Condition after Trigger
Performs a task when time is up after the trigger is fired. If the time condition is ready before the trigger condition, the task will be regarded as expired and will be deleted. - Time Condition or Trigger
Performs the task when either time is up or the trigger is fired.
Notification
The Notification tab allows you to notify someone by e-mail when a task has finished running, regardless of whether it was successful or unsuccessful. See the tab.
When task is successful
Specifies to send an e-mail when the task is successful.
When task fails
Specifies to send an e-mail when the task is unsuccessful.
To
Specifies the address you want to send the e-mail to.
Cc
Specifies the address you want to copy to.
Bcc
Specifies the address you want to secretly copy to.
Subject
Specifies the subject of the e-mail.
Comments
Specifies the contents of the mail or comments to the contents.