MIF data loading results in description field with invalid ??? characters
lanxpham 270003YRBB Visits (8077)
At times, when trying to upload some simple data such as a location into Maximo, you might encounter this abnormal display behaviour as seen below with the description.
1. You have checked and the import file used does not have these visible characters.
2. You have also ensured there were no errors were encountered with the upload.
If you enable root loggers SQL = INFO and INTEGRATION =DEBUG you will notice the following value gets bound to the description.
Notice the funny odd square character instead of the expected space, which eventually displays as "?" in your UI?
So, Why does this happen?
Hope you have found this information useful in helping identify why you get invalid characters when trying to upload data into Maximo.
Happy Uploading! :)