My Oracle Support Banner

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

Last updated on MAY 25, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.