Solution for Treasury Time out Error
Time out-expired.Error message: [Microsoft][ODBC SQL Server Driver]Query timeout expired.
Solution
- 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
USE Subaccounts GOfor SO
DBCC CHECKDB
USE BOSubaccounts GODBCC CHECKDB
Post a Comment