Postman day end and Report discrepancies error and Solution

Postman Database Problem and Solution

While doing dayend or viewing reports of different types of article it may show the discrepancies or it may shown the error message due to database may be corrupted. 

In some of the reports data could not fetched from database / it may shown the blank reports.

Solution

The above problem can be rectified by using the below mentioned query. 

USE master 

ALTER DATABASE POSTMAN 

SET single_user DBCC checkdb ('POSTMAN','repair_rebuild') 

DBCC checkdb ('POSTMAN','repair_allow_data_loss') 

ALTER DATABASE postman 

SET multi_user 

Finally Execute the below query

Use postman Dbcc checkdb 

Note : Repeat the above process until the Zero error will be resulted.

The above Query should be Executed in Query Analyzer and database gets repaired when results Zero.