Error: BMXAA0667E - The value of the changed attribute could not be assigned.
I faced this error, when trying to update length of one field in INVENTORY table. The field which I am trying to update length is a same as object and same as attribute in INVVENDOR table. So I started investigating INVVENDOR table, then I found below cause.
In my environment, problem is, INVVENDOR has a audit table A_INVVENDOR, but audit enabled is unchecked.
While investigating, found that, audit table A_INVVENDOR details available in MAXATTRIBUTECFG and MAXATTRIBUTE tables, but A_INVVENDOR table itself not exist.
Note: Before doing below changes, make sure you have backup of database. And better try in your development environment first.
Steps:
1. In database configuration, INVVENDOR table, make sure audit is disabled and audit table field is blank. In my case, audit enabled is false, but audit table field has value A_INVVENDOR. To remove, audit table field (it is read only), first check the check box of audit enabled, it makes audit table field editable. Now remove value of audit table field and uncheck audit enabled field. Save the record.
2. Apply configuration changes. It will remove A_INVVENDOR meta data available in MAXATTRIBUTECFG and MAXATTRIBUTE tables.
3. Now, change the length of the required field in INVENTORY table and save the record. Error will not occur.
I faced this error, when trying to update length of one field in INVENTORY table. The field which I am trying to update length is a same as object and same as attribute in INVVENDOR table. So I started investigating INVVENDOR table, then I found below cause.
In my environment, problem is, INVVENDOR has a audit table A_INVVENDOR, but audit enabled is unchecked.
While investigating, found that, audit table A_INVVENDOR details available in MAXATTRIBUTECFG and MAXATTRIBUTE tables, but A_INVVENDOR table itself not exist.
Note: Before doing below changes, make sure you have backup of database. And better try in your development environment first.
Steps:
1. In database configuration, INVVENDOR table, make sure audit is disabled and audit table field is blank. In my case, audit enabled is false, but audit table field has value A_INVVENDOR. To remove, audit table field (it is read only), first check the check box of audit enabled, it makes audit table field editable. Now remove value of audit table field and uncheck audit enabled field. Save the record.
2. Apply configuration changes. It will remove A_INVVENDOR meta data available in MAXATTRIBUTECFG and MAXATTRIBUTE tables.
3. Now, change the length of the required field in INVENTORY table and save the record. Error will not occur.
4 comments:
Even, I have faced such issues in my work environment where multi-language and multi-locale are installed.
This error comes when you have issues with Maximo Meta Data. This is why, it's always recommended to run integrityChecker on your maximo environment on a regular basis.
In my case multi-locale was giving pain.
Thanks Sourabh for providing valuable information.
In our case, there was an object for an interface table defined in Database Configuration, but the table from the database had been dropped.
Thanks for info!
Post a Comment