APAR status
Closed as Permanent restriction.
Error description
When the collation sequence for a Reporting Database is set to 'Hebrew_100_CS_AI_SC_UTF8' we find that each query with a filter sent from Cognos to the reporting database has "N" character for each filter. The DB collation is UTF-8 though the DB tables are not configured as Unicode. The problem is reproducible when the Tables from the reporting database are imported in Framework Manager and the tables are updated using the 'Update Object' found under FM tools
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * n/a * **************************************************************** * PROBLEM DESCRIPTION: * * See above * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Customer facing statement: First, where the original data type of a column imported from a database is CHAR, the data type of the column becomes NCHAR due to the UTF8 character set in the collation Hebrew_100_CS_AI_SC_UTF8 when updating the query subject. Second, when the model contains an NCHAR data type, then we generate the prefix 'N' in the WHERE clause. (In the planning, we add the prefix ?N? to a literal when comparing the literal with the NCHAR column - for example, select * from T where NCHAR_COL = N?abc?.) When using NCHAR data types, the data will be retrieved from SQL Server directly as unicode. The observed behavior is expected when using any UTF8 character set.
Temporary fix
Comments
APAR Information
APAR number
PH40495
Reported component name
COGNOS ANALYTIC
Reported component ID
5724W12XX
Reported release
B0D
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-09-09
Closed date
2022-09-20
Last modified date
2022-09-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B0D","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 September 2022