cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade 2005A sp00 p 8 to 2007A

Former Member
0 Kudos

I am trying to upgrade a DB from 2005A sp00 p 8 to 2007A p45. I was able to backup the DB and restore it to the SQL 2005 and then started my upgrade. During upgrading the system failed due. When I go back in to try the upgrage again I get an error that the "company DB is not consistent" Check the log file.

I check the file and it tells me the CINF compnaystatus is not vaild. The Status is at "U" which is one of the valid values.

How can I reset this to start the upgrade?

Joanne

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Joanne,

You need to use the original backup file before upgrade to restart the process. The failed db should not be used anymore. If you could not find the working one, log a ticket to SAP is your only option. There is no way that you could Correct inconsistent DB.

Thanks,

Gordon

mario_schoenberg
Contributor
0 Kudos

Hi Joanne,

As soon you have restored the original backup again, you should run queries of note [1000846|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMSZ3PTU4ODAwMDAr)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=1037574]].

Although in case there are or no results you should mention this in any support message you might log

as outlined in the Accelerated Upgrade Program ([B1AUP|https://websmp201.sap-ag.de/~sapidb/011000358700001047642008E]).

Kind regards

Mario Schoenberg

Senior Support Consultant

SAP Business One Forums Team

Edited by: Mario Schoenberg on Feb 8, 2009 11:34 AM

Former Member
0 Kudos

Thank you, I do have the original backup and will try the restore again and upgrade.

Jo

Former Member
0 Kudos

Thanks but that note is no longer available so I will try Gordon's answer and re-do the restore and upgrade.

Jo

Former Member
0 Kudos

Hi Joanne Pencola !

How do you back up database? You use function of SQL 2005 or the function of SAP Business One service manager?

You try to use SAP Business One service manager again.

Thanks!

Former Member
0 Kudos

Thanks to everyone for all the options. I was able to restore my original and re-do the upgrade and it went great....

I love this forum!

Joanne