Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

Getting PDS-PPE-0104 error while running Cognos report

  • 1.  Getting PDS-PPE-0104 error while running Cognos report

    Posted Tue October 29, 2024 12:44 AM
    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



    ------------------------------
    Lokeswara Yerramreddy
    ------------------------------


  • 2.  RE: Getting PDS-PPE-0104 error while running Cognos report

    Posted Tue October 29, 2024 09:37 AM

    Hi,

    As mentioned in my other post, 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. 



    ------------------------------
    Mark Fry
    Field Solutions Architect
    ------------------------------

    Original Message


  • 3.  RE: Getting PDS-PPE-0104 error while running Cognos report

    Posted Tue October 29, 2024 10:44 AM

    Hi Mark,

    Thank you for your response.

    Could you please provide the directions from where we can set the decimal precision to a lower number whether it can be set on report settings or Database or Cognos Server configuration ?

    Thanks,

    Lokeswara



    ------------------------------
    Lokeswara Yerramreddy
    ------------------------------

    Original Message


Related Content