Tuesday, August 13, 2013

EMO DATABASE - HOW TO REPAIR CONSISTENCY ERROR IN DB

Problem in Printing eMO (Database Corrupted)


While printing the eMOS, an error occurs. The
screen shot is shown. The error shows

Attempt to fetch logical page in database eMO belongs to object eMO Inward not to object eMO Offices

While checking the databases. The database is not in suspect state. While checking the Check db it shows There are some consistency errors.. Then I tried to repair the database with query. This worked for me


The query for corrupted database(Not for Suspected database) with minimum data loss is given below

DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

while While reporting the matter with PTC Mysore They give a solution. While running the exl file It completed with on error. While consulting the matter with PTC they replied thatIt can occur to some reasons like, network issue and excess size of log files. Please check for network connectivity. if everything is fine please try to shrink the database and check. While clearing the log file and restarting the server the query worked.

COURTESY : SAPARAVUR source:sapost.blogspot.com

0 comments:

Related Posts Plugin for WordPress, Blogger...