Pay Period Schedules not generating automatically

gdecaires · Post by **gdecaires** » Thu May 05, 2011 5:54 am

Hi,

We have several companies set up on one machine and all except one are running smoothly. The company in question is not generating pay period schedules automatically.

The cron jobs seem to be running fine for this installation. Also, when I run php AddPayPeriod.php from the maint folder the period is created.

Any help would be appreciated.

Post by **shaunw** » Thu May 05, 2011 9:48 am

You will need to follow the instructions located here:
http://forums.timetrex.com/viewtopic.php?f=6&t=89

To enable debugging mode so TimeTrex generate logs of what is going on.

Set the verbosity to 10 instead of 11 though.

Once this is done if you wait 24hrs and attach the logs we should be able to see whats going on. Its possible that the AddPayPeriod script got stuck and TimeTrex thinks its still running, so it won't run it again.

gdecaires · Post by **gdecaires** » Wed Sep 14, 2011 5:20 am

shaunw wrote:You will need to follow the instructions located here:
http://forums.timetrex.com/viewtopic.php?f=6&t=89

To enable debugging mode so TimeTrex generate logs of what is going on.

Set the verbosity to 10 instead of 11 though.

Once this is done if you wait 24hrs and attach the logs we should be able to see whats going on. Its possible that the AddPayPeriod script got stuck and TimeTrex thinks its still running, so it won't run it again.

This is the output from the log file. I've pasted the results of the cron job for the pay period schedule as it is supposed to happen. I don't see and error but the schedules are simply not being created automatically:

---------------[ Thu, 05 May 2011 23:59:02 -0400 (PID: 32761) ]---------------
---------------[ Fri, 06 May 2011 00:00:13 -0400 (PID: 317) ]---------------
DEBUG [206]: [Function](): URI: /var/www/SandridgeTT/maint/cron.php 
DEBUG [208]: [Function](): Production: 1 
DEBUG [374]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: AddPayPeriod 
DEBUG [382]: CronJobFactory::isScheduledToRun(): Epoch: 1304654400 - 06-May-11 12:00 AM AST 
DEBUG [388]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 5 
DEBUG [393]: CronJobFactory::isScheduledToRun(): Month Matches: 5 
DEBUG [398]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 5 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Hour Matches: 5 
DEBUG [408]: CronJobFactory::isScheduledToRun(): FINAL - Minute Matches: 5 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Last Run is Valid: 1304568060 
DEBUG [454]: CronJobFactory::Execute(): Job is NOT currently running, running now... 
DEBUG [94]: Validator::inArrayKey(): Key: 20 
DEBUG [711]: Factory::StartTransaction(): StartTransaction(): Transaction Count: 0 Trans Off: 0 
DEBUG [757]: Factory::Save(): Calling preSave() 
DEBUG [800]: Factory::Save(): Updating... 
DEBUG [625]: Factory::getUpdateQuery(): Update 
DEBUG [257]: Validator::isDate(): Raw Date: 1304654412 Converted Value: 1304654412 
DEBUG [656]: Factory::getUpdateQuery(): Data changed, set updated date: 
DEBUG [838]: Factory::Save(): Calling postSave() 
DEBUG [721]: Factory::CommitTransaction(): CommitTransaction(): Transaction Count: 1 Trans Off: 1 
DEBUG [460] Array: CronJobFactory::Execute(): Command RetCode: 1 Output:
<pre>
Array
(
)
</pre> 
DEBUG [106]: Validator::isNumeric(): Value:1 
DEBUG [94]: Validator::inArrayKey(): Key: 500 
DEBUG [145]: Validator::isLength(): Value: cron Length: 4 Min: 2 Max: 250 
DEBUG [145]: Validator::isLength(): Value: Executing Cron Job: 1 Command: php /home/www/SandridgeTT/classes/modules/core/../../..//maint/AddPayPeriod.php Return Code: 1 Length: 125 Min: 2 Max: 2000

Post by **shaunw** » Wed Sep 14, 2011 9:14 am

DEBUG [145]: Validator::isLength(): Value: Executing Cron Job: 1 Command: php /home/www/SandridgeTT/classes/modules/core/../../..//maint/AddPayPeriod.php Return Code: 1 Length: 125 Min: 2 Max: 2000

It appears that the command failed to run at all, Return Code: 1 means failure, 0 means success.

Are you getting any big red error messages at the top of each TimeTrex page complaining about maintenance jobs not running by chance?

This is the command that TimeTrex is trying to run:

Code: Select all

php /home/www/SandridgeTT/classes/modules/core/../../..//maint/AddPayPeriod.php

I'm going to guess that "php" does not exist in the PATH, so it can't be found. If you edit your timetrex.ini.php and specify the full path and file name of your PHP binary under the [path] section for the php_cli entry. It should look something like this:

Code: Select all

[path]
;Full path and name to the PHP CLI Binary
php_cli = /usr/bin/php

That should hopefully correct the issue.

gdecaires · Post by **gdecaires** » Mon Sep 26, 2011 5:54 am

This line:

php /home/www/SandridgeTT/classes/modules/core/../../..//maint/AddPayPeriod.php

is incorrect. The cron job is set up to run /var/www/SandridgeTT/classes/modules/core/../../..//maint/AddPayPeriod.php

but it is still trying to run at /home/www/.........

Do you know where this configuration is found so that I can change it?

Post by **shaunw** » Mon Sep 26, 2011 7:49 am

What is the exact command specified in cron?

In the TimeTrex.ini.php file, what is your PHP_CLI line set to?

gdecaires · Post by **gdecaires** » Mon Sep 26, 2011 8:57 am

Cron is set to run:

su www-data -c "/usr/bin/php /var/www/SandridgeTT/classes/modules/core/../../../maint/cron.php" > /dev/null 2>&1

my PHP_CLI is pointing to /var/lib/php5

Post by **shaunw** » Mon Sep 26, 2011 9:22 am

Okay, how come your command in cron uses a different PHP binary than the one specified in the timetrex.ini.php file?

Which one is correct?

gdecaires · Post by **gdecaires** » Mon Sep 26, 2011 9:31 am

The different PHP command is not intentional but is a symbolic link to the /var/lib/php5 command. This however doesn't seem to be the issue as cron is not reporting an error running the php but rather an error running a php command that doesn't exist. The timetrex installation is in /var/www but somewhere along the way, the cronjob is trying to run a file contained in /home/www/ which doesn't exist. I'm trying to find out where this erroneous path would be.

Thanks again.

Post by **shaunw** » Mon Sep 26, 2011 9:45 am

What version/edition of TimeTrex are you using?

gdecaires · Post by **gdecaires** » Mon Sep 26, 2011 11:28 am

We're using version 2.0.3 and it's the business edition

Post by **shaunw** » Mon Sep 26, 2011 11:58 am

Please email support@timetrex.com instead of using the forums for the Business Edition of TimeTrex, we are better equipped to help you that way and response times are much better.

Also, I would highly recommend upgrading to the latest version of TimeTrex (v3.6.0) as v2.X hasn't been supported for several years now and very soon there won't be an upgrade path at all.

TimeTrex Time and Attendance

Pay Period Schedules not generating automatically

Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Re: Pay Period Schedules not generating automatically

Time and Attendance