HFM Extended Analytics Extract Fails When Label, Description Or User Defined Metadata Item Properties Contain Apostrophe (Doc ID 605709.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Management - Version 9.2.0.0.00 to 9.3.1.0.00 [Release 9.2 to 9.3]
Information in this document applies to any platform.

Symptoms

HFM Extended Analytics fails when apostrophe occurs in the metadata label, description or user defined attributes. The log of the Extended Analytics operation may show error messages as below (example with SQL Server database):

Metadata update has failed. : (-2147197095) (A SQL error occurred on the database which prevented a command from executing. Contact the system administrator to review the specifics of the error.)
Processing status change: (-2147197095)
Data processing failed. : (-2147197095) (A SQL error occurred on the database which prevented a command from executing. Contact the system administrator to review the specifics of the error.)
30/06/2008 11:51:53 : Status : Processing completed with errors

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