SAP Knowledge Base Article - Preview

3283559 - Cannot insert duplicate key in object XI_AF_OAUTH_CACHE while using Mail adapter with OAuth 2.0 Authentication

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

SAP NetWeaver 7.5

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.