PI76710: RELATIVE TIME FUNCTIONS RESULT IN ERROR AGAINST SNOWFLAKE DATABASE

APAR status

• Closed as fixed if next.

Error description

• Several relative time functions, like _add_months, result in an
  error upon execution, due to an incorrect translation in the
  SQL. A trunc function will be send to the database, with a date
  value as argument, which is invalid. The error message is:
  caused net.snowflake.client.jdbc.SnowflakeSQLException: SQL
  compilation error: Invalid argument types for function 'TRUNC':
  (DATE)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytic 11.0.7.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

• RB00 PSN

     UP