Hi,
We are getting below error on Cognos while running one report in background.
"PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. -1,379,278,883 DMB-ECB-0070 PPDS Error."
Could you please suggest where and what might be the issue/root cause for this error and how to get rid of this error.
Thanks,
Lokeswara
Quote from: Lokesh Reddy on 28 Oct 2024 11:43:31 PMHi,
We are getting below error on Cognos while running one report in background.
"PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. -1,379,278,883 DMB-ECB-0070 PPDS Error."
Could you please suggest where and what might be the issue/root cause for this error and how to get rid of this error.
Thanks,
Lokeswara
Hi,
It looks like you have one or more values in your crosstab that exceed the maximum number of digits. I found a support article that covers this:
https://www.ibm.com/support/pages/pds-ppe-0104-record-was-rejected-arithmetic-overflow-occurred-data
Looks like setting the decimal precision to a lower number (eg 2) might get you past the issue.
Cheers!
MF.
Hi Mark,
Thank You for your response.
Could you please let me know from where we can set the decimal precision to a lower number, whether it can be set on Report settings or Cognos Server or SQL Database?
Thanks,
Lokeswara
Quote from: Lokesh Reddy on 29 Oct 2024 10:01:03 AMHi Mark,
Thank You for your response.
Could you please let me know from where we can set the decimal precision to a lower number, whether it can be set on Report settings or Cognos Server or SQL Database?
Thanks,
Lokeswara
What is the source of data in your report? Is it a package that points directly to a database, or is it an OLAP cube of some sort?
If it's a package over a database, you should be able to change the properties of the item in Framework Manager then republish the package - or your Data Module and save it. Or you could just change the properties of the item in your report.
Cheers!
MF.
Hi Mark,
Our reports are being created from FM model package.
Can you please let us know how can we set decimal precision on FM package and report.
Thanks,
Lokeswara