ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error 300 in OAuth Manager - Client(_id) value could not be persisted

book

Article ID: 223960

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

Error Showed when trying to upgrade OTK 4.2 and API Gateway 9.3 to the newest versions of all. At this moment we  are facing problems to create new otk clients. this error is displayed:

 

 

OAuth Manager Shows - Client(_id) value could not be persisted

 

 

Environment

Release : 9.4, 10.x

Component : API GATEWAY

Resolution

1. From otk_db check the index status 

SELECT TABLE_NAME, INDEX_NAME, STATUS, LAST_ANALIZED
FROM otk_db;

Before 

TABLE_NAME                INDEX_NAME                                   STATUS             LAST_ANALIZED 

OAUTH_ID_TOKEN       OAIDT_IDX_AZP                               UNUSABLE         ${not_Today}

OAUTH_ID_TOKEN       OAIDT_IDX_EXPIRATION                 UNUSABLE        ${not_Today}

OAUTH_CLIENTE_KEY   OCK_IDX_CLIENTIDENT                UNUSABLE        ${not_Today}

OAUTH_ID_TOKEN       PK_MAG_ID_TOKEN                         UNUSABLE        ${not_Today}

OAUTH_CLIENT_KEY     SYS_COO7744                                UNUSABLE        ${not_Today}

 

2. Make a DB backup. (Always a good practice before updating any entry in the otk_db or ssg database)

3. Stop the ssg service grom ssg Menu [option 2 then option 7) Manage CA API Gateway status ]


4. On the database side, use otk_db , rebuild the affected index(es) using the command below as an example:

alter index <index name> rebuild;

For example, the index OAIDT_IDX_AZP  would be rebuilt using:

alter index OAIDT_IDX_AZP  rebuild;

5. Start the ssg service from ssg Menu [option 2 then option 7) Manage CA API Gateway status ]

 

6. Check the Index again to confim all is fixed

SELECT TABLE_NAME, INDEX_NAME, STATUS , LAST_ANALIZED FROM otk_db; 

TABLE_NAME                INDEX_NAME                                   STATUS        LAST_ANALIZED

OAUTH_ID_TOKEN       OAIDT_IDX_AZP                              VALID            ${TODAY}

OAUTH_ID_TOKEN       OAIDT_IDX_EXPIRATION                VALID           ${TODAY}

OAUTH_CLIENTE_KEY   OCK_IDX_CLIENTIDENT              VALID            ${TODAY}

OAUTH_ID_TOKEN       PK_MAG_ID_TOKEN                       VALID            ${TODAY}

OAUTH_CLIENT_KEY     SYS_COO7744                              VALID            ${TODAY}