Page 1 of 1
timing control
Posted: Mon Sep 03, 2018 7:44 am
by azatrath
hi,
i am wondering something about case timing control. there is a case have 30 days time limit but sometimes its count from 1970. there is image showing the problem. i dont know what is the problem or solution.
Re: timing control
Posted: Mon Sep 03, 2018 9:04 pm
by amosbatto
What version of PM? Enterprise? What operating system? Manual or Bitnami install?
Where those cases with the due date set to 1970-01-01 or created by or routed by a [urlhttps://wiki.processmaker.com/3.2/Executing_cron.php]cron script[/url]?
If so, then you may need to configure the date.time_zone setting in the
php.ini file used by the PHP CLI. For example, on my Debian machine, I have to configure /etc/php/5.6/apache2/php.ini for PHP executed by the web interface and /etc/php/5.6/cli/php.ini for PHP executed by the command line (which is what cron.php uses).
There is a function used by PM to calculate the due date. You might need to configure a calendar to get it to work correctly.
IN your
env.ini file, set:
Do you see any error messages?
Re: timing control
Posted: Tue Sep 04, 2018 7:36 am
by azatrath
amosbatto wrote: ↑Mon Sep 03, 2018 9:04 pm
What version of PM? Enterprise? What operating system? Manual or Bitnami install?
Where those cases with the due date set to 1970-01-01 or created by or routed by a [urlhttps://wiki.processmaker.com/3.2/Executing_cron.php]cron script[/url]?
If so, then you may need to configure the date.time_zone setting in the php.ini file used by the PHP CLI. For example, on my Debian machine, I have to configure /etc/php/5.6/apache2/php.ini for PHP executed by the web interface and /etc/php/5.6/cli/php.ini for PHP executed by the command line (which is what cron.php uses).
There is a function used by PM to calculate the due date. You might need to configure a calendar to get it to work correctly.
IN your env.ini file, set:
Do you see any error messages?
thank you for replying amos, i am glad.
my system is Windows server 2012 and manual installion PM 3.2.1.
i have already made time zone. the errors appears with this configurate. there is still same problem. every 3 - 4 cases it appears 1 broken.
Re: timing control
Posted: Tue Sep 04, 2018 9:29 pm
by amosbatto
Are you using a custom calendar or the default calendar?
Are these users or tasks with different assigned calendars?
Re: timing control
Posted: Mon Sep 10, 2018 9:06 am
by azatrath
amosbatto wrote: ↑Tue Sep 04, 2018 9:29 pm
Are you using a custom calendar or the default calendar?
Are these users or tasks with different assigned calendars?
i am using custom calender. No all of them are same.
Re: timing control
Posted: Tue Sep 11, 2018 12:48 am
by amosbatto
I suggest that you file a bug report about it at
http://bugs.processmaker.com
Maybe the developers have a suggestion. You are the only person that I know to have encountered this problem.
Re: timing control
Posted: Wed Dec 12, 2018 8:32 am
by azatrath
amosbatto wrote: ↑Tue Sep 11, 2018 12:48 am
I suggest that you file a bug report about it at http://bugs.processmaker.com
Maybe the developers have a suggestion. You are the only person that I know to have encountered this problem.
hey amos, , found something may be a tip.
its only occurs when paralel task dont have due date. think about it. there is 3 tasks, after complete task 1 it will split to task2 and task 3 paralelly.
if task 2 and task 3 have diffetent due date, the one who have more time to complete will set itself 1970.
or can i use the trigger like this to set each task to different time with trigger? like setting task 1 uid and task 2 uid and set them with strtotime (+30 days)
Code: Select all$caseId = @@APPLICATION;
$query = "SELECT MAX(DEL_INDEX) AS NEXT_INDEX FROM APP_DELEGATION WHERE APP_UID='$caseId' ";
$result = executeQuery($query);
$nextIndex = $result[1]['NEXT_INDEX'];
$duedate = date('Y-m-d', strtotime(@@dueDate) ) . ' 18:00:00';
$result = executeQuery("UPDATE app_delegation SET DEL_TASK_DUE_DATE='$duedate'
WHERE APP_UID='$caseId' AND DEL_INDEX='$nextIndex' ");
Re: timing control
Posted: Wed Dec 12, 2018 4:30 pm
by amosbatto
If the Due Date is not being set for parallel tasks, then that is a bug in ProcessMaker. You can work around it with your trigger, but I would like to try to reproduce this problem.
Would you mind exporting your process and posting your .pmx file so I can test it?
PS: MySQL stores datetimes as seconds since Jan 1, 1970, so an empty datetime field will appear as 1970-01-01 00:00:00 .
Re: timing control
Posted: Wed Dec 12, 2018 4:54 pm
by azatrath
amosbatto wrote: ↑Wed Dec 12, 2018 4:30 pm
If the Due Date is not being set for parallel tasks, then that is a bug in ProcessMaker. You can work around it with your trigger, but I would like to try to reproduce this problem.
Would you mind exporting your process and posting your .pmx file so I can test it?
PS: MySQL stores datetimes as seconds since Jan 1, 1970, so an empty datetime field will appear as 1970-01-01 00:00:00 .
i upload my copy process, actuall its occurs almost every paralel event.
i have reported this problem
https://bugs.processmaker.com/view.php?id=26001 they told to me, they dont have this problem in 3.2.3
right nowi cant upgrade my system yet. but i need to avoid this problem. i need to help to write true trigge, cant handle by myself. i tried to write a trigger which set due date with task id fire after routing. it didnt work. i am not sure which trigger need to fire where.
i think your ps note is my real problem. i set 45 day work time and it gave me empty field, so that mysql set it 1970
Re: timing control
Posted: Wed Dec 12, 2018 5:41 pm
by amosbatto
I can't reproduce the problem in version 3.2.0 Community (manual install in Debian 9.5 with PHP 5.6.37, Mysql 5.7.23, Apache 2.4.25).
DueDateNormal.png (51.87 KiB) Viewed 4324 times
I'm using the default calendar. I had to modify your triggers to not query your PM Tables. Try running the modified version of your process to see the Due Dates still aren't set:
(395.38 KiB) Downloaded 94 times
Re: timing control
Posted: Thu Dec 13, 2018 3:05 am
by azatrath
amosbatto wrote: ↑Wed Dec 12, 2018 5:41 pm
I can't reproduce the problem in version 3.2.0 Community (manual install in Debian 9.5 with PHP 5.6.37, Mysql 5.7.23, Apache 2.4.25).
DueDateNormal.png
I'm using the default calendar. I had to modify your triggers to not query your PM Tables. Try running the modified version of your process to see the Due Dates still aren't set:
timeproblem-modified-1.pmx
ty for your effort amos,
can you try 4-10 times? it occurs 1 to 3 every 10 times. i tried without trigger too, same result.
Re: timing control
Posted: Fri Dec 14, 2018 12:16 am
by amosbatto
I tried 5 times and don't see the problem.
Try increasing your memory_limit, max_execution_time, and max_input_vars in your php.ini file.
Try using the default calendar and see if it only occurs with your custom calendar.
Re: timing control
Posted: Sun Aug 23, 2020 11:11 pm
by topeq10
Hi all,
I also having this problem.
Some cases is set to due date 1970.
Anyone can help to resolve?
