Tuesday, 29 May 2012

Problem in Printing eMO (Database Corrupted)



Yesterday I got a call from one of our 
suboffices regarding the printing of e 
Money Orders. The problem is that 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 consistancy 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.









0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Sample text


Advertisement

 

Copyright 2008 All Rights Reserved saparavur theme by SA PARAVURr Converted into Blogger Template by SA PARAVUR