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

Crosstab returns Arithmetic Overflow error only executed in Background

Started by rockytopmark, 20 Feb 2012 01:07:01 PM

Previous topic - Next topic

rockytopmark

In Cognos version 8.4.1, I have a written a Crosstab report that combines a PowerCube and 1 relational table source, for the purpose of reconciling that all the data in the table, made it into the Cube and into the proper tuples.  It is being delivered to Excel 2007.

This report also incorporates a Page Set, so that there is a fresh page (Excel worksheet) rendered whenever the main dimension (Entity) value iterates.

In this example, there are 30+ Entities.  When the report has iterated to a particular Entity (call it ABC) it errors out with an Arithmetic Overflow error (PDS-PPE-0104 A record was rejected. An arithmetic overflow occurred. (Data) DMB-ECB-0070 PPDS Error.)  There is one other key piece of information... this error ONLY occurs if I run the report to be processed in the background.  If I run the report interactively, it runs fine.

If I filter so the report doesn't iterate to this entity, ABC, it works fine... executed interactively or in the background. 

Entity ABC only has data in the relational table, so the cube hasn't got this Entity.  This shouldn't be an issue, however, since we UNION the 2 initial data sets together so no data in one or the other source should matter.

The values in the Table for Entity ABC are small... largest value is 2.

Any ideas?  I need to be able to schedule this report to execute in background for all Entities, so running interactively is out of the question.  Any experiences you can share, that are even vaguely similar, would be appreciated.

Opening an SR with IBM, but also would love to hear if anyone else has seen such odd behavior.

Thanks, M