COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: SW2007 on 14 Nov 2007 09:32:21 PM

Title: [Solved] Error Message
Post by: SW2007 on 14 Nov 2007 09:32:21 PM
Hi Cognoiser Again...

i got an error message when running my report in reportnet. That message is : "A record was rejected. An arithmetic overflow occurred. PPDSError 104." Why it could be happened? How to solve that?

Thanks..

PS : where i can find error codes library for reportnet?
Title: Re: Error Message
Post by: MFGF on 15 Nov 2007 02:38:09 PM
Hmmm,

PPDSError sounds like an error from PowerPlay rather than ReportNet.  Is this a PowerPlay Web report (ppx) that has been published to ReportNet's Cognos Connection portal?

Assuming this is the case, my guess would be that one of the measures in the PowerCube has been defined too small, so that the aggregation is causing it to overflow.  You'd really need to go back to Transformer to fix this, then rebuild the cube.

I may be barking up totally the wrong tree here - I've made a lot of assumptions to get this far...

Regards,

MF.
Title: [Closed] Re: Error Message
Post by: SW2007 on 19 Nov 2007 06:17:51 AM
Hi MFGF...

Thank you for your answer. That's not a PowerPlay Web Report (ppx). That's report net pure.
Now, i know why that's happened.

Because i use round function in my data item, so when i run that report, appears that error message. actually, i don't know why round function can be make my report error.
So...my trick is...i released round function from data item and go to the properties of data item, then i set data format with number which number of desimal = 0.

And my report running well...