Page 1 of 1

GMT Offset not working for latest uploaded list

PostPosted: Thu Feb 15, 2018 7:39 am
by jlam1021
Hello,
We have had vicidial in place for quite a while with absolutely no issues. On average we upload a new lead list every 3 months with about 100k leads in different time zones in the US. The server GMT is -6 and all of the times match for the server
SERVER - DESCRIPTION IP ACT LOAD CHAN DISK TIME VER
jlam Server jlam Y 0 - 0% 0 3% 2018-02-15 06:23:08 2076
PHP Time 2018-02-15 06:23:08
DB Time 2018-02-15 06:23:08

We are currently on Central time (US) GMT -6

The current lead list that we uploaded contains several leads from California - GMT -8 and our call center starts their dialing at 8:30am CST.

The dialer keeps dialing the California leads at 8:30 am CST even though the call time for california is set to 9am - which if I understand correctly is 9am PST

As far as I can tell the time zones are correct in the list
TIME ZONES WITHIN THIS LIST:
GMT OFFSET NOW (local time) CALLED NOT CALLED
-10.00 (Thu 15 Feb 2018 02:29) 0 64
-9.00 (Thu 15 Feb 2018 03:29) 0 16
-8.00 (Thu 15 Feb 2018 04:29) 1709 40991
-7.00 (Thu 15 Feb 2018 05:29) 4 402
-6.00 (Thu 15 Feb 2018 06:29) 29 14317
-5.00 (Thu 15 Feb 2018 07:29) 277 40505
-4.00 (Thu 15 Feb 2018 08:29) 1 32
SUBTOTALS 2020 96327
TOTAL 98347

The list is set to check time zone by country code and area code

Steps taken so far
Deleted the original list and reuploaded
Changed check timezone to postal code
Ran ADMIN_adjust_GMTnow_on_leads.pl manually - This is also running in cron
Verified that country code is set correctly in list in mysql
Rebooted the server
Currently as temporary solution I am switching the list order in the campaign - alternating between up and down to avoid dialing California leads too early

Any suggestions on what needs to be done to fix this?
Thanks!
John
Vicidial VERSION: 2.8-426a | BUILD: 140214-1643 | single Server | Intel(R) Xeon(R) CPU Quad Core L5320 1.86GHz |16gb Ram

Re: GMT Offset not working for latest uploaded list

PostPosted: Thu Feb 15, 2018 8:59 am
by mflorell
I'm not positive, but it's possible there is a bug related to this in the last 4 years that addressed this issue. As always, we recommend upgrading to a more recent version of VICIdial.

Aside from that, did you check the Call Time you have set for the campaign?

Re: GMT Offset not working for latest uploaded list

PostPosted: Thu Feb 15, 2018 12:27 pm
by jlam1021
Yes Call time is set to 9am for California and it starts calling them at 8:30am Central time which of course is 6:30am California.
What is strange is that we have never had any issues to date with call times...
Is there a step by step article to upgrade this version?
Thanks
John

Re: GMT Offset not working for latest uploaded list

PostPosted: Thu Feb 15, 2018 6:56 pm
by williamconley
Please post all the time settings on the server. Including (but not limited to):

Bottom frame from "Reports" after pushing the +/- next to the word "SERVER" which will show PHP and DB time.

Also show the settings for php.ini and mysql if you have set it.

Please also type "date" at the CLI and confirm the server's TZ and time are correct. Servers *do* get out of sync from time to time.

Also confirm the TZ on one of the leads that was called incorrect and confirm that it is set to the proper value, as this obviously matters.