How To Check BO Table Primary Key Sequence And Match To Next ID When VB Application BO data Restored From ATP Backup (Doc ID 2926258.1)

Last updated on FEBRUARY 10, 2023

Applies to:

Symptoms

Accidentally deleted a Live application which is using BYODB(Bring Your Own Data Base) with VB( Visual Builder) Instance.
Created a new application and data was recovered from DB backup.
When inserting any data into BO it is failing with

"Uniqueness Violation"{
 "type": "vbcs://businessObjects/data/uniquenessViolation",
 "title": "Bad Request",
 "status": 400,
 "o:errorDetails": [ { "title": "Uniqueness Violation", "detail": "Non-unique values found for Id", "o:abcs-error-type": "UniquenessViolationException", "o:errorCode": "ORA-00001", "o:abcs-entity-id": "XXMIL_INS_PI_LINES_ALL", "o:errorPath": "/id", "o:abcs-property-id": "id" } ]
}

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.