Solution for Treasury Time out Error

Time out-expired.
Error message: [Microsoft][ODBC SQL Server Driver]Query timeout expired.

Solution

  1. There may be huge data in the databases causing the time out error. 
  2. Take backups of Treasury, subaccounts, Subtreasury, BOsubaccounts databases. 
  3. Close Treasury, Subaccounts modules at the time of execution of the script.
  4. The script may be executed once or twice. Afterwards, day begin may be done in Treasury module. 
  5. Run the attached file with script tool to delete the old data upto 31.12.2011. 
Note:The approval of the competent authority may be obtained before deletion of old data

Query to execute once / twice: 

for HO

USE Subaccounts GO
DBCC CHECKDB
for SO
USE BOSubaccounts GODBCC CHECKDB