cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL Repository - Latin1 to UTF8

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

denis_konovalov
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

denis_konovalov
Active Contributor
0 Kudos

Yes, cmsdbsetup.sh is where it is found on *nix.

You select copy data source option, specify current DB as source and new utf8 DB as destination.

It should work

Former Member
0 Kudos

Hi Denis,

Thank you for this.  Will keep you posted on this matter.

Best regards,

Ron

Former Member
0 Kudos
  1. Yes. cmsdbsetup.sh is same as copydatasource in windows from CCM.
    • Navigate to the <InstallDirectory>/sap_bobj/
    • Stop the SIA,use ./ccm.sh -stop <sia name>
    • Execute ./cmsdbsetup.sh
    • Enter the SIA name (There must be atleast one Local CMS)
    • Choose the option 4 , i.e Copy
    • Select the database type of the Source CMS database.
    • Provide the Hostname and Credentials for the Source CMS database.
    • Select the database type of the Destination CMS database.
    • And provide the Hostname and Credentials for the Source CMS database.

Answers (0)