APAR status
Closed as program error.
Error description
Client's environment:?Cognos 8.4 FP2 with Oracle 10.2.0.4 as reporting database.?Others are unrelated to this issue.??Information:?Client has a table in Oracle, in one column(VARCHAR2), there are some rows of data contain acsii control characters.??example if we do a dump(column)?we get :??Typ=1 Len=21: 68,74,32,69,85,82,79,32,83,84,79,88,88,32,53,48,32,26,32,80,114? ?which is the acsii dec version of:??DJ EURO STOXX 50 Pr??note: the 4th last char(acsii 26) is a control character which is not showing in the text version.??here is a document on control characters:??http://www.robelle.com/smugbook/ascii.txt??note: ascii dec 0 to 31 are all control characters.???Issue: now in query studio, if you drag the column to the list, it displays fine, however if you put a filter on the column and do a search on the data has control characters will give an error:??DPR-ERR-2065: The response from Report Server is not well formed. No response envelop is received??this only happens to data with ascii control characters.???Question: ?1. how congos handle ascii characters in general??2. and what about control characters??3. are there any documents on supporting ascii???
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh * * Pack 1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM17592
Reported component name
COG8 BI QUERY S
Reported component ID
5724W12QS
Reported release
840
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-06-30
Closed date
2011-09-13
Last modified date
2011-09-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
COG8 BI QUERY S
Fixed component ID
5724W12QS
Applicable component levels
RA11 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWV","label":"Query Studio v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
13 September 2011