on 09-22-2010 9:00 AM
Hi Xperts,
After upgrading the SAP 2007B from Patch 15 to Patch 20, some of the company databases are not upgrading with throwing the error message that "Database is not consistent'.
Regards,
Bala
Hi,
Try this solution:
How to handle database inconsistencies
Symptom
This note specifies how to handle database inconsistencies.
Other terms
DBCC, Integrity, database, DB, data base inconsistency, inconsistencies, relational database, SAP Business One, Torn Pages.
Reason and Prerequisites
Consulting.
Solution
Run DBCC CHECKDB procedure, use the following query:
DBCC CHECKDB ('DB_Name')
Replace ('DB_Name') in the query with the database name.
This SQL function is indicating data page integrity problems in
SQL tables.
In case any errors found, SQL will generate the error message:
error: "Object ID 1913825930..."
to solve the problem, contact your Data base administrator.
If the query retrieves any error results, you can do the following:
- Refer to the related online help for Microsoft SQL Server at
http://social.msdn.microsoft.com/Search/en-US?query=DBCC%20CHECKDB&ac=3-Ask for support from your database administrator.
you must make sure that there are no users login to B1 before applying the above solution
JimM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try restoring from the pre-upgrade back up and starting the upgrade again. If the issue persists, log a message with SAP Support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.