Unable To Duplicate EPMA Application (Doc ID 1601780.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.2.304 and later
Information in this document applies to any platform.
EPMA database has been created with the correct collation (SQL_Latin1_General_CP1_CI_AS) as per the Oracle documentation.

Symptoms

Attempts to duplicate an EPMA application generates an error:

[2013-10-23T13:15:03.074+02:00] [EPMADIM] [INTERNAL_ERROR:32] [EPMADIM-1] [EPMADIM.Hyperion.DataAccessLayerCore.CommandWrapper] [tid: 15] [ecid: disabled,0] Exception occurred in the DAL.  Error Message: 'Must declare the scalar variable "@p_iCopyFromDimensionId".'.  SQL command or stored proc: insert into ds_property_dimension (i_library_id, i_dimension_id, i_application_id, i_prop_def_dimension_id, i_prop_def_member_id, c_property_value)
                  select 1,  47, 17, i_prop_def_dimension_id, i_prop_def_member_id, c_property_value
                      FROM ds_property_dimension pd1
                      where i_dimension_id = @p_iCopyFromDimensionId
                        and i_library_id = @p_SourceLibraryID
                        and i_application_id = @p_iSourceApplicationid
                        and NOT i_prop_def_member_id = 127
                        and not exists  
                              (select *  
                                from ds_property_dimension pd2
                                where pd2.i_library_id = 1
                                and pd2.i_application_id = 17
                                and pd2.i_dimension_id = 47
                                and pd2.i_prop_def_dimension_id= pd1.i_prop_def_dimension_id
                                and pd2.i_prop_def_member_id = pd1.i_prop_def_member_id)

Visible in the Windows Application Event log, EPMA and the DimensionServer.log.




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