PH04905: SAP IQ: QUERY SUBJECT VALIDATION FAILS BECAUSE OF "TOP 0" IN SELECT STATEMENT

APAR status

• Closed as unreproducible.

Error description

• The situation occurs when a query subject with calculated items
  needs to be validated.
  When the validation is done directly against the data source,
  here SAP IQ, we generate a "SELECT TOP 0".
  
  SAP IQ returns an error:
  XQE-DAT-0001 Data source adapther error:
  com.sybase.jdbc4.jdbc.SybSQLException: SQL Anywhere Error -674:
  Statement's size limit is invalid.
  
  SAP IQ does not support "TOP 0".
  

Local fix

• Use compatible query mode
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.2                       *
  ****************************************************************
  

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