Database upgrade problem in SAP 8.8

[Former Member]

Dear all

I have database in SAP B1 2007B PL:15 and same I need to replicate in SAP 8.8 PL:05 so I have restored DB in SAP 8.8 MSSQL server and when I login in to company which I have restored the DB it is showing message:cannot upgrade company databased from SAP B1 client,use upgrade CD.

SO I went to upgrade option in 8.8 setup and run the exe and fill the required things step by step but it company database option is disable so how cam i upgrade DB pls kindly suggest

Regards

M Auditya

[Former Member · Accepted solution]

Dear Auditya,

You would need to run the Upgrade.exe file order to upgrade DB to 8.8. Follow the instructions in the Upgrade Wizard.

Note: All users need to exit out of SAP B1 and please do not connect to the db you are trying to upgrade in SQL Management Studio. If you connect to the db the company database check box will be disabled in Upgrade Wizard. Also, please check PatchReadMe.pdf that comes with SAP B1 8.8 PL05.

Regards,

Praneeth

[Former Member · Accepted solution]

I have done according ur suggestion but still Company DB is disable and which I have restored the company DB is not showing in that upgrade list.Please suggest.

[Former Member · Accepted solution]

Auditya,

Did you restore the backup with .bak extension? Let us assume that you did. In the upgrade wizard, make sure you choose the right SQL Server 2005 or 2008, Server and Logins and move to the next screen.

Regards,

Praneeth

[Former Member · Accepted solution]

I have restored according to your suggestion but still in upgrade option company db is disable and even my company is not in that list.Please suggest wht to do

Regards

M Auditya

[Former Member · Accepted solution]

hi Auditya

it sems u have done all that u coul do fom your end in that case i would request you to please log a ticket with sap support portal u would requuire and s user id for that

Regards,

Manish

[Former Member]

Thks for suggestions

[mat_mat]

Dear All,

I did face the same thing like this, and i found one solution:

1. run SBO-COMMON upgrade manually from package folder.

2. run upgrade wizard.

should be ok to select company database after that.

regards,

mat

[Former Member]

Hi Experts,

Our SBO COMMON database transaction log is 36G in size. Is this a normal sized for SBO COMMON? If not what should I do? Please help.

Thanks very much,

Ben

[Former Member]

Sorry. I got the wrong place.