We have a user that is getting this error when connecting to HFM from SmartView: XML Load Error: Invalid xml declaration. She gets this error even on a new blank Excel sheet.
She can connect to Essbase via SmartView and can also run reports in Workspace that connect HFM. Other users can log in to SmartView on her machine, so it seems like an issue on her user. I thought it might be a POV issue so I created a worksheet that contained all dimensions on the sheet (empty POV window) and she still got the error trying to connect to that. We also double checked all her Smart View options and those are set correctly.
We recently upgraded to version 18.104.22.168 (22.214.171.124.310 for SmartView). Can anyone provide any help?
Did you say that other users are able to login to HFM from her machine but it seems to be an issue with her id,
Then try creating a native id for her with required provisions to see if she is able to login with native id then it needs her domain id profile reset before going that try repairing the SmartView and check if that works !!!
The following (not limited though) may be identified as possible causes for POV corruption:
- Expired information stored in user's internet browser cache
- Corrupt information stored in USERPARAMS table in the HFM repository database
- Metadata changes may cause a previously valid Point Of View (POV) to become invalid.
When that invalid POV is currently stored against the user preferences in the database the error may occur.