സ്ത്രീകള്‍ എങ്ങിനെ വസ്ത്രം ധരിക്കണം എന്ന് പുരുഷന്‍ നിഷ്ക്കര്‍ഷിക്കുന്നത് ശരിയോ? അല്ലെങ്കില്‍ തിരിച്ചും?

Wednesday, June 06, 2012

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

No comments:

Post a Comment

Hmmmmm... what are you thinking? Do not forget to comment,It helps us to improve this blog and help us to make better. on