Search found 55 matches

by joshsard
Thu Jul 27, 2017 10:53 pm
Forum: Help
Topic: overlapping cronjobs
Replies: 6
Views: 1537

Re: overlapping cronjobs

Hi,

The cache folder size is 39MB in size. Is that ok, or shall we delete it? Thanks
by joshsard
Thu Jul 27, 2017 7:40 pm
Forum: Help
Topic: overlapping cronjobs
Replies: 6
Views: 1537

Re: overlapping cronjobs

Hi, We are using v9.0.2-20151106-210132 community edition. I've also checked out our timetrex.ini.php, and it seems like cache is disabled: ; ; Cache settings ; [cache] enable = FALSE ;Linux dir = "/tmp/timetrex" Is that setting okay? Also, here is another screenshot of the process: htop.JPG Thanks
by joshsard
Thu Jul 20, 2017 1:12 am
Forum: Help
Topic: overlapping cronjobs
Replies: 6
Views: 1537

Re: overlapping cronjobs

Hi,

We use PostgreSQL db and we have 7360 rows in the users table.

What does the calcExceptions do?
Also where could I find the timetrex cache directory?

Thanks
Josh
by joshsard
Tue Jul 18, 2017 11:51 pm
Forum: Help
Topic: overlapping cronjobs
Replies: 6
Views: 1537

overlapping cronjobs

Hi,

I would like to know if all the rows in the table 'cron' should not be disabled or change the schedule? We are encountering some overlapping process, especially calcExceptions.php. Please see below screenshot:
overlapping process.JPG
overlapping cronjob processes running in timetrex production server
overlapping process.JPG (27.3 KiB) Viewed 1537 times
Thanks
Josh
by joshsard
Thu Nov 10, 2016 3:02 am
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Hi, The timetrex log only shows same logs like: “Load average within valid limits” from both Test and Prod, although the values from prod is higher than test : [Test] DEBUG [L1975] [35967ms]: Misc::isSystemLoadValid(): Load average within valid limits: Current: 0.58 Max: 9999 [Prod] DEBUG [L1975] [4...
by joshsard
Tue Nov 08, 2016 9:05 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Our sysadmin told me there were no proxy used :(
Do u happen to know if there are timetrex-specific settings relating to proxies?
by joshsard
Wed Nov 02, 2016 11:37 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Hi, There was a finding when we open google chrome dev tools while running the report: Prod Console Timetrex.png The red font was being shown in the log when the report is not generated. I believe that is a network related issue. We only get this in production environment which virtually has the sam...
by joshsard
Wed Oct 26, 2016 1:15 am
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

hi,

i would like to follow up on this, i've put the logs in my previous reply.

thanks
by joshsard
Sun Oct 23, 2016 11:24 pm
Forum: General Discussion
Topic: Set cache TRUE in timetrex settings
Replies: 1
Views: 2164

Set cache TRUE in timetrex settings

Hi,

I have just a quick question
Do I need to restart timetrex or anything when I change the following setting on timetrex.ini.php:

[cache]
enable = TRUE

from FALSE to TRUE?

Thanks
by joshsard
Sun Oct 23, 2016 9:11 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Hi guys, Unfortunately, we still have the issue, but I have seen an interesting bit from the log file: DEBUG [L2048] [21643ms]: Report::_output(): Format: csv DEBUG [L2024] [21785ms]: Report::getOutput(): Format: csv Total Time: 21.75560092926 Memory Usage: Current: 45448072 Peak: 411158848 DEBUG [L...
by joshsard
Mon Oct 10, 2016 10:51 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Update again: This is the link that produces the error message after the report generation failed: api/json/api.php?Class=APITimesheetDetailReport&Method=getTimesheetDetailReport&MessageID=7347e925-463e-03e8-c81d-595819a2c72e How can I use this 'MessageID' to get the correct info? The link when open...
by joshsard
Mon Oct 10, 2016 8:41 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Update: We even disabled the memory limit by setting -1 to the above setting, but the excel still does not generate. Note that in our production, we could only generate the TimeSheetDetail Report when the time period date range is 4 days or lower. The problem is when the time period date range is 5 ...
by joshsard
Mon Oct 10, 2016 7:46 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

But we already changed the setting of php.ini to below:

Code: Select all

memory_limit = 4096M
Our IT admin said that the PHP installed is 64-bit, and our server too is 64-bit.
by joshsard
Mon Oct 10, 2016 12:27 am
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Hi, I found another interesting log in /var/log/timetrex/php_errors.log: Allowed memory size of 2425131008 bytes exhausted (tried to allocate 1024 bytes) in /home/timetrex/timetrex/classes/modules/report/TimesheetDetailReport.class.php on line 1294 the line contains: if ( strpos($format, 'pdf_') ===...
by joshsard
Sun Oct 09, 2016 9:26 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

Hi, I would like to add additional information while debugging the report through the Chrome browser: NOT OK: timesheet_detail_report.png There was no error pop-up like before (ERROR: Please try again later or narrow your search criteria to decrease the size of your report). But the excel is not gen...
by joshsard
Sun Oct 09, 2016 6:26 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Re: Error in Generating TimeSheet Detail Report

We already created a separate TimeTrex test server which is the later version (9.1.3), and loaded our prod data there and ran the report, it still does not work.
by joshsard
Thu Oct 06, 2016 9:27 pm
Forum: General Discussion
Topic: Error in Generating TimeSheet Detail Report
Replies: 16
Views: 8427

Error in Generating TimeSheet Detail Report

Hi, I would like to ask for your help regarding an issue we have on our TimeTrex application. When we try to generate a report using the TimeSheet Detail Report, we get the following error: 502 Proxy Error The proxy server received an invalid response from an upstream server The proxy server could n...
by joshsard
Wed Sep 28, 2016 2:47 am
Forum: Help
Topic: SQL Profiler for TimeTrex
Replies: 0
Views: 5690

SQL Profiler for TimeTrex

Hi,

Is there any way to log which SQL queries/statements are executed while TimeTrex is being used? I saw somewhere in the forums something like PROFILER OUTPUT in the messages, is this what I need, and how do I enable it?

Thanks
by joshsard
Tue Aug 30, 2016 1:40 am
Forum: Help
Topic: TimeSheet Detail report not generating for 2 week daterange
Replies: 9
Views: 3832

Re: TimeSheet Detail report not generating for 2 week datera

Hi, I would like to have an additional checkbox called "Include Blank Records Only" but I checked the codes in \classes\modules\report\TimesheetDetailReport.class.php and it seems complicated to root out which code I need to implement it. Can anyone please help me out? I kindly need your suggestions...
by joshsard
Thu Aug 25, 2016 9:00 pm
Forum: Help
Topic: TimeSheet Detail report not generating for 2 week daterange
Replies: 9
Views: 3832

Re: TimeSheet Detail report not generating for 2 week datera

Hi,

Is there a way to create a report with "Blank Records" only? :D

Thanks
by joshsard
Wed Aug 24, 2016 11:25 pm
Forum: Installation Help
Topic: Specific versions of system requirements for latest TimeTrex
Replies: 1
Views: 2077

Specific versions of system requirements for latest TimeTrex

Hi, I have already read the link below http://forums.timetrex.com/viewtopic.php?f=6&t=6 but that post was 10 years ago. I'm just wondering what are the "specific" versions of the ff services below that you recommend, especially for the latest version that came out this month (v9.1.3, 8/22/2016)? - P...
by joshsard
Wed Aug 24, 2016 8:42 pm
Forum: Help
Topic: TimeSheet Detail report not generating for 2 week daterange
Replies: 9
Views: 3832

Re: TimeSheet Detail report not generating for 2 week datera

Hi,

Here are the current values of the php.ini:

max_execution_time=0 (means no limit)
memory_limit=4096M

Can we know what are use of these settings? It seems to affect the size/generation of the report
1. "Maximum Pages" value in the Setup tab
2. "Include Blank Records" in the Report tab

Thanks
by joshsard
Wed Aug 24, 2016 1:42 am
Forum: Help
Topic: TimeSheet Detail report not generating for 2 week daterange
Replies: 9
Views: 3832

Re: TimeSheet Detail report not generating for 2 week datera

hi, thanks for the update We had some progress by 1. Increasing the "Maximum Pages" value in the Setup tab 2. Unchecking "Include Blank Records" in the Report tab Although what do these settings mean? is there any way to increase the report size generated by timetrex? Thanks :) Edit: no improvement ...
by joshsard
Mon Aug 22, 2016 10:33 pm
Forum: Help
Topic: TimeSheet Detail report not generating for 2 week daterange
Replies: 9
Views: 3832

Re: TimeSheet Detail report not generating for 2 week datera

Hi, It is installed in Red Hat Enterprise Linux Server release 6.6 (Santiago). Does the PHP you mentioned the one bundled with the TimeTrex installation? Anyway, how do I change these so-called settings: -execution time -maximum memory settings Our admins have already increase the capacity of the in...
by joshsard
Sun Aug 21, 2016 11:39 pm
Forum: Help
Topic: TimeSheet Detail report not generating for 2 week daterange
Replies: 9
Views: 3832

TimeSheet Detail report not generating for 2 week daterange

Hi, We currently use TimeTrex Community Edition version v9.0.2-20151106-050132 And we having problems when creating reports under TimeSheet Detail via Excel Export. Please see screenshot below for the report settings: report_tab.png Display Columns: First Name Last Name Date First In Punch Last Out ...