After migrating EPM database server to new SQL 2016 database server and restored backup of 5 DBs (VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5), After reinstall EPM Application, it clear old data and replace with new DBs.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

After migrating EPM database server to new SQL 2016 database server and restored backup of 5 DBs (VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5), After reinstall EPM Application, it clear old data and replace with new DBs.

L2 Linker

We have migrated EPM SQL DB server due to slowness of old SQL database sever to new SQL 2016 database server and restored backup of 5 DBs (VFSTAGEDB5, VFMNGDB5, VFNESTDB5, VFSTATDB5, VFEVENTSDB5), and reinstall EPM Application according to Article Number : 000004907 and 000004236, after re-installation, it clear old data and replace with fresh DBs.

1 accepted solution

Accepted Solutions

L4 Transporter

Similar scenario happened to me once. However, I'm still not sure what's the root cause.

 

The first step you should do is to restore your DB from backup (maybe it's better to restore

to a test environment to verify detailed steps).

Then, remove EPM server from Windows Programs and then try to install newer version.

 

Would you please describe more detailed information?

  1. EPM version before upgrade
  2. EPM version that you want to upgrade to.
  3. OS version
  4. SQL Version

 

View solution in original post

2 REPLIES 2

L4 Transporter

Similar scenario happened to me once. However, I'm still not sure what's the root cause.

 

The first step you should do is to restore your DB from backup (maybe it's better to restore

to a test environment to verify detailed steps).

Then, remove EPM server from Windows Programs and then try to install newer version.

 

Would you please describe more detailed information?

  1. EPM version before upgrade
  2. EPM version that you want to upgrade to.
  3. OS version
  4. SQL Version

 

Many thanks for the information @Cloud Wang​ . We have done, what you mentioned in here. Finally issue has been resolved. I also want to know what was the root cause which happens to EPM migration.

  • 1 accepted solution
  • 339 Views
  • 2 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!