Length limit for "message" field in an alarm ingest through RESTmon 2.1

Products

• DX Operational Intelligence
• CA Application Performance Management SaaS
• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• CA Application Experience Analytics SaaS (AXA)
• DX Application Performance Management

Issue/Introduction

What is the length limit for "message" field in an alarm ingest through RESTmon 2.1?

 

Environment

Release : 21.3

Resolution

Even though the length of the message field in DX OI is practically unlimited, there is a limitation in RESTmon 2.1 as this version uses a database.

That is the reason for the error message:

 [pool-5-thread-5] ERROR DoiPublisher:120 - Exception: failed to send alarms to DOI.
java.sql.BatchUpdateException: data exception: string data, right truncation;  table: PUBLISHED_ALARM_ATTRIBUTES column: ATTR_VALUE

On the other hand, RESTmon 2.2 does not make use of a database so it does not have this limitation.

The recommendation then is to upgrade RESTmon to 2.2.1 which is the latest version available at the moment of publishing this article.