MicroStrategy - Force UTF-8 in Distribution Services

05 Feb 2022

Dificulty ★★★★☆

The error

When directly exporting report to text file it will be exported as ‘UTF-8’ but when using ‘Distribution Services’ it will be genereted as ‘UCS-2 LE BOM’ insted of ‘UTF-8’

For solution chose OS

Windows

Linux

1) Open Windows Registry, locate the following: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MicroStrategy\DSS Server\Castor\

2) Right clik and chose 'DWORD (32-bit) Value'

3) Enter "DSNotUseUnicodeForPT"

4) Set Value at 1

In the end it shud look like

1) In the MSIReg.reg file, locate the following: [HKEY_LOCAL_MACHINE\SOFTWARE\MicroStrategy\DSS Server\Castor]

2) Create an entry "DSNotUseUnicodeForPT "=dword:00000001
In the end it shud look like

"DSHostName"=""
"DSMaxConn"=dword:000003e8
"DSNumAggregateThreads"=dword:00000004
"DSNumDecompressThreads"=dword:00000001
"DSNumDeserializeThreads"=dword:00000004
"DSNumReceiverThreads"=dword:00000001
"DSPort"=dword:00007621
"HomePath"="/var/opt/MicroStrategy/IntelligenceServer"
"IgnoreAllExceptions"=dword:00000000
"MaintenanceModeEnabled"=dword:00000001
"ProcessAffinity"=""
"UseServerOSLocaleinFallback"="0"
"DSNotUseUnicodeForPT "=dword:00000001    

The Intelligence Server needs to be restarted for the changes to take effect