Saturday 30 November 2013

11.1.2.3 Planning – email configuration

To configure the email server in all planning releases prior to 11.1.2.3 it would be done through the system settings area in each application and this had to be done by the application owner.


Moving on to 11.1.2.3 and you will notice a subtle change in the system settings.


The email server option is not available anymore and if you are a planning administrator you may be wondering where it has gone.

From the release of version 11 it has been Oracle’s objective to get as much configuration information held centrally within the Shared Services registry which means all product components can share this information and there is no need for duplication which makes perfect sense.

At last planning has now moved a little step forward and can access the email configuration directly from the Shared Services registry so it only needs to be configured once and will be in sync with other EPM products.

So how is it configured, well if you have been involved with any of the EPM configuration then you will no doubt know the answer and that is it can be achieved using the EPM system configurator.

If you are not sure how to access the configurator then have a read here.


Once the configurator has started only select “Configure Common Settings


You will notice there are more email configuration options available than you will previously be used to with planning, some of the major complaints in the past with the planning email configuration was the mail server port could not be selected and anonymous authentication was the only option so this is a welcome change at last.

The biggest question I had was does the authentication option work as just because it is there a common setting it doesn’t mean it would necessarily be available to planning, it is something that I will shortly test out.

Once the email properties have been applied these will be stored in the Shared Services registry.


You can verify this by running a registry report with the epmsys_registry command line utility

The property values can also be updated directly using the utility, an example to update the email server hostname would be:

epmsys_registry.bat updateproperty SHARED_SERVICES_PRODUCT/@SMTPHostName mailserverhostname

Though for some reason there are two properties which seem to be the same SMTPHostName and SMTPMailServer so both should be updated.

To update the authentication password then the addencryptedproperty can be used which encrypt the password before writing to the registry:

epmsys_registry.bat addencryptedproperty SHARED_SERVICES_PRODUCT/@SMTPServerPassword password

It is also true that it is possible to export/import registry information using LCM though the important caveat being it doesn’t look to encrypt the password on import.


Anyway time to test out whether the email functionality is successful in planning with the authentication option enabled.


Unfortunately it seems to be that email addresses still have to be manually configured in planning and there is no option to bring this through from Shared Services which personally I think should be fully integrated by now.


For the test I enabled the due date option for a task list entry and then monitored the email server.


The email server logs confirmed the email was sent and authentication was successful.


A check of the planners email account confirmed the email was delivered so at least I know the functionality is definitely working.

Wednesday 6 November 2013

Patch available for 11.1.2.3 EAS web console bug with Java 7 update 45

Recently I posted a blog about an issue with 11.1.2.3 EAS web console and Java 7 update 45, if the update is applied then the web console is blank when opened and cannot be used.

I just noticed that there has been new patch set updates (11.1.2.3.003) released for Essbase related products which includes the following:

Patch 17609518: PATCH SET UPDATE: HYPERION ESSBASE ADMINISTRATION SERVICES SERVER 11.1.2.3.003

The one bug fix in the PSU is to address the Java issue:

17649604 - After Java 7 Update 45 has been updated, EAS console cannot start via Web Launcher.

I thought I would test out the patch and it has resolved the issue with the Java update.


The remaining Essbase related 11.1.2.3.003 patches are:

Patch 17609530: PATCH SET UPDATE: HYPERION ESSBASE RTC 11.1.2.3.003

Patch 17609535: PATCH SET UPDATE: HYPERION ESSBASE SERVER 11.1.2.3.003

Patch 17609493: PATCH SET UPDATE: HYPERION ANALYTIC PROVIDER SERVICES 11.1.2.3.003

Patch 17609497: PATCH SET UPDATE: HYPERION ESSBASE ADMIN SERVICES CONSOLE MSI 11.1.2.3.003


There are few interesting bug fixes for Essbase server:

17649547 - In some cases, after a dense restructure the size of the Essbase index files grows more than expected.

17649545 - During a dense restructure, the restructuring in some cases can fail and give the following error message: Corrupted Node Page in the B+tree.   [adIndPromoteSafeWrite] aborted


For Provider Services:

17275594 - In some cases, when retrieving with Smart View Client can result in getting an error: Binary Spreadsheet Table Token Error