If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Getting PDS-PPE-0104 Error

Started by Lokesh Reddy, 28 Oct 2024 11:43:31 PM

Previous topic - Next topic

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

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.
Meep!

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

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.
Meep!

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