AppSet Restore Fails on OLAP Step

[JHattendorf]

When attempting to restore an appset from our DEV environment in the PRD environment, the process fails on the OLAP step. All other steps complete successfully.

I've attempted several variations of the backup and restore process including:

• adding the PRD admin ID to the DEV appset as a user, backing up again and attempting to restore

• creating an appset in PRD by copying AppShell and then attempting to restore

I'm out of ideas. Any suggestions will be much appreciated.

Thanks in advance,

Jeff

[Former Member · Accepted solution]

I also received this message when trying to restore. I was told by SAP that there is a known issue with the restore on a multi-server configuration..

[Former Member]

If you have a multiserver installation which crashes after restoring SQL, try to log in to the restored appset via the administration console and see if you can process all dimensions and modify all applications.

If you cannot get into the appset, see if the SQL database is restored, if not, try to do it manually. Look into the appserver database if there is a record for your appset in the tables tblappsetinfo and tblappsetaccess. If not try to create them after restoring the SQL database.

This should enable you to login to administration with the instalation user and process all dimensions/modify all aplications. After that it should work fine.

-Joost

[JHattendorf]

Thanks to everyone for the suggestions. Here are a few updates:

- both servers are running the same version of SQL Server

- both are on the same version of BPC (5.0 SP2)

- both environments are 2-server environments (1 database, 1 web)

While I have not seen this issue in prior releases, a collegue encountered this last week at another client. The workaround he used was as follows:

...in DEV

• Backup the AppSet using Server Manager

• Manually backup the SQL database

...in PRD

• Manually restore the SQL database

• Restore the AppSet using ServerManager

• Select the "do not overwrite" option when prompted by ServerManager

I've also opened a ticket with support and expect to get an answer similar to what Vicki posted previously. I also plan to check the OLAP logs for any contributing factors - time permitting.

When I complete the process above, I will post the results.

[JHattendorf]

Joost - Thanks for the suggestion. This one of the many things I tried last night.

My original post was not completely correct. Server manager indicates that the first three steps complete successfully. However, examining the SQL database in SQL Server shows the database to be in a restore process/state.

The original backup made in Server Manager may be corrupt, which would explain why it does not finish restoring. This may also be why the OLAP step in ServerManager fails during a restore as the OLAP database cannot reference the SQL database when it is restoring.

Jeff

[JHattendorf]

Quick update.... support confirmed indicated that there may be an issue with the backup / restore process. After walking through a manual backup, I am able to log in to the appset in Admin but not in Excel. It appears we have another issue complicating the situation.

Jeff

[JHattendorf]

Final update... the issue was due to the size of the log file for the SQL database, which had grown to more than 20Gig. During the restore process, Server Manager hits a trigger that the SQL database restore process is complete and attempts to restore / rebuild the OLAP database.

Due to the large file size, the SQL database is still in the restore process. This prevents the OLAP cube step from completing properly.

The fix was to shrink the log files to 0 for the SQL databases AppSet and AppSetExtra.

[Former Member]

Hi,

Im also transporting Apps, but have a huge problem in Step 3, Olap DB.

As far as im concerned, the trouble is that the DB needs a change from MOLAP to OLAP.

Can you tell me how did you make this?

I simply clicked on Backup App , saved the folders in DEV server.

Copy those folders in PROD server, clicked on Restore App and thats it.

Thanx in advance

Velázquez

[Former Member]

Hi Jeff

Did you check if the versions of the soft are the same?

Nic

[Former Member]

Does the OLAP logging tell you anything?