BMXAA4049E - The value specified exceeds the maximum field length

August 11, 2017 AliceDegawa

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.

Previous Article
Looking for Feedback

  Here’s your chance to provide IBM some direct feedback – please take a few minutes to answer 10 questions...

Next Article
Maximo Asset Management 7.6.0.8 Interim Fix 002 released - do not use

Update 31 August: Do not download. A new Maximo Asset Management 7.6.0.8 Interim Fix will be released short...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!