#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.

[former_member142702]

WHat kind of data source do you use? Are those converted DeskI reports?

Regards,

Stratos

[Former Member]

Hi Stratos,

I'm using BW InfoCube => multiprovider => BEX Query => Universe => Webi. So the key figure used in Webi is created from the InfoCube.

[former_member142702]

Are you on BO XI 3.,1 SP2 and FP 2.4?

Regards,

Stratos

[former_member793810]

This means it is throwing wrong data. Suppose your data is numerical but it is throwing char or something else then this error comes.

What happens, The value_if_true and value_if_false parameters can mix string and number or string and date/time data types. If these data types are mixed, the function returns a string.

Date/time and number data types cannot be mixed; this results in a #DATATYPE error.

Can you check your variable again please?

Or you can refresh the report again to see if this error is gone.

Regards,

Bashir Awan