IBM Support

BMXAA4049E - The Value Specified Exceeds The Maximum Field Length

Troubleshooting


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.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Prev Maint","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg22007194

Page Feedback