Installation Event For ON Scenario Not Created After X1-MIGSM Job Due To W1-PrEqptMnt / Sync Request (Doc ID 2888023.1)

Last updated on JUNE 03, 2024

Applies to:

Symptoms

On : NA version, Environment Related

Installation Event for ON scenario not created after X1-MIGSM job due to W1-PrEqptMnt / Sync Request

Converting the legacy Service Point Meter History for Meter ID is 0301335523. 60% of the total 4.6 million SP/Meter Histories are impacted.

Batch X1-MIGSM ended with error.
Device Installation Event is not created after running X1-MIGSM SP/Meter Installation migration job. The Batch Run Tree presents no specific error message. Upon reviewing the logs, the error message found was "List has 2 references with the same keys [2017-12-03-00.01.00 %7 %9]."

After investigation, it was observed that the error happened on the Service Script W1-PrEqptMnt (Process Equipment Movement). This Service Script was called by the Plug-In Script W1-UPDASTND (Update Asset-Node Data) from the W1-OngoingSyncRequestAssetNode BO.

The script W1-PrEqptMnt was attempting to add another record in the list of Asset Disposition on Step 60 based on the parameters sent by the calling script, the Plug-In Script W1-UPDASTND. On the same step mentioned, there is a validation that checks if that record being added is already in the list by using the attachedToAssetId field.

However, the record being added is already existing in the list and the check using the attachedToAssetId field is not applicable to this scenario. The parameters sent by Plug-In Script W1-UPDASTND has no value for the attachedToAssetId field. Thus, it cannot determine that the record is already in the list.

Upon further investigation, it was found out that the attachedToAssetId field is populated by the Script D1-Det-AsMvt (Determine If Asset Movement Occurred) from the D1-InstallEventSyncRequest BO. It will populate the attachedToAssetId field for scenarios with secondary device.

This issue is applicable for Meters that are ON according to the CI_SP_MTR_EVT and has no secondary device.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.