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 V126.96.36.199 to V11.2.7 , we used Import application wizard as suggested by
Database Link between HFM V188.8.131.52 and HFM V11.2.7
HFM schema in new version V11.2.7 must
have following privileges.
CREATE DATABASE LINK
Create Database Link
CREATE DATABASE LINK DEVTONEWDEV CONNECT TO EPMXDEV1
IDENTIFIED BY PASSWORD USING HFMDEV11;
select * from all_db_links
Select * from HSX_DATASOURCES@DEVTONEWDEV;
We received following error at this
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
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
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.
Upgrade HFM Application from
V184.108.40.206 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.