A black diamond with a question mark in Web Intelligence Bi Launch Pad

[astudillo]

Dear All,

Please ,we have in BI launch pad , Web Intelligence a webi report where the Report Filter values are shown with black diamonds with a question mark mixed with the values of the fields of the tables as you can see in the screen shot attached

In the database tables those fields of the report filters are shown correct with out diamonds .

In Web Intelligence Rich Client those fields of the report filters are shown correct with out diamonds too

We use MySql 5 and BO SAP 4.2

In Bi Launch pad "Preferences", view is configured as HTML

Do you know please the cause of these Diamonds ? and how to fix the issue

I have found this sap answer -> https://apps.support.sap.com/sap/support/knowledge/en/2403492

but I cannot log in this page

Thanks in advance

Best Regards

Antonio

[denis_konovalov]

I have removed the image you provided as it contained private information which you should not share on public forums. (like server names or report data)

[ayman_salem · Accepted solution]

From your description, and as you mention, this works correctly with BI Richt Client, then the problem on the server.

and since your BI is installed on Unix and you are using the ODBC driver, I think the problem is with the version of the ODBC driver installed on your Unix system.

my proposition:

- Check another report on a different database with a different DB driver than ODBC (like Oracle with the Oracle client).

- Check whether the BI server (under Unix) is correctly installed with the UTF8 locale.

[astudillo]

Solution :

DriverUnicodeType=1

[ayman_salem]

The problem is that your browser (IE) is using the wrong character set.

For information on solving for IE, see https://docs.microsoft.com/en-us/troubleshoot/browsers/wrong-character-set-for-html-page

also, Try a different browser (Chrome or Firefox)

[astudillo]

I am using Google Chrome not IE,

please see screen shot

Thanks

[ayman_salem]

Have you tried a different browser and client system (windows system)?

Also, check which code page is being used on the server.

[astudillo]

The same problem is in IE and in Google Chrome .. please see screen shot

Bo server is installed in Unix but I start login in Bi Launch Pad in a browser IE or Chrome which is installed in windows

As you can see in the screen shot

The problems of Black Diamond with Question marks appear only in the values of the Report Filters which are data types STRING

Please you wrote: Also, check which code page is being used on the server. Could you explain me more your question?

Which code page should be installed in the BO SERVER ? I have not configured the BO SERVER

Do you think , charset in MYSQL could be the reason of the problem?

or the type of ODBC DRIVER (unicode type 1)???

The database is Mysql 5

We use in preferences (Web Intelligence) in Bi launch pad HTML ,

Do you think if We change HTML to Applet (VJM) the problem wil be solved ?

Thanks

[ayman_salem]

From your description, and as you mention, this works correctly with BI Richt Client, then the problem on the server.

and since your BI is installed on Unix and you are using the ODBC driver, I think the problem is with the version of the ODBC driver installed on your Unix system.

my proposition:

- Check another report on a different database with a different DB driver than ODBC (like Oracle with the Oracle client).

- Check whether the BI server (under Unix) is correctly installed with the UTF8 locale.

[astudillo]

es the same report works correctly with BI Rich Client , the problem is on the server.

Following your questions:

Check another report on a different database with a different DB driver than ODBC (like Oracle with the Oracle client).

I have checked and it works with another database and another odbc driver

PLEASE SEE ATTACHED THAT THE PROBLEM IS ON SERVER (BI LAUNCH PAD WEB INTELLIGENCE) WITH THE REPORT FILTER VALUES , STRING VALUES , NUMERIC VALUES ARE SHOWN CORRECTLY . IF WE PUT THE SAME FIELD OF THE TABLE THAT IS USED FOR THE REPORT FILTER ON A TABLE , THE VALUES IS SHOWN WITH DIAMONDS AND QUESTIONS MARKS, THE STRING DOES NOT APPEAR WITH ALL THE CHARACTERS , THE STRING IS CUT WHEN THE DIAMOND APPEAR . PLEASE SEE FIELD -> "SEGMENTO" IT IS SOMETHING VERY STRANGE

Check whether the BI server (under Unix) is correctly installed with the UTF8 locale.

Please let me add the configuration on the BO server below :

DSN ->CLOUD_SQL_BO

Driver = /opt/mysql-connector-odbc-5.3.13-linux-el7-x86-64bit/lib/libmyodbc5w.so

Description = Connector/ODBC 5.3 UNICODE Driver DSN unicode type 1

SERVER = ******************

PORT = 3306

USER = ************* Password = ***********

Can you see anything wrong ?

I attached you the ODBC driver configuration on local , in windows , for the relational connection (IDT) between IDT and the DATABASE MySQL ,please see screen shot

The version of the driver is 5.3.13 IN BOTH systems windows and unix , just in windows is 32 and in unix is 64 bits

We use in preferences (Web Intelligence) in Bi launch pad HTML ,

Do you think if We change preferences (Bi Launch Pad) HTML to the another option Applet (Virtual Java Machine ) the problem wil be solved ?

Thanks in advance

[ayman_salem]

so, the problem is with the MySQL ODBC that you use.

see KBA

2054107 - Double byte characters are displayed incorrectly when viewing Crystal Reports off MySQL OD...

try configuring the odbc driver on the server as described, then restart connectionServer and WebProcessingServer after configuration.

also see

1198955 - UTF-8 data from a MySQL database on UNIX/ Linux appears as question marks (??)

2028071 - How to setup a MySQL 5.x ODBC connection for use with Web Intelligence reports on Linux/UN...

...

also, check the Unix system to see which locale is set

Under the user who is running the BI, run the following command: locale

[astudillo]

Hello Ayman,

I cannot see KBA i cannot log in ONE Support Launchpad I do not have S-user ID

Remember that the issue of the black Diamonds with questions marks is only with string data type that are used in parameter filters and tables.. etc , No problems with numeric data type

Please write me the info from :

https://launchpad.support.sap.com/#/notes/2054107

"try configuring the odbc driver on the server as described, then restart connectionServer and WebProcessingServer after configuration".

Please write me the configuration of the odbc driver as it is described above

The current configuration as you know is :

"DSN ->CLOUD_SQL_BO

Driver = /opt/mysql-connector-odbc-5.3.13-linux-el7-x86-64bit/lib/libmyodbc5w.so

Description = Connector/ODBC 5.3 UNICODE Driver DSN unicode type 1"

After

Please write me the info from :

https://launchpad.support.sap.com/#/notes/1198955

https://launchpad.support.sap.com/#/notes/2028071

What must I do with the info from these urls above ?

"also, check the Unix system to see which locale is set

Under the user who is running the BI, run the following command: locale"

Once I know the locale is what must I change in LOCALE ?

Thank you very much in advance

Antonio