Postman database error while fetch articles in Despatch Module

While we fetch articles in "fetch from Postman" option in despatch module, it may shown the postman db error like shown in below.

Solution

The database of Postman may be corrupted.

Try once by restarting the server or follow the steps as below

• Take backup of Counter and postman database and close all the application which are using. 
• Run the below sql queries in Microsoft SQL server management studio line by line 

USE master 
ALTER DATABASE counter SET single_user 
DBCC checkdb ('counter','repair_rebuild') 
DBCC checkdb ('counter','REPAIR_FAST') 

Also read :Tool for RPC Issue in Meghdhoot Point of Sale

DBCC checkdb ('counter','repair_allow_data_loss') 
ALTER DATABASE counter SET multi_user 
use Counter dbcc checkdb
USE master ALTER DATABASE 
Postman SET single_user 

Also read :Fixed Fetch - COD Articles in Postman Module after Update 7.9.1

DBCC checkdb ('Postman','repair_rebuild') 
DBCC checkdb ('Postman','REPAIR_FAST') 
DBCC checkdb ('Postman','repair_allow_data_loss') 
ALTER DATABASE Postman SET multi_user
use Postman dbcc checkdb 

• In the Message, last line shows the allocation errors and consistency errors, if this is 0 means, your database is recovered. 

Note:Take backup of counter and postman database again and use the despatch application now.