APAR status
Closed as fixed if next.
Error description
One query of a report contains only data items referencing session parameters, like $account.defaultName. Against DB2 z/OS the report is failing with XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: . <IDENTIFIER> JOIN INNER LEFT RIGHT FULL. SQLCODE=-104, SQLSTATE=42601, DRIVER=x.xx.xx - when processing query: SELECT DISTINCT 'username' AS T0 FROM ( VALUES ('dummy') ) T1(c1).. ?This does only happen in Dynamic Query Mode.?Reason is the generated SQL:?SELECT DISTINCT 'username' AS T0 FROM ( VALUES ('dummy') ) T1(c1).. ??VALUES is not a form of a query for DB2 z/OS, instead it can only be used in a trigger.
Local fix
Add a query item that is referencing a database column to the qu ery in Report Studio.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh * * Pack 1 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PM85471
Reported component name
COG REPORT STUD
Reported component ID
5724W12RS
Reported release
A20
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-03-25
Closed date
2013-06-11
Last modified date
2013-06-11
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
RA21 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A20"}]
Document Information
Modified date:
14 December 2020