Description:

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.

1). Remove this record from the BC_KEYSTOREITEM table.
2). Restart the BC engine.

PGP Key pair creation failed with an ORA-00001 error.

BusinessConnect Trading Partner Admininstration Guide