IBM Support

BMXAA4049E - The value specified exceeds the maximum field length

Technical Blog Post


Abstract

BMXAA4049E - The value specified exceeds the maximum field length

Body

Problem:
Error in Preventive Maintenance application while trying to run Forecast Generation in the background.


Symptom:

Steps to replicate:

1. Go to Preventive Maintenance application.

2. Select 150+ PM records.

3. From More Actions, click on Generate Forecast.

4. From Generate Forecast dialog, enter the following and click OK:
Forecast For (Days) = 90
Run Forecast Generation in the Background? = Yes

At this point, system throws the message "BMXAA4049E - The value specified exceeds the maximum field length that is allowed for this attribute: Value = (siteid= 'XXXX' and pmnum= 'XXXX1' ) or (siteid= 'XXXX' and pmnum= 'XXXX2' )..., Object Name=MAXASYNCJOB, Attribute Name=WHERECLAUSE, Maximum Length=4,000.".


Cause:
This happens when too many records are selected.  The system throws the BMXAA4049E message in order to prevent performance issues.


Resolving the problem:
The recommended solution is to generate the PM Forecast using PMForecastCronTask.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11112385