Hyperion Interactive Reporting Returns Error: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Last updated on SEPTEMBER 02, 2016
Applies to:Hyperion BI+ - Version 18.104.22.168.00 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Nov-2012***
Following error message appears when running bqy reports in Interactive Reporting Web Client:
Server Error : 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.
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