Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel Reports Sent at Wrong Time
-
Hi,
First of all, I apologize if this has been solved already.
My problem is that I scheduled a report to be run every day in a MangoES, with the following cron pattern: 0 0 11 * * ?The strange thing that happens is that, even though the MangoES is in the correct time zone and displays the correct time and date, the report gets sent at 12:00 instead of 11:00, every day. Also, the email contents clearly show that it was scheduled for 11:00. Is this normal? What could I do to correct this 1-hour offset?
Thanks in advance.
-
Hi jflores,
Interesting! Can't say I can recall an issue anything like that. To recap, the report appears to have run at the right time with the right data but is taking an hour to appear in your email? The only way I would expect that behavior is if the report were taking an hour to finish, but that seems very long, or if the emails' timestamp is being viewed in a different timezone.
Is this Excel Reports or Reports ? What version? What timezone is it set to? What timezone are you in? If you have the report 'Run now' does it finish quickly?
-
Hey, @phildunlap.
No, it looks like it was run 1h afterwards. I am using the standard email template which includes the run duration, and since it is a very simple test report template, it only takes it under 2 seconds to complete. Last one took 1.92 seconds.
And well, I have been using the email when the report gets to me, and that happens exactly 1 hour after the schedule. It is the Excel reports module, v3.5.1. My user (which is the Superadmin and creator of the report) is set to America/Mexico_City, and I can see the CST abbreviation under the time and date on the menu side bar, which is correct.
And yes, that's also strange, if I run it with Run Now it gets generated and sent instantly.
What I initially thought was programming it for 1h before, but the information it generates would be lacking 1h. Also, the email would be wrong because it does display the correct Run Time Start.
It's as if the MangoES generated the report and just decided to wait exactly 1h to send it, but I am not sure if it generates it one hour later. I could check that out though, if it helps to bring more clarity to the issue.
Thanks!
-
My advice would be to log in via the ssh commandline and check the timezone there as well.
Data is stored as GMT/UTC and the settings apply that offset to show in the UI. I had the same issue when pulling data from API's using curl then forwarding the data into Mango. Meant I had to be more creative when I fired my script. Not sure if the mangoES units also set the linux OS timezone but it does not hurt to check, -
Hello, @mattfox .
I just checked the time zone via SSH and indeed it was set to Denver time (1 hour less) there. Then I used the SSH commands to change to the correct time zone via ~$sudo timedatectl set-timezone, and it worked! Now it displays the right time, which I'm sure will solve the issue.
Thank you so much!
-
Anytime!
-
@jflores13 said in Excel Reports Sent at Wrong Time:
Hello, @mattfox .
I just checked the time zone via SSH and indeed it was set to Denver time (1 hour less) there. Then I used the SSH commands to change to the correct time zone via ~$sudo timedatectl set-timezone, and it worked! Now it displays the right time, which I'm sure will solve the issue.
Thank you so much!
You should be able to set the timezone for the OS using the MangoES configuration module (look at the legacy UI system settings page - /system_settings.shtm)
-
@jared-wiltshire, that is true. This approach may be even more convenient and user-friendly, given that you don't need to log in via SSH and that you can see the available time zones as a drop down menu. Also, you can see the current time zone without the need of any command.
I was looking for that part and I was just able to find it as a submenu, in the System Settings accessed via the old menu (the one where you add and manage data sources). First, I was trying to add that particular module to my user's menu bar, but couldn't find the option, so I figured it might be there.
Anyways, this seems to work perfectly as well. Thanks!
-
This will be a handy post for those who are running cloud hosted solutions as there isn't a mangoES settings section for custom installs.
