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:
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:
- Take application data backup to make sure data is not lost in application recovery process.
- Stop application.
- 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.
- Take the backup of <db_name>.db file and delete it.
- Rename <db_name>.dbb file to <db_name>.db file.
- Start Application
- Now try refreshing application again from Hyperion Planning.