invalid_request error when registering new client

Products

• CA API Gateway

Issue/Introduction

After upgrading the OTK version to version 4.6.0, it is not possible to create a client from OAuth Manager.

Environment

Release : GW 10.1 / OTK 4.6.1

Cause

The mysql DB upgrade had not been applied completely. The script shipped was found to be failing midway due to “ERROR 1061 (42000) at line 27: Duplicate key name ‘ock_idx_expiration’“.

Resolution

Manually execute the SQL scripts which were skipped.

mysql> use otk_db;

mysql> CREATE INDEX ock_idx_expiration ON oauth_client_key (expiration);

mysql> CREATE INDEX oat_idx_rexpiration ON oauth_token (rexpiration);

mysql> CREATE INDEX oin_idx_expiration ON oauth_initiate (expiration);

mysql> CREATE INDEX odin_idx_expiration ON oauth_device_initiate (expiration);

mysql> CREATE INDEX ose_idx_expiration ON oauth_session (expiration);

CREATE INDEX oaidt_idx_jwtid ON oauth_id_token (jwt_id);