PGIM 5.1.1 Excel 2010 DST error for totalizers
While running PGIM 5.1.1 report scheduler, the automatic report in Excel 2010 was calculating an error after the March 7th, 2020 DST change. Reboot the PGIM server and manual running the reports corrected the issue for the totalizer. But the report scheduler that runs at midnight starting having the error in the totalizer again. The Start_Time is midnight and End_Time is cell +1. (shown below).
SCHEDULER_VARIABLE VALUE
PGIM_REPORT_START_TIME 24/05/2017 00:00:00
PGIM_REPORT_END_TIME =B5+1
The formula for the toalizer hasn't changed and is based on 1 day (min/max) of two associated cells (formulas are below).
='C:\Users\toota\AppData\Roaming\Microsoft\Excel\XLSTART\PGIM-Report.xlam'!pgim
_get_values('$PGIM_CONFI'!$A$31,"MIN,MAX",'$PGIM_CONFI'!B5,'$PGIM_CONFI'!B6,"PC
LT",2,2,0,"1 day",,"0A")
='C:\Users\toota\AppData\Roaming\Microsoft\Excel\XLSTART\PGIM-Report.xlam'!pgim
_get_values('$PGIM_CONFI'!$A$31,"MIN,MAX",'$PGIM_CONFI'!B5,'$PGIM_CONFI'!B6,"PC
LT",2,2,0,"1 day",,"0A")
So did a patch for Excel correct the DST issue for 2020 or is PGIM connection an issue. This is running on the PGIM Server.
Any help is appreciated,
Thanks in advance.
SCHEDULER_VARIABLE VALUE
PGIM_REPORT_START_TIME 24/05/2017 00:00:00
PGIM_REPORT_END_TIME =B5+1
The formula for the toalizer hasn't changed and is based on 1 day (min/max) of two associated cells (formulas are below).
='C:\Users\toota\AppData\Roaming\Microsoft\Excel\XLSTART\PGIM-Report.xlam'!pgim
_get_values('$PGIM_CONFI'!$A$31,"MIN,MAX",'$PGIM_CONFI'!B5,'$PGIM_CONFI'!B6,"PC
LT",2,2,0,"1 day",,"0A")
='C:\Users\toota\AppData\Roaming\Microsoft\Excel\XLSTART\PGIM-Report.xlam'!pgim
_get_values('$PGIM_CONFI'!$A$31,"MIN,MAX",'$PGIM_CONFI'!B5,'$PGIM_CONFI'!B6,"PC
LT",2,2,0,"1 day",,"0A")
So did a patch for Excel correct the DST issue for 2020 or is PGIM connection an issue. This is running on the PGIM Server.
Any help is appreciated,
Thanks in advance.
Answers
Hi;
Did you check the time zone file configuration? Does the Time zone setting on scanner and history server nodes the same?
In order to ensure a correct summer/winter time conversion of the archived measured values over a longer period, the data of time changeover must be stored on each client for the coming and past years.
This is done in the file:
…\PlantConnect.SYS\SysKonfi\TimeZone.txt
Verify that the TimeZone file has the same configuration in each node.
Regards
Did you check the time zone file configuration? Does the Time zone setting on scanner and history server nodes the same?
In order to ensure a correct summer/winter time conversion of the archived measured values over a longer period, the data of time changeover must be stored on each client for the coming and past years.
This is done in the file:
…\PlantConnect.SYS\SysKonfi\TimeZone.txt
Verify that the TimeZone file has the same configuration in each node.
Regards
Add new comment