Oracle® Hyperion Enterprise Performance Management Architect, Fusion Edition

Release 11.1.2.2.301 Patch Set Update (PSU): 11.1.2.2.301

Readme

About this Patch. 1

Patch Type. 1

Supported Paths to this Patch. 1

Prerequisites. 2

Other Patches 2

Supported Platforms. 2

Supported Languages. 2

Defects Fixed in this Patch. 3

Defects Fixed in 11.1.2.2.300. 5

Known Issues. 7

Applying this Patch. 9

Rolling Back this Patch. 11

Documentation Updates. 11

Help Systems for the 11.1.2.2.000 Release. 11

Troubleshooting FAQs. 12

 

About this Patch

This Readme file describes the defects fixed in this Oracle® Hyperion Enterprise Performance Management Architect, Fusion Edition (Performance Management Architect) patch and the requirements and instructions for applying this patch.

Caution: You are urged to carefully read and understand the following requirements. Failure to comply may result in applying a patch that can cause your application to malfunction, including interruption of service and/or loss of data. Before installing or applying this patch:

·      Verify that your system configuration (product version, patch level, and platform) exactly matches what is specified in the Readme.

Patch Type

This Patch Set Update (PSU) replaces files in the existing installation and does not require a full installation.

Supported Paths to this Patch

You can apply this patch to the following releases.

·         Oracle® Hyperion Enterprise Performance Management Architect (Performance Management Architect), Fusion Edition 11.1.2.2.000.

·         Oracle® Hyperion Enterprise Performance Management Architect (Performance Management Architect), Fusion Edition 11.1.2.2.300.

Prerequisites

Other Patches

Following is a list of other patches you need to apply:

Required Microsoft Patch

Microsoft has identified a security issue that could allow a hacker to compromise your Windows-based system. You MUST install the Microsoft VC 2005 SP1 ATL redistributable pack before applying this patch.

The updated VC 2005 redistributable is available here for both x86 (32-bit) and x64 (64-bit):

http://www.microsoft.com/downloads/details.aspx?familyid=766A6AF7-EC73-40FF-B072-9112BAB119C2&displaylang=en

Required User Rights

The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights:

Windows:
Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: “Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.”

UNIX/Linux:
Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products.
OPatches are not intended to be applied using a root user.

Supported Platforms

This patch supports the same platforms as release 11.1.2.2.000.

Supported Languages

This patch supports the same languages as release 11.1.2.2.000.

 

Defects Fixed in this Patch

These defects are fixed in this release.

Defect Number

Defect Fixed

• 17198048

If EPM Architect web tier, EPM foundation services and applications are on Linux and EPM Architect Dimension Server is on Windows; Import of Oracle® Hyperion Planning application using Life Cycle Manager into EPM Architect may fail with error: Couldn't determine the column delimiter for the ads file being imported.

• 17197918

In Dimension library; rename member option renames both member name and alias instead of member name only.

• 17197950

In the import file; if a user defined attribute values for primary and shared members are different; both the values should be merged and updated to primary and shared members.

• 16876472

Deploy an application by excluding a parent member, then move child member from the excluded parent member to another parent and redeploy; redeployment aborts.

• 16699007

Dimension synchronization between Application and Shared libraries is not considering attributes.

• 16552825

Deploy a Hyperion Planning application with Period dimension, do an invalid Period dimension changes and undo it; redeploy fails.

• 16044750

Validation for descendents of hierarchy in the Hyperion Calculation Manager fails as hidden top member of the hierarchy is searched by the logic; it should search from the View to get the top member.

• 15979968

Measures, Measure Detail, and AllocationType dimensions are not allowed to be part of Essbase applications causing them to lose system members when used in Essbase applications.

• 16900552

Data Synchronization fail as Essbase(ASO) puts negative numbers within brackets that are not recognized as valid by Financial Management.

• 17020333

Failures in EPM Architect upgrade for extended dimensionality from 11.1.2.1.000 to 11.1.2.2.000 are not detected at the start up of Dimension server causing redeployment or compare to deployed error: "Property DynamicProperties does not exist". 

• 16880424

EPM Architect is not handling exception due to incorrect user role and authentication information sent from ERP integrator.

• 17197264

User without ‘Create Integrations’ role is allowed to edit data synchronization definitions.

• 17198070

Share Hyperion Planning local dimensions and use them for Financial Management application deployment; dimension name in metadata XML file and their internal properties in database such as ‘MappedType’ would be missing.

• 16699226

Dynamic properties in the shared dimensions are not getting de-referenced from the dimensions causing validation error: “Dynamic PropertyID <ID> that is assigned to dimension <name> is not a valid property”.

• 17198207

Compare engine detects changes in static hidden properties at application and dimension level, which is incorrect and causes false validation failures that prevents application re-deployment.

• 17196933

Rename and add an alias to a member without alias, deployment of application of this member fails with validation error: “The given key was not present in the dictionary”.

• 16416513

Validation that prevent same name for dimension or member for Alias dimension or its member should be removed for Hyperion Planning else it causes validation error: “More than one member named 'Default' exists in the application”.

• 16867500

When synchronizing between shared and application libraries, User Defined Attribute values that are blank or null in the source are not replacing the target values.

• 16933478

When synchronizing between shared and application libraries, non array type property values that are blank or null in the source are not replacing the target values.

• 17198161

Create Hyperion Workforce Planning application with local dimension, synchronize Entity dimension with Shared Library, share Entity dimension; an error occurs: “An exception occurred while merging a local dimension into an existing shared dimension (in replace mode)”.

• 17197625

Dimension Library search does not work when non-English is set as primary language in browser.

• 17206977

EPM Architect Life Cycle Management import try to update a dimension global property like ‘HierarchyType’ of a shared parent member whose primary member is not a parent there by causing validation error: “Property value <value> is invalid for the 'HierarchyType' property”.

• 17198124

Migrated dimension members from EPM Architect using Lifecycle Management are not maintaining sort order as in the source.

• 17198048

Lifecycle Management import of shared dimension may fail with: Error "Couldn't determine the column delimiter for the ads file being imported"

• 17198032

Financial Management dimensions that are made as shared dimensions and deployed to other EPM applications (i.e. Hyperion Planning or Essbase or Hyperion Profitability and Cost Management) shall have dimension type property missing.

• 17197976

Navigating to member formula in grid editor and double clicking a cell containing a formula causes the member formula window to open with error: “Server was unable to process request”.

• 17197047

If Essbase(ASO) generic dimension Data Storage is ‘LabelOnly’, Hierarchy Type is ‘Stored’ and its children Consolidation is ‘~’; EPM Architect should treat it as valid instead of validation Error: “Consolidation must be set to '+' in stored hierarchies”.

• 16807960

Import is replacing the existing value of associated dimension member to null even though “Clear Before Import” is not checked.

• 16838645

Excluded shared members are getting migrated through Life Cycle Management in EPM Architect.

• 14519791

Over-ride and set ‘Period Type’ property of parent members (months) to ‘Base Time Period’, Exclude child members (weeks), Validation fails expecting 'Summary Time Period' for Month members.

16180061

In Italian locale; 3 of the Task Flow actions (Import Dimension from flat file, Import Dimension from Interface tables, Profitability Redeploy) are missing. Below steps to be followed. 

1. Apply EPM Architect 11.1.2.2.301 Opatch.

2. Stop EPM Architect services.

3. Copy 16180061.bat from Opatch\16692973 to <EPM_ORACLE_INSTANCE>\bin directory. (The default directory for <EPM_ORACLE_INSTANCE> is C:\Oracle\Middleware\user_projects\epmsystem1).

4. From the command line, go to <EPM_ORACLE_INSTANCE>\bin.

5. Run 16180061.bat.

• 16959684

Upon migration from EPM Architect using Lifecycle Management; values that are blank or null in the source are not replacing the target values; applicable for User Defined Attribute and Alias values.

• 13687540

OPatch for EPM Architect version 11.1.2.2.300 replaces 'AWBConfig.jar' with the defective one, causing database re-configuration to fail.

16303512

EPM Architect may fail due to Oracle database connection time out.

Workaround: Refer ‘Troubleshooting FAQs’ section for the steps that may help.

 

Defects Fixed in 11.1.2.2.300

These defects are fixed in this release.

Defect Number

Defect Fixed

• 14145268

You may be unable to load multiple user defined attributes for members using interface tables and may receive the error message, “Member [x] will be added but it is an orphan.  Please
check the hierarchy section/table for member.”

• 13402012

When you create a copy of an application via the Performance Management Architect Application Library, the smartlist set for an account member as an override made to the source application is not reflected in the copy of the application.

• 10278796

It may not be possible to delete an application that has a “Migrate Pending” status.

• 13950048

If you make a change to an alias and redeploy the application using the Batch Client, the alias may be removed.

• 13951177

When using the Batch Client to redeploy an application that is in a "deployed with error" state, you may receive an "invalid data source" error.

• 13738712

You may be unable to perform a data sync across different plan types within the same application.

• 14027962

You may be unable to synchronize an account dimension from the Shared Library to an Essbase aggregate storage (ASO) application.

• 13905722

You may be unable to deploy an application from Performance Management Architect to Hyperion Profitability and Cost Management when members within the dimension hierarchy are moved in the Shared Library, but have not been deployed previously to Hyperion Profitability and Cost Management.

• 14032730

Validation errors may occur when changing the alias of a member that was previously deployed.

• 13953749

If you edit the default port number in a data source, when you open the data source, the default port number may still display.

• 12880468

There should be a warning message when you rename the members under the Year dimension.

• 13599032

After searching for user defined attributes in the Performance Management Architect dimension library and sorting the results, double-clicking on one of the members may not highlight the correct member in the dimension library, but instead may highlight the member in the same relative position as the clicked on member.

• 13742332

The aggregation property of shared members in the Accounts dimension may be re-set to the default value (+) when the dimension is synchronized from the Shared Library.

• 14040136

In the Shared Library, if you create the folders, Parent->Child->GrandChild, move a dimension to the GrandChild folder, and search for any member by right-clicking a dimension in that folder, the member will display in the "Member Find - Shared
Library" property window. After you double click the member in the "Member Find - Shared Library" property window, it may not be found in that dimension.

• 12741133

You may be unable to import dimensions into Performance Management Architect using a tab-delimited flat file.

• 13889672

You may be unable to import application settings, shared dimensions, filters and overrides into Performance Management Architect using Lifecycle Management.

• 13846695

You may be unable to export a dimension from the Shared Library if the dimension name contains a forward slash (that is, a /).

• 13505754

After running a search in the Dimension Library and closing the search pane (by clicking the X at the top right), there may be a delay.

• 13959136

The member order in Financial Management may not match the member order in the Shared Library or in the application.

• 14123328

After you deploy a Planning application from Performance Management Architect, you may receive an “500 Internal Server” error message.

• 14008022

After you install release 11.1.2.2, the Library Job Console may not launch.

• 13794061

If you validate an out-of-sync Essbase aggregate storage or block storage application, this may update the status incorrectly to “in sync with deployment” though the application was not deployed.

• 13956812

If you perform a task flow for the redeployment of a Hyperion Profitability and Cost Management application, the task flow may not complete.

• 13854956

After upgrading Performance Management Architect from release 11.1.1.4, you may not be able to open all Performance Management Architect components in Workspace.

• 13779036

If you try to validate an Essbase application that was upgraded from 11.1.1.3 to 11.1.2.2.00, you may receive the following error message: “Application server ‘<ServerName:PortNumber>' is invalid. It is not registered with Shared Services.”

• 9921244

When you use the Batch Client utility to remove members, you may remove children of the members using the RemoveChildren option, but there is no option to remove the descendants of the children.

• 13639148

If you redeploy a Financial Management application that contains new custom dimensions, the deployment may not complete successfully and may generate errors in load file.

• 12750443

Excluded members should not display in Essbase after redeployment.

Known Issues

The following issues are the noteworthy known issues for this patch.

Defect Number

Defect Description

• 17580481

When you set up the Holding Company property for a particular entity member (for example, Entity1), you can select the same entity member (Entity1) as the Holding Company property. That is, you can set up the entity, incorrectly, as its own holding company.

• 11924751

When you share an attribute dimension, the members may lose the shared values.

• 10314331

When you select the top level member of a dimension, some of the top level members do not display in the shared dimension of an application and do not show up in the Excluded members list.

• 10033681

When creating a multi-currency Planning application using the Performance Management Architect Application Wizard, there are only 13 currencies available to be used as the default currency. However, when creating an application using the Planning Application Wizard, there are more than 150 currencies are available. The same currencies should be available in the Performance Management Architect Application Wizard.

13825885

Validation or launch of a synchronization may fail when the source is a flat file in a standard deployment.

• 13742698

The Dimension Server may fail to start when you try to connect to DB2 in Secure Sockets Layer (SSL) mode.

• 13473968

Data synchronization validation may fail if you are using non-ASCII member names.

• 13787993

After performing a schema upgrade from 11.1.1.3 to 11.1.2.2.000, in which the 11.1.2.2.000 upgrade exists separately from 11.1.1.3, when you validate an Essbase aggregate storage (ASO) or a Hyperion Profitability and Cost Management application, you may receive a validation warning message letting you know that the default values for some of the members' properties have changed, and because of this, you should run a CompareTODeployedApplication task so you know which members' properties have changed. When you run this task, the changed properties found may differ from the changed properties shown in the validation warning message.

12731406

If you run the Batch Client in a Unix or Linux environment, you may receive the error, “ERROR .HYPERION.<Machine Name> does not exist”.
To work around this, create a file with the name hyperion.<Machine Name> in the path
where the Batch Client is being run, and add the EPM_ORACLE_HOME path variable and
its value (for example, EPM_ORACLE_HOME=/scratch/oracle11/Middleware/
EPMSystem11R1).

• 16984252

In Dimension library, create a Hyperion Planning member with name ‘%’ in it; ‘%’ character gets re-displayed as ü.

Workaround: Rename the member to get back the ‘%’ character; further member name gets displayed correctly in Hyperion Planning after deployment.

• 16700771

In Internet Explorer 9.x; drag and drop to move members is not working in shared library.

• 14731832, 13844033, 16561444

In 64 bit Microsoft Excel; File generator fails with error: 'Compile error in hidden module; frmFlatFileGeneration’.

17400451

User with either Create Integrations or Run Integrations role can view, modify, copy, delete dimensions, view other users’ jobs and delete them.   

16663135

Data synchronization step in Task flow continue to remain in active status if it becomes ‘Completed with Errors’; it should continue with next step instead.

7334439, 16574313

Dimensions in the shared library does not get sorted by the option ‘Sort by Dimension Owner’

16357180

EPM Architect does not validate and prevent deployment of Hyperion Planning and Financial Management applications, if shared member is preceding the primary member.

16310436

In Dimension Library, expand two member trees, select base member of the second tree and left click the first member tree to collapse and select it; now second tree’s base member still not unselected and also its properties are loaded in the property grid editor.

16085631, 15892936

File generator does not write the dimension association if property value to base member relation does not exist between associated dimensions.

Workaround: Use LCM instead of File generator or create one property value to base member relation between associated dimensions.

16069889

Detach shared dimensions with association, make them local, re-activate association; property values to base members’ relations between associated dimensions are lost.

16023608

For a Hyperion Planning application that is upgrade from version 11.1.1.3.000 to version 11.1.2.2.000; generic dimension member’s  ‘Two Pass Calculation’ property is missing from the properties window of the dimension library.

 

 

Applying this Patch

The section includes important information about applying this patch for Performance Management Architect.

To apply this patch:

1.    Stop all Enterprise Performance Management Architect services.

2.    Stop Oracle® Hyperion Calculation Manager (Calculation Manager), Oracle® Essbase Studio and Oracle® Hyperion Profitability and Cost Management (Profitability and Cost Management), if they are running on the same computer where Performance Management Architect services are running.

 

3.    Download and unzip the downloaded patch file, 16692973_xxx.zip to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

Where xxx represents Windows 32-bit, 64-bit, or UNIX:

For Windows 32-bit, the patch file name is: 16692973_WIN32.zip

For Windows 64-bit, the patch file name is: 16692973_x64.zip

For UNIX, the patch file name is: 16692973_UX.zip

4.    Back up the EPMA database repository.

Note: If you need to roll back this service fix, you need to restore from this database backup. Restoring from backup results in a loss of all changes.

5.    On the computer where the Performance Management Architect Dimension Server, Web Tier, and Data Synchronization components are located, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

6.    To apply the patch, enter the following command on one line:

Windows:
opatch.bat apply <EPM_ORACLE_HOME>/OPatch/16692973 -oh <EPM_ORACLE_HOME>
-jdk <MIDDLEWARE_HOME>/jdk160_29

NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:
./opatch apply <EPM_ORACLE_HOME>/OPatch/16692973 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

7.    Restart Enterprise Performance Management Architect services.

8.    Start Oracle® Hyperion Calculation Manager (Calculation Manager), Oracle® Essbase Studio and Oracle® Hyperion Profitability and Cost Management (Profitability and Cost Management), if they were stopped in step 2.

9.    Restart Foundation Services.

10. All users should now clear cached files from their browsers.

Rolling Back this Patch

To roll back a patch:

1.    Stop all Enterprise Performance Management Architect services.

2.    Stop Oracle® Hyperion Calculation Manager (Calculation Manager), Oracle® Essbase Studio and Oracle® Hyperion Profitability and Cost Management (Profitability and Cost Management), if they are running on the same computer where Performance Management Architect services are running.

3.    From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (by default, Oracle/Middleware/EPMSystem11R1/OPatch).

4.    To roll back the patch, enter the following command on one line:

Windows:
opatch.bat rollback -id 16692973 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

NOTE: The default for <
EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:
./opatch rollback –id 16692973 -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME> /jdk160_29 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

NOTE: The default for <
EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

5.    Start all Enterprise Performance Management Architect services.

6.    Start Oracle® Hyperion Calculation Manager (Calculation Manager), Oracle® Essbase Studio and Oracle® Hyperion Profitability and Cost Management (Profitability and Cost Management), if they were stopped in step 2.

7.    Restart Foundation Services.

8.    All users should now clear cached files from their browsers.

Documentation Updates

Help Systems for the 11.1.2.2.000 Release

For the Performance Management Architect 11.1.2.2.000 release, help systems accessed from within the product have been updated for the 11.1.2.2.300 release. If you open a help system from the product menu, the 11.1.2.2.300 help system is displayed.

If you require a help system for the 11.1.2.2.000 release, you can download it from the documentation library: http://docs.oracle.com/cd/E17236_01/index.htm

Troubleshooting FAQs

How can I find out which releases and patches of EPM System products are installed in a deployment?

In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:

Windows:

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 –invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

Why do I get the following patch conflict error message when running OPatch?

If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:

Patch(es) <PreviousPatch#> conflict with the patch currently being installed (<NewPatch#>).

If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (<NewPatch#>) will be installed.

If a merge of the new patch (<NewPatch#>) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.

This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can either (1) roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical) or (2) request a “merged patch” consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative.  


Why do I get the OUI-67078 warning message when applying OPatch?

This warning means that the patch being applied is a superset of a patch already on the deployment and the existing patch will be rolled back. The following snippet shows the context of this warning.

The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777] in OH C:\Hyperion
-----------------------------------------------------------------------------------
OPatch Session completed with warnings.


I applied the patch successfully but I don’t see the changes from the patch in the product. What should I do?

When patching an .EAR file for an application, you may need to delete the cached files in the following folders in order to see the changes provided with the patch:

·         <MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/tmp/

·         <MIDDLEWARE_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/
<MANAGED_SERVER_NAME/cache

EPM Architect fails due to Oracle database connection time out. What should I do?

    Below steps may help

     1. Stop EPM Architect Dimension Server

2. Navigate to the " BPMA_Server_Config.xml" file (<Middleware Home>\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\ServerEngine\bin)

     3. Take the backup of the BPMA_Server_Config.xml

4. Edit the logging configuration section of your BPMA_Server_Config.xml file so that debug-level messages will be logged to the Windows Event Viewer by changing the logging level from INFO to DEBUG see below.

          <log4net debug="false">

         <!-- Define some output appenders -->

          <appender name="ConsoleAppender"

          type="log4net.Appender.ConsoleAppender,log4net" >

                   <param name="Threshold" value="DEBUG" />

          <layout type="log4net.Layout.PatternLayout,log4net">

          <param name="ConversionPattern" value="%d %m%n" />

          </layout>

         </appender>

          <appender name="EventLogAppender"

          type="log4net.Appender.EventLogAppender,log4net" >

          <param name="ApplicationName" value="AWB_DimServer" />

          <param name="LogName" value="Application" />

          <param name="Threshold" value="DEBUG" />

          <layout type="log4net.Layout.PatternLayout,log4net">

          <param name="ConversionPattern" value="[%t] %-5p %m" />

          </layout>

         </appender>

          <appender name="DebugOutAppender"

          type="log4net.Appender.OutputDebugStringAppender,log4net" >

          <param name="Threshold" value="DEBUG" />

          <layout type="log4net.Layout.PatternLayout,log4net">

          <param name="ConversionPattern" value="%X{processid} Thread ID: [%t];

          %-5p %m" />

          </layout>

         </appender>

          <appender name="ODLAppender"

          type="Hyperion.DimensionServer.ODLAppender,odl_appender_2">

          <param name="Threshold" value="DEBUG" />

          </appender>

          <!-- Setup the root category, add the appenders and set the default priority -->

          <root>

          <priority value="DEBUG" />

          <appender-ref ref="ConsoleAppender" />

         <appender-ref ref="EventLogAppender" />

          <appender-ref ref="DebugOutAppender" />

          <appender-ref ref="ODLAppender" />

          </root>

5. Now add the following XML tags under </Data_Access_Layer> section of the BPMA_Server_Config.xml

          <ConnectionPooling>

          <PoolingEnabled>true</PoolingEnabled>

<!--Connection Lifetime is the maximum life time (in seconds) of the connection.  Setting this to 0 disables it.-->

          <ConnectionLifetime>0</ConnectionLifetime>

          <!--MaximumPoolSize is the maximum number of connections in the pool.-->

          <MaximumPoolSize>100</MaximumPoolSize>

          <!--MinimumPoolSize is the minimum number of connections in the pool.-->

          <MinimumPoolSize>1</MinimumPoolSize>

<!--Controls the enlistment behavior and capabilities of a connection in context of COM+ transactions or System.Transactions. This setting must be either "dynamic" or "true".-->

          <Enlist>true</Enlist>

<!--The following 5 settings are specific to Oracle database  Connection Timeout is the maximum time (in seconds) to wait for a free connection from the pool.-->

          <ConnectionTimeout>15</ConnectionTimeout>

<!--HA Events enables ODP.NET connection pool to proactively remove connections from the pool when an Oracle RAC service, service member, database, or node goes down.  Works with RAC, Data Guard, or a single database instance.-->

          <HAEvents>false</HAEvents>

<!--Load Balancing enables ODP.NET connection pool to balance work requests across Oracle RAC instances based on the load balancing advisory and service goal.-->

          <LoadBalancing>false</LoadBalancing>

<!--PoolSizeDecrement (Decr Pool Size) is the number of connections that are closed when an excessive number of established connections are unused.-->

          <PoolSizeDecrement>5</PoolSizeDecrement>

<!--PoolSizeIncrement (Incr Pool Size) is the number of new connections to be created when all connections in the pool are in use.-->

          <PoolSizeIncrement>1</PoolSizeIncrement>

          <!--Validate Connection validates connections coming from the pool.-->

          <ValidateConnection>false</ValidateConnection>

          <!--The following 4 settings are specific to MS SQL Server-->

          <ConnectionReset>true</ConnectionReset>

          <LoadBalanceTimeout>0</LoadBalanceTimeout>

          <!--The following setting can be used to add any custom setting not covered by anything else.-->

          <CustomSetting></CustomSetting>

                    </ConnectionPooling>

     6. Increase the  ConnectionTimeout to some higher value say for example 60.

     7. Now start the Dimension Server.

8. Go to event viewer, there should be an event which includes the entire connection string as per the changes that we did in step 4.

9. Also make sure that the connection pool settings disappear if you remove the <ConnectionPooling> section from the BPMA_Server_Config.xml file and

     10. Restart EPM Architect Dimension Server.

 

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
http://www.oracle.com