ORA-12899: value too large for column "API_OTK "."OAUTH_CLIENT_KEY"."CALLBACK" (current: 3482, maximum: 2048

Products

• CA API Gateway

Issue/Introduction

After the our investigation on the following case provided no KB or similar doc from any of our sources (Communities, Tech Docs, etc) we are raising the case so you can provide the necessary help.

• Environment – Production
• Product version - 10.0

Bellow is the initial error :

"When writing trying to write a record to the GW database, we are getting the following error:

2022-04-11T11:26:45.486-0300 WARNING 815 com.l7tech.server.jdbc.JdbcQueryingManagerImpl: Failed to perform querying since [l7tech][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "API_OTK "."OAUTH_CLIENT_KEY"."CALLBACK" (current: 3482, maximum: 2048)

I would like to know if increasing the column in question from 2048 to 3500 or 4000 will not cause problems in the data recovery process at another time.

 

Environment

Release :

Component :

Resolution

the supported method is to change the size ,

mysql> ALTER TABLE otk_db.oauth_client_key MODIFY COLUMN callback VARCHAR(4096);

however do not support to change the data type from VARCHAR to CLOB