If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Error after upgrading to Cognos 11  (Read 1881 times)

Offline vasudev_jain

  • Full Member
  • ***
  • Join Date: Aug 2020
  • Posts: 6
  • Forum Citizenship: +0/-0
Error after upgrading to Cognos 11
« on: 12 Aug 2020 11:36:43 pm »
Hi All,

I am encountering the below error after upgrading from Cognos 10  to Cognos 11 while running the report.

XQE-GEN-0005 Found an internal error: Dimension hierarchy Created On Yr/Month appears more than once in a tuple during expression evaluation.

It will be great  if you guys can help me on this issue.

Thanks & Regards

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 536
  • Forum Citizenship: +48/-0
Re: Error after upgrading to Cognos 11
« Reply #1 on: 13 Aug 2020 07:10:05 am »
I think the first thing would be to check to see if Created On Yr/Month is appearing more than once in the tuple.  That means that something is trying to get the query engine to use objects from the hierarchy in such a way that the hierarchy is ending up more than once in the tuple, which as you know, would be quite a feat if you could accomplish it.  You would need to trace through the report, its queries, and the source model.

You have presumably read the error message.  Could you tell us what you understand the error message to mean please.  What possible actions to investigate the problem have you identified?