Wednesday, March 20, 2013

Treasury Monthly Report timeout expired

Problem:
             While view monthly report in Treasury supervisor (C Class office) it shows an error "Query timeout expired"


Solution:
  1. Download and Execute above exl
  2. Run below query using Query Analyser
USE BOSubaccountsGODBCC 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.

------------------------------------------------------------------------------------------------
A Great Thank to 

Sharmila Sethupathi(Writer POTOOLS)
System Administrator.

2 comments:
Write Comments
  1. Thanks sir
    Solution worked

    I had same problem and now solved

    Mukesh Parmar
    SA Bharuch Division

    ReplyDelete
  2. After done the above said procedure the problem is not rectified please guide us

    Anil Babu
    SA,Narasaraopet Div

    ReplyDelete