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.

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

book

Article ID: 239823

calendar_today

Updated On:

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

I have confirmed today , the supported method is to change the size ,

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

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