Cannot reject API Plan request -- reject reason size limit

Products

• CA API Developer Portal

Issue/Introduction

You are seeing a problem while rejecting a request for API Plan change on API Portal Classic 3.5. The requests are still in the queue even they were rejected.

You found some hibernate errors in catalina.out in the time of rejecting the requests.

The catalina.out shows an error:

10/29 11:12:45.153 ERROR (http-nio-37080-exec-2:) - Data truncation: Data too long for column 'errorMsg' at row 1

10/29 11:12:45.154 ERROR (http-nio-37080-exec-2:) - [PlanRequestXS general] -- org.hibernate.exception.DataException: could not execute statement

        at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:71)

...

        at com.thelevel.lrs.bm.PlanRequestXS.rejectRequest(PlanRequestXS.java:211)

...

        at java.base/java.lang.Thread.run(Thread.java:844)

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'errorMsg' at row 1

Environment

• Release : 3.5
• Component : API PORTAL

Cause

When rejecting the request, input a message of reject reason, the message has 377 characters.

However, the column 'errorMsg' only allow 255 characters.

Resolution

The rejecting reason has 255 length limit