Getting PDS-PPE-0104 Error

[Lokesh Reddy]

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

[MFGF]

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

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.

[Lokesh Reddy]

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

[MFGF]

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

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.

[Lokesh Reddy]

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