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
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