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

The Interim Fix (IFIX) is available at Fix Central.   As with all IFIXes, MAM 7608 IFIX 002 is cumulative a...

×

Want our latest news? Subscribe to our blog!

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