Monday, May 2, 2022

HFM Application migration and upgrade from V11.1.2.4 to V11.2.7

 Previously, we had used CopyApp utility to copy HFM Application from one environment to another environment or from one version to another.

However while migrating HFM application from V11.1.2.4 to V11.2.7 , we used Import application wizard as suggested by Oracle.

 There are 3 important steps for HFM application upgrade, migration to V11.2.7.

 

1)    Database Link between HFM V11.1.2.4 and HFM V11.2.7

HFM schema in new version V11.2.7 must have following privileges.

CREATE DATABASE LINK

SYS.DBMS_LOB

SYS.DBMS_SQL

Create Database Link

 Use following query to create database link between HFM V11.2.7 schema and HFM V11.1.2.4 schema.

CREATE DATABASE LINK DEVTONEWDEV CONNECT TO EPMXDEV1 IDENTIFIED BY PASSWORD USING HFMDEV11;

 To view the database links present, execute following query.

select * from all_db_links

 To view applications present in source HFM database, list out datasources using following query:

Select * from HSX_DATASOURCES@DEVTONEWDEV;

 

We received following error at this point:

Error:

ORA-12541: TNS:no listener

12541. 00000 -  "TNS:no listener"

*Cause:    The connection request could not be completed because the listener

           is not running.

*Action:   Ensure that the supplied destination address matches one of

           the addresses used by the listener - compare the TNSNAMES.ORA entry with

           the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to

           go by way of an Interchange). Start the listener on the remote machine.

            Error at Line: 3 Column: 31

 Our first step was to add TNS entry for source database (HFM V11.1.2.4 database) in destination database, however due to security at client, found that port 1521 was closed between source and destination databases and hence we had to get port opened through firewall request.

 After creating the DB link we can run below mentioned package in the target oracle DB.

 Oracle_Create_ImportApp_package.pck file



After successful execution, the new package, HFMUTIL_PKG, will show up under the HFM schema’s available packages, in SQL Developer. If you see the green dot showing on the package, right click and click Compile. If the green dot is not there, there is no need to do this step:



2)     Import Application

After successful creation of the database link, login to Workspace and go to Navigate -> Administer -> Consolidation Administration, then click on Import Application. The Database link should be available and a dropdown list of the source environment’s HFM applications should be available.




 

3)    Upgrade HFM Application from V11.1.2.4 to V11.2.7

Once HFM application is migrated, we need to upgrade it to V11.2.7 using upgrade utility. 








And this results in successful migration and upgrade of HFM application with more than 20 years data (750 GB) for our retail domain client. 

There were couple of issues during the process, I will soon blog about issues and solutions.