PH13826: INVALID COGNOS SQL FOR EXPLICIT JOIN SYNTAX

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels