Wednesday, 22 July 2015

DRM Application Update Timing Out

Another quick post: if you find that when you try to apply updates to a DRM application the utility times out trying to connect to the database, make sure there isn't an "@" sign in the database user's password!

Encountered this strange issue recently, hope it helps someone!

DRM Admin Password Expiry Fix

I realise I haven't done a blog post in a while, unfortunately work has been super busy recently, so I decided to drop a quick tip here.

I have had issues with the DRM admin password expiring. This is obviously not a situation anyone wants and it seems that DRM ignores the "no password expiry" option as well. The only fix I have found is running the SQL script below:

UPDATE [DRM].[dbo].[RM_User]
      SET [d_password_expire_date] = '2035-01-01 01:01:01.00'
      ,[b_exclude_from_timeout] = 1
      ,[b_no_password_expiration] = 1
      ,[b_exclude_from_lockout] = 1
 WHERE c_user_name = 'ADMIN'
GO


Obviously altering the name of the DRM database for your own.

Friday, 1 May 2015

The Real SQL Server Pre-Requisites for EPM

Oracle have published some pre-requisites for SQL Server databases to be used by EPM. You will typically see these mentioned:

ALTER DATABASE DB_XXX SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;
ALTER DATABASE DB_XXX SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE DB_XXX SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE DB_XXX SET MULTI_USER ;


However that really doesn't tell the whole story! I had to go through an Oracle Support Request to find this out but there are actually much more than that. 

The script below will run the full pre-requisites on all databases prefixed with "EPM_". I like to use prefixes on the databases as it keeps things neat, and it also means we can perform operations on more than 1 database at a time without worrying about screwing up anyone else's databases!

DECLARE @command varchar(1000)
SELECT @command = 'IF ''?'' LIKE ''EPM_%''
BEGIN
USE ?
SELECT DB_NAME() As DatabaseName
ALTER DATABASE ? SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE ? SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE ? SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE ? SET MULTI_USER ;
ALTER DATABASE ? SET ANSI_NULL_DEFAULT OFF;
ALTER DATABASE ? SET ANSI_NULLS OFF;
ALTER DATABASE ? SET ANSI_PADDING OFF;
ALTER DATABASE ? SET ANSI_WARNINGS OFF;
ALTER DATABASE ? SET ARITHABORT OFF;
ALTER DATABASE ? SET CONCAT_NULL_YIELDS_NULL OFF;
ALTER DATABASE ? SET QUOTED_IDENTIFIER OFF;
ALTER DATABASE ? SET RECURSIVE_TRIGGERS OFF;
END'
EXEC sp_MSforeachdb @command


It is also worth mentioning that EPM requires the languages on all users and databases to be "us_english". Again, had to go through an SR to find that one out as well!

If anyone discovers any further pre-requisites for MS SQL Server please let me know and I will update this post with the information.

Thursday, 16 April 2015

Serving Edited EAS Console JNLP File



There are 2 problems with EAS that, as far as I know, have been around since version 11.1.2.1:
  
1. EAS Console will not be able to connect when using an SSL-offloaded, load-balanced EAS URL (such as https://example.com/easconsole/)

2. Periodically EAS will need to be restarted. The EAS Console will not be able to authenticate successfully  and the logs will be filled with “response already committed” errors.


The fix for both of these errors is to edit the “easconsole.JNLP” file. With the first we must add “:443” to the EAS Console URLs, to ensure that SSL communication will happen over port 443. For the second we have to add a line with ‘<update check="background"/>’ to the file.
In order to serve up this edited JNLP file with EAS, we must make a few changes to OHS. First we must add a directory called “easconsole” under the “E:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\” folder, and place the edited JNLP file into it.



Then we must add the JNLP MIME type to OHS by editing the file “E:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\mime.types”. We must add in the following line:

application/x-java-jnlp-file jnlp



Then we must edit the file “E:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\epm_rewrite_rules.conf” (change as appropriate for other versions of EPM).  We must add the following line:

RewriteRule ^/easconsole/easconsole.jnlp /epmstatic/easconsole/easconsole.jnlp [PT]



Restarting OHS will put this new configuration into place. Congratulations, your “Launch” button just became useful again!





Wednesday, 4 February 2015

11.1.2.4: Useful Resources

So I will dump all of the useful EPM 11.1.2.4 links I have found so far into this consolidated post. If you find any more please let me know!

 ---


EPM 11.1.2.4: General Information

EPM 11.1.2.4 Documentation
EPM 11.1.2.4 is certified with Internet Explorer 11
Life Cycle Management Changes in 11.1.2.4
easy error tackling - new Error Message Guides in EPM 11.1.2.4
Thoughts on deprecated Essbase 11.1.2.4 features and the future of EAS

EPM 11.1.2.4: Installation & Configuration

EPM 11.1.2.4 Installation and configuration
EPM Test Drive Quattro
Taking 11.1.2.4 for a spin in the cloud
Firing Up 11.1.2.4 with John A. Booth’s Amazon Image
HFM 11.1.2.4 Running On Commodity Linux

EPM 11.1.2.4: Planning

Planning 11.1.2.4 New Features

EPM 11.1.2.4: HFM

A brief glance at HFM 11.1.2.4 from a techie perspective
Say Hello To HFM 11.1.2.4
Financial Management 11.1.2.4
HFM 11.1.2.4 under the covers – the new architecture  
HFM 11.1.2.4 and Copy App Utility - NOT! 

EPM 11.1.2.4: FDMEE

FDMEE 11.1.2.4 has been released
FDMEE 11.1.2.4...the show must go on!  


EPM 11.1.2.4: DRM

DRM 11.1.2.4 New Features Released! Official from Oracle!
DRM 11.1.2.4.301 Patch Details


EPM 11.1.2.4: Calc Manager

Calc Manager 11.1.2.4 New Functions


---

For  all of the blogs above I highly suggest bookmarking them - they are certainly much more useful than this one!

Tuesday, 3 February 2015

Posts to Come

Just a quick note to say: I'm still here! I will create some posts in the next few weeks to discuss the following topics:

EPM 11.1.2.3.500 -> 11.1.2.4 upgrade
DRM 11.1.2.4 installation
HFM 11.1.2.4 - upgrade path, recommendations, etc

Sunday, 7 December 2014

Looking Up at the Clouds...


I wanted to take a departure from the purely technical posts I usually do to discuss something that should be in the thoughts of everyone involved in Hyperion right now: the cloud.

It isn't just a buzzword any more - cloud is very real. Oracle is clearly pushing Hyperion EPM and OBIEE into the cloud, we can see that with their cloud Planning service, and we will soon see Financial Reporting coming to the cloud as well. 11.1.2.4 will see HFM become a Java application. Do not be surprised if some sort of "FMCS" cloud offering created further along the line.

The important thing to remember is that Oracle's cloud offerings are Linux-only, and to be able to offer a full Hyperion and OBIEE suite on their cloud all the components must be Linux compatible. In real terms this means everything becoming WebLogic applications or (if that isn't possible) standalone Java applications. This is where things are heading. Products that don't conform to this have 2 options, depending on if they are "strategic": become a Java application or get replaced by the strategic tool for that job.

To give two examples: HFM had to become a Java application: there is nothing to replace it and it is the only Hyperion option for performing consolidations (outside of creating custom Essbase apps and processes to support them - or silly things like that). EPMA Data Sync, on the other hand, can be replaced by the strategic tool for EPM-to-EPM loads which will be FDMEE. FDMEE is getting a whole bunch of new features in 11.1.2.4 that will make it absolutely the best tool to be using for this - such as native EPM-to-EPM loads, HPCM support and native DRM-to-FDMEE mapping integration (there is a more complete list here). So really once they have taken out the EPMA dependency from HPCM we may see EPMA fall by the wayside completely.

But let's be frank here: Oracle is not yet in a position to give a really complete cloud option with all the flexibility of an on-premises solution. That will change over time, though, and the decision on whether to go to the cloud or not will probably not be with us techies, it will be with the people holding the purse strings. So how much will these cloud offerings cost?

You have to contact Oracle for that information :) But remember for PBCS it is a subscription fee, of around "$120 per user per month with a 10 user minimum" but each application is on its own environment (more info here). The FPRCS service that will be launched soon will also have a "per-user, per-month" subscription model. So for small shops with basic needs they are probably a nice solution. As for the full Oracle Cloud offering I unfortunately don't have any estimates for pricing, as that includes support costs as well, but I wouldn't be surprised if you have to contact them for a quote that would then be given on a case-by-case basis. So the big customers may not be so quick to whip out their credit card and buy themselves a few slices of the clouds just yet...


But for now how can we, those in the trenches of Hyperion Infrastructure, be ready for what Oracle may have in store? Well the best advice to give is to really try to stay up to date on which products Oracle are considering to be strategic, and to always try to align with that wherever possible. You don't have to jump for the clouds just yet, if you keep your feet on the ground - but keep looking up - you should be fine.