오늘 무엇을 도와드릴까요?

Power Monitoring Expert HC EPSS report - when using the Generator Config Tool, the Run History does not populate when refreshed

Issue
The run report history does not populate when refreshed in the EPSS tool.

Product Line
Power Monitoring Expert 8.2
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
EPSS Report Generator Performance Configuration Tool

Cause
This can happen if Generator groups have the EPS_Available option selected. When the EPS_Available and the EPS_RUN measurement have the exact same timestamp in the database, the 'Refresh run history' button cannot populate the rung history as it can't gather information on that group.

Resolution
To fix this issue find the duplicate timestamps, and change the EPS_Available quantity to be slightly different. For example make the EPS_Available timestamp 1 second after the EPS_RUN measurement. The SQL query below will reveal the duplicate timestamps. Keep in mind that running this query on a large database could take a while to finish. This query will give a list of sources in the database with duplicate timestamps. From that list, one of the duplicate timestamps must be changed as described above.

USE ION_Data
SELECT * FROM
(

SELECT COUNT (*) AS duplicate, sourceID, TimestampUTC FROM datalog2

WHERE QuantityID IN (10950,11148)

GROUP BY SourceID, TimestampUTC

) AS Q

WHERE duplicate > 1

Once there are no longer duplicates, the run history will populate as expected.

To get rid of duplicates run the below script for each timestamp:

BEGIN TRANSACTION;

BEGIN TRY

USE ION_Data

DECLARE @Temp as DATETIME2 = '24-06-24 19:32:00.0000000' -- replace with timestamp from the script above

UPDATE Dbo.datalog2

SET @Temp = TimestampUTC = DATEADD(s,1,@Temp) -- increments EPS available by 1 second

where SourceID = 4 and QuantityID = 10832 and TimestampUTC = @Temp -- replace quantityID with the EPS available quantityID and the Source ID with the sourceID from the above script's output

END TRY

BEGIN CATCH

SELECT

ERROR_NUMBER() AS ErrorNumber,

ERROR_SEVERITY() AS ErrorSeverity,

ERROR_STATE() AS ErrorState,

ERROR_PROCEDURE() AS ErrorProcedure,

ERROR_LINE() AS ErrorLine,

ERROR_MESSAGE() AS ErrorMessage;

IF @@TRANCOUNT >0

ROLLBACK TRANSACTION;

END CATCH;

IF @@TRANCOUNT > 0

COMMIT TRANSACTION;

GO

게시 대상: 슈나이더 일렉트릭 Korea

게시 날짜:2020. 11. 26.최종 수정 날짜:2026. 4. 22.

제품군

Power Monitoring Expert 8.0

제품군

Power Monitoring Expert 8.0

도움이 필요하신가요?

제품 선택기

애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.

견적 받기

영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.

구매처

해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.

지원 센터

한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.

Power Monitoring Expert HC EPSS report - when using the Generator Config Tool, the Run History does not populate when refreshed

게시 대상: 슈나이더 일렉트릭 Korea

제품

지원

회사

빠른 링크

파트너

지속 가능성

이벤트

인사이트
opens new tab