Cannot Deploy EPMA Application or Cannot Start EPMA Services if Windows Regional Settings are Not Set to English (US)

		Modified 16-JUL-2010

---

Applies to:

Hyperion Financial Management - Version: 9.3.1.0.00 to 11.1.1.1.00 - Release: 9.3 to 11.1
Information in this document applies to any platform.

Symptoms

The end user is unable to deploy EPMA application views or it is not possible to start the EPMA Services, when the regional settings of the Windows user running EPMA services are set to anything else than US English. In bpma.log following error appears:

[ApplicationExportJob] [ERROR Object reference not set to an instance of an object.Exception: System.NullReferenceException Message: Object reference not set to an instance of an object. Source: dimension_server 
at Hyperion.DimensionServer.Dimension.<>c__DisplayClass11.<loadprimaryrelationships>b__10(RelationshipRecord relationship) 
at Hyperion.DataAccessLayerCore.DALRowset`1.Read() 
at Hyperion.DataAccessLayercore.DALRowset`1.Execute() 
at Hyperion.DataAccessLayerCore.SelectCommand`1.Execute(Action`1 callback) 
at Hyperion.DataAccessLayerCore.GenericDAO.Select[T](Action`1 callback) 
at Hyperion.DimensionServer.DAO.DimensionDAO.LoadRelationship(Int32 libraryID, Int32 dimensionID, Boolean primary, Action`1 action) 
at Hyperion.DimensionServer.DAO.DimensionDAO.LoadPrimaryReferences(Int32 libraryID, Int32 dimensionID, Action`q action) 
at Hyperion.DimensionServer.Dimension.LoadPrimaryRelationships() 
at Hyperion.DimensionServer.Library.Load() 
at Hyperion.DimensionServer.ApplicationExport.RenderApplication() 
at Hyperion.DimensionServer.ApplicationExport.Execute() 

Cause

This is caused by defect in EPMA 9.3.1 and 11.1.1.1 base versions. It occurs when regional settings for the user running the EPMA Windows services are not set to English (US).

Solution

The easiest workaround is to set the regional settings of the EPMA services Windows user to English / United States (on the machine where the EPMA services are installed). 

Note that it is not sufficient to simply ensure that it says English / U.S. in the Control Panel -> Regional Settings. It is necessary to also check the checkbox "Apply all settings to the current user account and to the default user profile" at the bottom of the Advanced page and then restart the server. 

This issue has been fixed in 9.3.1 Service Pack 3 release of Enterprise Performance Management Architect.   All customers are recommended to ensure they have applied the latest available Service Pack for all their Oracle EPM products.