COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: backhandx on 27 Feb 2017 11:24:53 AM

Title: Problem with data type property
Post by: backhandx on 27 Feb 2017 11:24:53 AM
HI all,

I am stucked with a problem that I did not meet before. Acutally, when testing a Quary Item I get the error : Missing CCL data type for DB column and datatype: TS PM YYYY-MM-DDBHH:MI:SSZ
The type of the TS column in the DB is : PERDIOD(TIMESTAP() WITH TIME ZONE) , not Null and the type setted in the Framework is : unknown.

Can anyone have some idea? I want to mention that this query worked before

Thanks for your reply