3732180 - Error message contains garbled characters "######" in Analysis for Offcie

In a ABAP system, the default language is set as Japanese in Transaction code SU01. After inputting User and Password and keep Language field empty in AO's logon dialogue. The error message contains garbled characters.

Logon attempt failed. Either the logon credentials are wrong or the user is locked, or the user account is not in valid date, or the password is expired or the desired language is not available. Please check user account in backend system.##################### (############).

If Language filed is fuifilled with EN or JA, the error message displays without issue in AO.

SAP Analysis for Microsoft Office 2.8

1. Confirmed the default language is Japanese in Transaction code SU01.
2. Connect to the system via insert data source from AO.
3. Inputting User and Password in logon dialogue and keep Language field empty.
4. Click OK button, error message contains garbled characters  "######". 

Basically, when not providing a logon language, the default language will be used. However, when the default language is set as Japanese, If neither specifying a codepage for the communication, the default one will be used as well, which is 1100 and which cannot deal with Japanese characters. In other words, when the language field is left empty, SAP NCo falls back to codepage 1100. Codepage 1100 is the single‑byte Western European encoding (ISO‑8859‑1 / Latin‑1), which cannot represent Japanese characters. Because Latin‑1 can’t encode Japanese, any server text that contains Japanese (for example the “wrong password” error message) appears as unresolved or garbled characters in AO when the language field is empty and NCo uses codepage 1100.

Change the setting "UseUnicodeCodepageInNco" to true (or check in UI) as KBA 2083067 - How to maintain settings for Analysis Office.

If the setting is true, it will force NCo to use codepage 4103(Unciode), instead of 1100 to represent Japanese.

without providing a logon language, logon screen, empty, wrong passwords, incorrect, credentials, RfcLogonException, AfO, include#, Name or password is incorrect (repeat logon) , KBA , BI-RA-AO-XLA , Excel Addin , Problem