oauth2 Tokens Override

When oauth2 tokens from Boomi Cloud API Management – Local Edition 4.x are migrated to 6.1.0, then existing oauth2 tokens with overlapping id in Boomi Cloud API Management – Local Edition 6.1.0 database will be overwritten.

If you want to keep existing oauth2 tokens in Boomi Cloud API Management – Local Edition 6.1.0 database, then perform the following steps before using oauth2 in Boomi Cloud API Management – Local Edition 6.1.0.

Procedure

1. Run the following query in Boomi Cloud API Management – Local Edition 4.x database.

   SELECT MAX(id) from onprem.oauth2_access_tokens;
2. Run the following command in Boomi Cloud API Management – Local Edition 6.1 database.

   ALTER TABLE masherysolar.oauth2_access_tokens AUTO_INCREMENT=A_NUMBER_LARGER_THAN_MAX_TOKEN_ID_IN_ML_4X;