COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Upgrading to Cognos Analytics => Topic started by: highwingers on 18 Oct 2018 08:23:05 AM

Title: Cognos 11 Timestamp issue
Post by: highwingers on 18 Oct 2018 08:23:05 AM
Hey anyone have a fix for this error I'm getting in my DQM report in Cognos 11
An unexpected exception occurred:
com.cognos.xqe.runtree.relational.vectorization.TimestampColumnVector incompatible with com.cognos.xqe.runtree.relational.vectorization.LongColumnVector
Title: Re: Cognos 11 Timestamp issue
Post by: MFGF on 22 Oct 2018 05:13:46 AM
Quote from: highwingers on 18 Oct 2018 08:23:05 AM
Hey anyone have a fix for this error I'm getting in my DQM report in Cognos 11
An unexpected exception occurred:
com.cognos.xqe.runtree.relational.vectorization.TimestampColumnVector incompatible with com.cognos.xqe.runtree.relational.vectorization.LongColumnVector


Hi,

What exact version of Cognos Analytics are you using? I found a PMR raised for a similar issue, and the fix was to install 11.0.11 (or later)

http://www-01.ibm.com/support/docview.wss?uid=swg1PI90035

Cheers!

MF.
Title: Re: Cognos 11 Timestamp issue
Post by: Sash007 on 13 Mar 2020 05:26:13 AM
Hello, I am using cognos version 11.1 and i'm getting the following error when executing a report: 

XQE-RSA-0021 An invalid attempt to cast a class occurred during data retrieval:
com.cognos.xqe.runtree.relational.vectorization.DoubleColumnVector incompatible with com.cognos.xqe.runtree.relational.vectorization.DecimalColumnVector


I am not getting this error however in cognos 10. I suppose this is due to the conversion to DQM from CQM. The report works fine as soon as i execute at least one query but i have to do it every time in order to get the report to work, otherwise i am getting this error.
Does anybody know how to solve this?
Thank you!