Cube refresh failed with Essbase Cube: Cube Name, Error code: 1060374 - Fix/suggestion

A quick one that took a while to fix the issue, assuming it helps the needy.  

The customer was running on EPBCS on version latest version. While running the database refresh it did throw the following error message, 

Cube refresh failed with Essbase Cube: Cube Name,

Error code: 1060374, Message: Error XML Exception: invalid character 0x1A in attribute value 'mbrName'

I did find an Oracle Document for the same issue, but it did ask to check the file encoding of the file that is uploaded to update the metadata. But seems the metadata was run before and Refresh Database was never run.

One of my collogue who actually did the metadata update helped me to fix the issue.

So the issue is there were unrecognized characters in the member name or on the alias of dimension members was causing the issue. In our case, it was something like the below, 

The unrecognized characters were displayed as SUB in notepad ++. It was displayed as a '[]' box in EPM. We deleted all these characters and did a Database Refresh, it did go through fine. 

So if you come across the same error try verifying the new dimension members that were loaded recently and look for any unrecognized characters, if found try deleting them and make sure you advise the team who provides those extracts to avoid those characters. 

Hope this was useful.

Cheers!!!!