'Error operation can not be completed' on Reports

Topics brought up by the TimeTrex open source community.
Locked
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

'Error operation can not be completed' on Reports

Post by Batrams »

I'm running 7.1.2 Community Edition on a Centos 6 server. Reports work fine under the classic/legacy interface, but if I try to view a report on the new beta interface, I get the message 'Error operation can not be completed'. Does anyone know where I might find a solution?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

What report specifically are you trying to run?
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

I'm trying to reproduce the Wages Payable report that I use without issue from within the classic interface. My apache error log shows:

[Mon Sep 09 11:03:24 2013] [error] [client 192.168.X.100] PHP Notice: Undefined variable: columns_data in /var/www/html/TimeTrex/classes/modules/report/Report.class.php on line 2949, referer: http://192.168.X.250/TimeTrex/interface ... 1377554426

as well as

[Mon Sep 09 11:03:24 2013] [error] [client 192.168.X.100] PHP Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /var/www/html/TimeTrex/includes/global.inc.php on line 65, referer: http://192.168.X.250/TimeTrex/interface ... 1377554426
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

Without knowing the exact report that you are trying to run, we can't help you any further.
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

"Wages Payable Summary" is the name of the report that works under the classic interface but gives the error under the beta interface. That report lists the hours worked by each employee for regular time and overtime during a given pay period. Maybe I don't understand what you're asking - if not please elaborate so I can provide more detail.

"PHP Notice: Undefined variable: columns_data" seems like it may be a bug in the beta interface's code. If I'd made some invalid choice in the setup of the report, I'd expect it would have been caught by input validation instead of causing TimeTrex to stop responding and display the generic error message to the user.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

The new interface doesn't have any report by the name "Wages Payable Summary". Specifically what menu item are you trying to use to generate this report in the new interface, or if possible provide a screenshot.
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

Hi - As I mentioned, "Wages Payable Summary" is the name of the report which works in the *classic interface*, and I'm trying to reproduce that report in the beta interface. So far I've been unable to get *any* report to work in the beta interface.

Attached is a screen shot of my attempt to view a very simple report. Regular time, First name, Last name are what appear in the 'display colums'. The error message seems to remain for as long as I wait. Please let me know if you require any more details.
Attachments
Screen shot of error
Screen shot of error
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

Please enable debug logging as described near the bottom of this FAQ:
http://forums.timetrex.com/viewtopic.php?f=6&t=89

Then replicate the problem again and attach the log file here.
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

Log is here:
http://pastebin.com/UK12YACh

It contains a line similar to what my apache error log showed:

<b>Debug::ErrorHandler()</b>: PHP ERROR - NOTICE(8): Undefined variable: columns_data
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

The real error is this:
DEBUG [L3015] [441ms]: <b>Debug::Shutdown()</b>: PHP ERROR - FATAL(1): Call to undefined function mb_detect_encoding() File: /var/www/html/TimeTrex/classes/modules/company/CompanyFactory.class.php Line: 3015<br>
Please re-run the TimeTrex installer, it appears as though you are missing critical requirements for TimeTrex to operate and the Requirement Check page of the installer should tell you exactly what you are missing.
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

When I first installed there was no error. I re-ran the installer and it whined about permissions of the timetrex_cron_last_executed.log file, which I corrected. The installer was then happy and completed, however I'm still unable to get reports working.... I'm seeing the same behavior. Should I post another log?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

What version of PHP are you using?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 'Error operation can not be completed' on Reports

Post by shaunw »

Checking into this further, appears that you don't have the MBSTRING PHP extension installed, which seems quite strange as its usually included with virtually all Linux distributions out of the box.
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

I'm using a stock CentOS Linux 6.4 server. I did 'yum install php-mbstring' and that seemed to complete properly but my reports are still giving the same error. Should I maybe re-run the installer yet again? or post a new log?
Batrams
Posts: 45
Joined: Mon Aug 18, 2008 9:11 am

Re: 'Error operation can not be completed' on Reports

Post by Batrams »

I spoke too soon - maybe had to wait for a cron job to run. I tried again and now reports work. Thanks for the great support!
Locked