COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: aband0n3d on 01 Sep 2009 07:51:11 AM

Title: report from 8.2 not working in 8.4
Post by: aband0n3d on 01 Sep 2009 07:51:11 AM
Hello, we have problems when putting reports written for 8.2 on our 8.4 server.
the error is kind of strange  - QE-DEF-0359 The query contains a reference to at least one object '[XXXXXXXX].[XXXX]' that does not exist, but when we ran the query on the database (oracle) it did not show any errors.

the difference in code generated in 8.2 and in 8.4 is as follows

8.2
where "XXXXXXXXXXX"."Reference_Date"=:PQ1 and "XXXXXXXXXXXXXX"."Run_Type"=:PQ2
and 8.4
where "XXXXXXXXXXX"."Reference_Date"=:PQ1 and "XXXXXXXXXXX"."Run_Type"=CAST( :PQ2 AS VARCHAR( 30 CHAR ) )

maybe someone knows how to change the behavior of 8.4 to match 8.2 ?