Arithmetic Overflow Error When Running a Report in PDF Format
If you use a Microsoft SQL
Server 2005 data source and your report includes aggregations, you
may encounter the following error when you run your report in PDF
format:
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server] Arithmetic overflow error converting expression to data type int. (SQLSTATE=22003, SQLERRORCODE=8115)
This error occurs because the action is performed in the database, and the database data type is too small.
This error did not occur in IBM® Cognos® Business Intelligence version 8.3 or earlier because aggregation was processed locally, by the Business Intelligence server. In version 8.4 or later, aggregation is processed at the database level.
To avoid this problem, increase the size of the the database data type.