In my database I have this value 1,200,000,000 which is stored as VARCHAR (256).
In Cognos report, this value is firstly converted to INTEGER using the CAST function and then it is multiplied by 5 ---> all stored in data item 1.
Then in another data item let's say data item 2 you take data item 1 and divide it by 4.
Now when I run my Cognos report, it fails and gives an error saying "UDA-EE-0065 Overflow occured on an "integer mul" operation".
Can someone please advise me how I can fix this?
Thank You
Hi,
integer has a limited size - probably 2,147,483,647 in your case. You need to choose another data type, e.g. BIGINT. That should solve your issue.
Regards
Christian
Thank you.
Your suggestion solved my issue.