Troubleshoot and support > Cache > Dynamic caching in an application
Troubleshoot: Settings for DynaCacheInvalidation URL
When executing the DynaCacheInvalidation task as a URL, the task settings should be tuned for the specific WebSphere Commerce environment.
Problem
In setting up the scheduled job for the DynaCacheInvalidation task, several items should be considered:
- Determine the job number (SCSJOBNBR) for the DynaCacheInvalidation scheduled task.
- Set an execute time for the DynaCacheInvalidation scheduled task.
- Ensure the DynaCacheInvalidation task is run according to the schedule defined.
Solution
Review the following information for setting details:
- Determine the job number (SCSJOBNBR) for the DynaCacheInvalidation scheduled task.
- Check the SCHCONFIG table using the following query:
select * from schconfig where sccpathinfo like 'Dyna%'If multiple results are returned, check the SCCQUERY column for the latest startTime and startTimeNanos. Also check the SCCACTIVE column (A for Active). The SCHCONFIG.SCCJOBREFNUM matches the SCHACTIVE.SCSJOBNBR.
- Set an execute time for the DynaCacheInvalidation scheduled task.
- Only one update to SCHACTIVE table is required. As an example, use the query:
update schactive set scsprefstart=CURRENT_TIMESTAMP where scsjobnbr=18172This query causes the scheduled job (SCSJOBNBR) to run when the scheduler is activated. The activation of the scheduler is set in the instance.xml file.
- Ensure the DynaCacheInvalidation task is run according to the schedule defined.
- After updating the SCHACTIVE.SCSPREFSTART the DynaCacheInvalidation task job runs as defined in the schedule. For example. if the schedule defines the job to run every 10 minutes, then using the CURRENT_TIMESTAMP, sets the next scheduled job to be 10 minutes from the time it executed. Starting at 3:00 PM the job would run at 3:10 PM, 3:20 PM and continue every 10 minutes.
Alternatively, if the current time is 3:00 PM, you can set the time for a past time (1:10 PM). This causes the job to execute immediately and updates the scheduled job to run at 10 minute intervals from the time it executed.
- If SCHACTIVE.SCSPREFSTART is updated while the job is running no problems are encountered. The scheduler only looks for jobs that are not running and attempts to execute the jobs if the time and status is correct.