Migration -> 10.2 Solution to: UDA-SQL-0358 Zeile 389: Syntaxfehler bei "19.2"

[charon]

HI all,

i recently migrated our Cognos from 10.1.1 to 10.2, and some error popped up like
UDA-QOS-0006 Error
UDA-SQL-0358 Line 389: Syntaxerror on "19.2".

-> Turns out Framework Manager now cares about the correct Data Types. MEans, if you join in your data layer different tables, and the key in the dimension is float64, the key in the fact table is integer64 for example, framework manager will have problems to connect correctly.
In Cognos 10.1.1 this wasnt a problem.,
Also, keep in mind that depending on the database your using FM might interprete the datatypes differently (e.g. an oracle integer64 i found in fm as "decimal" instead..)

Solution: Check all your joined fields and make sure the datatypes are correct.
In case you need to cast, try it on the etl side, because with bigger tables the case will slow down your fm quite a bit.

cheerz
:P

[cognostechie]

Yeah, that's why I don't prefer to upgrade to any new version until they come up with a patch !