OEM 13C : Fleet Patching and Provisioning fppSeriesOptIn Fails With Error "Error occurred while opting-in the series. ORA-02291: integrity constraint (SYSMAN.DB_GI_VER_PROPERTIES_FK2) violated "
(Doc ID 2965991.1)
Last updated on AUGUST 31, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control, Fleet Patching and Provisioning(FPP), fppSeriesOptIn is used to register the series created using FPP and use them as fleet gold images fails with below error.
https://xxx.com:6021/em/api/goldImages/actions/fppSeriesOptIn
{
"failed": 1,
"successful": 0,
"total": 1,
"items": [
{
"code": 0,
"seriesId": "F38FF654EC945ECAE0533F1F4B640286",
"seriesName": "DB_1914OPTIN_SERIES",
"serverName": "<Server Name>",
"message": "Error occurred while opting-in the series. ORA-02291:
integrity constraint (SYSMAN.DB_GI_VER_PROPERTIES_FK2) violated - parent key
not found\nORA-06512: at \"SYSMAN.GP_DB_INTSDK_GIS_METADATA\", line
174\nORA-06512: at \"SYSMAN.EM_GOLD_IMAGE\", line 3541\nORA-06512: at line
1\n"
}
]
}
emoms.trc
023-01-15 10:21:42,101 [[ACTIVE] ExecuteThread: '9' for queue:'weblogic.kernel.Default (self-tuning)'] ERROR
fppSeries.FPPSeriesServiceHandler logp.251 - Error occured while opting-in F24B3488712755E5E053D5044B642B5B
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (SYSMAN.DB_GI_VER_PROPERTIES_FK2) violated - parent key not found
ORA-06512: at "SYSMAN.GP_DB_INTSDK_GIS_METADATA", line 174 ORA-06512: at "SYSMAN.EM_GOLD_IMAGE", line 3541 ORA-06512: at line 1
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |