Sub Account day begin error couldnot locate the entry.. and solution

Could not locate the entry in the system database 'BOsupplysubacocunts'. No entry found with that name. Make sure that the name is entered correctly.

Solution to recover the database from the above said error

  • There may be an issue with BOSupplySubaccounts database at the PO. Hence, the message. 
  • Please check whether the database is in suspect mode. 
  • Further, execute the following in SQL Query analyser, with the approval of the competent authority, to settle the issue. 
USE MASTER GO
ALTER DATABASE BOSUPPLYSUBACCOUNTS
SET SINGLE_USER GO 
DBCC CHECKDB(BOSUPPLYSUBACCOUNTS, REPAIR_REBUILD) GO
ALTER DATABASE BOSUPPLYSUBACCOUNTS
SET MULTI_USER GO

Post a Comment

Previous Post Next Post

Most Visited

Search Content of www.potools.blogspot.com @