PM79591: Analysis Studio report errors "ANS-MES-0003" or "XQE-DAT-0001" in Dynamic Query Mode.

APAR status

• Closed as fixed if next.

Error description

• Cognos 10.2 Analysis Studio report runs ok in Compatible Query
  Mode, but either crashes or fails with errors "ANS-MES-0003" or
  "XQE-DAT-0001" in Dynamic Query Mode. Error details:?---
  ?XQE-DAT-0001 Data source adapter error:
  com.microsoft.sqlserver.jdbc.SQLServerException: Operand data
  type varchar is invalid for sum operator. - when processing
  query: SELECT Sum("Detail"."CallID") AS "column0",
  Sum("Detail"."CallID") AS "column1", Sum("Detail"."CallID") AS
  "column2", Sum("Detail"."CallID") AS "column3" FROM
  "heatdb"."dbo"."Detail" "Detail". ?--- ? ?Report is based on
  Microsoft SQL Server 2008 relational data via Native client and
  DQM JDBC client libraries. ?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1  or Upgrade to IBM Cognos Business Intelligence 10.2  *
  * Fix Pack 1                                                   *
  ****************************************************************
  

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

• RA21 PSN

     UP