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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

report from 8.2 not working in 8.4

Started by aband0n3d, 01 Sep 2009 07:51:11 AM

Previous topic - Next topic

aband0n3d

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 ?