Problem:
Getting Database Error BMXAA4211E While trying to save a work order
Steps to reproduce:
1) Create a new work order.
2) Enter the required information.
3) Save the work order.
The result is that following error is displayed:
"Database error occurred when operating on Workview : Record *** Class = *** and Site = ***. Report Error to the owner of deployment."
Cause
This is happening because there may already be existing records within the database that Maximo is unaware of. This can be very old data, and it can be data that was not used. The reason this error occurs is because Maximo is trying to write to the database and that record (the primary key value) already exists.
Resolving the problem
To resolve this issue, we suggest that you proceed to archive your data, and when doing so, you should select the option to remove the data that is being archived from the current database. When this is done, you should able to store the newly created work orders.
