Hyperion Interactive Reporting Returns Error: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 979782.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Hyperion BI+ - Version 11.1.1.2.00 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2012***

Symptoms

Following error message appears when running bqy reports in Interactive Reporting Web Client:

Server Error [1012]: Oracle Error -1: ORA-06502: Pl/SQL: numeric or value error: character string buffer too small ORA-06512: at "BANINST1.G$_DATE_PKG", line 628; ORA-06512: at "BANINST1.F_CONCAT_SARAPPD", line 47

This issue happens for report referencing a particular view. The view is an amalgamation of more than 10 tables of information that are linked together. These views are written by SCT Banner and contain stored functions and packages. It happens with all users and only on those reports that use the views. SCT Banner has also been upgraded to v8, which is Unicode compliant.

The same issue happens with IR Studio also, but hitting OK in the error message and processing the query for the second time retrieves the results successfully in this desktop environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms