FDM Report Fails With Error "Error: An error occurred retrieving the list of parameters for the selected report" (Doc ID 1665704.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.2.300 and later
Information in this document applies to any platform.

Symptoms

When running the FDM reports, certain reports are not working properly. The following error is displayed when running those certain reports

"Error: An error occurred retrieving the list of parameters for the selected report:
Detail: Data access error"

The error log has the following error message

** Begin FDM Runtime Error Log Entry [2013-11-07 10:04:58] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147467259
Description...................................... ORA-00911: invalid character
SELECT CatKey, CatName, CatDesc
FROM tPOVCategory
ORDER BY CatName;
Procedure........................................ clsDataAccess.farsSnap
Component........................................ upsWDataWindowDM
Version.......................................... 1112
Thread........................................... 37532

IDENTIFICATION:
User............................................. hypadmin
Computer Name.................................... VMHODANAMP18
App Name......................................... ARIES
Client App....................................... WebClient

CONNECTION:
Provider......................................... ORAOLEDB.ORACLE
Data Server......................................
Database Name.................................... PANAM7.ORACLEOUTSOURCING.COM
Trusted Connect.................................. False
Connect Status.. Connection Open



Changes

 

The FDM application was upgraded from 11.1.1.3.xxx version to 11.1.2.2.xxx version.

 

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