Symptom
From October 2020 onwards, Microsoft has decided to end the support of Basic Authentication Mode and only support OAuth 2.0 Authentication Mode. You would like to connect Process Integration (PI) or Process Orchestration (PO) to Microsoft Office365 using Mail adapter with OAuth 2.0 Authentication, but encounter the following error:
Key ID xxxxxxxxxxxxxxxx Refresh already exists in database: com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException:
Violation of PRIMARY KEY constraint 'PK__XI_AF_OA__xxxxx'. Cannot insert duplicate key in object '<Java Schema name>.XI_AF_OAUTH_CACHE'.
The duplicate key value is (xxxxxxxxxxxxxxxxxxxxx). OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]
Read more...
Environment
- SAP NetWeaver
- SAP Process Orchestration
Product
Keywords
Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, Process Orchestration 7.5, PI 7.5, PO 7.5, Mail adapter, OAuth Authentication, Microsoft, Outlook, Office365, Basic Authentication, XI_AF_OAUTH_CACHE , KBA , BC-XI-CON-MAI , Mail Adapter , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.