Hi all,
The story is a bit different from what I said before.
The query used in the crosstab (with the totals added) is used as a basis for another query (the one for the list).
It seems that this added totals in the first query can't be processed when generating the second query.
(In an ideal world, the totals should be ignored when generating the second query ;-) )
Solution is the same as mentioned before: make 2 completely different queries.
We thought first it was a migration issue but it might be not. My colleague who made the report isn't any longer sure if he did the change before or after the migration.
------------------------------
Regards,
Danny Casteels
SD Worx
------------------------------
Original Message:
Sent: Wed June 08, 2022 01:41 AM
From: Robert Klingiert
Subject: Error in reports since migration to 11.2 (V5DataItem)
Danny,
Go to the query and find the new added total. Set the aggregate function (in properties) to SUM instead of Automatic or Default.
Regards,
R. Klingiert
------------------------------
Robert Klingiert
Original Message:
Sent: Tue June 07, 2022 05:32 AM
From: Danny Casteels
Subject: Error in reports since migration to 11.2 (V5DataItem)
Hello all,
The report itself has a list and crosstab using the same query.
I figured out that the problem is due to totals added on the crosstab.
These totals are added to the underlying query as well and then the list fails with the error mentioned.
As a workaround, i duplicated the query and used the query without the totals for the list and the query with the totals for the crosstab.
------------------------------
Regards,
Danny Casteels
SD Worx
Original Message:
Sent: Thu June 02, 2022 03:41 AM
From: Danny Casteels
Subject: Error in reports since migration to 11.2 (V5DataItem)
Hello all,
Has anyone experienced problems with reports since migration to 11.2?
We have several reports that are giving errors like this:
XQE-GEN-0005 Found an internal error: com.cognos.xqe.ast.v5.query.V5DataItem incompatible with com.cognos.xqe.ast.v5Exp.V5SimpleNode
XQE-PLN-0004 Found an internal error on node 'V5DataItem'. The rollupAggregate setting 'automatic' is either unsupported or invalid.
Do you know what causes this and how to solve it?
------------------------------
Regards,
Danny Casteels
SD Worx
------------------------------
#CognosAnalyticswithWatson