AMU - Process Troubleshooter - Timezone

Hi Satishkumar

This is strange, I tried to reproduce on my test server but it came up fine for me : the Start Time shows me 00:00 because my start-of-day setting is 0, and the End Time is my computer's time for both Today and Custom.

I have to ask what version you have. To know this you can go in Composer -> Manage (left menu) -> Installed Extensions -> select MnfgCommon_Extension -> look for the Package Version.

Second, I would like you to verify that your database is correctly set to UTC. If it's something else, it leads to some unexpected timezone issues like this. To check this, you can make this SQL query : SELECT GETDATE(), GETUTCDATE(). Both columns should be identical, if they're different then you have the issue. You can also try this query : SELECT CURRENT_TIMEZONE(); but this query doesn't always work depending on SQL version & permissions. I know there's also some UTC-related Thingworx setting required, but I'm much less familiar with that, if what we find today isn't enough then I'll try to get help for this.

Third, I want to check if the database is returning the expected results. The first step is to find the EquipmentUid (column Uid in the Equipment table) for one of the equipments having this issue. Then, execute this query (you need to change the 1st line) : 

DECLARE @EquipmentUidList NVARCHAR(MAX) = '123456789' -- CHANGE THIS
DECLARE @TimeRangeList NVARCHAR(MAX)
EXEC MnfgCommon_QuickTimeIntervalList_SP
	@op_TimeRangeList = @TimeRangeList OUTPUT,
	@p_QuickTimeIntervalUID = 3, -- 3=Today
	@p_EquipmentUIDList = @EquipmentUidList,
	@p_IsRoundingDown = 0
SELECT	[UID],
		StartTime,
		EndTime
FROM 	OPENJSON(@TimeRangeList, '$')
WITH
(
	[UID]		BIGINT		'$.UID',
	StartTime	DATETIME	'$.StartTime',
	EndTime		DATETIME	'$.EndTime'
)

This will return the results for Today, interpreted by the database. I expect the results should be Start=06:00 and End=now+06:00.