My Oracle Support Banner

X1-MIGSM DM Batch Cannot Create Device Installation Event Due To Error "Duplicate Key Error: %" (Doc ID 2880665.1)

Last updated on SEPTEMBER 23, 2022

Applies to:

Oracle Utilities Customer Cloud Service - Version 22A and later
Oracle Utilities Customer to Meter Base - Version 2.9.0.0.0 to 2.9.0.0.0 [Release 2.9]
Information in this document applies to any platform.

Symptoms


X1-MIGSM DM batch cannot create Device Installation Event due to error "Duplicate key error: %"

Duplicate records are inserted into D1_ON_OFF_HIST when Install Event has CCB On/Off History with Sequence=0, and there is another record of On/Off History with Sequence=1.

Table D1_ON_OFF_HIST primary keys are Install Event ID and Sequence No.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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