Why I am receiving BMXAA4049E - The value specified XXX exceeds the maximum field length in classicification.

Body

In Classification application create a Classification xx with 192 characters. Create another Classification yy with 192 characters. For classification yy set the parent as the classification xx and save. You will receive the above error. If ClassificationID is set to 192 characters. The ClassStructure.HierarchyPath field would have a larger length to allow the display of the ClassificationID plus the ancestor IDs in the path. If a Classification has created with a value that was 192 characters, then it would potentially not fit into the hierarchypath field when combined with the ancestors the hierarchypath length is set to 254.

This is by design not a bug. The reason of ClassificationID is set to 192 characters was from a requirement of Maximo add-on product.

1. Reducing the length of 192 of Classificationid is not possible which is a default field length of Classificationid . Because Maximo only allows configuring a field to a larger length not smaller. Also if a user actually has a classificationid up to 192, reducing it will cause user's data loss.

2. Increasing the length of HIERARCHYPATH of the CLASSSTRUCTURE table is possible because it is non-persistent. The length is currently 254 characters. This can be increased up to 4000 characters if necessary.