Category: Scheduler

{syntax type="tiki" editor="plain"}
Admin warning about the scheduler (that didn't ran) shouldn't be displayed when the scheduler is not used.

{syntax type="tiki" editor="plain"}

Sorry for the multi-drawer report.

On a Tiki25 I have a "tracker_item_modify" action (see last point, can be debatted).

## Wiki Page vs CLI

When applying manually the action on a __wiki page__ it work just fine.

When I run the command through the __scheduler__, while verbose and logs says it was done, in reality the action is not applied.

When I use the __CLI__ I have this error:
{CODE()}
php console.php list:execute "List executes control page" "Resave evaluations"
Undefined property: Search_ResultSet::$errorInQuery on line 313 of /home/happyhome/public_html/lib/wiki-plugins/wikiplugin_list.php
Action Resave evaluations executed on page List executes control page.
error: Error executing action Resave evaluations on item 1677099144: tracker_item_modify action missing value, calc, add or remove parameter.
{CODE}

After fixing the issue (again see below) the __CLI__ is still reporting an error but the action is completed correctly.
{CODE()}
php console.php list:execute "List executes control page" "Resave evaluations"
Undefined property: Search_ResultSet::$errorInQuery on line 313 of /home/happyhome/public_html/lib/wiki-plugins/wikiplugin_list.php
Action Resave evaluations executed on page List executes control page.
<feedback>feedback: Action Resave evaluations executed successfully on 1 item(s).
</feedback>
{CODE}

## Scheduler inaccurate report
The scheduler report (run now) and logs make the admin believe all went right while the CLI shows errors.
If an action is not completed the logs should show the output (from the console).

## Empty action to re-save item with item-list
The targeted item has been created from list execute with a duplicate action and has 2 item-list.
The item-list field are not populated after the action, and they need to be "manually" edited/save to get the other items values.

To make it automatic, I added a list execute with an empty tracker_item_modify action set only to force a "manual" save of the item.
{CODE()}{step action="tracker_item_modify" field="dailyevaluationDate"}{CODE}
This work manually but failed when using the CLI

I changed for
{CODE()} {step action="tracker_item_modify" field="dailyevaluationDate" calc="(concat (add dailyevaluationDate 1))"}{CODE}
This work (it change the date and time, but it is not critical in this case - all stays within the same day)

They would be nice to have easy to setup “predefined schedules” delivered within Tiki by default.
Rebuild sitemap, rebuilt-index, ping to an external service, etc...

We could also implement some mechanism for them to be turned on and off via preferences.
IE (TBD):
In Admin => Search => Indexes;
Do you want to allow the scheduler to rebuild the index on a regular basis ?
Every nnn minutes (1440 = a day)

I got this message:
{CODE()}
Incorrect integer value: '' for column 'healed' at row 1
{CODE}
when adding a Tiki Scheduler task (in mysql strict mode)

Maybe it's just a warning?

I report it, just in case.

FYI, I couldn't make the simple task to rebuild the search index, through the scheduler command to run (through the Tiki UI) aparently, but I don't know whether it's related to this bug or to something else.

Using latest 18.x svn{sign user="xavi" datetime="2018-05-24T09:36:46+00:00"}

In Tiki23 a new dropdown was added to improve the UX and action selection.
Something nice BUT once you upgrade it will resets the previous and existing scheduled tasks without warning.

See : https://gitlab.com/tikiwiki/tiki/-/commit/a77af6f7da9f41e647de91693d8f0edbe0110616

{syntax type="tiki" editor="plain"}
On A Tiki 29 running successfully different scheduler task everyday I can see the " The Scheduler does not seem to have been executed recently." warning

The admin UI for the schedular contains some help text that is strangely totally untranslateable.

/templates/tiki-admin_schedulers.tpl contains this at line 147:
{CODE(Colors="Tiki")}
{remarksbox type="note" title="{tr}Information{/tr}"}
{tr}Use CRON format to enter the values in "Run Time":
<br>
Minute, Hour, Day of Month, Month, Day of Week
<br>
Eg. every 5 minutes: */5 * * * *{/tr}
{/remarksbox}
{CODE}

Since the text is correctly enclosed in tr in curly braces. I am at a loss why this is the case, and why it throws no error?

Also, I seem unable to translate the task descriptions. These are ConsoleCommand, ShellCommand, HTTPGetCommand. I cannot even find the location where they are set. While I figure that admins who want to use schedulers might understand those terms, so task descriptors are slightly less important, but the help text about CRON syntax isn't.

After my last upgrade of a working Tiki23 (5 days ago) sitemap creation using from the scheduler fail.

If I run the command from the scheduler manually it works.
If I run the command from the terminal php7.4 console.php sitemap:generate https://www.domain.com/, it work.

{img fileId="1680" thumb="box"}

I have set up a cron job ( -+*/15 * * * * cd /var/www/...../web/tiki17x; php56 console.php scheduler:run+- ) to run the console command on the server which checks the schedulers every 15 minutes but the defined scheduler task should be run every 2 hours, not each time the cron checks it. This is what I have there on the Scheduler control panel (the scheduler name is "Index rebuild every 2 hours"):
{CODE()}
Index rebuild every 2 hours ConsoleCommandTask * */2 * * * active ✔
{CODE}

(The ConsoleCommandTask is set up to i:r.)

!!Scheduler "Index rebuild every 2 hours" Logs:
{CODE()}
Start Time End Time Status Output
Aug 10, 2017 14:45:03 Aug 10, 2017 14:45:12 done Started rebuilding index...
Indexed
wiki page: 8
file: 6
file gallery: 4
trackeritem: 1
tracker: 1
trackerfield: 10
comment: 0
user: 2
group: 3
activity: 1
Rebuilding index done
Execution time: 9 secs
Current Memory usage: 58.8 MiB
Memory peak usage before indexing: 21.0 MiB
Memory peak usage after indexing: 59.7 MiB
Number of queries: 512

Aug 10, 2017 14:30:03 Aug 10, 2017 14:30:12 done Started rebuilding index...
Indexed
wiki page: 8
file: 6
file gallery: 4
trackeritem: 1
tracker: 1
trackerfield: 10
comment: 0
user: 2
group: 3
activity: 1
Rebuilding index done
Execution time: 8 secs
Current Memory usage: 55.0 MiB
Memory peak usage before indexing: 21.5 MiB
Memory peak usage after indexing: 55.9 MiB
Number of queries: 504

Aug 10, 2017 14:15:06 Aug 10, 2017 14:15:16 done Started rebuilding index...
Indexed
wiki page: 8
file: 6
file gallery: 4
trackeritem: 1
tracker: 1
trackerfield: 10
comment: 0
user: 2
group: 3
activity: 1
Rebuilding index done
Execution time: 9 secs
Current Memory usage: 54.7 MiB
Memory peak usage before indexing: 21.0 MiB
Memory peak usage after indexing: 55.6 MiB
Number of queries: 504
{CODE}

__I want to run the scheduled task every 2 hours as defined, not every 15 minutes I check if there are any new schedulers.__

Related links:
--https://dev.tiki.org/Scheduler-- actually, this is some other "Scheduler" (same name for different features?), oops {sign user="luci" datetime="2017-08-15T10:55:26+00:00"}
https://doc.tiki.org/Scheduler

On a Tiki25 you can set a cron job that will run every hours from/ specific hours.

IE: -+*/15 17-22/2 * * *+- is correct, see https://crontab.guru/#*/15_17-22/2_*_*_*
But the scheduler refuse to save it: "Cron run time is not valid"

Now we have Scheduler and plugin ListExecute we can fairly simply make an automated notification system for this tracker, to:
* email the originator if it's pending and needing retesting
* open, not fixed and a volunteer is listed
* still open after a very long time (gone stale?)
...that sort of thing.

Anyone fancy trying to set it up? (:mrgreen:)

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

{syntax type="tiki" editor="plain"}
Go to tiki-admin_schedulers.php, tiki-pagehistory.php?page=test(name of your existing page), try click "Actions" icon and see the behavior

The Scheduler is broken in Tiki24.

{img fileId="1799" thumb="box"}

Work in Tiki23 and in master (Tiki25).

I’m receiving warnings from Tiki Scheduler.

From: a Tiki admin email ?

Subject: "Scheduler "Batch Sync WO Status - SyncStatusECDEntered" was healed"

Body : "Scheduler "Batch Sync WO Status - SyncStatusECDEntered" is now marked as healed, since its running time is over minutes."


With that little information I have no clue which Tiki is trying to tell me something.
We should add information to the email like: url of the Tiki and Browser name.
I would add the date so I can copy/paste or forward easily the information.

Something else ?