#DATATYPE ERROR

[Former Member]

Hi Guru's,

Iu2019ve got an issue here on some of my reports on QA, the very same reports are running fine on Dev environment but the problem is in QA some columns are showing #DATATYPE on the reports when run on InfoView in QA, what is strange is the fact that the same report if I run it from BO rich client it runs fine and it shows the figures without any problems.

Iu2019ve checked these measures at Universe level and everything looks ok, like the function is set as sum.

Any advise from you side please?

[ashish_gupta3]

If it's working on Rich Client but fails in Infoview - you are probably having different middleware connectivity setting on your client machine than on the BOBJ Server.

e.g. If you are using Oracle, make sure you have the same tnsnames.ora file on your desktop as on the BOBJ Server or you are pointing to the same Oracle Name server at both the places. If it's a different setting, check the appropriate database configuration.