WebI report Prompt object results ORA-29275 partial multibyte character

[former_member211289]

Hi All,

In Web Intelligence query panel , we added one object into query filter as shown below.

For example , Material || Matches Pattern || KOM23%.

When I click on refresh , that prompt object displaying below error.

Error: The following database error occurred: ORA-29275 : Partial multibyte character.

Kindly check the attached screen shot and let me know how to solve this.

Please let us know, whether issue is from DB level or from connection.

Thanks

Ram

[former_member184088]

Hello Ram,

Kindly check SAP KBA1887981

Cause

The requested read operation could not complete because a partial multibyte character was found at the end of the input.

Resolution

• Ensure that the complete multibyte character is sent from the remote server and retry the operation. Or read the partial multibyte character as RAW.
• The core issue of that the nls_chracterset values for the multibyte character set does not match between either two databases in a distributed query, or a query where the webserver has a different character set. There are several possible fixes for the ORA-29275 error, all involving getting the NLS character sets to match:

1. Write a function to convert each row. Place this function inside a PL/SQL function and call it for each row of the table:CONVERT(COLUMN NAME,'NLS_CHARACTERSET','NLS_CHARACTERSET');
2. If you have a webserver, try setting the NLS_LANG environmental variable on the webserver to american_america.al32utf8.