Hyperion planning error "Network error[%s] cannot receive the data"

I have chosen this topic as this is very common error but confusing for users


Issue: 
While refreshing application from Hyperion planning to Essbase we receive error "Network error[%s] cannot receive the data"
Essbase application is stopped and an exception *.xcp log file is generated under the application's directory ...essbase0\app\<APPLICATION_NAME>

Cause:

Even though error message shows as network issue it is not related to network but Essbase application db is corrupted.


Resolution:

1. Take application data backup to make sure data is not lost in application recovery process.
2. Stop application.
3. Navigate to Essbase application database folder (D:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\app\<app_name>\<db_name>) and locate <db_name>.db (database file) and  <db_name>.dbb (database backup) file.
4. Take the backup of  <db_name>.db file and delete it.
5. Rename  <db_name>.dbb file to  <db_name>.db file.
6. Start Application
7. Now try refreshing application again from Hyperion Planning.