on 09-19-2013 2:32 AM
Hi All,
I am trying to troubleshoot an installation of BusinessObjects BI Platform 4.0 where the repository database is MySQL.
The problem is that when opening a report in the BI Launch Pad using WEBI, the values are not displaying properly.
Our team investigated and we found out that the repository tables in MySQL are in Latin1 when it should be UTF8. (According to this: http://wiki.scn.sap.com/wiki/display/BOBJ/How+to+Install+and+Configure+a+MySQL+Database+for+BI)
Is there a way for us to convert those repository tables to UTF8? Is it safe to export the data of the repository tables and use a tool such is ICONV in Linux to convert to UTF8 and import again?
Please help.
Thanks in advance and best regards,
Ron
Converting DB tables in a MySQL databases question should be asked in the MySQL vendor support organization.
From the perspective of BI4.0 product, why don't you simply create a new Unicode MySQL database and use Copy Data Source functionality to transfer your existing CMS DB to the new database ?
See admin guide for details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Denis,
Thank you for giving this suggestion.
I have a question, though.
Is the Copy Datasource functionality similar to using cmsdbsetup.sh in Linux?
If so, should I use Update (Option 6) or Copy (Option 4)? (From Section 10.1 of BIP Admin Guide)
Also, will the be converted as well to UTF-8 when I choose any of the two options?
If not, where can I find the Copy Datasource functionality?
Thanks In advance and best regards,
Ron
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.