Treasury Old data delete error time out expired

Query timeout expired error, while delete old data in treasury module. This may due to more number of rows are to be deleted from the database, It may take more time / timeout error.

Instruction / Solution to Delete old data

  1. There is a provision in Treasury module for Supervisor through Tools > Delete Option to delete old data from Treasury, Subtreasury, Subaccounts, BOSubaccounts databases Upto the required date. 
  2. If the data cannot be deleted due to having large data in the databases up to the required date through the Option and giving "timeout expired" message, then execute the attached file with script tool (2-3 times till execution is completed successfully) to delete the Old data from the above databases up to 31.12.2012.
  3. The script file may be executed after completion of day's transactions / work in Treasury, Subaccounts applications at the PO and when the server is not busy. 

Note: Please follow the prescribed procedure of taking backups of the databases and getting approval of the competent authority etc., before executing the script file.