Saturday, April 06, 2013

Solution for Treasury Time out Expired



Error:
       While View Monthly report in Treasury module it shows an error Time out-expired.
Error message: [Microsoft][ODBC SQL Server Driver]Query timeout expired.


Step 1:
  • There may be huge data in the databases causing the time out error. 
  • Take backups of Treasury, subaccounts, Subtreasury, BOsubaccounts databases. 
  • Close Treasury, Subaccounts modules at the time of execution of the script.
  • The script may be executed once or twice. Afterwards, day begin may be done in Treasury module. 
  • 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.

Step 2:
  1. Download and Execute above exl
  2. Run below query using Query Analyser
USE BOSubaccounts GO
DBCC CHECKDB 
Note 1: Execute query 1-2 times.

Note 2: While execute Above query in Analyzer it may show time out error, to overcome this error 
  • Set the Remote Query timeout as '0'  through option 
  • SQL server >Properties >Connections in SQL Server Management studio.
  • Afterwards, execute the above DBCC CHECKDB on BOSubAccounts database Once again and then Check for the report.