PGP Key pair creation failed with an ORA-00001 error.
Article ID: KB0093191
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect | - |
| Not Applicable | - |
Description
Description:
Symptoms:
While creating a PGP key pair in the host credentials tab, if the "Save" button is not pressed before leaving the credentials page, the record gets added into the BC_KEYSTOREITEM table. However, the PGP key doesn't appear on the host credentials page.
Cause:
In this case, the BC_KEYSTOREITEM table shows the record with the same alias under the column OBJNID. If you try recreating the PGP key pair under the host credentials tab, the Administrator will try to add another record in BC_KEYSTOREITEM with the same alias name, which will result in a "PGP Key pair creation failed. ORA-00001: unique constraint (TIBBC6RUNTIME_DEV.BC_KEYSTOREITEM_U_1) violated" error.
While creating a PGP key pair in host credentials tab, the following error occurs:
"PGP Key pair creation failed. ORA-00001: unique constraint (TIBBC6RUNTIME_DEV.BC_KEYSTOREITEM_U_1) violated."
Symptoms:
While creating a PGP key pair in the host credentials tab, if the "Save" button is not pressed before leaving the credentials page, the record gets added into the BC_KEYSTOREITEM table. However, the PGP key doesn't appear on the host credentials page.
Cause:
In this case, the BC_KEYSTOREITEM table shows the record with the same alias under the column OBJNID. If you try recreating the PGP key pair under the host credentials tab, the Administrator will try to add another record in BC_KEYSTOREITEM with the same alias name, which will result in a "PGP Key pair creation failed. ORA-00001: unique constraint (TIBBC6RUNTIME_DEV.BC_KEYSTOREITEM_U_1) violated" error.
Issue/Introduction
PGP Key pair creation failed with an ORA-00001 error.
Resolution
1). Remove this record from the BC_KEYSTOREITEM table.
2). Restart the BC engine.
This will resolve the issue and will allow you to create a PGP key pair under the host credentials tab.
2). Restart the BC engine.
This will resolve the issue and will allow you to create a PGP key pair under the host credentials tab.
Additional Information
BusinessConnect Trading Partner Admininstration Guide
Feedback
Yes
No
Powered by
