Hi,
Ive jsut finished instaling the new SAP BO 4.0 .
all working good , except the dashboard .
am facing problem using BO Dashboard 4.0 when using Query Builder :
Request processing failed. (XLS 000009)
Request processing failed. (XLS 000009) []<com.businessobjects.dsl.commons.exception.NestedException: Conversion from UTF8 to charset failed : Encoding not loaded>"
any clue why this error coming .
adilsami (BOB member since 2011-09-13)
Check your functions in the Excel…While mapping in to the Xcelsius there is something missing with in your Excel source file…
listener (BOB member since 2011-04-26)
the error comes up when using the QUERY BUILDER option on SAP DASHBOARD 4.0 … after selecting the universe & the requird dimension it gived the mentioned error …
adilsami (BOB member since 2011-09-13)
The above problem solved …
Resolution
Add “C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64” to the PATH environment variables on the SAP Business Objects Enterprise machine
Restart SIA where Dashboard Design Processing Server is registered
adilsami (BOB member since 2011-09-13)
Hi, I’ve already done this but the problem persists… 
I have to do anything else?
Thak you.
e.delacal (BOB member since 2012-01-18)
Hi e.delacal,
I am facing the same problem . Did you find a solution?
Thanks in advance,
Diana
dbvc (BOB member since 2009-09-14)
Hi,
I had the problem yesterday and I solved it, but I don’t know exactly how 
I’ve added …\win64_x64 (as suggested bby adilsami) and …\win64_x64\jdk\bin to the PATH of Windows.
With regedit, I have erased the content of the NLS_LANG key in 3 places:
All of this did not work at once, but it does now after a reboot of the BO server and a reboot of my computer. No time to do more testing.
If someone can isolate precisely the cause, I’m interested.
By the way, we’re all using Oracle, are we?
KFonMurphi 
(BOB member since 2007-10-16)
I have the same problem trying to query a unx universe with mono-source on an Oracle 11 connection.
But that works fine when querying another unx universe with multi-source on the same Oracle 11 connection + CSV/XLS connections…
I’ve added …\win64_x64 and …\win64_x64\jdk\bin to the PATH of Windows
I’ve installed SAP BI 4 SP2 Patch 12.
Is there any connection configuration difference between mono-source and multi-source unx ??
Modification of the post:
It’s working now… after rebooting the server.
The PATH modification seems to be suffficient.
jd.pro (BOB member since 2010-11-15)
error encountered Bus Obs 4 FP3…path added, reboot, problem solved. 
spoons 
(BOB member since 2012-06-26)
Hi,
We had the same issue and we find another solution.
This solution only work in case of client tools installation on the SIA server.
you have to add:
“C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86”
to the PATH environment variables.
I opened a ticket on SAP support and waiting an answer for this problem.
Regards,
prima (BOB member since 2011-11-18)
We are having same issue. We did add the path; reboot, started working fine. BUT next day the error is back ON.
Reboot again, it’s gone.
Next day back again…any solutions??
americanmc 
(BOB member since 2009-12-31)
Have you checked the maintenance tasks that occured on your serveur during the night?
There could be scripts that modify the PATH variable, that modify the Java environment, … and those tasks might be executed by other users with different configurations and rights.
jd.pro (BOB member since 2010-11-15)