APAR status
Closed as fixed if next.
Error description
A Compatible Query Mode package or model containing the following scenario: - at least database, business and dimensional view - 3 separate fact Query Subjects - 3 facts joined through anotjer table - SQL Join Syntax Governor is set to explicit - the 3 facts have filters applied in the business view - the report is using a fact of each of the tables from the dimensional view will fail with "This query contains an error and can not be executed." Depending on other model design, the error message can vary. Example 1: This query contains an error and can not be executed. It is recommended that you view the query feedback on the "Query Information" tab. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'. UDA-SQL-0358 Line 7: Syntax error near "where". Example 2: This query contains an error and can not be executed. It is recommended that you view the query feedback on the "Query Information" tab. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'. UDA-SQL-0358 Line 30: Syntax error near "end-of-statement".
Local fix
Change governor SQL Join Syntax to Server Determined. The same behavior is not present when using Dynamic Query Mode.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Analytics 12.0.0 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH13826
Reported component name
COG REPORT STUD
Reported component ID
5724W12RS
Reported release
B0A
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-06-25
Closed date
2023-06-06
Last modified date
2023-06-06
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":"B0A","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 June 2023